Senior Developer of Business Intelligence

Overview:

The Senior Developer Business Intelligence designs and delivers reliable, scalable business intelligence solutions that translate operational, financial, customer, and organizational data into information that supports business decisions. This senior individual contributor leads BI initiatives from requirements discovery through data modeling, report development, deployment, user adoption, and continuous improvement. The role requires advanced Power BI and SQL expertise with strong dimensional modeling, stakeholder partnership, and practical working knowledge of Microsoft Fabric.

Position based remotely anywhere in the continental US.

Responsibilities:

• Lead end-to-end business intelligence delivery, from requirements discovery and source assessment through data modeling, development, testing, deployment, documentation, adoption, and support.
• Develop and maintain high-quality Power BI dashboards, reports, scorecards, and semantic models using sound visual design, reusable DAX measures, Power Query transformations, appropriate security, and performance optimization.
• Write, tune, validate, and troubleshoot SQL across enterprise data sources; design dimensional models and reconcile reporting outputs to governed source data.
• Establish and maintain BI development standards for the team, in coordination with technical leadership, covering data quality, testing, deployment, version control, documentation, workspace organization, refresh monitoring, and ongoing support.
• Partner with business and technical stakeholders to define requirements, metrics, acceptance criteria, priorities, risks, and release expectations, translating complex needs into sustainable BI solutions.
• Analyze trends, variances, and performance drivers, and communicate concise findings and recommendations to technical and nontechnical audiences.
• Provide technical guidance, peer review, and mentoring to analysts and developers while remaining an active hands-on contributor. This position does not have direct supervisory responsibilities.

Qualifications:

• Bachelor’s degree in business intelligence, data analytics, computer science, information systems, statistics, mathematics, business, engineering, or a related discipline, or equivalent relevant experience.
• Five or more years of progressively responsible experience in business intelligence, analytics engineering, reporting, or related roles, including ownership of cross-functional BI deliverables.
• Advanced Power BI development skills, including dashboards, reports, semantic models, DAX, Power Query, security, refresh management, and performance optimization.
• Advanced SQL and dimensional modeling: Strong SQL development and troubleshooting skills, with experience designing star schemas, validating source-to-report logic, and working with large enterprise datasets.
• End-to-end BI delivery: Proven ability to lead requirements, design, development, testing, deployment, documentation, adoption, and production support with appropriate quality controls.
• Stakeholder partnership and communication: Ability to translate business needs into clear requirements and metrics, manage priorities and risks, and communicate technical concepts and analytical findings to varied audiences.
• Working knowledge of Microsoft Fabric: Familiarity with core Fabric concepts and the ability to become productive quickly in Lakehouse, Warehouse, pipeline, notebook, OneLake, and Power BI integration scenarios.

Preferred Qualifications

• Hands-on experience delivering Microsoft Fabric solutions using Lakehouse or Warehouse, OneLake, Data Factory pipelines, notebooks, SQL endpoints, and governed workspaces.
• Python, notebooks, REST APIs, JSON, XML, Power Automate, or similar tools for analytics automation, data preparation, validation, and integration.
• SSRS, Power BI Report Server, paginated reporting, subscriptions, or migration from legacy reporting platforms to Power BI or Fabric.
• Git or comparable version control, peer review, automated or repeatable testing, deployment pipelines, and Agile or iterative delivery practices.
• Experience with data governance, metadata, lineage, certified datasets, access controls, or regulated and confidential data.
• Practical experience with approved AI-enabled analytics capabilities, including validation of AI-generated SQL, DAX, summaries, or recommendations against governed data.
• Experience delivering analytics in complex operational or regulated indus…