Role Overview

The Data & Reporting Engineer will be responsible for designing, developing, and maintaining robust data pipelines, scalable data models, and insightful reports/dashboards. The role requires hands-on experience with Azure cloud data services and a strong ability to translate business requirements into technical solutions that deliver value and insights.

Key Responsibilities

• Design, build, and maintain data pipelines using Azure Data Factory (ADF).

• Develop and optimize data models, ETL processes, and stored procedures within Azure Synapse Analytics.

• Implement data integration solutions to ingest, transform, and orchestrate large volumes of structured and semi-structured data.

• Create and maintain Power BI dashboards and reports, ensuring alignment with business KPIs and usability standards.

• Collaborate with business stakeholders to gather requirements and deliver actionable insights.

• Ensure data quality, consistency, and performance across all reporting and data engineering solutions.

• Support data governance, security, and compliance best practices.

• Troubleshoot issues in data pipelines, queries, and reporting layers.

• Continuously improve processes by adopting automation, optimization, and cloud-native best practices.

Required Qualifications

• Bachelor’s or Master’s degree in Computer Science, Information Systems, Data Engineering, or a related field.

• 3–6 years of experience in data engineering and reporting roles.

• Strong hands-on experience with:

◦ Azure Data Factory (ADF) for pipeline orchestration and data integration.

◦ Azure Synapse Analytics / SQL Data Warehouse for data modeling and query optimization.

◦ SQL (T-SQL, stored procedures, performance tuning).

◦ Power BI (DAX, Power Query, data modeling, visualization best practices).

• Solid understanding of data warehousing, ETL concepts, and cloud data architectures.

• Experience working with Azure ecosystem (Data Lake, Key Vault, Logic Apps, etc.).

• Strong problem-solving skills and ability to work in a fast-paced, collaborative environment.

• Excellent communication and documentation skills.

Preferred Qualifications

• Experience with Python for advanced data processing.

• Knowledge of DevOps practices (CI/CD, Git, automated testing) in data environments.

• Familiarity with data governance, security, and compliance frameworks.

• Prior experience in consulting or services-based companies.

What We Offer

• Opportunity to work with cutting-edge cloud and AI-driven data solutions.

• A collaborative and innovative culture focused on client success.

• Competitive compensation and benefits package.

• Career growth opportunities across engineering, analytics, and AI solution areas.

Job Types: Full-time, Contract

Pay: $90,000.00 - $134,339.66 per year

Benefits:

• Dental insurance
• Flexible schedule
• Health insurance
• Paid time off
• Vision insurance

Work Location: Hybrid remote in Pasadena, CA 91101