Career Opportunities: IS EDW Development Manager (24644)

Candidates hired for remote positions must reside in Oregon, Washington, Utah, Idaho, Arizona, Nevada, Texas, Montana, or Wisconsin.

Job Summary

This position is responsible for managing an Enterprise Data Warehouse (EDW) team comprised of a supervisor and staff, including Data Architects, Data Engineers, Database Developers, and other roles.  This position may focus in one of the following areas:

Architecture/Build/Integration:  Evaluates, builds, and implements new capabilities that deliver a modern, reliable, and scalable analytics ecosystem.  Maintains oversight over technical choices, development of software code, EDW configuration, and infrastructure set up. Supports the EDW Operations team in resolution of critical EDW issues.  Plans and executes regular additions to EDW data sources and analytics capabilities as per roadmap.  Leads the continued transition of EDW to cloud architecture and support non-EDW teams beginning their cloud transition.

Operations:  Evaluates and implements new capabilities for data quality, data sharing, and EDW monitoring, as well as maintaining applications used by various analytic teams.  Maintains oversight over technical choices, development of software code, EDW monitoring, and application and infrastructure set up.  Oversees any production issues related to EDW and related applications and components and provide support in resolution of critical EDW-related issues. Plans and executes regular additions to EDW data feeds, monitoring, quality, and monitoring as per roadmap.

Essential Responsibilities

Operational Planning and Oversight

• Participates in long-term systems architecture planning specifically to take advantage of new cloud technologies, to resolve challenges encountered today and to set up system for scale to handle future volumes.
• Develops 18 to 24 month EDW roadmap in consultation with appropriate stakeholders.
• Plans and executes regular releases/upgrades as per agreed roadmap.
• Implements changes to EDW to support enterprise project requirements.
• Maintains visibility into roadmaps for Snowflake and Azure products such as Data Factory, Functions, Data Lake/Blob/FTP, Logic Apps, and appropriately adjust roadmaps, plans, and priorities to maintain low technical debt.
• Develops resource and capacity plans for unit’s direction and roadmaps.
• Manages and oversees the operations and performance of all areas of responsibility to ensure organizational effectiveness.
• Works collaboratively with other teams with-in Information Systems and Business Intelligence (ISBI) to provide expertise, support and capacity to solve larger cross team challenges or to facilitate resolution of intermittent issues or to support processes spanning multiple teams.
• Incorporates best practices for design, architecture, development, and support.
• Develops and maintains strong relationships with stakeholders in other business units and peers in ISBI and collaborate effectively with these groups.
• Communicates plans and intentions clearly to ISBI and non-ISBI groups.

Technical / Operational Leadership

• Leads the execution of strategic initiatives, plans, and goals and advises organizational vision and goals.
• Provides continuous evaluation of CareOregon’s EDW in support of scale, agility, and stability to meet existing and emergent organizational needs.
• Establishes and oversees vendor resources engaged in providing additional EDW development, quality assurance, and production support capabilities.
• Refines business and systems requirements for new information technologies in support of application rationalization and modernization.
• Develops, monitors, and reports on KPIs, metrics and SLAs across the team.
• Leads innovation, process reviews, and improvement efforts; improves processes and procedures to ensure compliance with regulatory bodies and statutes, including HIPPA standards for PHI protection and transmission.
• Promotes ISBI programs and staff across the organization through regular and transparent reporting, as well as publishing of short and long-term workplans.
• Provides operational leadership of ISBI teams in recommending, developing, and implementing internal and third-party solutions.
• Exercises sound business and technical judgement in making effective technical decisions for EDW design and architecture.
• Ensures compliance with internal auditing, HIPAA, and other federal regulations.
• Ensures technical documentation is established and maintained for EDW and related components and processes.

Project Management and Participation

• Plans, organizes, manages, and monitors work across the team.
• Acts as project manager for projects related to EDW improvements.
• Develops plans and processes for routine operational projects such as new vendor feeds and new application integrations with EDW; engages with the Enterprise Project Management Office for large, complex projects.
• Partners and when needed leads with other ISBI leaders in support of project management, release management, change management and incident management.
• Ensures project deliverables are met according to quality control schedules and standards.
• Utilizes ServiceNow or other agreed tool for managing resources, work plans and commitments.

Relationship Management

• Leads effective communication system for work groups, ensuring a collaborative culture.
• Builds and ensures effective relationships across internal teams and external organizations for current or future integration.
• Partners with internal leaders and managers in identifying improvement plans and processes.
• Develops and maintains knowledge of CareOregon’s critical functions in support of our members and patients; collaborates with stakeholders to understand informational requirements to support department goals.
• Represents CareOregon within and outside the organization, providing productive leadership presence and effectiveness.
• Establishes and maintains cooperative, productive working relationships with internal/external customers.
• Works collaboratively to resolve complex system and/or claims problems and assist internal and external user departments as required.

Employee Supervision

