Senior Data Engineer & Data Architecture Lead

Allied Solutions LLC; Carmel (IN); On-site; USD 120,000 - 160,000; Full time

Benefits offered by this job

Medical, dental and vision insurance

100% company-paid life and disability

401k with company match

Three weeks PTO

Job summary

Allied Solutions LLC is seeking a Senior Data Engineer to advance our data strategy. The role focuses on data acquisition, curation, and transforming data into a usable asset, building end-to-end data flows for BI, analytics, and monetization.

You will partner across the organization to design data architectures and contribute to future state roadmaps, mentoring ETL developers and collaborating with Data Intelligence on governance and performance.

Qualifications

• Bachelor’s degree or equivalent education/work experience.
• 5+ years experience with data warehousing, databases (MS SQL Server, Snowflake), and dimensional modeling.
• 5+ years in end-to-end data analysis and development.
• 3-5 years experience with AWS cloud services (Glue, Lambda, S3).
• Strong SQL; experience with Python or R preferred.

Responsibilities

• Create detailed documentation of data warehouse, data stores, and data flows.
• Troubleshoot data processing errors and work with teams on technical designs.
• Develop and refine BI-focused data architecture and architecture meetings.
• Collaborate to understand data needs and back-end steps for BI results.
• Maintain ETL processes, data models, and data governance.
• Mentor other ETL developers and contribute to architecture decisions.

Skills

SQL

Data warehousing

Dimensional modeling

AWS cloud services

Snowflake

Python

R

Git & CI/CD

ETL

BI architecture

Education

Bachelor’s Degree or equivalent

Tools

MS SQL Server

Snowflake (Snowpipe, Snowpark, Streamlit, Streams/Tasks)

AWS Glue

Lambda

S3

Git

CI/CD tooling

Job description

Allied Solutions LLC is seeking a Senior Data Engineer to advance our data strategy. The role focuses on data acquisition, curation, and transforming data into a usable asset, building end-to-end data flows for BI, analytics, and monetization.

You will partner across the organization to design data architectures and contribute to future state roadmaps, mentoring ETL developers and collaborating with Data Intelligence on governance and performance.