Data Analytics Engineer

Who We Are

At Lucet, we are industry leaders in behavioral health, dedicated to helping people live healthy, balanced lives. Our purpose is to advocate for and improve the overall well-being of those we serve, through balanced treatment of the mind and body.

When you join Lucet, you become a valued member of our team, serving more than 15 million people across the U.S. Our employees have a passion for helping others - and it shows. From entry-level employees to senior leaders, we are inspired by our members, putting them first in everything we do. From day one, you'll see firsthand the impact you have on our members, knowing you can make a true difference in their lives.

Why Join our Team

At Lucet, we’re committed to creating a workplace where top talent thrives both personally and professionally. We offer a dynamic, mission-driven environment where your work has real impact, your unique background and experience are valued, and no two days are alike. If you’re passionate about meaningful work and delivering impactful results, we encourage you to apply!

We support our team with a competitive compensation and benefits package, including:

• Annual compensation between $135,000 - $155,000 PLUS an annual performance-based, discretionary incentive.
• *Compensation is dependent on non-discriminatory factors including but not limited to an applicant's skills, education/degrees, certifications, prior experience, market data, and other relevant factors.
• Comprehensive health benefit options: Medical, dental, and vision coverage
• 401(k) with competitive employer match
• Company-paid life and disability insurance
• Paid parental leave and wellbeing incentives
• Generous paid time off, including volunteer time
• Flexible spending accounts for healthcare and dependent care
• Professional development opportunities and tuition reimbursement
• Remote work flexibility (role-dependent)
• Opportunity for meaningful growth, both personally and professionally, where your unique background and experience is welcomed and valued.

At Lucet, your work will directly support our mission to improve behavioral, physical, and social health—one member at a time.

What You Will Do - Essential Functions

The Data Analytics Engineer designs, develops, and supports cloud and on-premises data warehouse solutions that enable reporting, business intelligence, and analytics. This role builds and automates data pipelines, data marts, and data lake integrations using technologies such as Snowflake, SQL Server, AWS, Python, Airflow, and DBT while ensuring data quality, performance, and reliability. The Data Analytics Engineer collaborates across teams to deliver scalable data solutions, optimize existing processes, and support the organization's long-term data strategy through Agile development and continuous improvement practices.

•  Data Warehousing & Analytics
  

  • Develop, maintain, and optimize cloud and on-premises data platforms using Snowflake and Microsoft SQL Server, ensuring reliable, high-performing data warehouse, mart, and lake solutions.

  • Build and support analytics-ready datasets for reporting and business intelligence while troubleshooting and improving data platform performance, reliability, and accessibility.

• Data Engineering & Automation
  

  • Design, develop, and maintain scalable data pipelines and ETL/ELT workflows using Airflow, DBT, Airbyte, SSIS, SQL, Python, and Snowflake technologies to support data integration, automation, and analytics.

  • Support Agile data engineering practices by building Airflow DAGs, leveraging Snowflake capabilities, and managing CI/CD, database migrations, and source control processes using AWS and Git-based tools.

• Cloud Platforms & Data Quality
  

  • Support and maintain AWS cloud and on-premises data environments, ensuring secure, reliable, and high-performing data platforms through effective monitoring and administration.

  • Collaborate with business and technical stakeholders to deliver scalable analytics solutions while identifying and resolving data quality, integrity, and performance issues.

Who You Are

• Required Qualifications
• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Information Technology, Engineering, or a related field, or an equivalent combination of education and experience.
• 3+ years of experience in data engineering, analytics engineering, data warehousing, or related data management roles.
• 2+ years healthcare data experience
• Experience developing and supporting data warehouse solutions using Snowflake and/or Microsoft SQL Server.
• Proficiency in SQL development, including writing, optimizing, and troubleshooting complex queries and data transformations.
• Experience developing and supporting ETL/ELT processes and data pipelines.
• Working knowledge of Python and commonly used data libraries such as Pandas and Boto3.
• Experience with data orchestration and automation tools such as Airflow, DBT Core, Airbyte, SSIS, or SQL Agent.
• Knowledge of cloud platforms, preferably AWS, including services such as S3, EC2, VPC, and IAM.
• Experience using source control and DevOps tools such as Git, CodeCommit, CodeDeploy, or similar technologies.
• Knowledge of Agile development methodologies and software development lifecycle (SDLC) practices.
• Strong analytical, problem-solving, and troubleshooting skills.
• Effective written and verbal communication skills with the ability to collaborate across technical and business teams.
• Willingness to work occasionally outside of normal business hours.
• Ability to pass a background check upon hire and throughout employment which includes: County and Federal Criminal Records Search - felonies and misdemeanors ; InstaCriminal Multi-State Alias
  Search - National Sex Offender Registry, Multi-State Criminal Database, SSN validation and trace, and Most Wanted Lists (OFAC); Excluded Parties List System (EPLS)/SAM search - individuals/entities
  debarred, suspended, or otherwise excluded from receiving federal contracts, subcontracts, or federal assistance; Education Verification; Employment Verification; FACIS Level I - Sanctions or exclusions for federal and state healthcare programs; 10-panel drug screening; and E-Verify: Lucet does not use E-Verify to pre-screen applicants and complies with federal regulations prohibiting discrimination based on national origin or citizenship status
• Someone who embodies our values by:
• Serving everyone with compassion and leading with empathy.
• Stepping up and creating value by taking charge and acting when there is an opportunity.
• Adapting in a changing world by recognizing our responsibility to be agile and respond quickly.
• Nurturing growth and belonging by respecting and celebrating everyone for who they are.
• Competencies
• Must be detail oriented.
• Organization and time management skills.
• Strong analytic and problem-solving skills.
• Ability to work both independently and in various team settings.
• Responsible with a high level of integrity and ethical standards
• Intuitive nature to identify compliance irregularities
• Excellent communication and interpersonal skills, with the ability to collaborate across teams.
• Working Conditions:
• High-speed internet service (cable or fiber optic) with minimum download Speed of 20 Mbps, Upload Speed of 5 Mbps, and Maximum Latency of 100 milliseconds (must be installed before starting) required.
• Frequent use of computer and phone systems
• Must be able to constantly remain in a stationary, sitting position, communicate and exchange information with others, inspect information, perform repetitive motions with arms and fingers, interpret data, problem solve, make decisions, organize and plan, and maintain a positive and professional attitude in all situations.
• Work is performed from home with company-provided equipment. Sitting for long periods of time is expected and use of fingers and hands for typing is necessary.
• A quiet workspace with minimal background noise for calls.

We encourage applicants from a variety of backgrounds and experiences to apply, especially those who can demonstrate how their unique qualifications and skills align with the requirements of this role and support our mission to improve whole-person health.

This position will accept and review new applications and resumes no less than 5 business days after the original posting date and may remain open an extended period of time with no set end date based on the level of interest.