Strategic BI Analyst: Power BI, SQL & Automation

Jobtailor; Lawrenceville (GA); On-site; USD 85,000 - 120,000; Full time

Job summary

Jobtailor is seeking a data analytics professional to drive advanced data analysis and build Power BI dashboards in support of operational and strategic decisions. You will validate data sources, present findings, and automate processes using Python, SQL, APIs, and JavaScript.

The role focuses on improving data quality, reliability, and performance across reporting systems, with collaboration across product and leadership teams. Expect a hands-on, cross-functional environment.

Qualifications

• Bachelor’s degree in data analytics, CS, IS, business, statistics, or related field or equivalent experience.
• 3+ years in data analysis, systems analysis, BI, or related technical role.
• Experience building dashboards in Power BI including data modeling, Power Query, and DAX.
• Experience querying, validating, and integrating data using SQL with relational databases.
• Experience developing scripts, applications, or automation using Python, JavaScript, APIs.
• Experience QA testing, documenting defects, and validating data and system functionality.
• Experience with Accela Civic Platform or similar local government systems.
• Strong customer-facing, presentation, documentation, and cross-functional collaboration skills.

Responsibilities

• Perform advanced data and business analysis to support operational and strategic decision-making.
• Validate data sources, calculations, and methodologies.
• Present findings in a clear, timely, and actionable format.
• Develop, maintain, and enhance Power BI dashboards, reports, and visualizations.
• Monitor reporting refresh performance, usage, and stakeholder feedback.
• Develop scripts, applications, reusable tools, and automation using Python, JavaScript, SQL, APIs, and other technologies.
• Reduce manual effort, improve data quality, and enhance operational efficiency.
• Advise Product Owners and departmental leadership on system configuration, data quality, reporting, performance, risks, and improvement areas.
• Prepare technical documentation and conduct demonstrations, training, and knowledge-sharing sessions.
• Maintain and enhance dashboards, integrations, scripts, and automation solutions for reliability, performance, security, and maintainability.
• Identify continuous-improvement opportunities in reporting, data management, system performance, quality assurance, and business processes.
• Recommend practical, data-informed solutions.

Skills

Data Analysis

Power BI Dashboard Development

SQL Querying

Python Scripting

APIs

JavaScript

Education

Bachelor’s degree in Data Analytics, CS, IS, Business, Statistics, or related field

Tools

Jira

SQL Server Management Studio (SSMS)

SharePoint

Teams

Visio

Excel

PowerPoint

Accela Civic Platform

Job description

Jobtailor is seeking a data analytics professional to drive advanced data analysis and build Power BI dashboards in support of operational and strategic decisions. You will validate data sources, present findings, and automate processes using Python, SQL, APIs, and JavaScript.

The role focuses on improving data quality, reliability, and performance across reporting systems, with collaboration across product and leadership teams. Expect a hands-on, cross-functional environment.