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
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Lead federal cloud security and compliance efforts to achieve and sustain ATOs. Implement and automate FedRAMP/IL-5/RMF controls, manage continuous monitoring, coordinate 3PAO audits, drive cloud security architecture, oversee change control/SCRs, and lead incident response and POA&M remediation using AI-enabled automation and monitoring across high-security GovCloud environments.
Top Skills:
Ai AutomationAws GovcloudCC++Ci/CdEndpoint SecurityFedrampFismaIl-5JavaScriptLlmNist Sp 800-53PythonRmfSIEMVulnerability Management
Artificial Intelligence • Cloud • Internet of Things • Software • Cybersecurity • Industrial
Lead technical owner for Global Parts Pricing roadmap; design scalable analytics, integration, cloud, automation, and AI solutions; guide POCs, mentor architects, ensure governance, and align technology with business goals.
Top Skills:
APIsAWSAws BedrockDataikuDevOpsETLInfrastructure-As-CodePower AutomatePower BIPythonSnowflakeSnowflake CortexSQL
Artificial Intelligence • Cloud • Internet of Things • Software • Cybersecurity • Industrial
Develop and maintain Python data pipelines and CI/CD deployments to build business data objects supporting applications. Implement source-to-target mappings, unit and integration testing, resolve complex technical issues, and uphold software quality and best practices across the Data Engineering team.
Top Skills:
Amazon RdsAmazon S3Aws CloudformationAws CloudwatchAws EventbridgeAws FargateAws IamAws KinesisAws LambdaAws SagemakerAzure DevopsCi/CdClaude CodeDynamoDBGenai Developer ToolsGitGithub ActionsGithub CopilotJenkinsPythonSnowflake
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
