Informatica IDMC Data Architect (onsite)

Vitaver & Associates, Inc; Tallahassee (FL); On-site; USD 120,000 - 150,000; Full time

Job summary

Vitaver & Associates, Inc. seeks an Informatica IDMC Data Architect for an on-site Tallahassee engagement. Start ASAP for a 12+ month contract with extensions, 100% at the client's site. This is a temporary project with no remote option.

The role requires extensive experience in data architecture, IDMC, Snowflake, data lakes, ER modeling with Erwin, SQL, Python, and cloud/DataOps disciplines to design and deploy EDAP components in healthcare environments.

Qualifications

• 100% on-site at client site in Tallahassee, FL (required).
• 5+ years in data & analytics solution design in healthcare/admin.
• 2+ years Snowflake data warehouse experience.
• 2+ years cloud data lakes and lakehouse (AWS S3, Parquet, Delta Lake, Databricks).
• 7+ years ER modeling with Erwin Data Modeler.
• 5+ years Informatica IDMC (CDI/CDQ/CDP/CDIR).
• 5+ years SQL; 3+ years Python.
• 5+ years relational DBs and NoSQL; 3+ years AWS; 2+ years DevOps/DataOps.
• Bachelor’s degree in CS/Analytics/IS/Business Admin/Health Informatics.
• Current data/analytics certification or 18+ hours of webinars in last 3 years.

Responsibilities

• Provide technical, data, and process SME for the EDAP project.
• Profile source data with Informatica Cloud Data Profiling and document issues.
• Document current/target data models in Erwin with SMEs and architects.
• Design, develop, and support data pipelines, lakes, warehouses, and lakehouse tables.
• Design and support IDMC MDM/RDM processes, including match/merge and golden records.
• Implement BI and data science tool connections with access controls.
• Ensure data security, privacy (HIPAA), and regulatory compliance.

Skills

Data analytics collaboration

Healthcare data domain knowledge

Education

Bachelor's degree in Computer Science / Analytics

Data or analytics certification (e.g., CDMP)

Tools

Informatica IDMC

Snowflake Data Warehouse

AWS S3 / Cloud lakes

Parquet

Delta Lake

Databricks

Erwin Data Modeler

SQL

Python

NoSQL databases

AWS cloud infrastructure

DevOps / DataOps

Job description

Informatica IDMC Data Architect (onsite)

• Tallahassee, FL

14873 –Informatica IDMC Data Architect (onsite) – Tallahassee, FL

Start Date: ASAP

Type: Temporary Project

Estimated Duration: 12+ months with possible extensions

Work Setting: 100% of the time at the Client's site. No telecommuting or remote work. This is a non-negotiable requirement from the client.

Our client is filling this contract position exclusively through approved staffing partners, so this opportunity is not available by applying directly with the client.

Required

• Availability to work 100% of the time at the Client's site in Tallahassee, FL (required);
• Experience with data and analytics (D&A) solution design and business collaboration in a healthcare/administration environment (5+ years);
• Experience with data warehouse modeling, engineering, and support (normalized and dimensional), including Snowflake Data Warehouse (2+ years);
• Experience with cloud-based data lakes and Lakehouse structures (AWS S3, Parquet, Delta Lake, Hudi, Iceberg, Databricks) (2+ years);
• Experience with data modeling (Entity Relationship, Logical, Conceptual, Physical) and advanced proficiency with Erwin data modeler (7+ years);
• Experience with data pipeline/integration tools using Informatica, including the IDMC suite (CDI, CDQ, CDP, CDIR) (5+ years);
• Experience with SQL programming (5+ years) and Python or a similar object-oriented programming language (3+ years);
• Experience engineering relational databases (both row and columnar store) and NoSQL databases (Document, Graph, Vector, Key-Value) (5+ years), AWS cloud infrastructure (3+ years) and DevOps/DataOps processes (2+ years);
• Bachelor's degree in Computer Science, Analytics/Data Science, Information Systems, Business Administration, Public Health Informatics, or a related field;
• Current data and/or analytics certification (e.g., Certified Data Management Professional) or 18+ hours of related webinar/conference participation over the last 3 years as a substitute;

Preferred

• Experience with data and analytics testing/QA best practices, tools, and automation (5+ years);
• Experience with metadata and data catalog management (2+ years);
• Experience with Master Data Management (MDM) and Reference Data Management (RDM) using Informatica IDMC Customer 360/Reference 360 (2+ years);
• Experience with cloud-based BI tools such as Qlik and Tableau (4+ years);
• Experience with Data Science/Machine Learning platforms such as Dataiku (2+ years);
• Experience with AWS Lambda functions;

Responsibilities include but are not limited to the following:

• Provide technical, data, and process subject matter expertise for the Enterprise Data and Analytics Platform (EDAP) project;
• Profile source system data using Informatica Cloud Data Profiling to identify and document data issues for remediation;
• Document current and target state data models (ERD, logical, physical, dimensional) in Erwin in collaboration with business subject matter experts and architects;
• Design, develop, and support data pipelines, including ingestion, data lake layers, warehouse structures, and lakehouse tables, ensuring quality, security, and performance;
• Design and support Informatica IDMC MDM/RDM processes, including data ingestion, match/merge logic, and golden record management;
• Implement and support BI (Qlik, Tableau), GIS (ESRI), and Data Science/ML (Dataiku) tool connections, including fine-grained user access controls;
• Ensure the EDAP design and implementation meet data security, privacy (HIPAA), and regulatory compliance requirements;

Why apply?

• Gain experience with the company main value of which is excellence in providing for healthcare needs of the community;
• Work in the environment where you will be empowered by a long-standing culture of supporting individual initiative, creativity, appreciation for diversity and commitment to collaboration and teamwork;
• Receive realistic deadlines and all necessary tools, training and coaching to complete your task successfully;
• Benefit from multiple projects extensions;
• Get extra cash by participating in Vitaver Successful Completion Bonus Program;
• Receive support and advice from Vitaver consultants who are already working at our Client’s site;
• Always get paid in full and on time.