Data Engineer/BI Analyst (202912)

Position Summary: Bull City Talent Group's direct client has an immediate need for a Data Engineer/BI Analyst with a strong foundation in modern data platforms, semantic modeling, and data pipeline development. This hybrid role requires a balance of data engineering skills (especially in Azure, Databricks, and ADF) and BI expertise (Power BI modeling and optimization). You'll work cross-functionally to transform raw data into insightful, performant, and reliable reporting assets that support business decisions at scale. Job Duties & Responsibilities: • Develop Scalable Pipelines: Build and maintain robust data pipelines using Azure Databricks and Azure Data Factory, applying metadata-driven design principles • Data Cleansing & Transformation: Automate data ingestion and transformation using Python, SQL, and configuration-driven workflows. • Semantic Modeling: Design efficient and scalable Power BI semantic models using tools like Tabular Editor, ensuring clear relationships, optimized DAX, and usability • Report Optimization: Enhance Power BI report performance by refining visual layouts, filters, measures, and DAX calculations • Deploy via Git & CI/CD: Use Git and DevOps concepts to manage, test, and deploy pipeline and report changes across environments safely • Validate Data: Write effective SQL queries for data validation, exploration, and issue resolution throughout the pipeline • Collaborate Across Teams: Translate technical requirements into business-friendly terms and work alongside stakeholders, analysts, and engineers to deliver high-impact solutions • Monitor & Troubleshoot: Diagnose pipeline or data quality issues across distributed systems, ensuring reliable and accurate outputs Required Skills & Experience: • 8+ years of hands-on experience in data modeling/data visualization • Experience with Azure Data Factory - pipelines, parameterization, and architecture • Experience with MS Power BI - semantic model design, performance tuning, and DAX optimization • Strong grasp of BI fundamentals, from raw data to reporting layer • Databricks and Spark-based distributed data processing • Python for scripting, automation, and data transformation • SQL – for data exploration, joins, aggregations, and validation • Git – source control workflows, branching, pull requests • Metadata-Driven Design – externalizing logic via config tables • Understanding of CI/CD concepts for deployment consistency • Familiarity with generative AI technologies and interest in applying AI to business intelligence • Experience managing and delivering cross-functional data projects • Excellent communication skills