IBM MDM ARCHITECT

ArchitectArchitectFull TimeRemoteMid LevelTeam 1,001-5,000

Location

United States

Posted

49 days ago

Salary

0

Seniority

Mid Level

Job Description

IBM MDM ARCHITECT

OTSI

This is a remote position. Object Technology Solutions, Inc (OTSI) has an immediate opening for an IBM MDM ARCHITECT IBM MDM ARCHITECT (REMOTE ) MAJOR RESPONSIBILITES: · Own data quality, matching logic, and golden record creation · Strong experience in Master Data Management (MDM) · Hands-on with: · Matching & deduplication strategies · Golden record creation · Experience tuning: · False positives / false negatives · Knowledge of: · Phonetic matching (Soundex, etc.) · Data quality rules · Key Responsibilities · Define and tune matching algorithms · Identify and fix: · Duplicate records · Data inconsistencies · Work with business teams to: · Define matching rules · Handle edge cases · Validate new data sources and ingestion logic · Define data quality metrics & SLAs · Good to Have · Experience with tools like: · Informatica MDM / Reltio / IBM MDM · Exposure to SQL QUALIFICATIONS AND EXPERIENCE · The right fit is looking for IBM MDM (virtual) guy who is able to move on-prem MDM to cloud with kubernetes and they would need Java knowledge · Conduct comprehensive reviews of the current MDM ecosystem, including matching and linking algorithm performance, duplicate and suspect processing, and custom extensions. · Evaluate and enhance logging, monitoring, backup, and recovery processes to ensure system reliability and resiliency. · Assess and optimize transaction/query SLAs and index performance, identifying and addressing known issues such as bucket overflows and bulk-load mechanism gaps (including DataStage constraints). · Design, develop, and maintain Java code for MDM algorithms, data processing, and integration components, ensuring code is performant, scalable, and maintainable. · Refactor and optimize existing Java code, and write unit, integration, and system tests for all Java components. · Adjust matching algorithm thresholds to minimize false positives/negatives and add/test new matching attributes (e.g., email + last name, phone combinations). · Assess and implement phonetic matching techniques (e.g., Soundex), and lead feasibility studies to determine the need for single or multi-algorithm approaches for different business lines. · Perform sample pairing for new data sources, collaborating with business teams to identify edge cases and refine algorithm behavior, including store-identifier-based auto-matching where applicable. · Review and enhance frequency-based and dynamic bucketing strategies, assess passive execution options to minimize production impact, and validate interactions with STR tables and existing buckets. · Develop and document bulk load strategies, including ingestion options with and without entity management/event handlers; explore disabling matching for high-volume ingestion scenarios (e.g., 200M+ records) and evaluate alternative ingestion patterns beyond API-only approaches. · Capture and report on metrics, SLAs, and trade-offs for each ingestion strategy. · Target <2 seconds for matching response time through iterative tuning, must-gather data analysis, and leveraging load testing tools (e.g., JMeter); review reconciliation SLAs as part of ongoing optimization. · Address deployment challenges such as outages and unpredictable environment behaviors; explore and implement CICD or improved deployment automation; review and optimize configuration, code, and deployment steps for efficiency. · Plan and implement Auth/PingFed-based authentication, reduce reliance on process IDs and passwords, automate credential rotation, and maintain a dedicated 'Security' category in the scope documentation. · Ensure all code adheres to coding standards and guidelines. SKILLS AND ABILITIES REQUIRED · Java 21 (core and advanced), including object-oriented programming and multithreading · Master Data Management (MDM) platforms and tools · Algorithm development for data matching, linking, and deduplication (including phonetic algorithms like Soundex) · Data integration frameworks and ETL tools (e.g., DataStage) · SQL and database optimization (indexing, query tuning, bulk operations) · Performance tuning and system health monitoring for large-scale data systems · Logging, monitoring, backup, and recovery solutions · Load testing tools (e.g.,JMeter) · CI/CD pipeline tools and deployment automation (e.g., Jenkins, GitHub) · Secure coding practices, including Auth authentication and credential management · Micro services API development and integration (e.g., RESTful services) · Unit, integration, and system testing frameworks (e.g., JUnit, Mockito) · Documentation tools (Confluence, GitHub, DX Guides) · MDM Modernization · Migration from on-premises infrastructure to the cloud · Adoption of containerization for deployment and scalability

Related Categories

Related Job Pages

More Architect Jobs

