Meriton is a national team of experts driving HVAC innovation through a network of high-performing companies. From strategy and support to systems and solutions, we work behind the scenes to strengthen operations and build value—for our partners and our people. If you’re looking to make an impact, we’re glad you’re here.

At Meriton, you’ll join a team that believes in big ideas, doing great work, and building careers that matter—every step of the way. Job Title: Data Analyst Reports To: Data Migration Lead FLSA Status: Exempt Location: Shared Services Office, Irving, TX Summary: Project Ignite is a large-scale enterprise transformation program uniting 20+ operating companies onto a single Microsoft Dynamics 365 Finance & Operations and Project Operations platform.

Requirements

This Data Analyst role will support a multi-wave enterprise transformation program by helping prepare, assess, map, validate, and migrate data for D365 Finance & Operations (PMA) and D365 Project Operations deployments connected via dual-write. This is a role for a candidate with a strong foundation in SQL, solid business or MIS education, and hands-on experience with reporting or analytics tools. The analyst will work alongside Business Systems Analysts, Data Migration Leads, Solution Architects, Integration Engineers, and business stakeholders to translate source data into migration-ready, auditable, and reusable outputs.

The role will aid analysis, data mapping, system assessment, and readiness planning.

Translate business rules, legacy field usage, and entity-specific process differences into clear mapping logic, transformation rules, and documented

. Partner with business stakeholders to understand how source data is created, maintained, and used operationally, then assess fit against target-state

For later go-live waves, own the data workstream for one OpCo covering extraction, analysis, assessment, mapping, offline migration activities, issue resolution follow-up, and stakeholder communication. Contribute to standard templates and reusable practices so that later waves are faster, more consistent, and less dependent on one-off decisions. Delivery & Cross-Functional Collaboration Work closely with BSAs, Solution Architects, Integration Engineers, QA, and business SMEs to support testing, mock conversions, cutover planning, and hypercare activities.

Track open issues, risks, assumptions, dependencies, and status updates for assigned scope; escalate blockers early and communicate clearly with affected stakeholders. Coordinate any offline migration activities for the assigned workstream, including file preparation, validation, handoff timing, and business communications. Support UAT and dress-rehearsal cycles by validating data outcomes, tracing defects, documenting findings, and confirming remediation steps.

Based on demonstrated capability and program need, the role may also support or own pipelines, ETL procedures, and selected Microsoft Fabric assets or orchestration components used for migration, transformation, or reporting.

Responsibilities

: Data Assessment and Deployment Readiness Profile legacy/source data, assessing source-system readiness, and identifying data dependencies, gaps, and quality issues for upcoming deployment waves. Use SQL to extract, join, validate, compare, and reconcile datasets from source systems, staging files, and target structures. Build and maintain source-to-target mapping workbooks, data-quality issue logs, reconciliation workpapers, and extraction inventories.

Support repeatable migration playbooks, file-governance standards, naming conventions, and handoff procedures that can scale across multiple OpCos.