Data Architect

Allegis Group; Hanover (MD); On-site; USD 122,700 - 184,100; Full time

Benefits offered by this job

Medical, dental & vision

401(k) Retirement Plan

Life Insurance

Tuition Assistance

Paid Time Off

Job summary

A leading staffing and workforce solutions company seeks a Data Analytics Architect in Hanover, MD. You will architect scalable data solutions on the Snowflake AI Data Platform, focusing on data ingestion from multiple sources. Required qualifications include a Bachelor's degree and 5+ years of experience in database architecture, along with proficiency in SQL and ETL tools. This role offers competitive benefits including medical and 401(k). Salary range is $122,700 - $184,100, and the position is bonus eligible.

Qualifications

• 5+ years in database architecture and development, with strong experience in Snowflake AI Data Platform.
• Proven expertise in data modeling, integration, and ingestion from various sources.
• Experience with ETL tools (Matillion) and consuming REST APIs.

Responsibilities

• Architect and implement scalable data solutions on Snowflake, focusing on efficient ingestion from various sources.
• Redesign and standardize data models to align with enterprise best practices.
• Collaborate with cross‑functional teams to deliver robust analytics and reporting solutions.

Skills

Database architecture and development

Snowflake AI Data Platform

Data modeling

SQL

ETL tools (Matillion)

Cloud technologies (AWS, Azure)

Analytical skills

Problem-solving

Communication skills

Kimball Dimensional Modeling

Education

Bachelor's degree in Computer Science, Information Systems, or related field

Tools

SQL

Matillion

Job description

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 out of our headquarters in Hanover, MD 2‑3 days a week

Responsibilities

• 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: 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.
• 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

• Medical, dental & vision
• Hospital plans
• 401(k) Retirement Plan – Pre‑tax and Roth post‑tax contributions available
• Life Insurance (Company paid Basic Life and AD&D as well as voluntary Life & AD&D for the employee and dependents)
• Company paid Short and long‑term disability
• Health & Dependent Care Spending Accounts (HSA & DCFSA)
• Transportation benefits
• Employee Assistance Program
• Tuition Assistance
• Time Off/Leave (PTO, Allegis Group Paid Family Leave, Parental Leave)

Salary Range

$122,700.00 - $184,100.00

The position is bonus eligible.

Individual compensation offered for this position within this range will depend on many factors, including qualifications, skills, relevant experience, job knowledge, geographic location, internal equity, and other pertinent job‑related factors.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

If you would like to request a reasonable accommodation, such as the modification or adjustment of the job application process or interviewing process due to a disability, please email Lauren Lara at [e-mail] or call 410‑579‑3526 for other accommodation options.