Database Developer

Overview:
Partnership Solutions is currently seeking a Database Developer. The key function of this position is to collaborate with the Business and Data Solutions team to identify opportunities and deploy systemic tools to transform manual tasks and automate them to improve both operational effectiveness and upgrade process integrity to mitigate risk of loss.
The scope of this role also includes collaboration with functional areas throughout the enterprise to optimize the dissemination and reporting of key data elements and performance measures, as well as pursue process automation across the business and external vendors.
This position requires a solid grasp of SQL, strong analytical mindset, and hands on experience with data warehousing and ETL projects. The Database Developer will have some programming and application development background (Python, C#, JavaScript, etc.) and experience with analytical reporting / business intelligence suites (Tableau, PowerBI, SAS, etc.). A background in healthcare data and a fundamental understanding of managed care operations is desirable.
At Partnership Solutions, our work is performed in support of, and on behalf of, Care Design NY (a Care Coordination / Health Home), and Partners Health Plan (a Managed Care Organization), dedicated to providing supports and services for persons with intellectual and/or developmental disabilities. As their administrative arm, we share in a unified organizational culture and the work we do is in furtherance of our collective ability to achieve our shared organizational mission, vision, and values as stated below:
Purpose - Connecting people to their chosen supports to live a healthy and meaningful life.
Vision – We see a world that is accepting, inclusive, and promotes positive health for all individuals with intellectual and /or developmental Disabilities (I/DD).
Mission – Our mission is twofold: to provide compassionate, skilled person-centered care planning that includes a holistic approach to health and wellness, and to advocate for a disability inclusive world.

Values -

• Committed - We are committed to developing successful employees across the organization so members and families can receive high-quality supports.
• Compassionate - We are compassionate about creating open, honest relationships through collaboration, active listening, and showing empathy for others.
• Connected - We are connected to each other through a sense of belonging that enriches the work environment and shapes a positive experience for members and families.

All full-time positions come with generous benefits including $3000 tuition reimbursement per calendar year, and up to $250 of professional development courses! Click here to view the current benefits summary.
This position is virtual. Occasional travel to Partnership Solutions offices may be required.

Responsibilities:

• Assist in the establishment and maintenance of the data warehouse.
• Generate reports / dashboards necessary to successfully operate the business and establish strategy.
• Participate in end-to-end architectural design and development lifecycle for new data.
• Participate in cross-functional team collaboration to understand customer requirements, design prototypes, and optimize existing data.
• Develop, test, and document software code for data extraction, ingestion, transformation, cleaning, and analytics.
• Collaborate to maintain ETL pipelines and between vendors. Develop processes and procedures that allows the automated collection of healthcare data to streamline the reconciliation of eligibility and revenue from all premium payment sources and the payments of related claims expenditures.
• Collaborate with internal team members as well as external representatives from third-party vendors to ensure integrity of processing to comply with Federal and State regulatory requirements.
• Partner with business functions across the enterprise to capture and report out metrics specific to their respective functional areas and to ensure the monitoring of critical business and operational activities.
• Support file and data exchanges between vendors including but not limited to claim files, response files, formulary files, eligibility, and encounter files.

Qualifications:

• Assist in the establishment and maintenance of the data warehouse.
• Generate reports / dashboards necessary to successfully operate the business and establish strategy.
• Participate in end-to-end architectural design and development lifecycle for new data.
• Participate in cross-functional team collaboration to understand customer requirements, design prototypes, and optimize existing data.
• Develop, test, and document software code for data extraction, ingestion, transformation, cleaning, and analytics.
• Collaborate to maintain ETL pipelines and between vendors. Develop processes and procedures that allows the automated collection of healthcare data to streamline the reconciliation of eligibility and revenue from all premium payment sources and the payments of related claims expenditures.
• Collaborate with internal team members as well as external representatives from third-party vendors to ensure integrity of processing to comply with Federal and State regulatory requirements.
• Partner with business functions across the enterprise to capture and report out metrics specific to their respective functional areas and to ensure the monitoring of critical business and operational activities.
• Support file and data exchanges between vendors including but not limited to claim files, response files, formulary files, eligibility, and encounter files