JOB SUMMARY

The Sr. Data Engineer is responsible for modeling complex problems, building pipelines, maintaining ETL processes and troubleshooting issues within a cloud environment. They utilize cloud databases, Databricks and databases to support a robust infrastructure which drives large, revenue generating data strategies. Additionally, the Sr. Data Engineer suggests architecture ideas and assist junior engineers with their tasks/approaches.

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Participate in use case feasibility discussions and translate business idea / business problems into use cases.
  • Provide support as needed to maintain and update models running in production environment.
• Develop and maintain complex ETL processes and algorithms
  • Own and enhance ETL processes to move data from PMS to cloud databases
  • Monitor and troubleshoot processes on a daily basis
  • Document new and existing processes
  • Proactively and independently identify performance issues and recommend enhancement
• Modernize legacy data models and pipelines using Databricks and cloud database capabilities.
• Work closely with Chief Architect to make improvements and larger architectural changes
• Recommend or suggest improvements to the existing architecture.
• Support junior team members with technical questions, code reviews and code enhancements.
• Understand business problems/needs and provide proposed solutions.

KNOWLEDGE & REQUIREMENTS

REQUIRED QUALIFICATIONS

• Be able to work well with people of various backgrounds and education levels and establish cooperative working relationships with all coworkers.
• Timely and effectively communicate information to and consult with others in order to complete work assignments.
• Act in a responsible, trustworthy and ethical manner that considers the impact and consequences of one’s actions or decisions.
• Communicate ideas, thoughts, and facts in writing through the use of proper grammar, spelling, document formatting and sentence structure.
• Identify and respond to current and future clients’ needs; provide excellent client service.
• Evaluate and analyze problems or tasks from multiple perspectives; adaptively employ problem solving methods to find creative or novel solutions; use logical, systematic and sequential processes to solve problems.
• Complete assigned job tasks in an accurate and timely manner.
• Carefully prepare for meetings and presentations; follow up with others to ensure that agreements, tasks or commitments have been fulfilled.
• Demonstrate commitment to achieving Company’s core business objectives of increasing the role of pharmacy and improving patient health in America.

DESIRABLE QUALIFICATIONS

• Experience working with healthcare professionals in a clinical setting.
• Experience resolving issues that do not have clear answers.
• Experience with Databricks (preferred), Talend, Informatica or other ETL tools.
• Experience working in cloud databases (BigQuery preferred)
• Highly motivated and possessed excellent interpersonal, problem solving, and technical skills.
• High sense of urgency and accountability
• Adaptable, friendly, and ability to work with a team.
• Excellent attendance
• Passion for data and digging into the minutia of datasets.
• Take calculated risks based on data-driven analytics
• Be a self-starter
• Enjoy working in a fast-paced environment.

EDUCATION & EXPERIENCE

• Experience working with healthcare professionals in a clinical setting
• 6+ years of data analysis experience
• Expertise in algorithm design, machine learning, and applied statistics
• Proven track record in use of SQL specifically in cloud databases and working with data including extracting information, validating data, creating and maintaining custom data structures.
• Bachelor’s degree in Business, Computer Science, Information Systems or equivalent combination of education and experience.