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 are a team of collaborative and hard-working professionals working to improve behavioral health outcomes working in a fast-paced and changing environment. At Lucet, no two days are the same. If you find joy in meaningful work and delivering excellent results, we encourage you to apply!

We are looking for top-tier skills and experience in our remote-work environment and that’s because we offer top-tier compensation and benefits, which include:

Annual compensation between $110,000 - $120,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.

Health Insurance – $0 premium for employee-only coverage in our core program for those participating in our Wellbeing Incentive Program.

401(k) with competitive employer match

Company paid life and disability insurance, wellbeing incentives, and parental leave

Professional development opportunities and tuition reimbursement

Paid time off including paid time off for volunteering

Opportunity for meaningful growth, both personally and professionally, where your unique background and experience is welcomed and valued.

What You Will Do - Essential Functions

The Data Analytics Engineer will be responsible for strategically engineering, developing, and supporting on-premises and Cloud data applications and processes. The Data Analytics Engineer will also maintain related systems while ensuring high levels of data availability and data quality for the organization. The Data Analytics Engineer must retain a modern working knowledge of legacy and cloud-based data platforms using self-study and educational learning aids.

Data Architecture \& Cloud Expertise

• Assess and promote long-term goals for data warehousing across cloud and on-premises environments.

• Design and implement Cloud and On-prem Data Marts for BI and reporting needs.

• Research and recommend data warehouse products, services, and standards for procurement and development.

Development \& Automation

• Apply Agile methodologies within SDLC for project development and delivery.

• Implement process automation and orchestration using tools like Airflow, DBT, Airbyte, SSIS, and SQL Agent.

• Create complex Airflow DAGs in Python and leverage Jinja templates for workflow customization.

Technical Expertise

• Proficient in Snowflake and Microsoft SQL Server, including advanced Snowflake features (Tasks, Streams, SnowAPI).

• Intermediate skills in AWS architecture (S3, EC2, VPC, IAM) and CICD tools (CodeCommit, CodeDeploy).

• Skilled in SQL (ANSI \& T-SQL), Python (Pandas, BOTO3), and daily use of GIT, Cloud9 IDE, and Flyway for version control and migrations.

Adhere to Lucet’s Mission Statement, Core Values, Behaviors, Code of Ethical Business Conduct, and Compliance Program.

Comply with all Federal and applicable Stateand local laws and Lucet Policies and Procedures regarding privacy, confidentiality, and security of health information, and other designated information.

Who You Are

Required Qualifications

• Four years of college/BS in an IT related field or relevant experience.

• Working technical experience with designing, building, installing, configuring, and supporting on premise and Cloud data warehouse/data management systems

• 1-3 years’ experience with big data and related products (Cloud and/or On Premise)

• 1-3 years healthcare data experience

• Strong understanding of relational database structures, theories, principles, and best practices

• Relevant work experience dealing with production issues and debugging issues.

• Willingness to work occasionally outside of normal business hours.

• Ability to pass background check upon hire and throughout employment to include criminal felony \& misdemeanor search, SSN validation/trace search (LEIE), education report (highest degree obtained), civil upper and lower search, 7-year employment report, federal criminal search, statewide criminal search, widescreen plus national criminal search, health care sanctions-state med (SAM), national sex offender registry, prohibited parties (OFAC) (terrorist watchlist), and a 10-Panel Drug Screen.

Preferred Qualifications

• AWS certified / Snowflake Certified

• Experience with on premise to Cloud migrations.

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:

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

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

We encourage applicants with a range of experiences who can demonstrate how their qualifications and skills align with the requirements of this role.

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.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.