Lead Business Intelligence Report Developer

Lead Business Intelligence Report Developer

About the role

This role provides operational, technical, and thought leadership to the Business Intelligence Developers (Report Developers). It involves development of SSRS, PowerBI, and other reporting tools in alignment with business requirements.

Responsibilities

• Review documented report specifications, clarify requirement ambiguity, develop report output, and unit test the reports to ensure data accuracy.
• Work with internal customers, IT staff, and other stakeholders to define or refine requirements for business intelligence and reporting initiatives.
• Maintain and track the progress of reports assigned to the report development team.
• Coordinate code reviews to ensure reports are developed efficiently and in line with development standards.
• Consult the Enterprise Data & Reporting Manager on project prioritization, vendor management, and resource allocation.
• Encourage and support team collaboration, and coordinate knowledge sharing among the report development team.
• Work with Business Intelligence Analysts, internal customers, and external consulting teams to understand reporting requirements.
• Support QA and UAT testing as assigned.
• Support and train business users on reports and overall HUB data content.
• Ensure reporting solution development is documented in accordance with Data and Reporting Team standards.
• Design, develop, test, and deploy Power BI reports, dashboards, and datasets aligned with business requirements.
• Build and maintain Power BI semantic models using best-practice dimensional modeling (facts, dimensions, star schemas) in line with architectural standards.
• Develop complex DAX measures, calculated columns, and performance-optimized visuals.
• Use Power Query (M) to extract, transform, and cleanse data from the Hub and other source systems.

Qualifications

• 8+ years’ experience in SQL Development, and SQL Server Reporting Services (SSRS).
• 5+ years’ knowledge in Microsoft SQL Server, Visual Studio, Microsoft SSIS, Microsoft SSRS, and Azure DevOps.
• Strong experience developing visualization dashboards and paginated reports using PowerBI.
• Experience utilizing Microsoft Fabric.
• Experience in integration and deployment across multiple environments.
• Analytical, results-driven, and able to employ the right approach and methods to make the maximum use of time and resources.
• Excellent interpersonal, creative, and communication skills that allow effective, proactive working relationships in a team-oriented environment.
• Ability to multitask and prioritize, and able to complete tasks on set budgetary parameters and targets.
• Knowledge/experience with SQL queries and Business Intelligence concepts.
• Strong analytic skills.
• Strong attention to detail.
• Able to build and maintain relationships and facilitate collaboration and communication.
• Able to work independently and collaborate with people at all levels.
• Ability to positively engage, self-motivate, and possess a strong desire to learn.

Benefits

Everforth Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans. Additionally, we provide an ESPP (employee stock purchase program), a 401K program with a company match after 12 months of tenure, and a Health Savings Account (HSA) on the HDHP plan. The company also offers a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program, and other discounts. Professional development includes an on-demand training program, access to certification prep, a library of technical and leadership courses/books/seminars, and certification discounts and perks for associations such as CompTIA and IIBA. Everforth Apex has a dedicated customer service team for benefits and other resources, and a certified Career Coach is available.

Equal Opportunity Employer

Everforth Apex is committed to providing equal employment opportunities and does not discriminate or allow discrimination based on 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.