Design, implement and support Master Data Management (MDM) solutions, ETL and BI processes. Work with MDS/DQS, SSIS/SSRS, Oracle and SQL Server to integrate heterogeneous sources, model data, enforce governance, tune databases, and coordinate onsite/offshore teams.
Company Description
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
Ask IT Consulting Inc.| 33 Peachtree St., Suite 100 |Holtsville, NY 11742
Website: http://www.askitc.com/
Similar Jobs
Healthtech • Software • Analytics • Biotech • Pharmaceutical • Manufacturing
Leads process engineering for aseptic pharmaceutical filling operations, including process optimization, equipment troubleshooting, validation, yield improvement, CAPA, non-conformances, complaints, and change requests. Provides technical leadership for capital projects, introduces filling technologies, authors specifications and protocols, supports inspections and regulatory submissions, and partners with Manufacturing, Quality, Validation, Reliability Engineering, Supply Chain, suppliers, and contractors in a 24/7 manufacturing environment.
Top Skills:
Aseptic FillingAutocadCipClean UtilitiesFilling TechnologiesExcelMicrosoft PowerpointMicrosoft ProjectMicrosoft WordPlant UtilitiesPrecision Web HandlingSerializationSipSolidworksTension ControlThermal SealingVision Inspection SystemsVolumetric Dosing
Events • Food • Travel • Hospitality • Hotels & Resorts
Supervise overnight front office operations at Palmer House Hilton, leading team members through check-ins, check-outs, guest service, scheduling, task assignments, training, and shift meetings. Resolve guest concerns and escalated issues, monitor lobby flow, adjust staffing coverage, and complete night audits and balancing procedures while preparing operations for the next day.
Consumer Web • Coupons • Healthtech • Social Impact • Pharmaceutical
Analyze and optimize drug pricing using data-driven models, dashboards, reports, and strategic frameworks. Partner with Sales, Operations, Marketing, Finance, Product, pharmacy partners, and data teams to identify opportunities, define success metrics, improve reporting, and balance pharmacy economics with patient affordability. Serve as a trusted analytical advisor and support backend data development and query optimization.
Top Skills:
ExcelLookerPowerPointSQLTableau
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
