Senior BI Developer: AI-Driven Analytics & GMP Dashboards

Aligned Automation Services Pvt Ltd | Contract Senior BI Developer Concord, United States | Posted on 05/06/2026 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. Key Responsibilities 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. Enterprise Power BI dashboards (GMP & non-GMP) deployed and adopted by Concord site users. Databricks Lakehouse data layers (staging, refined, analytical) operational and optimized. Databricks Genie self-service analytics spaces with curated semantic models and business glossaries. AI-powered BI workflows integrated with Azure ecosystem (Claude, Copilot, Genie). ETL/DI pipelines via Azure Data Factory fully documented and running in production. GMP test protocols, validation scripts, and audit-ready documentation. User guides, training materials, and knowledge-transfer sessions delivered to local SMEs. Requirements Must-Have Hard Skills AI Tools: Claude API, GitHub Copilot, Databricks AI Azure Databricks & Databricks SQL (Unity Catalog) Advanced SQL (CTEs, Window Functions, Stored Procedures) Power BI Row-Level Security (RLS) & Governance Must-Have Soft Skills Strong analytical & problem-solving mindset Ability to translate complex data into actionable business insights Clear written & verbal communication with non-technical stakeholders Collaborative mindset with cross-functional teams Self-starter – able to work independently onsite with minimal supervision Attention to detail (critical in GMP-regulated environment) Stakeholder management & requirements gathering Time management & ability to prioritize multiple deliverables Good-to-Have Hard Skills MCP Connectors & Agentic AI Architecture Manufacturing / Pharmaceutical domain knowledge Prompt Engineering for LLM-based applications Experience with Fabric / Microsoft OneLake SSRS, SSAS, or other legacy BI platforms Good-to-Have Soft Skills Experience in regulated (GMP/FDA) manufacturing environments Experience conducting formal training / KT sessions Ability to mentor and coach junior BI developers Comfortable presenting findings to senior leadership Proactive mindset – identifies gaps and proposes solutions Adaptability to evolving AI/ML tool landscape #J-18808-Ljbffr Aligned Automation, LLC