Data Architect

About the Role

Key Responsibilities

• Evaluate client need and define the scope and sizing of data management work.
• Provide data management recommendations from client engagement workshops, existing applications, data sources, documentation, and business need.
• Translate business requirements into technology solutions.
• Use modeling techniques including Data Flow, ER Diagram, Conceptual, Logical, Physical, and Metamodels.
• Capture technical metadata through data modeling tools.
• Analyze and translate business requirements into conceptual and fully detailed logical and physical data models.
• Work with solutions architects, subject matter experts, and data stewards and lead data discovery discussions to capture business requirements and map requirements to logical and physical data modeling solutions.
• Conduct data model reviews with team members.
• Identify and document business logic & mapping rules needed to transform data before loading it into the target system.
• Anticipate possible problems and resolve them before they impact users when possible.
• Ensure database designs efficiently support BI and end user requirements.
• Work with client Analytics and Business Intelligence teams to understand strategic requirements.

Requirements

• Minimum of five (5) years' experience with design and engineering of data management solutions for government healthcare systems.
• Minimum of five (5) years' experience architecting and modeling an enterprise data presentation layer, semantic layer, distribution layer, dependent data marts, and business intelligence reporting solutions against an enterprise-wide data warehouse according to industry standards.
• Minimum 3 years experience communicating skills while serving as the primary interface between business, enterprise architecture, and technical resources developing information management solutions.
• A Bachelor's Degree in Information Systems Engineering, Computer Science, or a related field is preferred.
• Experience working with data architecture within an MMIS or large State Health and Human Services System (preferred).
• Strong experience in data standardization, data cleansing, data management, data visualization, and unified information models across multiple systems.
• Hands-on experience with Oracle SQL, PL/SQL, R, Python, or Cypher.
• Knowledge of key Business Intelligence and Data Analytics tools such as Tableau, Power BI, Alteryx.
• Exposure to Databricks Spark, Delta Technologies, Informatica, SSIS, Talend, ETL tools.
• Deep understanding of cloud technologies like Azure, AWS, Snowflake, Data Bricks.
• Experience managing and working with virtual teams.

Nice to Have

• Experience working with data architecture within an MMIS or large State Health and Human Services System.
• Fluent in both normalized and dimensional model disciplines and techniques.
• Skills to assess and analyze existing database design solutions for query performance.
• Knowledge of industry standards such as DMBoK.
• Experience with industry leading tools like Databricks Spark, Delta Technologies, Informatica, SSIS, Talend.
• Understanding of cloud platforms including Azure, AWS, Snowflake, Data Bricks.

Qualifications

• Minimum of five (5) years' experience in data management solutions for healthcare systems.
• Minimum of five (5) years' experience with enterprise data modeling and architecture.
• Minimum 3 years' experience in client communication and stakeholder engagement.
• Bachelor's Degree in relevant field (preferred).

Benefits & Perks

• Starting pay range of $120,556 - $145,000, depending on experience and location.
• Eligibility for incentive compensation based on individual and/or company performance.
• Company benefits including medical, dental, and vision insurance with employer contribution.
• Flexible spending or health savings account.
• Life and AD&D insurance.
• Short and long-term disability coverage.
• Paid time off and employee assistance programs.
• Participation in a 401k program with company match.