Data Engineer / Analytics Developer

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.