Role Description Serve as a Pharmacy Lead responsible for leading the design, configuration, and optimization of Oracle Health Millennium pharmacy applications and workflows across Claritev client engagements. This role ensures safe medication practices, seamless EHR-pharmacy integration, and operational efficiency by aligning clinical, technical, and regulatory needs into scalable pharmacy solutions. Job Roles and Responsibilities - Lead the architecture, design, and configuration of pharmacy applications and medication management workflows. - Translate pharmacy operational requirements into system and integration specifications. - Design and optimize workflows related to medication ordering, dispensing, administration, and reconciliation. - Support formulary management, medication dictionaries, order sets, and clinical decision support. - Partner with integration teams to ensure pharmacy interoperability with EHR, dispensing systems, and automation tools. - Oversee validation, testing, and optimization of pharmacy system changes and new implementations. - Collaborate with pharmacy directors, clinicians, and technical teams to ensure regulatory compliance and medication safety. - Provide go-live leadership, issue resolution, and stabilization support post-deployment. - Mentor pharmacy analysts and contribute to governance, standardization, and best practices across Claritev programs. Qualifications - Minimum of +10 years combined related work experience, including: - At least 5 years of experience in healthcare information technology (HCIT) consulting or other client-facing IT roles. - An additional 2 years of work experience directly related to the duties of the job. - Bachelor's Degree required. - Knowledge and experience with Oracle Health pharmacy applications: Medication Manager, Product Manager, Bedrock, Olympus, PHADBTools, etc. - Experience in HCIT system design and build. - Experience in workflow and technology assessment. - Experience with integration between clinical and revenue cycle applications. - Strong presentation skills and ability to communicate complex information to operations, financial, and application teams. - Travel up to 50% will be required for this role. Requirements - The salary range for this position is $100-125K. Specific offers take into account a candidate’s education, experience, and skills, as well as the candidate’s work location and internal equity. - This position is also eligible for health insurance, 401k, and bonus opportunity. Benefits - Medical, dental and vision coverage with low deductible & copay. - Life insurance. - Short and long-term disability. - Paid Parental Leave. - 401(k) + match. - Employee Stock Purchase Plan. - Generous Paid Time Off – accrued based on years of service. - WA Candidates: the accrual rate is 4.61 hours every other week for the first two years of tenure before increasing with additional years of service. - 10 paid company holidays. - Tuition reimbursement. - Flexible Spending Account. - Employee Assistance Program. - Sick time benefits – for eligible employees, one hour of sick time for every 30 hours worked, up to a maximum accrual of 40 hours per calendar year, unless the laws of the state in which the employee is located provide for more generous sick time benefits. EEO Statement Claritev is an Equal Opportunity Employer and complies with all applicable laws and regulations. Qualified applicants will receive consideration for employment without regard to age, race, color, religion, gender, sexual orientation, gender identity, national origin, disability or protected veteran status. Application Deadline We will generally accept applications for at least 5 calendar days from the posting date or as long as the job remains posted.

United States
$100K - $125K / year
AgileEngine logo

Data Architect ID52062

AgileEngine

AgileEngine is an Inc. 5000 company that creates award-winning software for Fortune 500 brands and trailblazing startups across 17+ industries. We rank among the leaders in areas like application development and AI/ML, and our people-first culture has earned us multiple Best Place to Work awards.

Architect49 days ago
Full TimeRemoteTeam 1,001-5,000

