Data Engineer / Analytics Developer (ETL & BI)

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.