Data Architect

Job Summary:

The Data Analytics Architect will be responsible for supporting the development and adoption of the Allegis Analytics Warehouse and Enterprise Data Lake implemented in our AI Data Cloud Platform.

The Architect will perform research and analysis, architect Database Designs and ELT solutions to support all consumers across the entire Enterprise.
In addition, this role will drive the advancement of the Snowflake AI Data Cloud by architecting and optimizing data ingestion from diverse sources.

The Architect will lead efforts to modernize and standardize enterprise data models, eliminate redundancy, and reduce technical debt from legacy systems, ensuring the data platform is robust, scalable, and aligned with enterprise best practices.

In-Office Requirement:

• Required in-office presence at least 4 days per week

Responsibilities

Essential Functions:

• Architect and implement scalable data solutions on Snowflake, focusing on efficient ingestion from various sources (databases, files, cloud applications, APIs).
• Redesign and standardize data models to align with enterprise best practices, ensuring consistency and reliability.
• Identify and eliminate redundant data structures and legacy technical debt, streamlining integration and performance.
• Collaborate with cross-functional teams to deliver robust analytics and reporting solutions.
• Monitor and tune system performance, ensuring high availability and optimal data delivery.
• Stay current with emerging technologies and recommend improvements to the data platform.

Qualifications

Minimum Education and/or Experience:

• Bachelor’s degree in Computer Science, Information Systems, or related field, or equivalent experience.
• 5+ years in database architecture and development, with strong experience in Snowflake AI Data Platform

Skills/Abilities:

• Proven expertise in data modeling, integration, and ingestion from disparate sources.
• Proficiency in SQL, data warehousing concepts, and cloud technologies (AWS, Azure).
• Experience with ETL tools (Matillion) and consuming REST APIs.
• Strong analytical, problem-solving, and communication skills.
• Experience with Kimball Dimensional Modeling

Core Competencies:

• Build relationships
• Develop people
• Lead change
• Inspire Others
• Think critically
• Communicate clearly
• Create Accountability

Benefits Overview:

Benefits are subject to change and may be subject to specific elections, plan, or program terms.

This role is eligible for the following:
o Medical, dental & vision
o Hospital plans
o 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available
o Life Insurance (Company paid Basic Life and AD&D as well as voluntary Life & AD&D for the employee and dependents)
o Company paid Short and long-term disability
o Health & Dependent Care Spending Accounts (HSA & DCFSA)
o Transportation benefits
o Employee Assistance Program
o Tuition Assistance
o Time Off/Leave (PTO, A...