Personnel Board of Jefferson County · 4 hours ago
Business Intelligence Reporting Analyst – Jefferson County (On-Site)
The Personnel Board of Jefferson County is seeking a motivated Business Intelligence Reporting Analyst for an On-Site position within the Information Technology Services (ITS) Department. This role is responsible for the complete BI development process, including data sourcing, preparation, analysis, modeling, and report design utilizing SQL, Power BI, and other BI tools to drive data-driven decision-making.
Human ResourcesRecruitingTraining
Responsibilities
Designs, develops, and maintains interactive dashboards and reports using Power BI and SQL, transforming complex data into visually intuitive, actionable insights that support business decision-making
Sources, cleanses, integrates, and manages data from multiple systems, including data warehouses, cloud platforms, flat files, vendor feeds, spreadsheets, and web APIs, ensuring accuracy and completeness
Creates and maintains scalable, efficient data models that support both standard reporting and ad hoc analytics, ensuring data integrity and optimal report performance
Monitors data pipelines and report outputs to ensure data accuracy, reliability, and timeliness; proactively troubleshoot and resolve data discrepancies and technical issues
Continuously optimizes the performance of reports and dashboards through query tuning, model refinement, and visualization best practices to ensure quick load times across all devices
Conducts in-depth, ad-hoc analyses to address critical business questions, identify trends and anomalies, and provide actionable insights and recommendations to leadership
Partners with business users and cross-functional teams to gather requirements, define KPIs, ensure reporting solutions meet business needs, and convert legacy reports (e.g., SSRS) to BI platforms
Develops and maintains BI documentation, create user guides, and provide training and ongoing support to promote self-service analytics and data literacy across the organization
Qualification
Required
Experience working with programming languages and relational databases (e.g., T-SQL, SQL, Python, VB.NET, C++, Java) to analyze, transform, and manipulate complex data for business intelligence and reporting purposes
Experience administering Business Intelligence (BI) and Enterprise Resource Planning (ERP) systems, including managing user permissions, maintaining data integrity, mapping data sources, and supporting system operations
Experience analyzing and translating business requirements to interactive Business Intelligence reports and dashboards
Experience performing data analysis and manipulation
Experience leading projects, collaborating with cross-functional teams, and providing training and support to end users on Business Intelligence reporting tools and processes
Preferred
Bachelor's degree in Business Intelligence, Data Analytics, Business Analytics, Information Systems, Computer Science, Data Science, or related field
Experience in business analysis
Experience working with SQL Server development
Benefits
Medical and dental insurance
Employer-sponsored retirement plan (pension)
Generous paid holidays
Sick and vacation leave
More