POSITION SUMMARY
The Sr Data Engineer (DS) will help support our Data Science team in the management and support of XSOLIS’s central data warehouse environment. This role will be responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection used to support our various systems. The Sr Data Engineer (DS) will work closely with the Data Science team, as well as cross functionally, to ensure systems and services achieve maximum success with low computational cost and high scalability driven by the needs of our clients. The Sr Data Engineer (DS) should be collaborative, creative, forward-thinking, have great listening skills, and a strong work ethic.
ESSENTIAL DUTIES AND RESPONSIBILITIES:
The essential functions include, but are not limited to the following:
· Design and create new data structures to support Data Science processes
· Design, develop, and optimize SQL code required to retrieve and consolidate data from external systems into the Data Science data structures
· Design and develop Python code using a variety of libraries with a focus on Pandas and Numpy
· Use database administration knowledge for database security, object permissions, backups, indexes, and performance tuning
· Design systems to monitor batch and streaming ETL processes and alert the team when there is a failure or data inconsistency
· Develop new features to the Data Science prediction stack, care level score compute, and Bokeh reporting environments
· Prepare documentation including technical specifications, processes, source to target mappings, ERDs, data flow documents, and new feature specifications
· Provide mentorship for junior-level developers including training, code reviews, and recommendations of best practices in database design and Data Engineering
MINIMUM QUALIFICATIONS (KNOWLEDGE, SKILLS, AND ABILITIES):
· Bachelor’s degree in Computer Science or other quantitative field of study, trade school certification, or equivalent amount of work experience that demonstrates acceptable knowledge in these skills
· 6 or more years of experience in a Data Engineering or equivalent role
· Experience writing well-abstracted, reusable code components using languages such as python, C#, Go, etc.
· Strong Python development skills and familiarity with common data science libraries (such as NumPy, Pandas, and Scikit-Learn)
· Experience with relational database design
· Expert SQL coder
· Familiarity with basic statistical analysis
· Knowledge of AWS services including Amazon S3, SQS, SNS, Elastic Container Service, and EC2 Servers
· Experience using CloudWatch, Datadog, or other monitoring software
· Experience with Amazon Redshift a plus
· Experience with Kafka a plus
· Strong written and verbal communication skills
· Solid critical thinking and problem-solving skills
· Ability to work independently and collaboratively in a team structured environment
Candidates must successfully pass a background check and drug screen (if applicable) prior to beginning employment with Xsolis. Xsolis Client’s may also require additional screenings.
Xsolis is an equal employment opportunity employer. All employees of Xsolis fall under the same security role, which includes access to sensitive information, including proprietary data and PHI.