Senior Data Analyst - SQL/ETL, Hybrid (Minneapolis)

ITR Group; Minneapolis, Saint Paul (MN, MN); Hybrid; USD 85,000 - 113,000; Full time

Benefits offered by this job

Medical Insurance

Dental Insurance

401(k)

Job summary

ITR Group is seeking a Senior Data Analyst to support a Finance modernization project and data-platform migration to Google Cloud Platform. The role focuses on data validation, reconciliation, variance analysis, reporting, and dashboard development as legacy and modern systems run in parallel.

You will collaborate with Engineering, Product, Finance and Business teams to identify data discrepancies, document findings, and support Go-Live decisions.

Qualifications

• 5+ years hands-on SQL in large-scale data platforms (BigQuery, Hadoop, etc.)
• 3+ years ETL/data pipeline tool experience (Airflow, Informatica, dbt)
• Python and/or PySpark for data analysis
• Experience with Power BI/Looker/LookML for dashboards
• Strong data validation, reconciliation, root-cause analysis, and data-quality skills
• 5+ years in a data analytics role and 3+ years in Agile environments
• Excellent communication and collaboration with technical and non-technical stakeholders

Responsibilities

• Develop complex SQL queries to compare legacy and modern data and identify variances
• Perform data validation, reconciliation, duplicate detection, and audit/control-total validation
• Analyze mappings, transformation logic, reporting requirements, data lineage, and data-quality rules
• Investigate data discrepancies and collaborate with cross-functional teams to determine root causes
• Document variances, root causes, resolutions, and exceptions
• Develop reconciliation and exception reports and sign-off documents
• Build dashboards and visualizations communicating variances, trends, and KPIs
• Establish and monitor data-variance trends for Go-Live decisions
• Use Python/PySpark for data analysis and data movement
• Work with ETL/data-pipeline tech to validate transformations
• Participate in Agile delivery with user stories and sprint ceremonies
• Support ~2 quarters of parallel operation between legacy and modern platforms

Skills

SQL

Python

PySpark

Data Visualization

BigQuery/Hadoop

Agile

Communication

Tools

Airflow

Informatica

dbt

Power BI

Looker

LookML

Job description

ITR Group is seeking a Senior Data Analyst to support a Finance modernization project and data-platform migration to Google Cloud Platform. The role focuses on data validation, reconciliation, variance analysis, reporting, and dashboard development as legacy and modern systems run in parallel.

You will collaborate with Engineering, Product, Finance and Business teams to identify data discrepancies, document findings, and support Go-Live decisions.