MSR Technology Group

Job Description Job Description Senior Healthcare Data Modeler - EDW / Cloud Modernization Location: Remote, Continental U.S. Preferred Location: Central U.S. / Midwest Travel: Occasional Mot open to third parties Position Summary We are seeking a hands-on Senior Healthcare Data Modeler to support a large Enterprise Data Warehouse and cloud modernization initiative. This role will work with complex healthcare datasets and translate business requirements into scalable enterprise data models and solutions. The Senior Healthcare Data Modeler will own the design, governance, and evolution of conceptual, logical, and physical data models supporting the EDW and its modernization. The environment is transitioning from a legacy Teradata EDW toward modern Azure and Snowflake cloud architecture. The ideal candidate brings deep healthcare data modeling experience, expert SQL skills, strong data governance and metadata knowledge, and hands-on experience designing enterprise data models across Medicaid, Medicare, claims, provider, TPL, and member data. Responsibilities Data Architecture & Strategy Develop long-term data architecture strategies, standards, and roadmaps in collaboration with business and technical stakeholders. Lead data architecture, data modeling, and data movement initiatives supporting Medicaid, Medicare, and Commercial healthcare data. Work across healthcare subject areas including claims, provider, TPL, and member data. Define how logical designs translate into physical databases and how data flows through successive architectural layers. Maintain accurate documentation of the enterprise data architecture and environment. Data Modeling & Design Translate complex business requirements into scalable enterprise data models. Design and maintain conceptual, logical, and physical data models across staging, integration, and semantic/presentation layers. Develop dimensional models using Kimball star/snowflake, normalized OLTP/3NF, OLAP, and Data Vault modeling techniques. Implement Slowly Changing Dimensions, role-playing dimensions, dimensional hierarchies, surrogate keys, and data classifications. Define primary and foreign keys, indexes, partitioning, constraints, and referential integrity rules. Create and maintain ERDs, data flow diagrams, and data model documentation using Erwin or comparable modeling tools. Data Governance, Quality & Compliance Ensure data architecture and modeling practices align with healthcare regulatory and security requirements. Oversee source-to-target mapping, data movement, interfaces, and data quality. Maintain data dictionaries, business glossaries, metadata, lineage documentation, and data modeling standards. Support classification and protection of PII and PHI in accordance with applicable healthcare data security requirements. Support Data Quality, Data Profiling, Data Governance, Data Security, Metadata Management, MDM, Data Archival, and Data Migration initiatives. Collaboration & Delivery Partner with Data Architects, ETL/Data Engineers, Business SMEs, BI Developers, and DBAs throughout the architecture and implementation lifecycle. Provide technical recommendations for scalable data warehouse, data mart, data mining, and analytics solutions. Address data challenges involving systems integration, compatibility, and multi-platform environments. Develop testing criteria to ensure the fidelity and performance of data architecture. Communicate risks and issues clearly to project and stakeholder teams. Cloud Modernization & Migration Support modernization of legacy Teradata data models to Azure and Snowflake. Contribute to target-state architectures involving Azure Synapse, Databricks Lakehouse, and Snowflake. Design models supporting Medallion architecture, including Bronze, Silver, and Gold layers. Work with Delta Lake and Parquet patterns. Assess existing data models for modernization, redundancy, performance, and optimization opportunities. Required Qualifications BS or MS in Computer Science, Business Information Systems, Engineering, or a related field. 10+ years of IT experience. 7+ years of data modeling, data strategy, and roadmap experience supporting large, complex healthcare environments. Experience implementing large-scale, end-to-end Data Management and Analytics solutions. 5+ years of healthcare data modeling experience involving Medicaid, Medicare, and/or Commercial healthcare data. 5+ years of experience with Erwin or comparable data modeling tools such as ER/Studio or SQL Developer Data Modeler. Expertise in conceptual, logical, and physical data modeling. Expertise with normalized OLTP, OLAP, MDM, and dimensional modeling techniques. Strong experience with star schemas, Slowly Changing Dimensions, role-playing dimensions, dimensional hierarchies, and data classification. 5+ years of expert-level SQL experience, including complex analytic queries, stored procedures, DDL, DML, DCL, query optimization, and ANSI SQL. 5+ years of experience with Data Quality, Data Profiling, Data Governance, Data Security, Metadata Management, MDM, Data Archival, and Data Migration. Strong knowledge of HIPAA, PHI, PII, and healthcare data security requirements. Strong problem-solving, communication, influencing, and presentation skills. Ability to work independently in a fast-paced environment with multiple concurrent priorities. Preferred Qualifications State Medicaid EDW or MMIS experience. Experience with Medicaid federal reporting programs such as T-MSIS, PERM, MARS, or Quality of Care. Teradata Vantage experience and exposure to modernization of Teradata workloads to cloud platforms. Microsoft Azure experience, including Azure Data Lake Storage, Azure Data Factory, and Purview. Azure Synapse and/or Databricks Lakehouse experience. Snowflake experience, including data object design and performance tuning. Experience with Delta Lake, Lakehouse architecture, or Microsoft Fabric. Experience with Data Vault modeling. Power BI or Tableau experience. Hands-on ETL experience with Informatica, Azure Data Factory, or similar tools. Python or R experience. Exposure to AI/ML or GenAI tools used for data modeling, documentation, or metadata enrichment. Work Arrangement 100% remote within the Continental U.S. Central U.S. / Midwest candidates preferred. Occasional travel may be required. This role works across distributed and matrixed business and technology teams.

