Data Warehouse Engineer, Lantern

• The ideal candidate will have hands-on experience with Azure Data Factory, Fivetran, and dbt, and a strong understanding of modern data architecture and performance tuning
• Bachelors degree in computer science or related field
• 3-5 years of experience with reporting and analytics
• Proven experience with ELT tools such as Azure Data Factory, Fivetran, and dbt
• Strong SQL skills and understanding of data warehousing concepts
• Experience with performance tuning and data model optimization
• Ability to collaborate effectively with cross-functional teams
• Familiarity with cloud data platforms (e.g., Azure, Snowflake, BigQuery) is a plus
• You use LOGIC in your decision making and understand that progress is critical to making change. You focus on the execution of your content while balancing a fast-paced environment and you take the time to celebrate both the small & big wins
• INCLUSION is a core tenant of your personal beliefs. A diverse and inclusive environment is incredibly important to you. You understand and desire to be a part of a diverse team with different experiences and perspectives & you cherish the differences in each individual that you interact with
• You have the GRIT, drive and ambition to tackle big problems. Big problems require big ideas and a team that supports new ideas
• You care deeply for your customers are driven to keep HUMANITY in all decisions. Your customers aren’t just the individuals using your product. They are the driving factor in your motivation to make a change
• Integrity guides you in life. Focusing on the TRUTH vs. giving people the answers they want to hear
• You thrive in a Team Environment. Collaboration is key in innovation and creating change
• These pillars of LIGHT are a reminder to our team that we are making a difference by providing guidance and support in navigating the often complex and confusing landscape of healthcare. We hope that through this LIGHT, individuals can find their way to the best care, resources, and support they need to get back to life
• If this sounds like you, we would love to connect to speak further about career opportunities at Lantern

Desirable

• This role will focus on building and maintaining robust ELT pipelines, designing scalable data models, and optimizing analytic performance within the Lantern Analytic Platform
• Implement and Monitor ELT Pipelines:
• Design, develop, and maintain scalable ELT workflows using Azure Data Factory, Fivetran, and dbt. Proactively monitor pipeline health and troubleshoot issues to ensure reliable data delivery
• Data Modeling and Collaboration:
• Partner with data analysts to understand business needs and translate them into efficient, well-documented data models using dbt. Continuously refine models to support evolving analytic requirements
• Analytics Platform Optimization:
• Manage and optimize the Lantern Analytic Platform by monitoring query performance, implementing data partitioning strategies, and refining data models to enhance speed and efficiency