Senior Data Engineer
Teladoc Health is a global, whole person care company made up of a diverse community of people dedicated to transforming the healthcare experience. As an employee, you’re empowered to show up every day as your most authentic self and be a part of something bigger – thriving both personally and professionally. Together, let’s empower people everywhere to live their healthiest lives.
Summary of Position
Data Engineers are primarily responsible for creating data pipelines and transforming them into usable data that is stored in Cloud stores or relational databases. They determine the best ways to ingest, manipulate data in the database management system, as well as test programs for efficiency, performance and troubleshoot and correct problems. Individuals are expected to analyze and review business requirement documents, Source to Target Mappings and complex data models. Will be responsible for the end-to-end development and testing of the ETL data pipeline processes, including documenting technical data flows between operational systems. Candidates should have proven experience designing and developing transformation rules to support sourcing from transaction databases.
Essential Duties and Responsibilities
Understands and works on complex issues where analysis of situations or data requires an in-depth evaluation of variable factors.
Exercises judgment in selecting methods, evaluating, adapting of complex techniques and evaluation criteria for obtaining results.
Frequently advises others on complex matters.
Work with various business and IT groups to define, analyze and document the technical requirements.
Document code, provide progress reports, and perform code review and peer feedback.
Own the entire lifecycle of functional specifications and provide timely delivery to business, development, QA and operations team.
Continuously evaluate and identify improvements in the system processes and architecture.
Track milestones, activities and inter-dependencies across projects and tasks, with frequent status updates.
Apt in logical thinking when solving complex business challenges.
Well experienced in programming views, stored procedures, and functions.
Design and implement applications to interface with SQL databases and cloud stores.
Efficient in data modeling, data governance and data integrity for designing, building, and executing requirements to build data pipelines.
Well versed with workflow automation and performance tuning involving creation of database triggers, table indexes and alternate solution designs customed to specific business needs.
Creating and designing Dynamic Code components thus supporting extensibility and implementation of enhancements requiring minimum effort and maximum output.
Apt in Code review and enhancements per standard industry recommendations.
Write test plans; conduct unit testing, regression testing as well as integration testing.
Good in written and verbal communications thus able to coordinate and execute the Projects with Technical and business users.
Able to drive analysis-based outcomes, that help management take informed decisions.
Well versed with all phases of SDLC across environments.
Other duties as assigned.
The time spent on each responsibility reflects an estimate and is subject to change dependent on business needs.
Qualifications Expected for Position
Strong Skills in Data Modelling such as Star Schema, -Snow Flake Schema, Fact, and dimensional tables. Experience in Data integration of various data sources into data staging area and target data warehouse.
Experience with multi-dimensional data models.
ETL / Data Migration Design.
Expert in creating and analyzing complex stored procedures.
Experience in performance tuning and query optimization.
Excellent communication skills supporting recommendations, design ideas, and analysis to Team and stakeholders.
Knowledge of current industry trends in reporting and analytics technologies.
Problem-solving and critical thinking skills.
Experience with large scale OLTP, Data warehouse and cloud systems.
Experience delivering solutions for enterprise level systems.
Proven expertise in Data Analysis, profiling, and data cleansing in a VLDB environment.
Be a self-thinker, initiator, and motivator.
Experience with any scripting or programming language like Python, Shell etc.
Knowledge and familiarity with database security concepts and standard methodologies.
Experience with MySQL, Aurora, or RedShift databases a plus.
Experience with clinical or healthcare data a plus.
Experience with Talend a plus.
Bachelor’s degree in an analytical field (e.g., computer science, business information systems) required; year of work experience may be substituted.
Master in degree in relative field is a plus.
11+ years of experience working as a SQL/data developer.
9+ years of experience in data warehouse environment.
7+ years of experience working with ETL design and development.
7+ years of experience in data analysis/data mining.
5+ years of working experience in Agile and scrum methodology.
Experience working in AWS, Azure or any cloud environment is a plus.
Required license or credential needed to perform job: N/A
The above qualifications, knowledge, experience, and/or background are expected but not required for this role.
☐ Office ☒ Remote ☐ Hybrid (Office & Remote)
Travel percentage reflects an estimate and is subject to change dependent on business needs.
To perform this job successfully, an individual must be able to perform each essential job duty satisfactorily. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform essential job functions. Teladoc Health will make reasonable accommodations for the known physical or mental limitations of an otherwise qualified individual in line with company policy.
Teladoc Health is the global virtual care leader, offering the only comprehensive virtual care solution spanning telehealth, expert medical, and licensed platform services. Teladoc Health serves the world's leading insurers, employers, and health systems and helps millions of people around the world resolve their healthcare needs with confidence.
Job Description Acknowledgment
This job description is a general overview of nature and level of work performed by employees with this job designation It is not intended to be a comprehensive list of all duties, responsibilities and qualifications required of this position. Management reserves the right to add, delete, and/or modify any of the job duties or requirements at any time. I acknowledge that I have read and understand the above job description. By signing this job description, I understand the duties that are expected of me.
Why Join Teladoc Health?
A New Category in Healthcare: Teladoc Health is transforming the healthcare experience and empowering people everywhere to live healthier lives.
Our Work Truly Matters: Recognized as the world leader in whole-person virtual care, Teladoc Health uses proprietary health signals and personalized interactions to drive better health outcomes across the full continuum of care, at every stage in a person’s health journey.
Make an Impact: In more than 175 countries and ranked Best in KLAS for Virtual Care Platforms in 2020, Teladoc Health leverages more than a decade of expertise and data-driven insights to meet the growing virtual care needs of consumers and healthcare professionals.
Focus on PEOPLE: Teladoc Health has been recognized as a top employer by numerous media and professional organizations. Talented, passionate individuals make the difference, in this fast-moving, collaborative, and inspiring environment.
Diversity and Inclusion: At Teladoc Health we believe that personal and professional diversity is the key to innovation. We hire based solely on your strengths and qualifications, and the way in which those strengths can directly contribute to your success in your new position.
Growth and Innovation: We’ve already made healthcare yet remain on the threshold of very big things. Come grow with us and support our mission to make a tangible difference in the lives of our Members.
As an Equal Opportunity Employer, we never have and never will discriminate against any job candidate or employee due to age, race, religion, color, ethnicity, national origin, gender, gender identity/expression, sexual orientation, membership in an employee organization, medical condition, family history, genetic information, veteran status, marital status, parental status or pregnancy.