Each staff member assigned to this project must have a background screening that is equivalent to a Level Two (2) screening standard.
This is a fixed fee/hourly based project which is inclusive of travel, lodging, per diem expenses and all other costs associated with the completion of the associated tasks.
Interviews:
In the event an interview is requested; all interviews will be conducted via web Cam.
Telecommuting:
Not allowed for this position.
Purpose
This scope of work is for a Data and Analytics Architect/Engineer who will be responsible for collaborating with the CLIENT (Department) and its System Implementer (SI) to implement and maintain technical aspects of the EDAP component within the data modernization (DM) program. This contractor will provide data modeling/design services, as well as hands-on engineering development during the implementation of various (EDAP) use cases and will provide support services once in production.
CONTRACTOR QUALIFICATIONS AND EXPERIENCE:
Min 13-15 years of experience in IT.
Contractor staff assigned to this agreement must possess the following minimum qualifications and experience:
5.1. Minimum of Bachelor’s (4-year) degree in Computer Science, Analytics/Data Science, Information Systems, Business Administration, Public Health Informatics, or another related field.
5.2. Current data and/or analytics certification such as Certified Data Management Professional (CDMP). Eighteen or more hours of participation in webinars or conferences over the last 3 years related to data and analytics may be substituted for the certification.
5.3. Five or more years of experience collaborating with various lines of business and the analyst/data science community; must demonstrate an understanding of general business operations related to healthcare and administration, the ability to translate use case requirements into data and analytics (D&A) solutions, and the ability to articulate D&A solutions, tool usage and data models to a non-technical audience.
5.4. Five or more years of experience modeling, engineering, implementing, and supporting data warehouses (both normalized and dimensional) including two or more years of experience with Snowflake Data Warehouse.
5.5. Three or more years of experience designing, engineering, implementing, and supporting cloud-based data lakes, including lake layers and bucket structures in AWS S3 and related Apache Foundation tools such as Parquet.
5.6. Two or more years of experience modeling, engineering, implementing, and supporting cloud data lakehouse structures (Delta Lake, Hudi, and Iceberg) utilizing Databricks.
5.7. Seven or more years of experience in data modeling (including Entity Relationship, Logical, Conceptual, and Physical models) for analytical purposes, and data profiling/reverse engineering for both schema-on-read and schema-on-write environments. The experience must include advanced proficiency with Erwin data modeler.
5.8. Five or more years of experience with data pipeline/Integration tools, including source to target mapping, coding, data quality and enrichment transforms, observability, orchestration, performance optimization, and testing, via various methods (i.e., ETL/ELT/batch, CDC, Streaming) using Informatica tools.
5.8.1. This experience must include two or more years of experience using Informatica IDMC suite of tools including Cloud Data Integration (CDI), Cloud Data Quality (CDQ), Cloud Data Profiling (CDP), and Cloud Data Ingestion and Replication (CDIR).
5.9. Five or more years of experience with SQL programming, three or more years of experience with Python or a similar object-oriented high-level programming language. Experience with AWS Lambda functions is helpful.
5.10. Five or more years of experience engineering relational (both row and columnar store) and NoSQL (i.e., Document, Graph, Vector, Key-Value) databases.
5.11. Three or more years of experience working within the AWS cloud infrastructure.
5.12. Two or more years of experience utilizing Dev or DataOps processes.
5.13. Five or more years of data and analytics testing/quality assurance and acceptance experience, including best practices, tools, and automation.
5.14. Two or more years of experience working with metadata and a data catalog that support the data lakehouse and data warehouse operations, as well as supporting machine learning.
5.15. Two or more years of experience implementing and supporting Master Data Management (MDM) and Reference Data Management (RDM) in Informatica IDMC (Cloud) Customer and Reference 360 SaaS.
5.16. Four or more years of experience supporting cloud-based Analytics & Business Intelligence (ABI) tools: Qlik and Tableau, including secure data warehouse connections, performance and user access controls.
5.17. Two or more years of experience supporting cloud-based Data Science and Machine Learning platforms (DSML): Dataiku, including statistical model life-cycle management, endpoints, and machine learning.
5.18. Must possess excellent communication skills, including verbal, written and diagramming.
Education: Minimum of Bachelor’s (4-year) degree in Computer Science, Analytics/Data Science, Information Systems, Business Administration, Public Health Informatics, or another related field.
CONTRACTOR RESPONSIBILITIES:
6.1. SERVICE TASKS: As directed by the Department, contractor’s staff will perform the following tasks in the time and manner specified:
6.1.1. Monthly and as directed by the Department, provide technical, data, and process subject matter expertise and championship to the Department related to all aspects of the Enterprise Data and Analytics Platform (EDAP) project.
6.1.2. Monthly and as directed by the Department, reverse engineer, study, and utilize Informatica Cloud Data Profiling (CDP) to profile prioritized source system data models, dictionaries, and data flows to understand and document current state and identify data problems that will have to be remediated within the EDAP.
6.1.3. Monthly and as directed by the Department, work with business subject matter experts (SMEs) and the Enterprise Data and Analytics Architect to document the current state Entity Relationship Diagram (ERD) in Erwin as well as current state logical and physical data models for in- scope Department subject areas.
6.1.4. Monthly and as directed by the Department, perform needs analysis, analyze business processes, develop process maps, in collaboration with project team members.
6.1.5. Monthly and as directed by the Department, collaborate with Data Governance team to develop, maintain, and align data standards and business glossary/data dictionary with the data models, as well as develop error handling and data quality rules to be used in the data pipelines, adhering to the main data quality dimensions of accuracy, completeness, timeliness, consistency, validity, and uniqueness.
6.1.6. Monthly and as directed by the Department, collaborate with business SME’s, the SI, architects, and technical data stewards to create and maintain target state data models (conceptual, logical, physical) for both the data warehouse and data lakehouse. This includes physical and logical data structures and both normalized (i.e., third normal form – 3NF), dimensional models (i.e., star and snowflake schemas, and delta lake/iceberg schemas. 6.1.7. Monthly and as directed by the Department, use Informatica Cloud Metadata Command Center (MCC) and Cloud Data Governance and Catalog (CDGC) to design, develop, and support metadata (both active and passive) tagging / collection and maintenance processes and pipelines, ensuring metadata is kept in sync in the various EDAP components.
6.1.8. Monthly and as directed by the Department, collaborate with Department OIT and technical SMEs to provision source data connectors for purposes of data profiling, lineage, quality scoring, and integration. Manage the Informatica secure agent server clusters to optimize performance and cost.
6.1.9. Monthly and as directed by the Department, collaborate with the SI, EDAP project team and architects to design (source to target mapping), develop, and support data pipeline components, including ingestion, data lake layers, data warehouse structures, data lakehouse tables, ensuring high data quality, security, pipeline orchestration, performance and cost optimization.
6.1.10. Monthly and as directed by the Department, collaborate with the SI, EDAP project team and architects to design, develop and support Informatica IDMC Cloud Customer 360 SaaS MDM and RDM, including source system data ingestion, domain models, data enrichment and quality, match/merge logic, survivorship rules, golden record, and data extraction for the data hubs and data lakehouse/warehouse environments.
6.1.11. Monthly and as directed by the Department, collaborate with the SI and EDAP project team in designing, developing, and supporting a performance-optimized, high quality data hub environment for system-to-system data exchanges to replace ‘spaghetti’ integrations that accommodates batch and real-time updates and are accessed via Application Programming Interfaces (APIs).
6.1.12. Monthly and as directed by the Department, collaborate with the SI and OIT staff, and the Department analyst community to implement and support ESRI, ABI (Qlik, Tableau) and DSML (Dataiku) tools, including connections to EDAP data structures and metadata, as well as fine-grained user access controls (row and column) utilizing classifications in the metadata.
6.1.13. Monthly and as directed by the Department, collaborate with Department OIT staff to optimize performance and cost of Snowflake virtual warehouse clusters and Databricks classic compute plane.
6.1.14. Monthly and as directed by the Department, collaborate with the SI and OIT staff to ensure the EDAP design incorporates robust security and privacy compliance throughout the cloud ecosystem, including AWS S3, Databricks, Snowflake, Informatica, Qlik, Tableau and ESRI.
6.1.15. Monthly and as directed by the Department, ensure the data pipeline, data storage, and data access implementations addresses data privacy, and regulatory compliance to HIPAA and other regulated sensitive data types and includes sensitive data identification, classification, and tagging or metadata for both structured and unstructured data (i.e. files).
6.1.16. Monthly and as directed by the Department, ensure EDAP components addresses secure system and user (developers and analysts) access to tools and data as well as monitoring/alerting of access to various components of EDAP. User authorization includes fine-grained user access controls such as RBAC, PBAC, ABAC, at the row- and column-level.
6.1.17. Monthly, follow the EDAP testing plan to perform various data pipeline testing functions, including unit, integration, regression and support user acceptance testing.
The Data Architect will report to the designated CLIENT supervisor.
Note : This is a Full Time ON-SITE Contract Position with NO remote options allowed.
**When responding please do tell us your All-inclusive compensation requirements ***.
POSITION STARTS : Oct 2026
# of Positions : 1
No phone calls please.
Local Citizens are encouraged to Apply
No relocation assistance provided.
ONLY Candidates with an exact match will be contacted
Candidates should be authorized to work in the US.
