Data Reporting & Analytics Developer

Role Description

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

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

Benefits

• Flexible work from home options available