Senior MDM Engineer - Hybrid

Job Description

Job Description

Genesis10 is currently seeking a Senior MDM Engineer for a hybrid position (2-3 days onsite per week) with a Major Utility Company located in Dallas, TX. This is a 12- month contract opportunity.

In this role, you will own the match, merge, and survivorship rules for the client's transmission and distribution data. You will support and analyze data anomalies for source data originating in multiple environments including Data Warehouse, ODS, and Data Replication/ETL. You will collaborate closely with business users and the Data Management team to support complex data-related initiatives and assist in the setup and documentation related to Data Governance and Master Data Management solutions.

Responsibilities:

• Profile source data and measure data quality (completeness, uniqueness, validity and consistency)
• Define and tune match, merge, and survivorship rules in Ab Initio including thresholds, weights and exception handling in collaboration with data stewards
• Investigate data anomalies/issues reported by Business and root-cause duplicates and false merges, providing recommendations for mitigation and driving fixes upstream
• Build dashboards and reports on match accuracy, duplicate rate, MDM health, stewardship backlog, and business impact
• Configure and tune rules, deduplication routines, and survivorship criteria to ensure a single source of truth in data set
• Write requirements, mappings, and acceptance tests for MDM integrations
• Work with ETL, Replication and DBA teams to determine data transformations, data movement and derivations and document accordingly
• Work with Data Stewards on review queues; define unmerge and remediation processes
• Build and optimize data integration workflows connecting source systems to a centralized MDM hub
• Partner with analysts, data governance teams, and business stakeholders to implement master data management
• Support Data Governance functions such as definitions, ownership, documenting lineage, data standardization, and dictionary
• Work with support teams to ensure consistent and pro-active support methodologies are adhered to for all aspects of data movements and data transformations
• Assist in break fix and production validation as it relates to data derivations, replication and structures
• Ability to explain data problems to non-technical stakeholders

Requirements:

• 5 years in data analysis with 2 or more years in MDM or data quality
• Advanced SQL; hands-on data profiling and reconciliation is essential
• Previous experience working with Oracle Exadata and SQL Server databases
• Experience with an MDM platform (Ab Initio preferred)
• Extensive working knowledge of Data Governance, ETL, REST API development, OLAP and best practices for data tracking
• Ability to work in a team-oriented, fast-paced agile environment managing multiple priorities
• Strong attention to detail
• Ability to collaborate effectively and work as part of a team

Desired skills:

• Denodo experience
• Big Data experience (Hadoop, MongoDB)
• Postgres and Cloud experience
• Regulated Industry experience

Only candidates available and ready to work directly as Genesis10 employees will be considered for this position.

If you have the described qualifications and are interested in this exciting opportunity, please apply!

Ranked a Top Staffing Firm in the U.S. by Staffing Industry Analysts for six consecutive years, Genesis10 puts thousands of consultants and employees to work across the United States every year in contract, contract-for-hire, and permanent placement roles. With more than 300 active clients, Genesis10 provides access to many of the Fortune 100 firms and a variety of mid-market organizations across the full spectrum of industry verticals.

For contract roles, Genesis10 offers the benefits listed below. If this is a perm-placement opportunity, our recruiter can talk you through the unique benefits offered for that particular client. Benefits of Working with Genesis10:

• Access to hundreds of clients, most who have been working with Genesis10 for 5-20 years.
• The opportunity to have a career-home in Genesis10; many of our consultants have been working exclusively with Genesis10 for years.
• Access to an experienced, caring recruiting team (more than 7 years of experience, on average.)
• Behavioral Health Platform
• Medical, Dental, Vision
• Health Savings Account
• Voluntary Hospital Indemnity (Critical Illness & Accident)
• Voluntary Term Life Insurance
• 401K
• Sick Pay (for applicable states/municipalities)
• Commuter Benefits (Dallas, NYC, SF, and Illinois)

For multiple years running, Genesis10 has been recognized as a Top Staffing Firm in the U.S., as a Best Company for Work-Life Balance, as a Best Company for Career Growth, for Diversity, and for Leadership, amongst others. To learn more and to view all our available career opportunities, please visit us at our website.

Genesis10 is an Equal Opportunity Employer. Candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.