Senior Data Engineer: Architect of BI & Data Platforms

Allied Solutions, LLC; United States; On-site; USD 120,000 - 170,000; Full time

Benefits offered by this job

Medical, dental and vision insurance

Company-paid life and disability

401k with company match

Paid time off

Job summary

Allied Solutions, LLC is seeking a Senior Data Engineer to architect and operationalize data flows for BI, analytics, and data monetization. You will own end-to-end data modeling, ETL maintenance, and governance while collaborating across teams to deliver scalable data platforms.

The role emphasizes data architecture, cloud services (AWS), Snowflake tooling, and strong SQL skills with a focus on enterprise data solutions and performance optimization.

Qualifications

• Bachelor’s degree or equivalent experience in a technical 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 AWS experience (Glue, Lambda, S3).
• 3-5 years with Snowflake (Snowpipe, Snowpark, Streamlit).
• Extensive SQL experience; programming in R or Python preferred.
• Experience with Git and CI/CD; strong attention to detail.
• Familiar with SDLC, OO analysis, PM, BA; team player and strong communicator.

Responsibilities

• Create detailed documentation of data warehouses, stores, and end-to-end data flows.
• Troubleshoot data and processing errors in existing solutions.
• Collaborate with technical teams and users to design technical solutions.
• Develop and refine BI-focused data architecture.
• Partner with Data Intelligence to translate requirements into back-end data work.

Skills

SQL

Data warehousing

Data analysis

Communication

Team collaboration

Education

Bachelor’s Degree

Tools

AWS

Snowflake

Snowpipe

Snowpark

CI/CD

Git

Python

R

S3

Job description

Allied Solutions, LLC is seeking a Senior Data Engineer to architect and operationalize data flows for BI, analytics, and data monetization. You will own end-to-end data modeling, ETL maintenance, and governance while collaborating across teams to deliver scalable data platforms.

The role emphasizes data architecture, cloud services (AWS), Snowflake tooling, and strong SQL skills with a focus on enterprise data solutions and performance optimization.