Senior Python Data Analyst Jobs in Portland, ME (NOW HIRING)

Onpoint’s office is located in the heart of Portland’s historic Old Port alongside a strong network of local businesses, historic neighborhoods, and walking and biking paths that connect the downtown with Greater Portland. We offer our employees a competitive salary and benefits package that includes:

• Healthcare Coverage. Comprehensive healthcare options, including medical, dental, and vision plans
• Retirement Plan. 403(b) retirement plan with an employer profit‑sharing contribution plus employer match
• Life & Disability Benefits. 100% employer‑paid life insurance and disability benefits
• Paid Time Off. 12 paid holidays and 20 days of paid time off in your first year
• Tuition Reimbursement. Annual reimbursement of $5,250 for career‑related courses at an accredited college or university
• Health & Fitness Reimbursement. $250 annual reimbursement for gym memberships, home fitness equipment, and more
• Cell Phone Stipend. $75 per month cell phone stipend paid directly to you each pay period

Onpoint is an equal‑opportunity employer with a staff of 80+ who share a set of core values that shape our daily work. Our staff remains the key to our success, providing a valuable mix of knowledge and fresh perspectives. We also have fun along the way, sharing in regular celebrations of work achievements, all‑staff outings (go, Portland Sea Dogs and Maine Mariners!), and employee‑led activities like recreational sports leagues and a book club.

Together, we do more than work on deadlines and deliverables. We work on important solutions that make our communities better. If you’re looking for a career where your skills directly translate into a better healthcare system and more informed decision‑making, consider joining our team!

OVERVIEW

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.

RESPONSIBILITIES

• 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.
• 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.

QUALIFICATIONS

• 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 Redshift 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.

This is a hybrid role with 3 in‑office days required each week – Tuesday, Wednesday, Thursday.

OVERVIEW

The Client Account Manager is responsible for the cultivation, administration, and maintenance of client relationships; develops an in‑depth knowledge of data products and services, including a fundamental knowledge of data management processes, tools, and structures, and of the underlying data itself; conducts quality assurance review processes and identifies and participates in internal process and product improvement initiatives; coordinates and prioritizes projects and deliverables; provides effective project management and excellent customer service for Onpoint’s clients; and ensures quality and timeliness standards are achieved for client deliverables.

RESPONSIBILITIES

Project and Client Relationship Management

• Develop and oversee implementation of company‑wide project management processes, tools, and methods.
• Project management and other project‑related responsibilities associated with medium‑sized data management and reporting systems development, implementation, and ongoing operations support; requires proactive project and program planning, timely and effective communication including appropriate documentation; and internal coordination and follow‑through.
• Proactively identify and address customer needs, be continuously alert and responsive to changing customer business needs, and ensure effective integration with service delivery capabilities and priorities.
• Develop and manage contractual scope of work within allowed resources, identifying and addressing the need for internal discussion and potential contract amendments.
• Provide timely and effective on‑site, telephone, and/or videoconferencing support (e.g., client inquiries, requests for ad hoc reporting assistance, miscellaneous research) and training to clients and data users.
• Manage and monitor client satisfaction, recommend appropriate strategies, tactics, and operational initiatives to continuously enhance the client experience.

Quality Assurance

• Develop knowledge of data submission specifications, collection and release procedures, and/or regulations.
• Lead and/or support organization‑wide process improvement initiatives.
• Help reinforce a culture of continuous improvement characterized by efficient work systems, effective documentation and training, and ongoing monitoring and improvement.
• Seek and communicate input from customers around product improvements.

Business Development

• Assist in new business development, including cultivation of new work with existing clients, assisting with responses to RFPs, participation in regional and national meetings and initiatives, and other outreach efforts.

Other

• Understand the value that Onpoint places on maintaining the confidentiality and integrity of our company 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.
• Adhere to all policies and procedures as outlined in the Onpoint Health Data Employee Handbook.
• Perform all other duties as assigned.

QUALIFICATIONS

• General healthcare business knowledge preferred.
• 3‑5 years project management experience (PMP certification preferred).
• Experience and knowledge of healthcare claims data and processes, including standard transaction sets, coding methods, and processing.
• Strong analytic skills with the necessary attention to detail.
• A bachelor’s degree or higher.
• Three or more years in health data management and/or healthcare‑related positions.
• Strong computer skills, preferably with knowledge of SQL, MS Excel, and other data management tools.
• Familiarity with Tableau/BI tool solutions (preferred).
• Excellent organization, time management, and project management skills, with a track record of consistent and effective follow‑through.
• Excellent written and verbal communication skills with demonstrated ability to work in a team‑oriented culture.
• Strong work ethic and commitment to excellence, including leading by example.
• Ability to work independently.

This is a hybrid role with 3 in‑office days required each week – Tuesday, Wednesday, Thursday.

OVERVIEW

The Health Data Analyst (HDA) works closely with the Analytics team to review, analyze, and provide graphical and verbal presentation of health care data. The HDA learns to run queries and interprets outcomes to provide a key quality assurance role for our clients’ data. The HDA will also run reports that inform our clients on health care quality, access, and cost. Under direction of senior staff, the HDA also investigates unusual findings in the data and helps build new reports and products. The HDA must be detail oriented, capable of learning independently, and able to work on multiple projects at a time in a fast‑paced, team‑oriented environment.

RESPONSIBILITIES

Analysis and Reporting

• Learn to use software tools such as SQL, SAS, R to query medical claims data and provide clients reports for multiple projects (e.g., use existing code to conduct linkages, run quality measure rates, refresh of person level files for analytic use).
• After becoming familiar with coding tools, begin to modify code to develop new reports.
• Prepare graphical reports using Tableau, Excel, and other statistical programs and PowerPoint.
• Work with senior members of the Analytics Team to present health data in an accurate, efficient, and thoughtful manner.
• May take a lead analyst role on client/project after becoming familiar with Onpoint processes and databases.

Quality Assurance

• Support analytic staff by running Onpoint’s data quality processes for extracts and other Onpoint products and reports. This may include running queries using SAS and SQL to identify unusual findings in analyses and reports and reviewing them with the project lead and senior analysts.
• Assist with evaluation and testing of new software applications.
• Help complete review and quality assurance of multiple Onpoint reports and deliverables.

General

• Work with Health Analytics Manager and project leads regularly to balance multiple projects and priorities.
• Begin to develop expertise in All Payer Claims Data, Onpoint’s data systems, and other healthcare topics.
• Begin to develop strong understanding of relational databases.
• Actively seek opportunities to learn and contribute more to the team.
• As a member of a broader team, take on and perform duties beyond specific role as assigned.

Other

• 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.

QUALIFICATIONS

• Bachelor’s degree in sciences, mathematics, or another major with an emphasis on analytical or quantitative skills development, or equivalent experience.
• Strong problem solving and critical thinking skills.
• Proficiency utilizing Excel and/or other data visualization tools to work with and analyze data sets.
• Excellent verbal and written communication skills.
• An interest in working with clients in a professional environment.
• Detail‑oriented.
• Experience handling multiple projects while successfully meeting deliverable due dates.
• Experience working collaboratively as well as independently within multidisciplinary teams.
• Experience in health care data and analysis, health information technology, statistics, relational databases, and/or knowledge of querying and analytical tools (e.g., SAS, SQL, Tableau, R, Python, Excel) preferred.

This is a hybrid role with 3 in‑office days required each week – Tuesda