Apply on Employer Site

Allied Solutions LLC · 1 day ago

Sr. Data Engineer

Carmel, IN

Full-time

Onsite

Senior Level

5+ years exp

Allied Solutions LLC is focused on executing a robust Data Strategy and is seeking a Senior Data Engineer to play a critical role in this initiative. The role involves data acquisition, curation, and transformation, working cross-functionally to develop optimized data models and architecture to support business initiatives.

Financial ServicesInformation Technology

H1B Sponsor Likely

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 tradeoffs between usability and performance needs

Mentors other ETL Developers and Data Engineers

Qualification

Data warehousingSQLAWS cloud servicesSnowflakeETL maintenanceData modelingRPythonGitCI/CDCustomer-orientedCloud-based technologiesMaster Data ManagementAnalytical skillsProduct management skillsAttention to detailCollaborationEffective communication

Required

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.)

Extensive Experience with SQL required

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

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

Preferred

3-5 years of experience with Snowflake (Snowpipe, Snowpark, Streamlit, Streams/Tasks)

Experience with R or Python

Experience with Git and CI/CD

Experience with cloud-based technologies and services (SaaS, PaaS, IaaS)

Experience with Master Data Management

Benefits

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

Company

Allied Solutions LLC

Allied Solutions uses technology based products and services to meet the insurance, lending and marketing needs of more than 6,000 financial institutions in North America.

Founded in 2000

Carmel, Indiana, USA

1001-5000 employees

http://www.alliedsolutions.net/

H1B Sponsorship

Allied Solutions LLC has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (2)

2023 (2)

2022 (1)

2021 (1)