Data Analytics Engineer

Lucet•,

20h•$135,000 - $155,000•Remote

About The Position

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. 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! At Lucet, your work will directly support our mission to improve behavioral, physical, and social health—one member at a time.

Requirements

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
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.

Responsibilities

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.
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.
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.

Benefits

Annual compensation between $135,000 - $155,000 PLUS an annual performance-based, discretionary incentive.
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.