Performance Data Engineer providing data modeling expertise and engineering a cloud - based Data Lakehouse platform. Support Federal agency ETL applications with ongoing development and maintenance responsibilities.
About the role
- Data Migration Consultant responsible for migrating various data types into Microsoft Dynamics 365 CE. Analyze structures, develop mapping documentation, and ensure data integrity during migration.
Responsibilities
- Analyze source system data structures, including customer profiles, accounts, vehicles, transponders, payment methods, transactions, violations, invoices, and billing records
- Identify critical data relationships, parent/child hierarchies, and foreign key dependencies
- Develop detailed data mapping and transformation documentation from source systems to Dynamics 365 CE entities (standard and custom)
- Build, test, and execute ETL pipelines using tools such as SSIS/KingswaySoft, Azure Data Factory, Power Platform Dataflows, or custom .NET utilities
- Perform data cleansing, normalization, deduplication, and standardization to meet Dynamics CE data model requirements
- Execute multiple migration cycles, including test loads, validation, and final production migration
- Ensure referential integrity, high data quality, and accuracy of historical data
- Generate reconciliation reports, resolve data inconsistencies, and troubleshoot migration errors
- Document migration strategies, execution runbooks, and transformation rules for future reference
Requirements
- 8-12 years of proven experience migrating data from tolling systems, transportation platforms, legacy CRMs, or other high-volume transactional systems
- Strong SQL skills for complex queries, stored procedures, data transformation, and data validation
- Hands-on experience with Microsoft Dynamics 365 CE / CRM data model, entities, and relationships
- Proficiency with ETL/migration tools: SSIS with KingswaySoft, Azure Data Factory, Power Platform Dataflows, Custom C#/.NET migration scripts
- Experience with large-scale migrations involving millions of records
- Strong understanding of relational data structures such as: Customer ⇄ Account ⇄ Vehicle ⇄ Transponder ⇄ Transaction
- Ability to analyze large datasets, identify anomalies, and resolve inconsistencies
- Bachelor’s degree in engineering or a bachelor’s degree in technology from a recognized university
Benefits
- Equal opportunity employer
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Manager for Data & AI team at Valorem Reply focused on modern data platforms with Microsoft technologies. Leading technical direction and collaborating with clients on data governance frameworks.
Manager of Data & AI team focused on building modern data platforms using Microsoft technologies. Collaborating with clients and team members for successful delivery and governance.
Senior Staff Data Engineer at DeepL working on enterprise - wide data engineering standards and cloud solutions. Leading technical initiatives and mentoring engineers to support data capabilities across the organization.
Data Engineer contributing to advanced analytics and machine learning solutions in aviation at Boeing. Collaborating within a data science team to produce industry - leading insights and build cloud - based tools.
Data Engineer designing and maintaining scalable data solutions in GCP and Snowflake environments. Collaborating with clients and stakeholders to ensure data quality and functionality.
Data Architect leading data architecture and engineering projects within GCP and Snowflake environments for AI consulting company. Collaborate with clients to define data strategies and guide implementation teams.
Senior Data Engineer optimizing scalable data pipelines at Matrix for the Brazilian energy market. Involved in ETL processes and data architecture design with a collaborative team environment.
Implementation Engineer guiding customers in data architecture and integration solutions at MotherDuck. Collaborating with teams and leading technical discussions to ensure customer success.
Data Engineer/Senior Data Engineer developing scalable ETL/ELT pipelines and architecting data systems at Manulife. Collaborating with data professionals to ensure data quality and compliance.