AgileEngine is an Inc. 5000 company that creates award-winning software for Fortune 500 brands and trailblazing startups across 17+ industries. We rank among the leaders in areas like application development and AI/ML, and our people-first culture has earned us multiple Best Place to Work awards. WHY JOIN US If you're looking for a place to grow, make an impact, and work with people who care, we'd love to meet you! ABOUT THE ROLE As a Cloud Data Architect, you’ll lead the design of a next-generation AWS data platform from the ground up — building the Medallion Lakehouse architecture that will become the unified data foundation for the entire organization. This is a greenfield opportunity for a senior architect who wants genuine ownership: shaping ingestion patterns, governance frameworks, and scalable data models across S3, Redshift, Glue, dbt, and Airflow. WHAT YOU WILL DO - Lead design and implementation of enterprise data architecture following Medallion framework; - Develop data models, pipelines, and schemas for data unification, governance, and analytics; - Build and optimize AWS-based data infrastructure using core services; - Implement Lakehouse architecture integrating structured and unstructured data; - Ensure performance, scalability, and cost efficiency of the data ecosystem; - Design and oversee data ingestion from multiple on-prem and cloud systems; - Define integration strategies using batch, streaming, and event-driven patterns; - Collaborate with governance teams to enforce data security, access control, and quality; - Work with engineering and business teams to deliver scalable data solutions; - Support data platform modernization initiatives and roadmap execution; - Document architecture, standards, and data flows for diverse audiences. MUST HAVES - 8+ years of experience in data engineering or architecture; - 5+ years of experience working with AWS data ecosystems; - Expertise with AWS core services (S3, Glue, Redshift, Lambda, Athena, Kinesis, EMR); - Experience with data integration tools (dbt, Step Functions, Airflow, AWS DMS, Kafka, Kinesis); - Strong knowledge of data modeling (Medallion/Lakehouse, dimensional modeling, Data Vault, Kimball); - Experience with infrastructure as code (Terraform, CloudFormation); - Proficiency in Python, SQL, and Spark (PySpark) for ETL; - Strong understanding of data governance, quality, and security; - Experience with enterprise-scale architecture and data integration; - Upper-intermediate English level. PERKS AND BENEFITS - Professional growth: Mentorship, TechTalks, and personalized growth roadmaps. - Competitive compensation: USD-based pay with education, fitness, and team activity budgets. - Exciting projects: Modern solutions with Fortune 500 and top product companies. - Flextime: Flexible schedule with remote and office options.

Argentina
Full TimeRemoteTeam 10,001+Since 1833H1B Sponsor

