Data Engineer

Liberty Dental Plan Careers•Tustin, CA

2h•Remote

About The Position

Join Liberty Dental Plan and help us transform healthcare through data! We’re looking for a Data Engineer who thrives on building scalable data solutions and enabling actionable insights. If you’re passionate about data architecture, automation, and innovation, this is your opportunity to make an impact. The Data Engineer is responsible for designing, constructing, and maintaining the systems and infrastructure required to process and analyze large volumes of data. This role will work closely with data scientists, analysts, and other stakeholders to ensure data is collected, stored, and processed efficiently. The Data Engineer will also develop and implement data pipelines, perform data quality checks, and optimize data storage and retrieval.

Requirements

Bachelor’s degree in Computer Science, Data Science, Mathematics, or related field.
2+ years of experience in data analysis, ETL, and data warehousing, including experience working with MS SQL Server database and Microsoft BI stack (SSIS, SSRS, SSAS, and Power BI).
Ability to independently execute mid-level data engineering tasks with ownership of projects.
Ability to implement Data Warehouse modeling techniques to capture complex business requirements.
Ability to contribute to the development of scalable data solutions and streamline reporting.
Strong proficiency in SQL, specifically with MS SQL Server 2012 and higher, and Python and libraries like Pandas, PyODBC, NumPy, is required.
Experience with BI tools (Power BI) and data visualization.
Strong analytical and problem-solving skills.
Experience with BI/DW lifecycle including source data analysis, ETL, data-marts, reporting, dashboards and analytics.
Strong verbal/written communication and data presentation skills, including an ability to effectively communicate with both business and technical teams.

Nice To Haves

Experience using Azure Synapse, dbt, Dagster or Airflow, and Fabric is highly desirable.
Experience with AGILE methodology, desirable.
Experience with Healthcare data not required, but highly desirable.
Experience with healthcare data and Kimball methodology.

Responsibilities

Develop and maintain KPIs, metrics, and dashboards by leveraging diverse datasets.
Ensure data quality and integrity through data validation, cleansing, and error handling.
Design and implement back-end processes using data warehouse modeling techniques.
Build and optimize ELT pipelines to capture and transform data for analytics and reporting.
Partner with cross-functional teams to gather and refine business requirements for data solutions.
Implement data security measures and access controls to protect sensitive information.
Automate and improve data processes and workflows for scalability and efficiency.
Develop, test, and maintain high-quality code in SQL, Python, Power BI, Azure Synapse, dbt, Airflow or similar programming languages.
Distill problem definitions, models, and constraints from informal business requirements.
Monitor data infrastructure for performance and reliability to address issues promptly.
Participate in data governance and compliance efforts to meet regulatory requirements.

Benefits

Competitive pay structure and savings options to help you reach your financial goals.
Excellent 401(k) retirement benefits, including employer match, Roth IRA options, immediate vesting during the Safe Harbor period, and access to professional financial advice through Financial Engines.
Affordable medical insurance, with low-cost premiums for employee-only coverage. Liberty subsidizes the cost for eligible dependents enrolled in the plan.
100% employer-paid dental coverage for employees and eligible dependents.
Vision insurance with low-cost premiums for employee-only coverage and dependents.
Company-paid basic life and AD&D insurance, equal to one times your base salary, with options to purchase additional supplemental coverage.
Flexible Spending Accounts for healthcare and dependent care expenses.
Voluntary benefit programs, including accident, critical illness, and hospital indemnity insurance.
Long-term disability coverage.
Expansive wellness programs, including company-wide wellness challenges, BurnAlong memberships, and gym discounts.
Employee Assistance Program (EAP) to support mental health and well-being.
Generous vacation and sick leave policies, with the ability to roll over unused time.
10 paid company holidays.
Tuition reimbursement for eligible educational expenses.
Remote or hybrid work options available for various positions.