DataJobs.io
← Back to all jobs

Job Description

At Allied Solutions, the Senior Data Engineer supports the company’s Data Strategy by turning raw data into reliable, usable assets. This onsite role in Carmel, IN focuses on building modern data architecture that enables business intelligence, advanced analytics, and data monetization outcomes.

What you’ll do

  • Create and maintain detailed documentation for the data warehouse, data stores, and end-to-end data flows.
  • Troubleshoot and fix data and data processing errors within existing solutions to improve reliability.
  • Collaborate with technical teams and internal and external users to develop technical designs and data approaches.
  • Develop and continually refine the BI-focused data architecture that supports reporting and analytics.
  • Partner closely with the Data Intelligence department to understand data and reporting requirements and deliver the necessary back-end steps.
  • Perform gap analysis between source system databases and the enterprise data warehouse to support BI efforts.
  • Develop and maintain data sets while standardizing data collection and processing methodologies.
  • Provide technical advice and weigh in on decisions impacting cross-functional teams.
  • Participate in architecture meetings to help define project scope, time frames, and cost estimates.
  • Work on plans and architecture to extract, integrate, and/or push data to and from third-party providers.
  • Deliver enterprise data solutions, including ETL maintenance, warehouse data models, periodic upgrades, security, governance, and performance optimization.
  • Maintain a clear understanding of warehouse and data mart models and the business information within each.
  • Identify process improvement opportunities and alternative technologies to enhance speed to business value delivery.
  • Collaborate with developers and subject matter experts to define technical vision and analyze trade-offs between usability and performance.
  • Mentor other ETL Developers and Data Engineers.

What you bring

  • Bachelor’s Degree required, or equivalent education/work experience.
  • 5+ years with data warehousing and databases including MS SQL Server and Snowflake, plus dimensional modeling.
  • 5+ years of end-to-end data analysis and development.
  • 3-5 years with AWS cloud services including AWS Glue, AWS Lambda, and S3.
  • 3-5 years with Snowflake (Snowpipe, Snowpark, Streamlit, Streams/Tasks) preferred.
  • Extensive SQL experience 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 as part of a team.
  • Customer-oriented problem-solving mindset while maintaining productivity, efficiency, and quality.
  • Effective communication with clients, management, and project partners.
  • Experience with SaaS, PaaS, and IaaS preferred.
  • Experience with Master Data Management preferred.
  • Strong analytical and product management skills, including interpreting customer business needs and translating them into application and operational requirements.

Tools and technologies

SQL, MS SQL Server, Snowflake, AWS Glue, AWS Lambda, S3, Snowpipe, Snowpark, Streamlit, Streams/Tasks, R, Python, Git, CI/CD, SaaS, PaaS, IaaS

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
  • Career growth opportunities for employees of all levels

Similar Jobs