Data Reporting Analyst

Strategic Mindz LLC; Atlanta (GA); On-site; USD 90,000 - 120,000; Full time

Job summary

Strategic Mindz LLC is seeking a Data Reporting Analyst to design, build, and maintain the reporting layer, data pipelines, and analytics products supporting operations and mandated reporting. The role sits at the intersection of data engineering and business intelligence, translating operational data into dashboards and reports for stakeholders.

The ideal candidate has advanced SQL skills, hands-on BI tool experience (Power BI/Tableau/SSRS/Cognos/MicroStrategy), and strong data modeling

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 enterprise BI/reporting tools: Power BI, Tableau, SSRS, Cognos, or MicroStrategy.
• Experience building and maintaining ETL/ELT processes using Informatica, SSIS, Talend, dbt, or equivalent.
• Relational databases knowledge: SQL Server, Oracle, PostgreSQL, or DB2.
• Experience with dimensional data modeling and data warehouse design principles.
• Ability to gather reporting requirements from non-technical stakeholders.
• Strong data validation, reconciliation, and QA practices.
• Experience with Git and collaborative development workflows.
• Excellent written and verbal communication skills.

Responsibilities

• Design, develop, and maintain operational and analytical reports, dashboards, and data visualizations.
• Build and optimize ETL/ELT pipelines to move data into the data warehouse or reporting layer.
• Write, tune, and troubleshoot complex SQL and performance-critical queries.
• Develop and maintain data models supporting reporting and analytics.
• Produce recurring state and federal compliance reports with accuracy and timeliness.
• Gather reporting requirements from non-technical stakeholders and translate into specs.
• Implement data quality checks, reconciliation logic, and validation rules.
• Support ad-hoc data requests and analysis for 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 outputs.

Skills

Advanced SQL

BI/Analytics

Stakeholder liaison

Data modeling

Validation & QA

Git version control

Education

Bachelor's degree in CS/IS/Stats or related field

Tools

Power BI

Tableau

SSRS

Cognos

MicroStrategy

Informatica

SSIS

Talend

dbt

SQL Server

Oracle

PostgreSQL

DB2

Job description

Data Reporting Analyst

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 on Healthcare Industry.
• 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