Senior Data Engineer

Posted Yesterday
Be an Early Applicant
Carmel, IN, USA
In-Office
Senior level
Insurance
The Role
Builds and maintains enterprise data architecture, warehouses, data models, ETL processes, and end-to-end data flows. The role transforms and integrates data for business intelligence, analytics, and monetization, troubleshoots processing issues, conducts source-system gap analysis, and advises on technical decisions. Responsibilities include documentation, governance, performance optimization, architecture planning, process improvement, cross-functional collaboration, and mentoring data engineers.
Summary Generated by Built In
The Senior Data Engineer plays a critical role in the successful execution of Allied’s Data Strategy. This role will be focused on data acquisition, curation, and transformation of data into a useable asset. They will work cross-functionally to develop and deploy optimized data models and modern data architecture in support of strategic data and business initiatives. This role will serve as a subject matter expert for data domain knowledge, SQL, data design, and data processes across the enterprise. This individual will collaborate with teams across the organization to design and build end to end data flows for optimal business intelligence, advanced analytics, and data monetization efforts. Lastly, this role will contribute to core design of data architecture, data models, schemas, and inform future state Data Management and Data Strategy roadmaps.

Job Duties and Responsibilities

  • Creates detailed documentation of data warehouse, data stores, and end-to-end data flows
  • Troubleshoots and corrects data and data processing errors in existing solutions
  • Works with other technical teams as well as with internal and external users to develop technical designs
  • Develops and continually refines the BI-focused data architecture
  • Works closely with the Data Intelligence department to understand the data and reporting requirements from internal and external customers and the steps to take on the back-end data side to achieve the expected results
  • Conducts gap analysis on source system databases against Allied’s enterprise data warehouse in support of Business Intelligence efforts
  • Develops and maintains data sets and standardizes data collection and processing methodologies
  • Provides technical advice and weighs in on technical decisions that impact cross-functional teams
  • Attends and contributes to architecture meetings to determine project scope, time frame, and cost estimates
  • Works on plan and technical architecture to extract, integrate, and/or push data to or from third-party providers
  • Provides enterprise data solutions for Allied, including ETL maintenance, warehouse data models, periodic upgrades, security, governance, and performance optimization
  • Understands the data warehouse and data mart models as well as being familiar with the business information contained in each
  • Locates and defines new process improvement opportunities or alternative technologies that will enhance speed to business value delivery with our data
  • Collaborates with developers and subject matter experts to establish the technical vision and analyze trade-offs between usability and performance needs
  • Mentors other ETL Developers and Data Engineers

Qualifications (Education, Experience, Certifications & KSA)

  • Bachelor’s Degree required, or equivalent education/work experience
  • 5+ years of experience with data warehousing, databases (MS SQL Server, Snowflake), and dimensional modeling
  • 5+ years of experience in end-to-end data analysis and development
  • 3-5 years of experience in AWS cloud services (AWS Glue, Lambda, S3, etc.)
  • 3-5 years of experience with Snowflake (Snowpipe, Snowpark, Streamlit, Streams/Tasks) (preferred)
  • Extensive Experience with SQL required
  • Experience with R or Python (preferred)
  • Experience with Git and CI/CD (preferred)
  • Strong attention to detail
  • Familiarity with Object-Oriented Analysis, Project Management, Business Analysis Methodology, and the SDLC
  • Ability to collaborate effectively and work as part of a team
  • Customer-oriented, with a desire to resolve problems to the customer's satisfaction while maintaining focus on productivity, efficiency, and quality
  • Effective communicator to clients, management, and project partners
  • Experience with cloud-based technologies and services (SaaS, PaaS, IaaS) (preferred)
  • Experience with Master Data Management (preferred)
  • Strong analytical and product management skills required, including a thorough understanding of how to interpret customer business needs and translate them into application and operational requirements.

