Data Engineer Analytics Developer (End-to-End ETL & BI)

Job Title

Data Engineer / Analytics Developer (ETL & BI)

Location

Baltimore Maryland (Hybrid onsite with remote flexibility)

Job Summary

STAFFXPERT LLC is seeking a Data Engineer / Analytics Developer on behalf of our client in Baltimore Maryland. This role is ideal for a highly skilled data professional with strong expertise in Azure-based data engineering ETL/ELT pipeline development Databricks/Synapse and Power BI reporting solutions.

The ideal candidate will be responsible for designing scalable data pipelines developing enterprise analytics solutions and delivering impactful dashboards and reporting capabilities in a modern cloud-based data environment.

Key Responsibilities

• Design develop and maintain end-to-end ETL/ELT pipelines for enterprise data integration.

• Build scalable data ingestion frameworks integrating APIs databases flat files and legacy systems.

• Develop interactive dashboards KPIs and semantic models using Microsoft Power BI.

• Perform data transformation cleansing and integration using SQL Python PySpark and Spark.

• Implement and manage lakehouse and medallion architecture (Bronze/Silver/Gold layers).

• Develop and optimize data warehouses Delta tables and reporting models.

• Create reusable workflows and orchestration pipelines using Azure Synapse Analytics Azure Data Factory (ADF) and Databricks.

• Implement data quality validation logging monitoring and error handling processes.

• Optimize SQL queries Spark jobs and Power BI datasets for performance and scalability.

• Collaborate with business stakeholders to gather requirements and deliver technical solutions.

• Support data governance security access controls and CI/CD best practices.

• Contribute to advanced analytics and AI/ML data integration initiatives.

Required Qualifications

• 7 years of experience in Data Engineering Analytics Engineering BI Development or ETL Development.

• Strong experience with Microsoft Power BI including dashboards DAX Power Query and semantic modeling.

• Hands-on expertise with Azure Synapse Analytics Azure Databricks and Azure Data Factory (ADF).

• Strong proficiency in SQL Python PySpark and Spark-based data processing.

• Experience building and maintaining enterprise-scale ETL/ELT pipelines.

• Strong understanding of data warehousing dimensional modeling and lakehouse architecture.

• Experience working with Delta Lake ADLS Gen2 and Parquet.

• Familiarity with orchestration tools such as Synapse Pipelines or Databricks Workflows.

• Knowledge of CI/CD Git/source control and DevOps practices.

• Experience implementing data governance security and access management standards.

• Ability to work collaboratively with technical and business stakeholders.

Preferred Qualifications

• Microsoft Azure certifications such as DP-203 or PL-300.

• Experience supporting AI/ML or advanced analytics initiatives.

• Prior experience in public sector transportation or large enterprise environments.

• Experience working with large-scale multi-source enterprise data platforms.