Manager Azure Cloud Infrastructure

JOB SUMMARY: Hands on manager, who maintains and optimizes the Microsoft Azure infrastructure for the DVACO including virtual servers, databases and other cloud based applications that support Operations and Analytics functions for the DVACO. Works with external payers and venders to support monthly claims and roster loads that feed DVACO analytics platform. Maintain and create databases, views, ETL functions and stored procedures in conjunction with Operations and Analytics teams. Works in a DBA development capacity to assist with the integration of new data sets, optimize\automate system functions and assist the analytics team to build foundational layers for Power BI and other applications. Configures, maintains, recovers, and insures the performance of Relational Data Base Management Systems (RDBMS) on multiple database platforms. Manages three direct reports supporting integration and product development activities with Azure. Essential Accountabilities: Azure Cloud

1. Works with cloud vender and DVACO leadership to develop and strategies and deploy new capabilities that meet DVACO business requirements
2. Ensures Azure cloud configuration meets MLH IT security policies
3. Optimizes Azure cloud infrastructure while balancing budgetary considerations
4. Maintains Azure server infrastructure
5. Monitors server and application performance
6. Creates and tests disaster recovery plans
7. Maintains SFTP endpoints
8. Monitors Azure Download and Upload performance
9. Assists the development of appropriate testing methodology and migration paths for implementing changes

Product Development

1. Supports the agile development methodology by maintaining and monitoring existing scrum software solutions
2. Helps to prioritize technical development while working with scrum master support staff
3. Leads the product build cycle by developing, testing and rolling out new product code while working with the Operations and Analytics team
4. Leads the monthly refresh of the multi payer dimensional model and other data repositories

RDBMS Administration and Development

1. Develops and support changes to the clinical and claims multi payer dimensional model and other data warehouses, databases, etc.
2. Supports Power BI and other analytical products including the creation of necessary Dax queries
3. Configures, maintains, and insures performance of RDBMS applications
4. Designs and implements new physical RDBMS structures (i.e., tables, stored procedures and views) to meet business requirements
5. Analyzes, optimizes and documents any customized RDBMS structures (i.e., tables and views)
6. Insures recoverability of data bases
7. Diagnoses and resolves RDBMS outages and failures
8. Documents all configurations in writing

Extract, Transform and Load (ETL) and Automation

1. Develops and supports Microsoft Data Factory\Bricks environments including the creation of new pipelines, maintenance, etc.
2. Manages the regular upgrades to the Microsoft Data Factory\Bricks environments
3. Manages data feeds to and from Azure cloud to various venders and other parties
4. Transforms and loads data sets into RDBMS structures
5. Develops validation routines on data sets
6. Ensures accuracy of loads and extracts
7. Automates operations within the Azure cloud wherever possible

Primary Customers or Key Working Relationships:

1. DVACO Operations and DVACO Analytics Staff
2. External Venders

QUALIFICATIONS: Education: Bachelor of Science in Computer Science is preferred. Experience: Expertise with the following functions demonstrated by at least (x) years’ experience:

1. Working knowledge of MS Data factory\Bricks – 1 year
2. Development and implementation of ETL and auto scripting capabilities – 3 years
3. Development and Support using Power BI or Similar Solution – 2 years
4. Maintenance, recoverability and performance of MS SQL Server – 3 years
5. Development and optimization of database tables, stored procedures and views – 4 years
6. Experience managing Azure or AWS Cloud capabilities – 2 years
7. DBA Support of software and\or analytics development team – 3 years

Technical Skills\Capabilities:

• MS Azure Cloud, Data Factory and Data Bricks
• MS Power BI or similar tool
• Maintains proficiency and expertise in MS SQL Server Components (Query Analyzer, SSRS, SSIS Analysis Server, Stored Procedures, Jobs, and Functions)
• Practical experience programming in Python or similar tools.
• Capable of programming in SAS, SQL Query Construction or other programming languages.
• Experience creating and maintaining stored procedures, tables, views, indexes, etc that support the software and analytics development
• Demonstrates strong mathematical, statistical, financial, technical, interpersonal, organizational, project management skills, and ability to maintain confidentiality.
• Evidence of independent analytical and problem solving skills.
• Exceptional time management and organizational skills.
• Ability to effectively handle numerous priorities simultaneously.

WORKING CONDITIONS: This position requires the ability to handle multiple tasks simultaneously, remain effective under stress, and work hours outside the range of the regular schedule.

---

We are committed to the health and wellness of our employees. We offer competitive salaries, comprehensive benefits, generous paid time off, 403b savings plan, lucrative pension plan, tuition reimbursement, and more! Learn more about our benefits. If interested, please apply online at https://www.mainlinehealth.org/careers , Job ID 59501 We are an EOE/Veterans/Disabled/LGBTQ employer. Main Line Health celebrates our differences and our similarities. Learn more about our Diversity and Inclusion culture. Applicants must certify that they have not used tobacco products or nicotine in any form in the 90-days prior to submitting an application to Main Line Health. This will be verified during pre-employment testing. We are an Equal Opportunity Employer. Please, no agency calls