Analytics Engineer

This position is focused on efficiently transforming and prepping large datasets for Onpoint’s Analytics staff and clients. The Analytics Engineer plays a key role in designing and maintaining Onpoint’s most complex data transformation logic. The successful candidate will acquire a diverse set of skills in data management, leveraging tools such as SQL, Tableau, python, and many AWS Services to effectively cleanse and enhance hundreds of terabytes of healthcare data for Onpoint’s client base. The successful candidate in this role must be detail oriented and able to work on multiple projects at a time., * Use industry best practices to extract and transform data from data lakes using Spark SQL, python, and AWS services such as AWS Glue.

• Contribute efforts to research, evaluate, recommend, and implement new products, tools, and software solutions.
• Participate in analysis, design, development, and implementation of data solutions.
• Collaborate on system architecture and data model development.
• Make meaningful contributions to design sessions; gather and understand user requirements and assist with development and finalization of specifications.
• Follow project specifications closely and clearly communicate progress and status.
• Take an active role in maintaining existing data pipeline code base, troubleshooting issues, and optimizing code for performance.
• Perform operational, production support, and maintenance tasks.

• Contribute to end user technical training and documentation.

• Understand the value that Onpoint places on maintaining the confidentiality and integrity of our corporate and client data and meet applicable privacy and security compliance requirements
• Ensure that Onpoint and client data is accessed, handled, processed, transmitted, disclosed, and stored according to operational and IT policies and procedures
• Immediately report any suspected or actual violation of privacy and security policies or unauthorized access or disclosure of Onpoint or client data
• Understand that compliance with all privacy and security policies, laws, and regulations is part of each employee’s annual performance evaluation
• Adhere to all policies and procedures as outlined in the Onpoint Health Data Employee Handbook
• Perform all other duties as assigned

• A bachelor’s degree or higher in computer science or related field plus one (1) or more years in systems development or data engineering
• Experience with SQL and python is preferred
• Familiarity with HEDIS measures preferred
• Familiarity with Hadoop, SparkSQL, Amazon EMR, Parquet, Amazon Athena, Amazon Redshfit not required, but desirable
• Knowledge of performance tuning - analyzing log data and query tuning, partitioning, optimizing code
• Experience with Unix or Linux environments preferred
• Experience working with healthcare data preferred
• Demonstrated ability to learn and work with new tools as system as business needs evolve
• Experienced in diagnosing technical challenges by reading code and technical documentation
• Ability to produce clear and concise technical documentation
• Ability to work well independently and as part of a team
• Strong problem solving and critical thinking skills
• Excellent organizational, interpersonal, and time management skills

Onpoint Health Data is a dynamic, fast growing nonprofit company committed to delivering independent, reliable, and insightful data solutions to clients nationwide. If you are a motivated self-starter looking for the opportunity to work with emerging technologies and a collaborative, energetic team, Onpoint would be a perfect fit. We offer a competitive compensation and benefits package, and a great office space conveniently located in Portland’s historic Old Port district.