Intermediate Data Warehouse Analyst

Roles and Responsibilities

• Develop and maintain ETL/ELT pipelines, primarily using Azure Data Factory (ADF).
• Perform SQL development for data extraction, transformation, and loading.
• Design, implement, and maintain data models in Snowflake.
• Build and maintain business reporting dashboards using Power BI or Sigma.
• Work with large, complex datasets to support business and enterprise reporting requirements.
• Collaborate with cross-functional teams to define data requirements and transformation logic.
• Ensure adherence to SDLC processes and support production data environments.
• Troubleshoot data issues and ensure data integrity.
• Contribute to data warehousing design, including OLAP and OLTP concepts and relational structures.

• Strong SQL experience (mandatory; this is an SQL-heavy role)
• Hands-on experience with Snowflake
• Experience with ETL/ELT development, preferably using Azure Data Factory (ADF)
• Experience with reporting tools such as Power BI or Sigma
• Understanding of data warehousing concepts, data flows, and transformation logic
• Familiarity with cloud environments, preferably Microsoft Azure
• Understanding of OLAP vs. OLTP design concepts and relational data structures
• Strong analytical and problem-solving skills
• Excellent communication skills and ability to work in a team-oriented environment
• Ability to organize work independently and manage multiple tasks/projects

• Experience with Informatica or Oracle Warehouse Builder if ADF experience is limited
• Previous experience in production support for data platforms