Millennium Health
Data Engineer
Millennium Health, San Diego, California, United States, 92189
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.The Data Engineer will be responsible for the testing, analysis, development and maintenance of data pipeline processes and applications. The position will be about 80% testing and validation of Data Services processes and 20% development. Previous experience using ETL software is desirable. Ideal candidates will be passionate about exceeding client expectations and is driven to learn new data engineering technologies. In addition, candidates must be able to understand complex data structures, and will have a strong understanding of logical and physical database design.Key Responsibilities:
80% testing and validation of data pipelines, dbt models, and enterprise reports and data sources.20% development of data pipelines, dbt model, and Tableau and SSRS reporting.Performing all testing and validation of data transformations to populate data into a warehouse table structure that is optimized for reporting.Recent testing and development working with relational as well as NoSQL data stores and data lake methods and approaches (logging, columnar, star and snowflake, dimensional modeling).Experience testing and performance tuning SQL and data pipelines in OLAP and Data Warehouse environments.Establishing efficient design and programming patterns for engineers.Designing, integrating and documenting technical components for seamless data extraction and analysis.Ensuring best practices that can be adopted in our data systems and share across teams.Working in a team environment, interact with multiple groups daily (very strong communication skills).Must be able to work on-site in the San Diego office.Minimum Requirements:
Bachelor’s degree, preferably in Computer Science or Information Systems.2+ Years experience testing data pipelines, data structures, and enterprise reports.2+ Years experience ETL Development experience using tools like SnapLogic, SSIS, Talend and others.2+ Years experience with writing, debugging and performance tuning SQL code.2+ Years experience with transactional and dimensional database design and development.2+ Years experience working with visualization tools such as Tableau or Power BI.Experience with Data Warehouse design, ETL and ELT models, and architecting efficient software designs for DW platform.Knowledge of database modeling and design in a Data Warehousing context.Strong familiarity with data warehouse best practices.Strong SQL skills, having worked with relational and non-relational databases.Comfortable working within an AWS environment preferred.Ability to work with others or independently.Experience with HIPAA compliance preferred.Proactive individual with good written and verbal communications required.Physical & Mental Requirements:
This position will require the following physical requirements; sitting (75%), walking (15%), standing (10%), lifting up to (10 pounds).This position will require the following mental requirements;
Ability to reason through problems to reach solutions, troubleshooting ability, effective written and verbal communications skills and ability to see, type, speak on phone and work with various departments within the company.Additional Requirements:
This position will require the following mental requirements; while performing the duties of this job, the employee is regularly exposed to high pressure/high stress situations. He/she works in a typical office environment and is occasionally exposed to moving mechanical office machines. The noise level in the work environment is usually moderate. Some travel to job sites and other offices is required. Must be able to travel and work extended schedule as needed.Benefits Offered:
Medical, Dental, Vision, Disability Insurance.401k with Company Match.Paid Time off and Holidays.Tuition Assistance.Behavioral and Health Care Resources.Salary Range: $90,000 - 105,000 per year. Salary offered is dependent on qualifications, experience, and geographical location.Please note this job posting is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.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.
#J-18808-Ljbffr
80% testing and validation of data pipelines, dbt models, and enterprise reports and data sources.20% development of data pipelines, dbt model, and Tableau and SSRS reporting.Performing all testing and validation of data transformations to populate data into a warehouse table structure that is optimized for reporting.Recent testing and development working with relational as well as NoSQL data stores and data lake methods and approaches (logging, columnar, star and snowflake, dimensional modeling).Experience testing and performance tuning SQL and data pipelines in OLAP and Data Warehouse environments.Establishing efficient design and programming patterns for engineers.Designing, integrating and documenting technical components for seamless data extraction and analysis.Ensuring best practices that can be adopted in our data systems and share across teams.Working in a team environment, interact with multiple groups daily (very strong communication skills).Must be able to work on-site in the San Diego office.Minimum Requirements:
Bachelor’s degree, preferably in Computer Science or Information Systems.2+ Years experience testing data pipelines, data structures, and enterprise reports.2+ Years experience ETL Development experience using tools like SnapLogic, SSIS, Talend and others.2+ Years experience with writing, debugging and performance tuning SQL code.2+ Years experience with transactional and dimensional database design and development.2+ Years experience working with visualization tools such as Tableau or Power BI.Experience with Data Warehouse design, ETL and ELT models, and architecting efficient software designs for DW platform.Knowledge of database modeling and design in a Data Warehousing context.Strong familiarity with data warehouse best practices.Strong SQL skills, having worked with relational and non-relational databases.Comfortable working within an AWS environment preferred.Ability to work with others or independently.Experience with HIPAA compliance preferred.Proactive individual with good written and verbal communications required.Physical & Mental Requirements:
This position will require the following physical requirements; sitting (75%), walking (15%), standing (10%), lifting up to (10 pounds).This position will require the following mental requirements;
Ability to reason through problems to reach solutions, troubleshooting ability, effective written and verbal communications skills and ability to see, type, speak on phone and work with various departments within the company.Additional Requirements:
This position will require the following mental requirements; while performing the duties of this job, the employee is regularly exposed to high pressure/high stress situations. He/she works in a typical office environment and is occasionally exposed to moving mechanical office machines. The noise level in the work environment is usually moderate. Some travel to job sites and other offices is required. Must be able to travel and work extended schedule as needed.Benefits Offered:
Medical, Dental, Vision, Disability Insurance.401k with Company Match.Paid Time off and Holidays.Tuition Assistance.Behavioral and Health Care Resources.Salary Range: $90,000 - 105,000 per year. Salary offered is dependent on qualifications, experience, and geographical location.Please note this job posting is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.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.
#J-18808-Ljbffr