The Jefferson County Commission is seeking a Business Intelligence (BI) Reporting Analyst to transform complex data into clear, actionable insights through impactful visualizations and reporting, supporting data-driven decision-making across the organization.
Requirements
- 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 working with SQL Server development.
- Experience in business analysis.
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.
Other
- Experience leading projects, collaborating with cross-functional teams, and providing training and support to end users on Business Intelligence reporting tools and processes.
- 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.
- Job is primarily sedentary involving sitting for long periods of time, but may involve occasional walking or standing for brief periods.
- May involve occasional light lifting of items or objects weighing up to 25 lbs.
- Work is conducted almost exclusively indoors in an office setting.
