Description

You will design, build, and maintain data pipelines across on-premises and cloud environments to ingest, transform, and store large datasets.

Responsibilities

• Design and optimize dimensional models using star and snowflake schemas to improve query performance.
• Build and manage end-to-end ETL/ELT pipelines using SSIS and Azure Data Factory.
• Integrate diverse data sources including SQL, NoSQL, APIs, and files while implementing validation and monitoring.
• Automate deployment, testing, and monitoring of workflows through CI/CD pipelines.
• Partner with analysts and stakeholders to translate requirements into curated data marts and fact/dimension tables.
• Develop interactive Power BI dashboards and use statistical methods to identify trends and patterns.

Required Skills

• 5+ years of experience in data engineering or data analytics roles.
• Proficiency with SQL and NoSQL databases.
• Experience building ETL/ELT processes and managing data pipelines.
• Hands-on experience with SSIS and Azure Data Factory (ADF).
• Strong programming skills in Python and R.
• Experience working with APIs and various file formats.
• Ability to implement CI/CD pipelines for workflow automation.
• Knowledge of DAX for Power BI reporting and data modeling.
• Bachelor's degree in a relevant field.

Preferred Skills

• Experience with machine learning methods for predictive or descriptive modeling.
• Experience working in an Agile environment.

Key Skills

Education

Bachelor's degree