Senior Data Engineer

JOB SUMMARY (added March 2024)

The Senior 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 Senior Data Engineer suggests architecture ideas, works closely with architects and assists 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 enhancements
• Modernize legacy data models and pipelines using ETL tools 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 technology. 
• Experience resolving issues that do not have clear answers.
• Experience with machine learning and applied statistics
• Experience with Java and Springboot
• Thorough experience with Databricks, Glue, Talend, Informatica or other similar ETL tools.
• Experience working in cloud databases (Redshift, BigQuery)
• 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.
• Passion for data and digging into the minutia of datasets.
• Take calculated risks based on data-driven analytics
• A self-starter and enjoys working in a fast-paced environment

EDUCATION & EXPERIENCE REQUIREMENTS

• Minimum years of work experience:   7 years
  • 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
• Minimum level of education or education/experience:   Bachelors Degree in
  • Bachelor’s degree in Business, Computer Science, Information Systems or equivalent combination of education and experience.
• Experience resolving issues that do not have clear answers.
• Excellent attendance

PHYSICAL REQUIREMENTS

• The physical demands described here are representati