Data Engineer

Millennium Health; San Diego (CA); Remote; USD 121,000 - 149,000; Full time

Job summary

An established industry player is seeking a skilled ETL Developer to join their innovative team. In this fully remote position, you'll be responsible for designing and maintaining ETL processes using cutting-edge tools like SnapLogic and SSIS. Your expertise will ensure the integrity and security of critical data, helping healthcare professionals monitor medication use effectively. This role offers a collaborative environment where your contributions will directly impact patient care. If you are passionate about data integration and want to be part of a mission-driven organization, this is the perfect opportunity for you.

Benefits

Medical Insurance

Dental Insurance

Vision Insurance

Disability Insurance

401(k) with Company Match

Paid Time off

Holidays

Tuition Assistance

Behavioral Health Resources

Qualifications

• Master's degree or equivalent in Computer Science or related field.
• 1 year experience in ETL development or software engineering.

Responsibilities

• Analyze and maintain ETL/ELT processes using SnapLogic and SSIS.
• Ensure data quality, consistency, and security in data warehouse.

Skills

ETL development using SSIS

ETL development using SnapLogic

SQL Server stored procedures

Data Warehouse methodologies

Logical Database Design

Testing code

Source control tools (Bitbucket, SVN)

Education

Master's degree in Computer Science

Bachelor's degree in related field

Tools

SnapLogic

SSIS

SQL Server

Bitbucket

SVN

Job description

Description

Millennium Health LLC is an accredited specialty laboratory with more than a decade of experience in medication monitoring and drug testing services, helping clinicians monitor the use and misuse of prescription medications and illicit drugs. The testing is used by healthcare professionals to obtain objective information about patients' recent use of prescription medications and/or illicit drugs and helps monitor the effectiveness of treatment plans

• Analyze, design, develop and maintain ETL/ELT (Extract Transform Load/Extract Load Transform) processes and applications using Snaplogic and SSIS ETL/ELT tools and processes.
• Work with application developers, business partners, management, and Data Warehouse team.
• Develop ETL/ELT procedures based on business requirements and service level agreements.
• Deliver quality data integration projects.
• Review requirements, architecture, and design components of ongoing and upcoming projects.
• Develop and document systems, processes and logic required to expose existing data sets in warehouse to end users for reporting and analysis purposes.
• Monitor ETL/ELT applications for performance and improvement opportunities.
• Ensure quality, consistency and security of company data and data warehouse systems.
• Troubleshoot and diagnosis complex software and data problems.
• Perform packaging and release management.
• 100% telecommute position reporting to San Diego, CA.
• Ability to ensure HIPAA, Confidentiality and Compliance policy, procedures, and standards are always adhered to.
• Ability to ensure administrative, physical and technical cyber security controls are always adhered to.

Requirements

Master's degree or equivalent in Computer Science, Computer Engineering, Electrical Engineering, Information Technology or related field.

1 year of experience in ETL development, software engineering, software development or a combination of these fields. Employer will accept pre- or post-Master's degree experience. All experience must be post-Bachelor's degree.

• Work experience to include 1 year of experience with all the skills listed below:
• ETL development using SSIS or SnapLogic.
• Writing, performance tuning, and debugging SQL Server stored procedures.
• Working with Transactional or Fact-Dimensional Databases.
• Utilizing Data Warehouse and BI Reporting methodologies.
• Logical and Physical Database Design.
• Working with SQL and T-SQL.
• Testing self-drafted code.
• Using source control tools, to include Bitbucket and SVN.

• Any and all experience can be gained concurrently.

• 40 hrs./wk.
• Address of employment: 100% telecommute position reporting to San Diego, CA.

Salary Range: $121,368.00 to $148,492.00 per year.

Individuals interested in applying for the position must submit resume with

Job #MV-0921 to: [e-mail].

Millennium Health is an Equal Opportunity/Affirmative Action Employer and E-Verify participant. All qualified applicants will receive consideration for employment without regard to race, color, creed, sex, national origin, disability, gender identity, sexual orientation, or protected veteran status.

Benefits

• Medical, Dental, Vision, Disability Insurance
• 401 (k) with Company Match
• Paid Time off and Holidays
• Tuition Assistance
• Behavioral and Health Care Resources