Business Intelligence Developer

Looking for an experienced Business Intelligence Developer to join a growing professional services organization specializing in enterprise data solutions and analytics. This role offers the opportunity to design and optimize key reporting tools that impact decision-making across multiple business functions.

Role Overview

The BI Developer will lead the development, maintenance, and enhancement of interactive dashboards, reports, and data models to support enterprise-wide analytics. This position requires a deep technical understanding of data integration, visualization, and database management within a complex, fast-paced environment.

Key Responsibilities

• Design, develop, and maintain dynamic dashboards, reports, and scorecards using Power BI, ensuring they meet stakeholder requirements.
• Build and optimize data models, datasets, and semantic layers to facilitate accurate and efficient enterprise reporting.
• Develop complex SQL queries, stored procedures, and database objects within Microsoft SQL Server to support reporting and analytics needs.
• Create, implement, and troubleshoot ETL workflows utilizing SQL Server Integration Services (SSIS) and related Microsoft data integration tools.
• Troubleshoot and resolve data visualization, report, and data refresh issues while enhancing report performance and reliability.
• Conduct data validation and quality checks to ensure reporting accuracy and data integrity across multiple systems.
• Collaborate closely with business users to gather reporting requirements and translate them into scalable technical solutions.
• Design and deploy KPI dashboards and executive-level reports tailored for strategic decision-making.
• Manage report deployment processes, security configurations, and user access rights to ensure compliance and data security.
• Document technical solutions, create data dictionaries, and establish reporting standards for ongoing maintenance and scalability.
• Perform routine system upgrades, updates, and enhancements to existing BI platforms.
• Identify automation opportunities for manual report processes to increase operational efficiency.
• Provide end-user training and ongoing support for Power BI dashboards and reports.
• Stay current with Microsoft BI solutions, cloud platforms, and industry best practices to continuously improve BI offerings.

Core Qualifications & Requirements

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Business Intelligence, or related field (or equivalent combination of education and experience).
• 3–5 years proven experience developing and supporting Microsoft BI solutions in enterprise environments.
• Demonstrated expertise in building Power BI dashboards, reports, and data models.
• Strong background working with large datasets, enterprise data warehouses, and relational databases.
• Proven troubleshooting and performance tuning skills for BI applications and reporting tools.
• Experience supporting professional services, legal, or law firm environments preferred.
• Familiarity with financial, HR, payroll, billing, and operational reporting.
• Industry-recognized Microsoft certifications related to Power BI, Azure, or SQL Server are highly desirable.
• Experience working with cloud-based Microsoft data tools and platforms.

Technical Skills

• Advanced SQL development, including writing complex queries, stored procedures, and database optimization
• Power BI, Power Query, DAX, and data modeling techniques
• Microsoft SQL Server, SSIS, SSRS, Azure Data Factory (preferred)
• Data warehousing, dimensional modeling, relational databases
• Data governance, security, and compliance standards
• Integration of data from enterprise systems like ERP, HRIS, accounting, and payroll platforms

Skills and Abilities

• Strong analytical, problem-solving, and troubleshooting skills
• Excellent communication and stakeholder management capabilities
• High attention to data accuracy and detail orientation
• Ability to manage multiple priorities and meet deadlines efficiently
• Customer service focus with responsiveness to user needs