Senior Data Engineer and BI Developer

Data Engineering (~50%) Azure Data Factory, Logic Apps & Function Apps

• Design and build end-to-end data pipelines and ingestion workflows using Azure Data Factory, ensuring scalability, observability, and data quality at every stage.
• Develop and maintain serverless automation and event-driven integrations using Azure Function Apps and Logic Apps, including orchestration flows.
• Publish data to SharePoint Lists from ADF pipelines, using SharePoint Online REST APIs and OAuth authentication flows.
• Own infrastructure-as-code practices using Terraform, and drive CI/CD pipeline development and deployment automation through GitHub Actions and Harness.
• Integrate Azure AI Services and Azure OpenAI into data workflows - including document intelligence, embeddings, semantic search, and AI-assisted data enrichment.
• Architect/Manage analytical workloads within Azure Synapse Analytics, including Lakehouse patterns, and Spark-based transformations.
• Maintain continuity of existing pipelines and ongoing maintenance work.

BI Development (~50%) Power BI

• Design, build, and maintain Power BI reports, dashboards, and semantic data models that translate raw and curated data into actionable business insight.
• Develop and optimize DAX measures, calculated columns, and data model relationships to support self-service and executive-level reporting.
• Manage Power BI datasets, gateways, and refresh schedules, ensuring data in reports stays current and reliable.
• Partner with business stakeholders to gather reporting requirements and translate them into intuitive, well-governed dashboards.
• Apply row-level security and workspace governance best practices within the Power BI Service.

You will also bring a strong working knowledge of AI and machine learning platforms, including Azure AI Services and Azure OpenAI, to help the organization move from data delivery toward intelligent, insight-driven automation.

Experience with Microsoft Fabric is a plus., * Around 10 years of combined experience across data engineering and BI development, with a strong focus on cloud-native solutions.

• Expert-level experience with Azure Data Factory, Logic Apps, and Function Apps - reflecting roughly half of the role’s day-to-day work.
• Intermediate-level Power BI developer skills, including building and maintaining reports, dashboards, and data models - reflecting the other half of the role.
• Practical experience publishing data to SharePoint Lists from ADF pipelines, including familiarity with SharePoint Online REST APIs and OAuth authentication flows.
• Proven experience with infrastructure-as-code using Terraform, and CI/CD platforms such as GitHub Actions and Harness.
• Demonstrated experience integrating Azure AI Services or Azure OpenAI into data pipelines or platform workflows, including working with REST-based AI APIs, prompt engineering, embeddings, or AI-assisted data processing.
• Strong proficiency in SQL and at least one data-oriented programming language, with Python preferred given its centrality to AI and ML integration work.
• Hands-on expertise with Azure Synapse Analytics.
• Experience with Microsoft Fabric is a nice to have.

• 401(k)
• Dental insurance
• Health insurance
• Paid time off
• Vision insurance