Business Intelligence Developer

Business Intelligence Developer

Department: Information Technology 

Location: Remote

Role Type: Contract (6-months with possibility for extension and fulltime)
 

About Our Client
A long-standing leader in providing technology-driven solutions to federal government customers, this organization is known for delivering mission-critical IT services and consulting across diverse industries. With nationwide operations and a focus on supporting public sector clients, the company values innovation, collaboration, and integrity while advancing technology capabilities for complex environments.

Job Description
We are seeking a Business Intelligence Developer to spearhead development and delivery of critical reports and dashboards to business clients within the Federal Government. In this role, you will utilize your experience with Microsoft Power BI and other Microsoft reporting and analytic tools in a cloud-based environment to help customers meet their data needs.

The role will focus on working directly with key stakeholders to understand requirements, reengineering existing reports, supporting data governance, and implementing advanced reporting capabilities. You will collaborate with analysts, data engineers, and architects to ensure data quality, enhance performance, and provide innovative insights that make a direct impact on federal operations.

Duties and Responsibilities
• Work directly with key stakeholders to understand data needs, document report requirements, provide user support
• Design, develop, and implement operational and analytic reports, visualizations, dashboards, and data extracts utilizing Microsoft Power BI and other query tools
• Reengineer existing Power BI and SSRS reports and dashboards to source data from Azure data lake, Synapse Analytics, and Azure SQL Managed Instance
• Analyze current ETL logic and data sources such as SQL Server databases and SSAS cubes to understand required data transformations
• Analyze report performance and implement performance tuning, including visual components, DAX queries, Power Query, data model, caching to deliver high performance reports
• Utilize Azure cloud data services such as data lake (ADLS), data warehouse, Synapse Analytics, and Analysis Services, to design and develop optimal reports to meet user needs
• Collaborate with other team members including business analyst, data modeler, data architect, and data engineers to support design and implementation of data models and data transformations for Power BI reports
• Design, develop, and implement processes and functions to ensure data quality in reports and analytics
• Support Power BI administration tasks, including workspaces, access controls, apps, gateway and cloud data source connections, monitoring reports usage, monitoring and tuning utilization of compute and storage capacity
• Ensure alignment with data governance policies, processes, and procedures
• Incorporate AI/ML techniques and functions (e.g. Power BI Copilot) to enhance data processing and reporting
• Assist the Help Desk with problem and incident management
• Assist with end user training
• Actively support Agile DevOps process, including Program Increment planning
• Actively engage in continuous learning to increase relevant skills

Required Experience/Skills
• Bachelor’s degree and 8+ years of prior relevant experience
• At least 4 years of demonstrated experience delivering reports, visualization, and analytics using Power BI, to include Power BI Cloud Service, Power BI desktop, Power BI Report Server
• At least 4 years of experience working directly with business end users to understand requirements, develop reports, and provide ongoing support
• Experience with the Microsoft Business Intelligence Stack (Power BI, SSAS, SSRS, and SSIS)
• Experience tuning reports performance including optimizing DAX, Power Query, data models
• Experience with SQL databases (OLTP, OLAP), flat file (e.g. excel) data sources, multi-dimensional models, TSQL, DAX/MDX, Power Query
• Understanding of reports development using Azure based data services (Synapse Analytics)
• Experience in Agile projects, working with a multi-functional team
• Strong analytical capabilities with proven problems solving skills
• Must be detail oriented, and able to support multiple projects and tasks
• Demonstrate continuous learning to increase relevant skills
• Ability to work well in a team environment and/or work alone with limited supervision
• Ability to successfully obtain a government-issued Public Trust clearance

Nice-to-Haves
• Experience working on Federal government projects
• Experience delivering reports in the law, HR, financial management, inventory, property, management domains
• Power BI and Microsoft Azure data analytics related certifications
• Experience supporting data governance
• Experience with Design Thinking and Human Centered Design, and persona-driven solutions

Education
Bachelor’s degree required

Pay & Benefits Summary

• Pay rate up to 59/h W2

Keywords
Business Intelligence | Power BI | Azure | Synapse Analytics | Data Visualization | Federal Government | SSRS | SSAS | SQL | ETL | Remote