• Manages team(s) and recommends team direction and goals in alignment with the organizational mission, vision, and values.
• Identifies work and staffing needs to meet work expectations; recruits and hires, using an equity, diversity, and inclusion lens.
• Plans, organizes, schedules, and monitors work; ensures employees have information and resources to meet job expectations.
• Leads the development, communication, and oversight of team and individual goals; ensures goals, expectations, and standards are clearly understood by staff.
• Trains, supervises, motivates, and coaches employees; provides support toward employee development.
• Incorporates guidance from CareOregon equity tools into people leadership, planning, operations, evaluation, and decision making.
• Ensures team adheres to department and organizational standards, policies, and procedures.
• Evaluates employee performance and provides regular feedback to support success; recognizes strong performance and addresses performance gaps and accountability (corrective action). 
• Performs supervisory tasks in collaboration with Human Resources as needed.

Organizational Responsibilities

• Perform work in alignment with the organization’s mission, vision and values.
• Support the organization’s commitment to equity, diversity and inclusion by fostering a culture of open mindedness, cultural awareness, compassion and respect for all individuals.
• Strive to meet annual business goals in support of the organization’s strategic goals.
• Adhere to the organization’s policies, procedures and other relevant compliance needs.
• Perform other duties as needed.

Experience and/or Education

Required

• Minimum 8 years’ relevant experience, including recent experience with most or all of the following.:

• Leading cross functional teams with Data Architects, Data Engineers, and Database Developers
• Leading teams through the re-architecture of business-critical systems
• Leading teams through cloud migration of business-critical systems
• Leading change with-in team and across the enterprise
• Leading and maturing a service organization in an environment of diverse stakeholders and dynamic priorities
• Leading a service organization leveraging the follow-the-sun support model
• Experience with Agile frameworks
• BUILD TEAM only: Leading teams accountable for EDW systems design, implementation, and support
• OPERATIONS TEAM only: Leading teams accountable for EDW operations, data quality, and administration of applications used for analytics

• Minimum 2 years’ experience in a supervisory position or minimum 1 year experience in a supervisory position with completion of CareOregon’s Aspiring Leaders Program

Preferred

• Experience with Snowflake and MS Azure cloud specifically utilizing Data Factory, Azure Functions and Data Lake / Blob Store
• Experience working in health care payer/managed care organizations
• Bachelor’s degree in Information Services, or technology related field
• PMP or other project management training and experience in managing large projects

Knowledge, Skills and Abilities Required

Knowledge

• Thorough knowledge of system development methodologies
• Technical knowledge in the areas of modern EDW architecture, production support, and vendor management

• BUILD TEAM only:  Data engineering
• OPERATIONS TEAM only:  Data quality, monitoring, application administration

• Expert knowledge of managing and leading Agile teams
• Strong knowledge of Managed Care concepts and Health Plan business processes preferred
• Strong understanding of Medicaid and Medicare programs preferred

Skills and Abilities

• BUILD TEAM only: Ability to manage and report on complex EDW subjects and analytic capabilities to internal and external leaders and partners
• OPERATIONS TEAM only: Ability to manage and report on EDW monitoring, data quality, and application administration to and external leaders and partners
• Ability to manage architectural direction and drive modernization of business-critical systems
• Ability to effectively develop and convey team goals and plans, ensuring integration into strategic plans and initiatives
• Ability to develop and lead high performing team members, including hiring, goal setting, coaching, performance management, and development
• Ability to inspire and manage teams in support of continuous improvement related to complex, business critical systems
• Ability to build and maintain professional relationships with business, community, and internal management groups
• Excellent analytical and research skills
• Strong project management skills
• Excellent written and verbal communication skills; skilled in presenting and communicating application or product or program effectiveness at all layers of an organization (staff and leaders)
• Ability to take the initiative to see beyond the original request so that all logically related work is completed without needing a specific request for implied steps
• Ability to interpret contract language and regulations
• Ability to lead, plan and manage in ambiguous environments and with high degree of uncertainty
• Ability to manage the workloads of others and interact effectively and motivate staff to perform at their highest level
• Ability to manage and effectively resolve conflict with-in and across teams
• Ability to occasionally work outside of standard office hours as needed
• Ability to consistently handle multiple projects and chronic deadline pressure
• Ability to make sound judgments as to how to architect and implement EDW to build sustainable, scalable solution
• Continuous learning required as to ensure team and systems stay up-to date on modern technologies and practices
• Ability to work effectively with diverse individuals and groups
• Ability to learn, focus, understand, and evaluate information and determine appropriate actions
• Ability to accept direction and feedback, as well as tolerate and manage stress
• Ability to see, read, and perform repetitive finger and wrist movement for at least 6 hours/day
• Ability to hear and speak clearly for at least 3-6 hours/day

Working Conditions

Work Enviornment(s):              ☒ Indoor/Office        ☐ Community        ☐ Facilities/Security      ☐ Outdoor Exposure

Member/Patient Facing:          ☒ No                           ☐ Telephonic         ☐ In Person

          Hazards: May include, but not limited to, physical and ergonomic hazards.

Equipment:  General office equipment

Travel: May include occasional required or optional travel outside of the workplace; the employee’s personal vehicle, local transit or other means of transportation may be used.

Work Location: Work from home

#MULTI

Candidates of color are strongly encouraged to apply. CareOregon is committed to building a linguistically and culturally diverse and inclusive work environment.

Veterans are strongly encouraged to apply.

We are an equal opportunity employer. CareOregon considers all candidates regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, genetic information, disability, or veteran status.

Visa sponsorship is not available at this time.