Integration Developer - 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.

Compensation and Benefits:

• Competitive salary dependent upon years of experience, education level, certifications, and skillset 
• Comprehensive health benefits & wellbeing program with opportunity to earn 100% company paid health insurance and up to $1,500 HSA company contributions.
• Competitive 401(k) with up to 4% company match and immediate vesting
• Tuition reimbursement
• Vacation, sick time & company paid holidays included

ROLE AND RESPONSIBILITIES
The Integration Developer is part of the Data Governance team and will help ensure that data assets are of proper quality and highly available. The role includes developing data integration processes and maintaining and supporting them in Microsoft Azure environment.

PRIMARY DUTIES
• Integrate healthcare and financial data provided by clients and external vendors
• Integrate data from HR, Accounting, CRM and other source systems, as applicable
• Build, maintain, test and support Azure Data Factory (ADF) pipelines
• Monitor ETL and reporting jobs, and support and maintain all integration processes
• Troubleshoot data issues, identify root cause, and resolve or escalate as necessary
• Optimize processes for performance, resiliency, accuracy, efficiency and scalability
• Analyze data, transform it based on business rules, and deliver to target systems
• Load data while maintaining data lineage and operational tracking
• Maintain documentation, manage source code, participate in code reviews, and test
• Implement best practices, and ensure quality and timeliness of deliverables

MINIMUM QUALIFICATIONS AND REQUIREMENTS
• 2+ years as a database and ETL developer
• 1+ years using Azure Data Factory (ADF) or SQL Server Integration Services (SSIS)
• Strong knowledge of T-SQL and stored procedures in a Microsoft SQL Server environment
• Strong knowledge of database concepts such as tables, views, and indexes
• Good knowledge of quality assurance best practices in an ETL environment
• Demonstrated ability in meeting deadlines and communicating progress across projects
• Ability to coordinate and collaborate with other team members and business owners
• Bachelor’s degree or higher

PREFERRED EXPERIENCE
• Experience working with data integration related to Healthcare or Financial data
• Experience developing PowerShell or python scripts

#IND123