Senior Data Integration Engineer
About Lantern
Lantern is the specialty care platform connecting people with the best care when they need it most. By curating a Network of Excellence comprised of the nation's top specialists for surgery, cancer care, infusions and more, Lantern delivers excellent care with significant cost savings to employers and their workforces. Lantern also pairs members with a dedicated care team, including Care Advocates and nurses, for the entirety of their care journey, helping them get back to good health, back to their families and back to work. With convenient access to specialists nationwide, Lantern means quality care is within driving distance for most. Lantern is trusted by the nation's largest employers to deliver care to more than 6 million members across the country. Learn more about us at lanterncare.com.
About You:
- 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.
Please apply to our role & someone from our Talent Acquisition Team will reach out to help you navigate our interview process.
The Sr Data Integration Engineer shall apply specialized knowledge to conceptualize, design, develop, configure, and implement data engineering solutions that move, clean, and load data across multiple systems within EDHC. This role will have a strong focus on Salesforce and MuleSoft integrations, ensuring secure and scalable data exchange across enterprise platforms. The engineer will collaborate with business and IT teams to understand business needs, design integration solutions, and deliver modern, maintainable data pipelines.
The teams supported include: Application Engineering, Data Engineering, Decision Science, and Business Analytics.
Location: Remote, USA
A successful candidate will:
- Build robust and automated pipelines to ingest and process structured and unstructured data sources, with an emphasis on Salesforce CRM data and MuleSoft API-led integrations.
- Develop high-performance data queries, stored procedures, and ETL/ELT processes for Salesforce, MuleSoft, and enterprise data warehouses.
- Leverage the right tools (SQL, MuleSoft, Salesforce APIs, Azure, Power BI) to deliver scalable, testable, and maintainable solutions.
- Troubleshoot data integration issues, identify root causes, and work closely with business and technical teams to resolve them.
- Stay current with evolving Salesforce and MuleSoft technologies to ensure best practices are applied in solution delivery.
Responsibilities and Duties
- Design, develop, and maintain MuleSoft APIs, connectors, and integration flows to enable seamless data movement across Salesforce and other enterprise applications.
- Build and optimize Salesforce data pipelines, including data extraction, transformation, and loading into analytical platforms.
- Ensure integration solutions adhere to security, data governance, and performance standards.
- Collaborate with Salesforce administrators, developers, and architects to align data strategies with business needs.
- Document requirements and translate them into technical system specifications.
- Execute and coordinate requirements management and change management processes.
- Perform unit and integration testing for MuleSoft and Salesforce pipelines.
- Provide support for data-related issues within Salesforce, MuleSoft, and enterprise data warehouses.
- Act as a subject matter expert for Salesforce data models and MuleSoft integration patterns.
- Explore new integration technologies and contribute to innovation within the data engineering team.
Qualifications:
- Bachelor’s degree in IT or related field preferred; equivalent combination of education and experience acceptable.
- 5+ years of professional data engineering experience in enterprise-scale environments.
- 3+ years of MuleSoft development experience (API design, Anypoint Studio, API Manager, RAML).
- 3+ years of Salesforce data integration experience (Salesforce APIs, Bulk API, Data Loader, SOQL).
- 6+ years of SQL development experience (ETL, ELT, complex queries, and data analysis).
- 3+ years working with enterprise data warehouses.
- Experience with Azure Data Factory and/or Enterprise Data Lakes.
- Experience with Databricks (big plus).
- 1+ years of Microsoft Power BI report development.
- Strong Data Modeling capabilities, including designing conceptual, logical, and physical data models to support integration and analytics.
- Good to have programming experience in Java, C#, Python, or another object-oriented programming language.
- Experience with CMD shell, PowerShell scripting, or automation frameworks.
- Strong problem-solving and data troubleshooting skills.
- Ability to work in large-scale, complex data environments.
- Excellent communication skills, with the ability to collaborate with technical and non-technical stakeholders.
- Strong organizational skills and attention to detail.
- Self-motivated with the ability to manage multiple priorities in a fast-paced environment.
- Healthcare industry experience – Nice to have.
Benefits:
- Medical Insurance
- Dental Insurance
- Vision Insurance
- Short & Long Term Disability
- Life Insurance
- 401k with company match
- Flexible Paid Time Off
- Paid Parental Leave
Lantern does not discriminate on the basis of race, sex, color, religion, age, national origin, marital status, disability, veteran status, genetic information, sexual orientation, gender identity or any other reason prohibited by law in provision of employment opportunities and benefits.
Apply for this job
*
indicates a required field