Note: The job is a remote job and is open to candidates in USA. ITR Group is seeking a Senior Data Analyst to support a large-scale Finance data modernization initiative. The role involves validating and reconciling data during the migration from legacy systems to a modern Google Cloud Platform data platform, ensuring data integrity and quality throughout the process.
Responsibilities
- Validate and reconcile data between legacy and modern Finance platforms during parallel operations
- Develop complex SQL queries and datasets to identify data variances and ensure data integrity
- Build dashboards and reports that highlight data quality, reconciliation results, and variance trends
- Partner with Product Managers, Engineers, Finance, and Business teams to investigate data discrepancies, determine root causes, and document business-approved resolutions
- Create reconciliation reports, exception reports, validation summaries, and business sign-off documentation
- Analyze data mappings, transformation logic, data lineage, and business rules to ensure accurate migration
- Support Go-Live readiness by helping define acceptable data variance thresholds and providing actionable insights to stakeholders
- Participate in Agile ceremonies, backlog refinement, and cross-functional collaboration
Skills
- 5+ years of experience in a Data Analyst or similar analytics role
- Advanced hands-on SQL experience with large-scale data platforms such as Google BigQuery, Hadoop, or similar technologies
- Experience building and maintaining ETL/data pipelines using tools such as Dataproc, Airflow, Dataform, dbt, or comparable technologies
- Strong Python and/or PySpark experience for data movement, transformation, and analysis
- Experience with reporting and visualization tools including Power BI, Looker, and LookML
- Strong expertise in: Data validation and reconciliation, Source-to-target data mapping, Data quality analysis, Duplicate and exception detection, Audit/control total validation, Business rule validation
- Ability to interpret mapping documents, transformation logic, reporting requirements, and data lineage
- Excellent communication skills with experience collaborating across Engineering, Product, Finance, and Business teams
- 1–3 years working within Agile delivery teams
- Experience supporting enterprise retail organizations
- Knowledge of finance, merchandising, inventory, supply chain, sales, digital, or customer data domains
- Experience with Google Cloud Platform (GCP) and Medallion Data Architecture
- Familiarity with SAP S/4HANA finance data structures and reporting
- Experience supporting enterprise data modernization or cloud migration initiatives
Benefits
- Medical, dental, and 401(k) for eligible employees
Company Overview