Business Intelligence Developer

Our client is seeking a highly skilled Business Intelligence Developer to design, develop, and deliver enterprise-grade reporting, dashboards, and analytical solutions. This role leverages Power BI to provide actionable insights across the organization.

The ideal candidate brings a strong combination of technical BI proficiency, and the ability to translate complex business requirements into scalable, governed data and visualization solutions.

Key Responsibilities:

Data Integration

• Design and develop reporting solutions
• Build reusable semantic and data models to support enterprise analytics
• Collaborate closely with business stakeholders and Data Engineering teams on ETL/ELT processes and curated data layer integration

BI & Visualization Development

• Develop interactive dashboards and reports using Power BI
• Build executive level dashboards (Senior Leadership Team ready views, SLTready views)
• Develop operational dashboards across the enterprise
• Implement row level security (RLS) and role based access level security (RLS) and role based access
• Translate business KPIs into structured, reusable data models
• Partner with stakeholders to refine and standardize metrics
• Design and deliver cloud based BI solutions on Azure, leveraging Azure Data Lake, Azure SQL, and Power BI to enable scalable, secure analytics.
• Build and optimize semantic models and dashboards using Power BI, integrating data from Azure platforms with strong performance, governance, and cost efficiency.

Data Modeling & Architecture

• Design and implement star schemas for reporting and analytics
• Develop advanced DAX calculations and measures in Power BI
• Optimize report performance through query tuning and aggregation strategies
• Ensure data lineage, governance, and metric consistency
• Support Medallion architecture (Raw → Silver → Gold)
• Leverage Copilot and other LLM tools to enable self service analytics and reporting service analytics and reporting

Governance & Quality

• Perform data validation and reconciliation against source systems
• Implement and support data quality checks
• Support audit and regulatory reporting requirements
• Document data definitions, transformations, and business logic

Requirements:

Technical Skills:

• 5+ years of experience in BI / Data Analytics development
• Power BI (DAX, Power Query, data modeling)
• Strong SQL skills (complex joins, window functions, performance tuning)
• Experience with Azure, Data Lake, MS Fabric and SQL Server preferred
• Experience working with large datasets

Preferred Qualifications:

• Experience with ETL tools such as ADF, SSIS, Informatica, or similar
• Experience supporting AMS or modernization programs
• Familiarity with Data Governance and MDM concepts
• Experience supporting Digital / Transformation initiatives

Soft Skills:

• Strong stakeholder communication and collaboration skills
• Ability to work effectively with both business and technical teams
• Executive ready storytelling through dashboards and insights ready storytelling through dashboards and insights
• Detail oriented with a strong analytical mindset oriented with a strong analytical mindset
• Demonstrated ownership of outcomes, not just report development