Sr. Database Developer

Overview

About MPOWERHealth:

For over a decade, MPOWERHealth has supported the independent musculoskeletal physician with best-in-class clinical services, back-office solutions, and advanced technology. We pride ourselves on being a partner that offers foresight to customers. We simplify what's complex, and we help them find a better way. Our best-in-class analytics coupled with industry-leading expertise make MPOWERHealth the company our customers can rely on no matter what lies ahead.

Benefits:

• Multiple medical plan options

• Health Savings Account with company contributions

• Dental & vision coverage for you and your dependents

• 401k with Company match

• Vacation, sick time & Company paid holidays

• Company wellbeing program with health insurance incentives

Role and Responsibilities

The Sr. Database Developer will be responsible for designing and building databases/data warehouses to store and manage healthcare claims and financial data. This position will analyze data, develop, test, and implement processes to load it, and assist with reporting. This person will have a strong understanding of RDBMS/Data Warehouse concepts, along with knowledge of claims or financial data.

Responsibilities

PRIMARY DUTIES

• Analyze Healthcare data, architect and design data models, and create databases/data warehouses

• Design and develop ETL processes necessary to load this data to the Enterprise Data Warehouse (EDW)

• Implement, schedule, monitor and support all related processes, applications and databases

• Build indexes and fine tune queries to ensure performance needs are met

• Collaborate closely with reporting team to create data mart to support reporting and analysis needs

• Perform advanced data analysis, identify issues and data gaps, and help provides insights

• Implement and support Master Data Management processes

• Ensure flexibility, scalability, consistency and quality when build solutions

• Follow best practices for development, QA, deployment, source code management

• Manage source code, conduct code reviews, and test

• Monitor and support processes/jobs, and follow up on

• Coordinate closely with other developers to streamline processes and optimize

• Gain strong knowledge of underlying data and business rules, and assist other teams

• Adopt agile methodology, and assist in tracking and communicating progress of deliverables

Qualifications

Minimum Qualifications and Requirements

• 5+ years' experience in designing/modeling, and building data warehouses and data marts

• 5+ years' experience building stored procs, tables, views, functions, in MS SQL Server

• 2+ years' experience working with Healthcare claims or Financial data

• Demonstrated knowledge of data warehousing concepts and methodologies, technologies, and tools

• Bachelor's degree or equivalent combinations of education and experience

• Demonstrated ability to understand, discuss and document complex data models

• Excellent communications skills, both, written and oral

• Ability to manage and complete multiple concurrent projects in a timely manner

• Excellent problem solving and analytical skills

Preferred Experience

• Experience working with Azure DevOps

• Experience working with Azure Data Factory highly desired

• Experience building Power BI Reports is a plus

#IND123

Responsibilities PRIMARYDUTIES

• Analyze Healthcare data, architect and design data models, and create databases/data warehouses

• Design and develop ETL processes necessary to load this data to the Enterprise Data Warehouse (EDW)

• Implement, schedule, monitor and support all related processes, applications and databases

• Build indexes and fine tune queries to ensure performance needs are met

• Collaborate closely with reporting team to create data mart to support reporting and analysis needs

• Perform advanced data analysis, identify issues and data gaps, and help provides insights

• Implement and support Master Data Management processes

• Ensure flexibility, scalability, consistency and quality when build solutions

• Follow best practices for development, QA, deployment, source code management

• Manage source code, conduct code reviews, and test

• Monitor and support processes/jobs, and follow up on

• Coordinate closely with other developers to streamline processes and optimize

• Gain strong knowledge of underlying data and business rules, and assist other teams

• Adopt agile methodology, and assist in tracking and communicating progress of deliverables