Job Description
One of our large retail clients is looking for an ETL Developer to join their team. This client has about 140 SSRS financial and back office related reports that need to move from SSRS to Snowflake. The ETL Developer is responsible for designing and implementing ETL data pipelines. With a focus on Azure and SQL, the ideal candidate will possess experience in building efficient ETL processes and may also contribute to the conversion of existing ETL workflows onto future platforms. About 30% of the time will be maintenance work in SSRS and the other 70% will be new development in Snowflake. Responsibilities are shown below:
• Design, develop, and maintain ETL data pipelines to facilitate the extraction, transformation, and loading of data from various sources.
• Collaborate with cross-functional teams to understand data requirements and translate them into effective ETL solutions.
• Optimize ETL processes for performance, scalability, and reliability.
• Troubleshoot and resolve issues related to data integrity, quality, and pipeline performance.
• Document ETL processes, workflows, and configurations for knowledge sharing and future reference.
• Contribute to the migration of existing ETL workflows onto future platforms, ensuring compatibility and efficiency.
• Stay updated with industry trends and best practices in ETL development and data integration technologies.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.
Required Skills & Experience
• Must be comfortable going onsite 5 days per week
• 3-5+ years of experience as an ETL Developer, specifically designing and building ETL data pipelines from diverse data sources
• Strong SQL skills with experience in writing complex queries and optimizing database performance
• At least one year of experience working with Snowflake including data modeling, performance tuning, and integration with cloud-based data platforms
• Experience working with SSRS
• Proficiency in Azure services, particularly Azure Data Factory or similar ETL tools
• Ability to work collaboratively in a team environment and communicate effectively with stakeholders
• Familiarity with data warehousing concepts and dimensional modeling
Nice to Have Skills & Experience
• Experience working with Databricks
• Experience with version control systems (e.g., Git) and CI/CD pipelines
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.