Note: The job is a remote job and is open to candidates in USA. Dahl Consulting is partnering with a leading national retailer undergoing a large-scale finance modernization initiative. The Data Analyst – Finance Data Platform role focuses on ensuring data integrity during migration from legacy systems to a modern Google Cloud Platform environment by validating, reconciling, and reporting data. The analyst will collaborate with product, engineering, and business teams to identify variances and support Go-Live decisions during a parallel operation period.
Responsibilities
• Develop queries and datasets to validate legacy versus modern application data and identify variances
• Build reports using end-user visualization tools to present variances and trends between source systems
• Document data variances and root causes in collaboration with Product Managers, Engineers, and Business Teams, and obtain business sign-off for known variances
• Build dashboards to monitor data variance trends for stakeholders and help determine tolerance thresholds for Go-Live decisions
• Partner with cross-functional teams to support the modernization of Finance applications and the two-quarter parallel operation period
• Contribute to a collaborative agile delivery environment, participating in sprint ceremonies, defect triage, and iterative delivery cycles
Skills
• 5+ years of hands-on SQL experience with big data platforms/databases such as Google BigQuery, Hadoop, or similar
• Senior-level experience with ETL and data pipeline tools such as Dataproc, Airflow, Dataform, dbt, or similar
• Solid experience with Python/PySpark coding for data movement and analysis
• Experience with data visualization and reporting tools such as Power BI, Looker, and LookML for dashboard development, KPI reconciliation, semantic layer validation, and data analysis
• Strong background in data analysis, data validation, source-to-target reconciliation, duplicate detection, reject/error validation, audit/control total validation, and business rule validation
• Ability to analyze mapping documents, reporting requirements, transformation logic, data lineage, and data quality rules
• Experience creating reconciliation reports, validation summaries, exception reports, defect logs, and business sign-off documentation
• Strong communication and collaboration skills with the ability to work closely with engineering, product, finance, business, and legacy system teams
• 5+ years working in a data analytics role
• 1–3 years of experience working in an agile team
• Prior retail industry experience, particularly working with large enterprise data in finance, supply chain, merchandising, inventory, stores, sales, digital, product, or customer domains
• Experience working with Google Cloud Medallion Data Layer and GCP-supported data processing tools
• Familiarity with SAP S/4HANA data structure and finance domain report building experience
• Experience working in agile delivery environments, including user stories, acceptance criteria, sprint ceremonies, defect triage, and iterative delivery
Benefits
• Dahl Consulting is proud to offer a comprehensive benefits package to eligible employees that will allow you to choose the best coverage to meet your family’s needs. For details, please review the DAHL Benefits Summary: https://www.dahlconsulting.com/benefits-w2fta/.
Company Overview
• Dice offers a marketplace that enables direct connections between recruiters and technologists. It was founded in 1990, and is headquartered in Centennial, Colorado, USA, with a workforce of 201-500 employees. Its website is https://www.uk.dice.com.
Company H1B Sponsorship
• Dice has a track record of offering H1B sponsorships, with 2 in 2022, 4 in 2021, 5 in 2020. Please note that this does not guarantee sponsorship for this specific role.