Data Reporting & Analytics Developer

Job Summary

We are seeking an experienced Data Reporting & Analytics Developer to join a State of Georgia modernization program. You will design, build, and maintain the reporting layer, data pipelines, and analytics products that support program operations, management decision-making, and mandated state and federal reporting.

This role sits at the intersection of data engineering and business intelligence. You will work directly with program staff and business analysts to turn operational data into dashboards, scheduled reports, and analytical datasets that stakeholders rely on.

Key Responsibilities

Design, develop, and maintain operational and analytical reports, dashboards, and data visualizations

Build and optimize ETL/ELT pipelines to move data from transactional systems into the data warehouse or reporting layer

Write, tune, and troubleshoot complex SQL — stored procedures, views, window functions, and performance-critical queries

Develop and maintain data models (star/snowflake schemas, dimensional models) supporting reporting and analytics

Produce recurring state and federal compliance reports, ensuring accuracy, completeness, and on-time delivery

Partner with business analysts and program staff to gather reporting requirements and translate them into technical specifications

Implement data quality checks, reconciliation logic, and validation rules across pipelines

Support ad-hoc data requests and analysis from program leadership

Document data definitions, lineage, business rules, and report specifications

Participate in code reviews, testing, and release activities

Troubleshoot data discrepancies across source systems and reporting outputs

Mandatory Qualifications

Professional experience in data reporting, business intelligence, or analytics development

Advanced SQL skills, including query optimization and performance tuning against large datasets

Hands-on experience with at least one enterprise BI/reporting tool: Power BI, Tableau, SSRS, Cognos, or MicroStrategy

Experience building and maintaining ETL/ELT processes using tools such as Informatica, SSIS, Talend, dbt, or equivalent

Working knowledge of relational databases — SQL Server, Oracle, PostgreSQL, or DB2

Experience with dimensional data modeling and data warehouse design principles

Demonstrated ability to gather reporting requirements directly from non-technical business stakeholders

Strong data validation, reconciliation, and quality-assurance practices

Experience with version control (Git) and collaborative development workflows

Excellent written and verbal communication skills

Desirable Qualifications

Experience on state or federal government projects

Experience producing federally mandated reports and understanding of associated compliance requirements

Cloud data platform experience — AWS (Redshift, Glue, Athena, S3), Azure (Synapse, Data Factory), or Snowflake

Python or R for data analysis, automation, or scripting

Experience with modern data stack tooling (dbt, Airflow, Fivetran)

Understanding of data governance, master data management, and data cataloging

Knowledge of PHI/PII handling and HIPAA-adjacent data privacy requirements

Experience with agile delivery methodologies

Bachelor's degree in Computer Science, Information Systems, Statistics, or a related field

Flexible work from home options available.