It’s More Than a Career, It’s a Mission. Our people are the foundation of our success. By joining our growing team at Sarah Cannon Research Institute (SCRI), a subsidiary of McKesson, you will have the opportunity to become part of one of the largest community-based cancer programs to advance oncology treatments and improve outcomes for cancer patients across the globe. We look for mission-driven candidates who have a desire to advance the fight against cancer and make a difference in the lives of patients diagnosed with cancer every day. Our Mission People who live with cancer – those who work to prevent it, fight it, and survive it – are at the heart of every decision we make. Bringing the most innovative medical minds together with the most passionate caregivers in their communities, we are transforming care and personalizing treatment. Through clinical excellence and cutting-edge research, SCRI is redefining cancer care around the world. As a Lead Data Architect, you will play a pivotal role in driving our database strategy across all products. This role demands a profound expertise in data architecture to analyze, design, and implement complex systems ensuring robust, scalable solutions that support our business goals. Your expertise will ensure that our data infrastructure is robust, scalable, and aligned with our mission, enabling us to harness the power of data to improve healthcare delivery and support our ongoing commitment to clinical research and our patients. Job Responsibilities: - Responsible for designing, building, and managing the organization's data infrastructure. - Create the blueprint for how data is collected, stored, processed, and used, ensuring it's accessible, reliable, and secure. - Design the structure and systems that allow the organization to effectively manage and use its data, ensuring it is a valuable asset for decision-making and business operations. - Create and maintain documentation for database architecture, procedures, and standards. Key Responsibilities: - Data Strategy: Develop and implement a comprehensive data strategy aligned with business goals. This involves understanding the organization's data needs and creating a roadmap for effective data management. - Data Modeling: Design conceptual, logical, and physical data models that represent the structure and relationships of data within the organization. - Data Architecture: Create and maintain the overall data architecture framework, including databases, data warehouses, data lakes, and other data systems. - Data Mapping: Develop and implement data mapping rules to transform data from source systems to target systems, ensuring data accuracy and consistency. - Data Integration: Design and implement processes for integrating data from various sources, ensuring data consistency and accuracy. - Data Governance: Establish data governance policies and procedures to ensure data quality, security, and HIPPA compliance across all data systems and platforms. - Technology Evaluation: Evaluate and recommend data management technologies and tools to support the organization's data needs. - Problem Solving: Identify and resolve data-related issues, ensuring data integrity and reliability. - AI Solutions: Design and implement architectures that seamlessly integrate AI models and algorithms with existing data infrastructures, including cloud-native and legacy systems. - Collaboration: Work closely with stakeholders, including business analysts, data scientists, and IT professionals, to understand data requirements and translate them into technical solutions. Influence projects to make decisions related to data strategies including data quality, data architecture and data management best practices Minimum Job Qualifications: - Minimum of 7 years of experience in enterprise data architecture, including data requirements collection, data architecture analysis, evaluation, documentation, data modeling, design, development, model validation, and data integration in modern data platforms (e.g., Azure, Databricks, Snowflake). - Bachelor’s Degree in Computer Science, Information Systems, Engineering, or equivalent experience. Critical Skills: - Minimum 10 years of experience in database engineering/management required. - Knowledge of software development methodologies (e.g., Agile, DevOps, SDLC, CI/CD, GitHub). - 7+ years' experience working with data sources (e.g. APIs) and databases such as Oracle, PostgreSQL, SQL Server, and cloud databases. - Knowledge of cloud technologies like Azure (Data Factory, Databricks), AWS. - Strong knowledge of industry best practices — code coverage. - Strong knowledge of database concepts, data modeling techniques, system performance analysis and tuning, and data warehousing concepts. - Knowledge of various operating systems such as Linux, Unix, and Windows. - Ability to write complex queries and perform advanced database operations using SQL. Preferred Skills: - Expertise in modern cloud-native database solutions - Experience with database migration tools and strategies, including handling zero-downtime migrations and data synchronization - Proficiency in infrastructure-as-code and automation tools (Terraform) for database deployment and management. - Ability to design scalable database architectures that support microservices and distributed systems - Experience with various database patterns (CQRS, event sourcing, sharding strategies) - Understanding of data modeling for both relational and NoSQL databases About Sarah Cannon Research Institute Sarah Cannon Research Institute (SCRI) is one of the world’s leading oncology research organizations conducting community-based clinical trials. Focused on advancing therapies for patients over the last three decades, SCRI is a leader in drug development. In 2022, SCRI formed a joint venture with former US Oncology Research to expand clinical trial access across the country. It has conducted more than 850 first-in-human clinical trials since its inception and contributed to pivotal research that has led to the majority of new cancer therapies approved by the FDA in the past decade. SCRI’s research network brings together more than 1,300 physicians who are enrolling patients into clinical trials at more than 200 locations in 20+ states across the U.S. Please click here to learn more about our research offerings. We care about the well-being of the patients and communities we serve, and that starts with caring for our people. That’s why we have a Total Rewards package that includes comprehensive benefits to support physical, mental, and financial well-being. Our Total Rewards offerings serve the different needs of our diverse colleague population and ensure they are the healthiest versions of themselves. For more information regarding benefits through our parent company, McKesson, please click here. As part of Total Rewards, we are proud to offer a competitive compensation package. This is determined by several factors, including performance, experience and skills, equity, regular job market evaluations, and geographical markets. In addition to base pay, other compensation, such as an annual bonus or long-term incentive opportunities may be offered. McKesson has become aware of online recruiting-related scams in which individuals who are not affiliated with or authorized by McKesson are using McKesson’s (or affiliated entities, like CoverMyMeds or RxCrossroads) name in fraudulent emails, job postings or social media messages. In light of these scams, please bear the following in mind: McKesson Talent Advisors will never solicit money or credit card information in connection with a McKesson job application. McKesson Talent Advisors do not communicate with candidates via online chatrooms or using email accounts such as Gmail or Hotmail. Note that McKesson does rely on a virtual assistant (Gia) for certain recruiting-related communications with candidates. McKesson job postings are posted on our career site: careers.mckesson.com. We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.

United States
Full TimeRemoteTeam 201-500

ABOUT THIS ROLE As a Technical Architect at Kibo, you will be responsible for leading the design and implementation of our ecommerce/OMS platform in conjunction with the technical architecture of our clients' systems and software. You will work closely with the development team, external stakeholders, and other cross-functional teams to ensure that the architecture is aligned with the business goals and strategic direction of the organization. ABOUT KIBO WHAT YOU’LL DO - Lead thorough design, development, and configuration endeavors for Commerce/ Retail (eCommerce and Order Management) applications - Collaborate, design, and development Kibo solutions that align project requirements and client business objectives - Develop code elements as needed to support Kibo Principles and/or assist with proof of concept to Project delivery teams - Lead technical and business discussions internally and externally to provide guidance and support to cross-functional teams throughout project lifecycle - Counsel Project Management teams in project planning, milestones, go-live/solution rollouts, and risk identification/mitigation to ensure deliverables are high quality and timely - Guide internal and external stakeholders through Commerce implementation and upgrade projects - Evaluate new technologies and trends and make recommendations to guide customers and project teams through Commerce/Retail projects and implementations - Develop and maintain best practices documentation and reusable frameworks to expedite project execution - Troubleshoot and resolve complex functional, deployment, or systemic issues with enterprise software applications and custom solutions - Support UAT, QA and Performance testing initiatives to meet functional and non-functional requirements

United States