
Senior Data Engineer
Allied Solutions LLC1 day ago
Carmel, IN, USASenior
Responsibilities
- Acquire, curate, transform, and integrate data into usable enterprise assets and end-to-end data flows.
- Design, develop, document, and maintain data warehouses, data stores, schemas, dimensional models, and BI-focused data architecture.
- Troubleshoot and correct data and data-processing errors in existing solutions.
- Develop and maintain datasets and standardized data collection and processing methodologies.
- Conduct source-system gap analyses against the enterprise data warehouse to support business intelligence efforts.
- Maintain ETL solutions and provide data security, governance, upgrade, and performance optimization support.
- Develop technical designs and architecture for extracting, integrating, and transferring data to and from third-party providers.
- Collaborate with technical teams, developers, subject matter experts, internal users, external users, and the Data Intelligence department.
- Provide technical advice, participate in architecture meetings, and evaluate trade-offs between usability and performance.
- Identify process improvements and alternative technologies that improve speed to business value.
- Mentor ETL Developers and Data Engineers.
Requirements
- Bachelor’s degree or equivalent education/work experience.
- At least 5 years of experience with data warehousing, databases, including MS SQL Server and Snowflake, and dimensional modeling.
- At least 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 features including Snowpipe, Snowpark, Streamlit, Streams, and Tasks is preferred.
- Extensive SQL experience is required.
- Experience with R or Python is preferred.
- Experience with Git and CI/CD is preferred.
- Experience with cloud-based technologies and services, including SaaS, PaaS, and IaaS, is preferred.
- Experience with Master Data Management is preferred.
- Familiarity with object-oriented analysis, project management, business analysis methodology, and the SDLC.
- Strong analytical, product management, communication, collaboration, customer-service, and problem-solving skills.
Benefits
- Medical, dental, and vision insurance coverage.
- 100% company-paid life and disability coverage.
- 401(k) options with company match.
- Three weeks of paid time off by the end of the first year.
- Career growth opportunities and promotion from within.
- Broad career options across a diverse business portfolio.
About Allied Solutions LLC
Allied Solutions LLC provides technology-enabled insurance, lending, and risk-management products and services to banks, credit unions, and other North American financial institutions. Its B2B portfolio includes collateral protection and tracking, claims and recovery, compliance support, and programs aimed at deposit growth and non‑interest income. Founded in 1978 and headquartered in Carmel, Indiana, the company serves more than 6,000 institutions across the U.S. and Canada.