BI DEVELOPER

Job DescriptionThe BI Developer is responsible for the design, development, maintenance, and support of Microsoft Business Intelligence solutions, including dashboards, reports, data models, and data integrations.This role works closely with business stakeholders to transform data into actionable insights using the Microsoft BI stack, including Power BI, SQL Server, SSIS, SSRS, and Azure-based data services.The Microsoft BI Developer will also troubleshoot reporting issues, optimize performance, and ensure the accuracy and reliability of business intelligence solutions.ResponsibilitiesDesign, develop, and maintain interactive dashboards, reports, and scorecards using Microsoft Power BI.Build and maintain data models, datasets, and semantic layers to support enterprise reporting needs.Develop and optimize SQL queries, stored procedures, and database objects within Microsoft SQL Server.Create and maintain ETL processes using SQL Server Integration Services (SSIS) and other Microsoft data integration tools.Troubleshoot and resolve dashboard, report, data refresh, and performance issues.Monitor data quality and validate the accuracy and integrity of reporting outputs.Collaborate with business users to gather requirements and translate them into technical solutions.Design and implement KPI dashboards and executive-level reporting solutions.Support report deployment, security configuration, and user access management.Develop and maintain technical documentation, data dictionaries, and reporting standards.Perform routine maintenance, upgrades, and enhancements to existing BI solutions.Identify opportunities to automate manual reporting processes and improve operational efficiency.Provide end-user training and support for Power BI reports and dashboards.Stay current with Microsoft BI technologies, industry trends, and best practices.QualificationsBachelor’s degree in Computer Science, Information Systems, Data Analytics, Business Intelligence, or a related field.Equivalent combination of education and experience may be considered.3–5+ years of experience developing and supporting Microsoft BI solutions.Demonstrated experience building Power BI dashboards and reports.Experience working with enterprise data warehouses and large datasets.Experience troubleshooting and optimizing BI applications and reporting environments.Experience supporting professional services or law firm environments.Experience with financial, HR, payroll, billing, and operational reporting.Microsoft certifications related to Power BI, Azure, or SQL Server.Experience with cloud-based Microsoft data platforms.Technical SkillsAdvanced proficiency in SQL and database development.Strong experience with:Microsoft Power BIMicrosoft SQL ServerSQL Server Integration Services (SSIS)SQL Server Reporting Services (SSRS)Azure Data Factory (preferred)Experience with DAX, Power Query, and data modeling concepts.Knowledge of relational databases, data warehousing, and dimensional modeling.Familiarity with data governance, security, and compliance standards.Experience integrating data from ERP, HRIS, accounting, payroll, and other business systems.Skills and AbilitiesStrong analytical and problem-solving skills.Excellent communication and stakeholder management abilities.High attention to detail and commitment to data accuracy.Ability to manage multiple priorities and meet deadlines.Strong customer service orientation and responsiveness.