Senior SQL Developer

Job Description

One of our large retail clients is looking for a SQL 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 ... learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy:

Skills and Requirements

Must be comfortable going onsite 5 days per week

5-7+ years of experience as a SQL Developer, specifically writing complex queries and optimizing database performance

Experience as an ETL Developer, specifically designing and building ETL data pipelines from diverse data sources

Experience working with SSRS

Ability to work collaboratively in a team environment and communicate effectively with stakeholders

Familiarity with data warehousing concepts and dimensional modeling At least one year of experience working with Snowflake including data modeling, performance tuning, and integration with cloud-based data platforms

Proficiency in Azure services, particularly Azure Data Factory or similar ETL tools

Experience working with Databricks

Experience with version control systems (e.g., Git) and CI/CD pipelines

Experience customer facing and being able to talk to stakeholders