Job Description

The purpose of this job is to provide technical expertise and direction for the development, implementation and support of Master Data Management (MDM) and data quality (DQ) platforms.

This position will require someone with:

* Associate or bachelor’s degree in computer science, business administration, information technology or related field preferred
* Five to seven years’ experience in master data solutions with a minimum of five years’ experience with data integration projects
* Expert T-SQL knowledge and skills required
* Intermediate knowledge of SSIS, SQL and Oracle RDBM solutions
* Knowledge of EBX5 preferred
* Knowledge of Java programming preferred
* PFJ institutional knowledge preferred
* Hands on experience with technical development and support for MDM and DQ technologies
* Experience with architecture, design and development of data integration solutions
* Strong experience with ETL development and database/SQL development/tuning, in particular for SQL Server
* Strong understanding of relational and dimensional database structures, theories, principles, and practices in relationship to business strategy and goals
* Sound understanding of MDM concepts
* Sound understanding of data modeling, data quality and data profiling
* Strong understanding of scripting languages
* Ability to resolve semantic discrepancies in data definitions that arise among multiple sources and projects

The basic duties of this position include:

1.Provide technical leadership and support for MDM platform, including solution architecture, inbound/outbound data integration (ETL), maintenance/tuning of match rules and exceptions, data model changes, incremental update execution and monitoring, and collaboration with infrastructure and data teams to maintain multiple environments. (development/test/production/sandbox)
2.Advise and provide support to data stewards, other system owners and technical personnel in MDM concepts and technical matters
3.Execute queries against MDM hub and other inbound/outbound databases as required
4.Collaborate with source systems data stewards and technical personnel for data governance and to resolve any data quality or technical issues related to data ingestion
5.Provide technical leadership and support for data quality (DQ) technology, including development, data profiling, and data quality assessments
6.Apply MDM technology for one-off data matching and cleansing efforts
7.Contribute to other data integration projects in the capacity of ETL Architecture/Analyst/Developer
8.Contribute to development projects related to big data
9.Mentor junior team members
10.Ensure all activities are in compliance with rules, regulations, polices, and procedures
11.Complete other duties as assigned


Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!

Apply Online