Job Description Job Description Informatica MDM Developer - ETL / SQL Remote - Continental U.S. Contract Opportunity (not open to third parties) Central U.S. / Illinois / Midwest candidates preferred Occasional travel may be required Position Overview We are seeking an experienced Informatica MDM Developer to support a large-scale Master Data Management environment. This is a hands-on development role focused on Informatica MDM, ETL/data integration, SQL, data quality, and Python automation. The developer will build and support MDM solutions, Informatica workflows and data loads, troubleshoot production issues, support testing and defect resolution, and help maintain reliable MDM operations. Key Responsibilities Develop and support solutions using Informatica MDM. Integrate data from multiple source systems to support a unified client/member view. Develop Informatica mappings, mapplets, sessions, workflows, and transformations. Work with transformations including Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, Rank, Source Qualifier, Lookup, and Sorter. Schedule and monitor Informatica/ETL jobs across development, system testing, and production environments. Automate data staging and processing through scripting. Develop, maintain, and analyze complex SQL queries and scripts. Work with large enterprise relational databases and Teradata. Support data quality, matching, standardization, reconciliation, and data governance processes. Troubleshoot production and post-release issues and develop solutions. Work directly with QA teams on defect resolution, validation, and testing. Participate in unit, integration, and system testing. Participate in technical discussions and recommend solutions or requirements. Use Python for scripting, automation, testing, or data processing support. Required Qualifications 5+ years of experience in MDM, ETL/ELT, data engineering, or data integration development. 3+ years of hands-on Informatica MDM implementation experience. Hands-on experience developing Informatica mappings, mapplets, sessions, workflows, and transformations. Experience scheduling, monitoring, and troubleshooting Informatica jobs. Strong SQL experience working with large MDM and enterprise relational database platforms. Experience with data quality, matching, unique client/member identifiers, standardization, reconciliation, and data governance. Experience supporting ETL/MDM operations, performance tuning, issue resolution, and SDLC delivery. Python experience supporting scripting, automation, testing, or data processing. Bachelor's degree in Computer Science, Data Analytics, Information Systems, Engineering, or equivalent experience. Preferred Qualifications Experience with other MDM platforms, including cloud-native MDM solutions. State government, public-sector, or regulated-industry experience. Healthcare, Medicaid, claims, eligibility, provider, or Health and Human Services data experience. Agile/Scrum experience. Exposure to X12, EDI, XML, JSON, APIs, or HL7/FHIR. Exposure to Azure, ADF, Databricks, Snowflake, Data Lake, or similar cloud data platforms. Experience with MDM, EDW, ETL, or on-premises-to-cloud modernization initiatives. Exposure to automation, AI/ML, GenAI, or LLM-assisted engineering. Ability to work independently in a remote, matrixed environment. Work Arrangement 100% remote within the continental U.S. Central U.S., Illinois, or Midwest location preferred. Occasional travel may be required.

