Business Intelligence Developer

Job#: 2091110

Job Description:

Apex Systems is seeking a Business Intelligence Developer who can work remotely within the U.S. This role may involve occasional travel to Washington D.C. so a candidate located near there is preferred.

Summary:

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

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

Qualifications:

• Bachelor's degree and 8+ years of prior relevant experience
• 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
• 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

Preferred Qualifications:

• 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

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or .

Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico.

Apex Benefits Overview: Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our 'Welcome Packet' as well, which an Apex team member can provide.