Senior Business Intelligence Developer

About the Role: We are urgently seeking a Senior Business Intelligence (BI) Developer to join our team onsite at our Concord, USA facility. This is a 100%-dedicated, immediate-hire position supporting the Concord site’s local data and BI deliverables. The ideal candidate will design, develop, and maintain enterprise-grade Power BI dashboards, Databricks Lakehouse solutions, and AI-powered self-service analytics within a GMP-regulated manufacturing and pharmaceutical environment. The role requires a strong command of Azure data services, SQL, DAX, Power Query (M), and emerging AI/ML tools (Claude, Copilot, Databricks Genie). You will be the primary BI technical resource for the Concord site, working directly with local SMEs and cross-functional stakeholders to drive data-driven decision-making and digital transformation. The Senior BI Developer will serve as the primary local technical resource — enabling local BI adoption, supporting GMP-compliant reporting, and helping the site leverage cutting-edge AI/ML and self-service analytics tools. Responsibilities: Power BI Report & Dashboard Development • Design, build, and maintain Power BI reports and dashboards aligned to enterprise BI standards and GMP compliance requirements. • Create and replicate GMP (Good Manufacturing Practices) reports from other sites; develop non-GMP reports for local Concord site-specific needs. • Implement DAX measures, calculated tables, and row-level security (RLS); optimize report performance and data refresh cycles. • Apply Power Query (M) transformations and advanced data modeling techniques (star schema, composite models) for scalable analytics. Databricks Lakehouse & Data Engineering • Develop and maintain staging, refined, and analytical data layers within the Databricks Lakehouse architecture (Unity Catalog). • Write and optimize complex SQL queries, CTEs, window functions, views, and stored procedures on Databricks SQL and Azure SQL Server. • Troubleshoot and resolve connectivity issues across Power BI, Databricks, Denodo, and SQL Server environments. • Create and maintain stored procedures, functions, tables, views, triggers, jobs, and data backups. AI-Powered & Self-Service Analytics • Design, build, and maintain Databricks Genie agents and natural-language query spaces for end-user self-service analytics. • Curate semantic models, example queries, and business glossaries to ensure accurate, governed AI responses. • Leverage AI-powered development tools (Claude, GitHub Copilot, Databricks AI features) to accelerate SQL optimization, report development, and data profiling. • Evaluate emerging AI/ML capabilities relevant to BI and manufacturing analytics; support configuration of NLQ interfaces for business users. • Develop and deploy AI applications integrated with Azure ecosystem; experience with MCP connectors and Agentic AI Architecture preferred. Data Integration & ETL • Design, develop, and implement Data Integration (DI) processes to extract, transform, and load data from diverse sources for analytical needs. • Leverage Azure Data Factory (ADF) and Azure Databricks pipelines for end-to-end ETL orchestration. • Ensure data quality, lineage, and governance compliance within Azure Data Lake and Databricks Unity Catalog. GMP Documentation & Validation • Create test protocols, test scripts, and other validation deliverables per GMP regulatory requirements. • Provide comprehensive documentation for reports, dashboards, data models, and custom solutions. • Maintain audit-ready documentation in compliance with pharma/manufacturing quality standards. Stakeholder Support & Knowledge Transfer • Provide technical support to local Concord end users on BI reports and dashboards. • Conduct knowledge-transfer sessions; create user guides and training materials for non-technical stakeholders. • Collaborate with local SMEs to ensure DI and BI deliverables meet site-specific business requirements. Required Skills: Strong command of Azure data services, SQL, DAX, Power Query (M), and emerging AI/ML tools (Claude, Copilot, Databricks Genie). Preferred Skills: Experience with MCP connectors and Agentic AI Architecture preferred.