Senior Data Engineer & Architecture Lead

Allied Solutions, LLC; Carmel, Northern (IN, KY); Hybrid; USD 120,000 - 160,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Life insurance

Disability insurance

401k match

Paid time off

Career growth

Job summary

Allied Solutions, LLC is seeking a Senior Data Engineer to lead data acquisition, curation, and transformation into usable assets. You will help design and deploy modern data architecture and end-to-end data flows for BI and analytics, collaborating with teams across the enterprise.

The role focuses on data models, schemas, and roadmaps for Data Management and Data Strategy, with opportunities to mentor peers and influence cloud-based data solutions.

Qualifications

• Bachelor’s degree or equivalent in a related field.
• 5+ years in data warehousing, databases (MS SQL Server, Snowflake) and dimensional modeling.
• 5+ years in end-to-end data analysis and development.
• 3-5 years of experience with AWS cloud services.
• 3-5 years with Snowflake (preferred).
• Strong SQL and data modeling expertise.
• Experience with Python or R is a plus.
• Familiarity with Git and CI/CD and SDLC concepts.
• Excellent communication and collaboration skills.

Responsibilities

• Create and maintain detailed documentation of data warehouse, data stores, and end-to-end data flows.
• Troubleshoot data and processing errors in existing solutions.
• Collaborate with technical teams and users to design solutions.
• Develop and refine BI-focused data architecture.
• Understand data and reporting requirements from customers and support back-end data work.
• Perform gap analyses against enterprise data warehouse to support BI.
• Develop and maintain data sets and standardize collection/process methods.
• Provide technical guidance on cross-functional decisions and architecture.
• Attend architecture meetings to define scope, timelines, and costs.
• Design data extraction/integration paths with third-party providers.
• Maintain enterprise data solutions including ETL, warehouse models, upgrades, security, governance.
• Understand data warehouse/mart models and business information held.
• Identify process improvements and new technologies to accelerate value delivery.
• Collaborate with developers/SMEs to align vision and performance needs.
• Mentor other ETL Developers and Data Engineers.

Skills

Data modeling

Data architecture

ETL development

SQL proficiency

Analytical skills

Team collaboration

SDLC knowledge

Communication

Education

Bachelor’s Degree or equivalent

Tools

AWS

Snowflake

SQL

Git & CI/CD

Snowpipe / Snowpark

Python/R

Cloud services (SaaS, PaaS, IaaS)

Job description

Allied Solutions, LLC is seeking a Senior Data Engineer to lead data acquisition, curation, and transformation into usable assets. You will help design and deploy modern data architecture and end-to-end data flows for BI and analytics, collaborating with teams across the enterprise.

The role focuses on data models, schemas, and roadmaps for Data Management and Data Strategy, with opportunities to mentor peers and influence cloud-based data solutions.