ERP Data Analyst jobs in United States
cer-icon
Apply on Employer Site
company-logo

Atlas · 1 day ago

ERP Data Analyst

Atlas is a nationwide leader in civil engineering and consulting services, seeking an ERP Data Analyst to join their team. The role involves leading data migration efforts, defining data standards, and providing analysis to ensure data quality and consistency within the Atlas Data Lakehouse.

ConstructionConsultingDeliveryEnvironmental ConsultingEnvironmental EngineeringInformation Technology
check
H1B Sponsor Likelynote

Responsibilities

Lead end-to-end data migration efforts for acquired and legacy companies by analyzing, extracting, transforming, loading, and validating data from source ERP systems into Deltek Vantagepoint
Own and define data migration standards, including source-to-target mappings, transformation logic, validation rules, and reconciliation approaches
Develop and maintain comprehensive migration documentation to track progress, support repeatable processes, and ensure auditability
Partner with business stakeholders and end users to facilitate discovery sessions, understand system usage, and identify data dependencies, edge cases, and historical context
Analyze legacy and third-party ERP systems to determine how source data aligns to the Vantagepoint data model, recommending data remediation or conversion strategies where gaps exist
Provide data analysis and subject-matter expertise to initiatives within the Atlas Data Lakehouse, ensuring consistency between ERP data, analytical models, and reporting outputs
Proactively identify data quality risks and migration issues, escalating and advising on resolution strategies to ensure successful system cutovers

Qualification

Data analysisData migrationMicrosoft SQL ServerERP systemsData mappingData validationRelational data modelsTransformation logicBusiness stakeholder engagementDocumentation

Required

Bachelor's degree in Computer Science, Information Systems, Business, Accounting, or a related field, or equivalent practical experience
5+ years of experience in data analysis, data migration, or system integration roles supporting enterprise systems
Demonstrated experience migrating or integrating data between ERP or large-scale business systems
Strong understanding of relational data models, data quality principles, and data validation techniques
Experience working directly with business stakeholders to gather requirements and translate business processes into data solutions
Advanced proficiency with Microsoft SQL Server, including complex queries, views, stored procedures, and performance troubleshooting
Hands-on experience supporting ERP platforms, preferably Deltek Vantagepoint and/or Deltek Vision, including understanding of core functional data domains (projects, billing, labor, finance)
Strong experience with data mapping, transformation logic, and source-to-target documentation for system migrations
Ability to analyze complex relational data models and translate legacy system structures into target ERP schemas
Experience validating migrated data through reconciliation, exception analysis, and data quality checks
Proven ability to document technical processes, data mappings, and migration runbooks in a clear and repeatable manner

Preferred

Experience with Deltek Vantagepoint or similar professional services ERP platforms
Exposure to acquisitions or legacy system migrations
Familiarity with financial, project, or operational data (e.g., projects, labor, billing, GL)
Experience documenting data mappings, transformation logic, and migration runbooks
Knowledge of modern data platforms or lakehouse architectures

Benefits

Health
Dental
Vision
Life
AD&D
Voluntary life / AD&D
Disability benefits
Leaves of absence
401k
Paid time off
Paid holidays
Employee assistance program
Educational assistance program

Company

Atlas

twittertwittertwitter
company-logo
Atlas Technical Consultants (Atlas) provides professional testing, inspection, engineering, environmental and consulting services nationwide.

H1B Sponsorship

Atlas has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (3)
2024 (7)
2023 (1)
2022 (4)
2020 (1)

Funding

Current Stage
Public Company
Total Funding
$145M
Key Investors
Blackstone Credit
2023-01-31Acquired
2020-02-18Post Ipo Equity· $145M
2020-02-18IPO

Leadership Team

leader-logo
Giuseppe Robbiano
Chief Information Officer
linkedin
leader-logo
Sarah Hilty
Chief Legal Officer
linkedin
Company data provided by crunchbase