We offer our employees a robust compensation package! Our comprehensive benefits include: medical, dental and vision insurance coverage; 100% company-paid life and disability coverage, 401k options with company match, three weeks PTO by the end of the first year and much more. Allied proudly promotes from within as part of a strong commitment to providing career growth opportunities for employees of all levels. Our diverse business portfolio allows employees broad career options with the advantage of staying with the same organization.
All qualified candidates will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law.

To view our privacy statement click here

To view our terms and conditions click here

Skills Required

  • Bachelor's degree or equivalent education and work experience
  • 5+ years of experience with data warehousing, databases, including Microsoft SQL Server and Snowflake, and dimensional modeling
  • 5+ years of experience in end-to-end data analysis and development
  • 3-5 years of experience with AWS cloud services, including AWS Glue, Lambda, and S3
  • 3-5 years of experience with Snowflake, including Snowpipe, Snowpark, Streamlit, Streams, and Tasks
  • Extensive experience with SQL
  • Experience with R or Python
  • Experience with Git and CI/CD
  • Familiarity with object-oriented analysis, project management, business analysis methodology, and the software development life cycle
  • Experience with cloud-based SaaS, PaaS, and IaaS technologies and services
  • Experience with Master Data Management
  • Strong analytical and product management skills, including translating customer business needs into application and operational requirements
  • Ability to collaborate effectively and work as part of a team
  • Effective communication with clients, management, and project partners

Allied Solutions LLC Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Allied Solutions LLC and has not been reviewed or approved by Allied Solutions LLC.

  • Healthcare Strength — Medical, dental, and vision coverage are offered with multiple plan choices (PPO and CDHPs) and company HSA contributions, alongside an EAP and optional critical illness, hospital, and accident coverage. Group life, accidental death and dismemberment, and short- and long-term disability are provided at no cost to employees.
  • Retirement Support — Pre-tax and Roth 401(k) programs include a company match and are administered through Securian with investment portfolios and educational tools. These elements reinforce the company’s emphasis on long-term savings and financial security.
  • Leave & Time Off Breadth — Generous paid time off, paid holidays, paid family leave, and paid volunteer time are part of the package. These offerings expand time-off options beyond standard vacation allotments.

Allied Solutions LLC Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Carmel, IN
1,001 Employees

What We Do

Allied Solutions uses technology based products and services to meet the insurance, lending and marketing needs of more than 4,000 financial institutions in North America. Dedicated to helping their clients grow, protect and evolve their business, Allied Solutions maintains several regional offices and service centers around the country and is a subsidiary of Securian Financial Group, Inc. #FinancialServices #EnhanceRevenue #ExpandLending #ManageRisk #ImproveMarketShare #EngageEmployees #AlliedInsights #FindYourPassion #BlueCulture

Similar Jobs

SoFi Logo SoFi

Senior Data Engineer

Fintech • Mobile • Software • Financial Services
Easy Apply
Remote or Hybrid
United States
4500 Employees
125K-234K Annually

Doximity Logo Doximity

Senior Software Engineer

Healthtech • Information Technology • Mobile • Productivity • Software • Analytics • Telehealth
Easy Apply
In-Office or Remote
2 Locations
740 Employees
165K-227K Annually

The Aerospace Corporation Logo The Aerospace Corporation

Senior Supplier Quality Engineer - Data Analytics

Aerospace • Artificial Intelligence • Cloud • Machine Learning • Software • Cybersecurity • Defense
Remote or Hybrid
2 Locations
4600 Employees
97K-146K Annually

PwC Logo PwC

Applied AI Health Data System Engineer-Senior Manager

Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Hybrid
65 Locations
370000 Employees
124K-280K Annually

Similar Companies Hiring

MassMutual India Thumbnail
Big Data • Fintech • Information Technology • Insurance • Financial Services
Hyderabad, Telangana
Granted Thumbnail
Artificial Intelligence • Healthtech • Insurance • Mobile • Financial Services
New York, New York
23 Employees
Vega Thumbnail
Artificial Intelligence • Automotive • Insurance • Transportation
US
65 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account