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
Fintech • Healthtech • HR Tech • Information Technology • Financial Services • Telehealth
Provides empathetic phone and chat support to families navigating loss, disability leave, and other difficult life events. Responsibilities include creating care plans, researching resources and service providers, answering logistical questions, documenting interactions, meeting service levels, escalating sensitive issues, maintaining knowledge resources, and sharing user insights. The role requires independent work, strong communication, organization, problem-solving, adaptability, and comfort with technology and sensitive data.
Top Skills:
Google SuiteSlackZendesk
Artificial Intelligence • Cloud • Internet of Things • Software • Cybersecurity • Industrial • Industrial Equipment
Performs data gathering, mining, processing, modeling, and customer analytics on large datasets. Applies NLP, text analysis, machine learning, and statistical methods to identify customer needs and generate business insights. Develops and optimizes algorithms, presents findings to management through data visualization, and supports requirements analysis and data-driven decision-making. The role also involves AI agent development, cloud technologies, version control, and Agile collaboration.
Top Skills:
AgileAmazon BedrockAWSData VisualizationDatabase SystemsGitGithub CopilotGCPLangchainMachine LearningAzureNatural Language ProcessingNumpyPandasPythonScipy
Artificial Intelligence • Cloud • Internet of Things • Software • Cybersecurity • Industrial • Industrial Equipment
Develops Python data pipelines and business data objects for applications. Designs, implements, tests, and deploys software and CI/CD pipelines, performs source-to-target mapping, resolves complex technical issues, and promotes software quality practices. The role requires collaboration across functional teams, independent execution of complex assignments, and experience with cloud platforms, Snowflake, version control, and AI coding tools.
Top Skills:
Amazon CloudwatchAmazon DynamodbAmazon EventbridgeAmazon KinesisAmazon RdsAmazon S3Amazon SagemakerAws CloudformationAws FargateAws IamAws LambdaAzure DevopsCi/CdClaude CodeGitGithub 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
