Technical Specialist - MDM

Ask IT consulting; Chicago (IL); On-site; USD 90,000 - 120,000; Full time

Job summary

Ask ITC Inc. in Chicago is seeking a Technical Specialist for Master Data Management to manage MDM repositories, data modeling, and ETL processes. You will work with data warehouse environments, Focusing on MDS, DQS, and related tools to ensure high data quality and governance.

Ideal candidates have hands-on experience with MSBI-like ETL/Reporting tools, Oracle and Unix scripting, and a track record of coordinating cross-functional teams for complex data projects in a large organization.

Qualifications

• Experience with MDM products and data governance.
• Strong SQL and data warehouse or data mart exposure.
• Familiarity with Oracle, Unix/Linux scripting is a plus.

Responsibilities

• Develop and maintain Master Data repositories across environments.
• Collaborate with data analysts to translate requirements into technical designs.
• Coordinate onsite/offshore teams for MDM implementations.
• Source new data via files, web services, or DB views for MDM entities.

Skills

MDM concepts

Data quality

Data modeling

ETL

Tools

MDS

DQS

DTS

Informatica

SSIS

SSRS

Job description

Ask ITC Inc. which is backed by a $500 million Microtek group company, provides an industry leading blend of technology, business consulting, and outsourcing services.

Ask IT is a minority-owed enterprise; it has been founded on providing the highest quality possible and on the devotion to customer satisfaction.

Job Description

Job Title: Technical Specialist- MDM

Location: Chicago IL

Job Description

• Master Data Management products (Master Data Services MDS, others), Data Quality tools (DQS), Data Modeling concepts and tools, Other ETL (DTS, Informatica etc.)
• Microsoft Business Intelligence (MSBI) – SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)
• Experience complex Master Data repositories and heterogeneous environments in a large organization (Preferably Retail)
• Experience implementing MDM solutions, working with data warehouses and/or data marts.
• Experience in Oracle - Strong SQL, PL/SQL, tuning, Unix/Linux Shell scripting
• Experience in SQL Server – Strong SQL (Complex Stored Procedures, Materialize View etc.), Tuning, Unix/Linux shell scripting (knowledge in Oracle is added advantage)
• Specializations in data modeling, data architecture, meta data management, and/or data governance. Experience working with Business Analyst/Users to translate functional requirements to technical design Experience in onsite/offshore coordination Responsibility New Market sources for existing data model entities and attributes representing additional population of people, locations, and suppliers. Sources may be landed in MDM via file, web service, and DB View
• New subscriptions to existing data model attributes via file, web service, DB View, LDAP update, or Oracle table update New business initiatives or new markets for previous initiatives that do not have an application source for master data and require a MDM UI to author their master data New business initiatives that require data model changes to accommodate new entities and attributes, new operational processes, new governance policies, new sources, and new subscriptions

Additional Information

Website: http://www.askitc.com/