Job Description Job Description POSITION SUMMARY: The CMM Programmer is responsible for writing CMM programs for various parts and gauging. In addition CMM the programmer oversees the quality lab. Other related tasks as assigned by management. KEY ROLES AND RESPONSIBILITIES: Program and operate Coordinate Measurement Machine (CMM) using PC DMIS software. Interpret internal and customer blue prints by applying GD&T principles. Manage weekly CMM schedule Ability to align and secure holding fixtures and gauges. Ability to create CMM programs from supplied CAD files Communicate CMM results and interpret data with internal engineering and quality staff on a daily basis. Calibrate and troubleshoot CMM equipment (Brown & Sharpe & Mitutoyo). Communicates with staff regarding suspect measurement system methods and analysis. Prepares measurement system analysis reports as required. Performs general administrative duties as required. Ability to multi task in automotive environment Proficient in Google, Microsoft applications Education High school diploma or GED equivalent. Functional Experience 3-5 years previous experience in an automotive quality assurance or customer environment. Knowledge of quality systems, statistical process control and blueprints. Industry Experience Ideally, the successful candidate will bring a manufacturing background in a fast-paced environment, preferably in automotive. Experience working in organizations where continuous improvement has been part of the company's culture. Experience working with Plex. Previous tier one automotive experience is desirable. Core Competencies GD&T Knowledge: A deep understanding of Geometric Dimensioning and Tolerancing (GD&T) is crucial for interpreting part specifications and ensuring accurate measurements. Blueprint Reading: The ability to read and interpret engineering drawings and CAD models is essential for understanding part features and tolerances. CMM Software & Hardware: Proficiency in operating and programming specific CMM software packages (e.g., PC-DMIS) and understanding various CMM machine types or other laboratory equipment. Metrology & Measurement: Knowledge of fundamental metrology principles, measurement techniques, and different measurement sensors and probes. Data Analysis: Familiarity with data analysis tools and statistical methods to interpret inspection data, identify trends, and generate reports. CAD Software: Experience with Computer-Aided Design (CAD) software is valuable for model-based programming. Machine Calibration: Ability to perform basic calibration and maintenance on CMM machines to ensure accuracy. Required Skills Attention to Detail: Meticulous attention to detail is paramount for accurate programming and to prevent significant quality issues. Problem-Solving: Strong problem-solving skills are needed to troubleshoot measurement issues and optimize inspection processes. Analytical Skills: The capacity for strong analytical thinking helps in analyzing data and identifying potential manufacturing problems. Communication: The ability to clearly communicate technical information and inspection findings to other team members, including non-specialists. Computer Skills: Comprehensive computer skills are necessary for operating CMM software, managing data, and potentially using macro programming. Organizational Skills: Good organizational skills help in managing programs, data, and maintenance schedules efficiently. Other Requirements Recommend procedures and budget for quality engineering areas. Ensure quality customer files are current to IATF16949 requirements. Performs internal audits as necessary. Work Saturdays if required Physical Requirements Sometimes lifts, carries or moves objects up to 25 pounds, occasionally over 60 pounds. Office environment with noise from computer peripherals such as mainframe, disk drives and test equipment. Factory environment with noise from manufacturing equipment. Exposure to dangerous equipment. Possible serious injury due to carelessness around equipment. Sometimes lifts, carries or moves objects - up to 50 pounds.