Data Integration Specialist D365
Garland - Miller Park Drive, United States
The Data Integration Specialist will drive / execute data migrations and make sure to:
Incorporate data from M&A companies in our state-of-the-art ERP environment, D365 Finance & Operations. This data will have to be collected, cleansed and imported into Microsoft Dynamics 365 using various tools and solutions, in close collaboration with Master Data Manager, Data Stewards, M&A Project Managers, ERP, CRM and BI specialists.
Contribute to the Data Quality Continuous Improvement initiatives
Responsibilities / Tasks
Create and enforce policies for effective data integration and ingestion
Write and maintain documentation of the data integration processes, data mappings and workflows
Map and integrate M&A master data to existing master data, being compliant with Corporate Master Data Management policies
Perform Data validation to ensure data consistency, accuracy, and completeness
Implement data quality checks and validation routines as part of the integration process
Create reports on data flow status, error logs, and integration performance
Integrate (Migrate) opening balances for GL, AP, AR, and Inventory
Clearly distinguish between full integrations of new legal entities and hybrid integrations of merging legal entities and set up and execute different dataflows accordingly
Coordinate data cleansing activities with Master Data Manager, Data Stewards
Execution of data cleaning activities assigned via our Service Desk ticketing system according to priorities
Functional leadership: Coach and steer data stewards in the full M&A Data Integration process
Manage M&A projects and code build versioning in DevOps
Build strong partnerships with colleagues at all levels, inside and outside the Data, Technology and Digital teams, as well as collaborating with other data experts across the entire organization.
Skills & Competencies
Excellent understanding of data administration and management functions (collection, analysis, distribution etc.)
Familiarity with modern database and information system technologies
Proficient in Microsoft Azure native tools, A.O. Azure Data Factory, Azure Synapse and Azure SQL
Prior work experience in IT incl. within the data area: 8 years
Proficient in Microsoft DevOps
Proficient in Microsoft Office – Excel
Functional knowledge in Microsoft Dynamics
A curious data enthusiast, analytical mindset and passion for problem-solving
Hands-on
Learning on the fly: open to change, enjoys challenges and finding solutions
Customer focus: establishes good connections with external and internal people and maintains good relationships with employees
Team player and create positive environment
Ability to work independently, prioritize tasks, and meet deadlines.
Adaptability to fast-changing business environments and priorities.
The requirements of the job will develop and change according to the needs of the business and the employee will be expected to adapt to these changes. This list is non-exhaustive, and the employee will be expected to carry out any tasks and duties for which he/she is trained for and/or has been assigned to.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Azure Data management Data quality DevOps Excel Finance SQL
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.