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. Required Skills & Qualifications • 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 Preferred • Experience with Informatica or Oracle Warehouse Builder if ADF experience is limited • Previous experience in production support for data platforms