Data Architect

Skills

Review Business Requirements Documentation and Technical Design Documentation; participate in peer review cycles with technical and non-technical counterparts. Establish and maintain documentation of programs user guides policies and procedures to support the acceptance of solutions by non-technical users. Collaborate with Business Data Analysts Developers and Data Analysts to develop and integrate data insights and solutions within the Data & Analytics team. Provide oversight input design and implementation support for new solution development including new data platforms data management storage environments business intelligence solutions and service-oriented architecture. Act as a technical mentor for team members providing input and feedback. Create and maintain a catalog of architectural diagrams used by the team. Promote a self-service architecture to encourage a trusted source of distributed data and analytic capabilities leading the enterprise in its goal to be an insight-driven organization.

Description

The Data Architect, Data & Analytics role is a contingent position responsible for advising, constructing, and implementing the technical design for the organization’s data and analytic solutions. This role provides key oversight and direction for the overall architecture, design, and implementation needed to support end-user data and analytic needs. Responsibilities include input on the design of data ingestion, data management, data warehousing, data stores, data extraction, and business intelligence tools. The ideal candidate will understand business needs and champion enterprise data architecture and modeling to support execution.

Responsibilities

• Bachelor’s degree in Computer Information Services or a related field.
• 5 years of experience with enterprise data management, including hybrid and cloud environments.
• Proficiency with SQL Server core data engine, SSIS, Power BI, Visual Studio, MS Office Products, and source management tools (e.g., TFS, Git).
• Expertise in Microsoft Azure resources such as Azure Data Lake Storage Gen2, Azure Data Factory, Azure Databricks, and Azure SQL Database.
• Strong knowledge of relational databases, including MS SQL Server or Azure SQL Database, indexing best practices, and designing and tuning stored procedures.
• Experience with change management and code promotion through non-production environments.
• Familiarity with designing systems using XML/XSLT and/or JSON.
• Experience in configuring, resiliently loading, and ensuring performant data stores.
• Proficiency in working with and loading Data Lake Medallion Architecture.
• Ability to develop data translation objects and data processing flows using modern tools and adapt to new ones as needed.
• Proven ability to work independently to resolve complex technical data transformation issues.
• Strong communication and presentation skills.
• Experience managing multiple projects simultaneously with minimal supervision.

Educational Requirements

• 3 years of experience in data warehouse or analytics-focused data environments, including star schemas, tabular models, and business intelligence tools.
• 3 years of experience in the Healthcare industry, particularly with Healthcare Payers.