Senior Data Analyst (SQL/ETL)

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

• Hybrid onsite (flexible) - Minneapolis, MN

Seeking a Senior Data Analyst to support a major Finance application modernization and data platform migration to a modern Google Cloud Platform (GCP) environment.

This role will focus on data validation, reconciliation, variance analysis, reporting, and dashboard development as legacy Finance applications operate in parallel with modern platforms. You will work closely with engineering, product, Finance, business, and legacy-system teams to identify data discrepancies, determine root causes, document findings, and support critical Go-Live decisions.

The ideal candidate is highly hands-on, analytical, and comfortable working through complex or ambiguous data problems independently. Strong candidates can explain not only what they did, but how they approached a problem and why they made specific technical decisions.

What You’ll Do

• Develop complex SQL queries and datasets to compare legacy and modern application data and identify variances.
• Perform data validation, reconciliation, duplicate detection, reject/error validation, audit/control-total validation, and business-rule validation.
• Analyze mapping documents, transformation logic, reporting requirements, data lineage, and data-quality rules.
• Investigate data discrepancies and collaborate with Product, Engineering, Finance, and Business teams to determine root causes.
• Document identified variances, root causes, resolutions, and accepted exceptions.
• Develop reconciliation reports, exception reports, validation summaries, defect logs, and business sign-off documentation.
• Build dashboards and visualizations that communicate data variances, trends, KPIs, and reconciliation results.
• Establish and monitor data-variance trends and assist stakeholders in determining appropriate tolerance thresholds for Go-Live decisions.
• Use Python/PySpark for data analysis, processing, and data movement.
• Work with ETL and data-pipeline technologies to understand and validate data transformations.
• Participate in an Agile delivery environment, including user stories, acceptance criteria, sprint ceremonies, defect triage, and iterative delivery.
• Support approximately two quarters of parallel operation between legacy and modern platforms.

Required Qualifications

• 5+ years of hands-on SQL experience working with large-scale data platforms/databases such as Google BigQuery, Hadoop, or similar technologies.
• 3+ years of experience with ETL/data pipeline tools, such as Airflow, Informatica, dbt, or similar technologies.
• Hands-on experience with Python and/or PySpark for data analysis and data processing.
• Experience with data visualization and reporting tools such as Power BI, Looker, and/or LookML.
• Strong experience with:
  • Data validation and reconciliation
  • Source-to-target comparison
  • Variance detection and root-cause analysis
  • Duplicate and reject/error validation
  • Audit and control-total validation
  • Data quality analysis
• Ability to analyze and interpret data mappings, transformation logic, reporting requirements, data lineage, and data-quality rules.
• Experience creating reconciliation reports, exception reports, validation summaries, defect documentation, and business sign-off materials.
• 5+ years of experience in a data analytics role.
• 3+ years of experience working in an Agile environment.
• Strong communication and collaboration skills with technical and non-technical stakeholders.

This is a highly visible data quality and modernization initiative. Your analysis will help ensure that Finance data is accurately transitioned from legacy applications to the modern GCP-based platform and will provide stakeholders with the information needed to make informed Go-Live decisions.

ITR Group offers a competitive compensation and benefits package, including medical, dental, and 401(k) for eligible employees. The W2 pay range for this type of role is approximately $62.00 - 82.00 per billable hour. This range is an estimate and not a guarantee of compensation. The final rate will be determined by factors such as experience, market trends, and specific job assignments. Discover more about how ITR Group connects top talent with leading client opportunities.

ITR Group is an Equal Opportunity Employer. We do not discriminate against applicants on the basis of their race, color, national origin, religion, creed, disability, age, sex, sexual orientation, gender identity, marital status, familial status, or status with regard to public assistance, or membership or activity in a local human rights commission.