Data Warehouse Manager

Arizona State Government; Hyde Park Township (IL); Remote; USD 110,000 - 120,000; Full time

Job summary

An established industry player is seeking a Data Warehouse Manager to lead a dedicated team in delivering comprehensive data solutions. This role offers a unique opportunity to manage a talented group while ensuring the integrity and quality of data across the agency. With a focus on innovative data management techniques and collaboration with various stakeholders, you will play a vital role in shaping data strategies that support decision-making processes. Enjoy a fantastic work/life balance with options for remote work, comprehensive benefits, and the chance to grow your career in a supportive environment. If you are ready to take the next step in your career, this position could be the perfect fit for you.

Benefits

10 paid holidays per year

Paid Vacation and Sick time

Paid Parental Leave

Robust insurance plan

Retirement benefits

RideShare and Public Transit Subsidy

Career development opportunities

Qualifications

• Bachelor's degree plus 5+ years of experience in data warehousing.
• 7+ years in ETL processes and BI tools preferred.

Responsibilities

• Manage a data warehouse team and oversee ETL processes.
• Collaborate with agency leadership to define data needs.

Skills

Data Warehouse Management

ETL Processes

SQL Development

Data Analysis

Staff Management

Project Management

Communication Skills

Education

Bachelor's Degree

Master's Degree in Computer Science

Tools

Azure Synapse

Informatica

Databricks

Cognos

Power BI

Job description

AHCCCS

Arizona Health Care Cost Containment System
Accountability, Community, Innovation, Leadership, Passion, Quality, Respect, Courage, Teamwork

The Arizona Health Care Cost Containment System (AHCCCS), Arizona’s Medicaid agency, is driven by its mission to deliver comprehensive, cost-effective health care to Arizonans in need. AHCCCS is a nationally acclaimed model among Medicaid programs and a recipient of multiple awards for excellence in workplace effectiveness and flexibility.

AHCCCS employees are passionate about their work, committed to high performance, and dedicated to serving the citizens of Arizona. Among government agencies, AHCCCS is recognized for high employee engagement and satisfaction, supportive leadership, and flexible work environments, including remote work opportunities. With career paths for seasoned professionals in a variety of fields, entry-level positions, and internship opportunities, AHCCCS offers meaningful career opportunities in a competitive industry.

Come join our dynamic and dedicated team.

Data Warehouse Manager

Information Services Division (ISD)

Job Location:

Address: 801 E. Jefferson Street, Phoenix, AZ 85034

Posting Details:

Must reside in Arizona.

Salary: $110,000 - $120,000

Grade: 30

Closing Date: Open Until Filled

This position is eligible for full-time remote work (including virtual office arrangement in Arizona).

Job Summary:

A career in public service awaits you. COME JOIN OUR TEAM!

A great benefit of working for the State of Arizona is a fantastic work/life balance. State employees enjoy challenging work, popular remote work options, comprehensive health and wellness benefits, and career growth opportunities.

We are searching for someone to manage a small tenured data warehouse team and who is very proficient working in Azure Synapse, Informatica, or Databricks. If you’ve been in a team lead position in a similar environment and are ready to move into a management role – this opportunity could be for you!

What You'll Do:

The position reports through the Information Services Division (ISD) as the Data Warehouse Manager of the Data Warehouse team at AHCCCS. The Data Warehouse Manager is responsible for achieving the goals and objectives of AHCCCS through managing the data warehouse human, financial, and operational resources. You will work with customers throughout the agency to identify data needs and then define, develop, and test solutions using sound data management techniques. You’ll also be asked to maintain production ETL processes, occasionally in an on-call capacity, to ensure the timeliness and accuracy of all data loads. As the Data Warehouse Manager, you will need to have a strong technical background with extensive experience in an enterprise data warehouse environment.

Major duties and responsibilities include but are not limited to:

1. Managerial duties include, but are not limited to leading the Data Warehouse team and assigned contractors, recruitment, setting objectives, analyzing performance, making staffing and data management decisions, managing deadlines, collaborating and advising Agency leadership and staff, and reviewing work.
2. Manage data extractions, transformations and load procedures including analysis of existing source systems and data sources and monitor ETL workflows. Translate functional and technical requirements into detailed architecture, design and extensible code. Provide expertise in ETL, SQL development, and data analysis to staff.
3. As an expert in AHCCCS data, actively participate in inter-divisional projects as a data lead. Work to proactively obtain and provide information that will assist decision makers in determining what data AHCCCS has and how to effectively and efficiently access the available information. Collaborate on project management initiatives.
4. Support and enhance existing extract, transform, and load processes. Create technical design documents that capture source to target mapping, define transformation algorithms, and document data quality rules, data flows and transformations.
5. Work with staff and stakeholders to identify analytical requirements. Validate the integrity and quality of the data to be used, while troubleshooting any issues; and develop, test, and validate data sets to be utilized in various analytical reports and dashboards throughout the agency.
6. Mentor data management techniques to developers and business users with less skill or experience while optimizing data warehouse performance. Collaborate on data management initiatives, strategy and governance, standards, integration, and quality.
7. Administer and manage data analytics platforms such as Cognos and Power BI to ensure optimal performance, reliability, and security. Collaborate with cross-functional teams to design, implement, and refine data models that support reporting and decision-making processes. Assist in the upgrade, patching, and maintenance of analytics tools and systems to ensure they remain current and effective.
8. Proactively seek to add value to the system by staying current on data warehousing and data management industry and best practices by participating in projects, learning collaboratives, and trainings that involve leaders both inside and outside of the Agency.
9. Defines immediate and long term goals, priorities, and plans to ensure team goals are aligned with the goals and priorities of the organization. Identifies required resources; trains, schedules and monitors resources; leads hiring process; accountable for effective use of resources and disciplinary action when required. Review and update direct staff's position descriptions as needed.
10. Assists in the development and support of policies, procedures, standards and forms.

Knowledge, Skills & Abilities (KSAs):

Knowledge:
• Data Warehouse concepts, practices, and procedures
• ETL tools and processes (i.e. Informatica)
• Oracle and SQLServer database management systems
• Strong understanding of SQL and relational and multidimensional designs
• IBM Cognos Framework Manager or equivalent BI tool
• Medicaid/Medicare care programs and services
• Expert technical knowledge of Agency programs, operations and dependencies
• PMMIS
• Statistical, financial and performance analysis methods and techniques

Skills:
• Staff management and leadership techniques
• Data Management Strategy and Governance, Standards, Integration, and Quality
• Business Requirements Analysis
• Data Analysis / Data Modeling
• ETL design and development
• SQL query optimization
• Written and verbal communication
• Interpersonal Relationships
• Project Management
• Problem Solving
• Decision making

Abilities:
• Communicate with business users to determine requirements for data, reports and analyses
• Extract, transform, clean, and move data and metadata so they can be loaded into a data warehouse, data mart, or operational data store
• Design and manage the BI tools and applications environment
• Multi-task with quick turnaround times and under pressure
• Model leadership characteristics, positive attitude and personal responsibility
• Develop, manage, and update data models, including physical and logical models of the data warehouse, datamart, and staging area
• Understanding of SQL and relational and multidimensional query designs
• Interview end users to determine requirements for data, reports, analyses, meta data, training, service levels, data quality, and performance
• Work in a Virtual Office Environment

Qualifications:

Minimum:
• Bachelor’s degree plus 5 or more years of related experience in related discipline (or equivalent experience).

Preferred:
• Bachelor's degree in Computer Information Systems, Computer Science or related area. 7+ years of data warehousing experience related to databases and BI tools. 7+ years of experience defining and developing ETL processes. Knowledge of health care operations and terminology; preferably within Medicaid. 3+ years of managerial experience in Information Technology.

Pre-Employment Requirements:

• Successfully pass fingerprint background check, prior employment verifications and reference checks; employment is contingent upon completion of the above-mentioned process and the agency’s ability to reasonably accommodate any restrictions.
• Travel may be required for State business. Employees who drive on state business must complete any required driver training (see Arizona Administrative Code R2-10-207.12.)

If this position requires driving or the use of a vehicle as an essential function of the job to conduct State business, then the following requirements apply:Driver’s License Requirements.

All newly hired State employees are subject to and must successfully complete the Electronic Employment Eligibility Verification Program (E-Verify).

Benefits:

Among the many benefits of a career with the State of Arizona, there are:
• 10 paid holidays per year
• Paid Vacation and Sick time off (13 and 12 days per year respectively) - start earning it your 1st day (prorated for part-time employees)
• Paid Parental Leave-Up to 12 weeks per year paid leave for newborn or newly-placed foster/adopted child. Learn more about the Paid Parental Leave pilot program here.
• Other Leaves - Bereavement, civic duty, and military.
• A top-ranked retirement program with lifetime pension benefits
• A robust and affordable insurance plan, including medical, dental, life, and disability insurance
• Participation eligibility in the Public Service Loan Forgiveness Program (must meet qualifications)
• RideShare and Public Transit Subsidy
• A variety of learning and career development opportunities

By providing the option of a full-time or part-time remote work schedule, employees enjoy improved work/life balance, report higher job satisfaction, and are more productive. Remote work is a management option and not an employee entitlement or right. An agency may terminate a remote work agreement at its discretion.

Learn more about the Paid Parental Leave pilot programhere. For a complete list of benefits provided by The State of Arizona, please visit our benefits page

Retirement:

Lifetime Pension Benefit Program
• Administered through the Arizona State Retirement System (ASRS)
• Defined benefit plan that provides for life-long income upon retirement.
• Required participation for Long-Term Disability (LTD) and ASRS Retirement plan.
• Pre-taxed payroll contributions begin after a 27-week waiting period (prior contributions may waive the waiting period).

Deferred Retirement Compensation Program
• Voluntary participation.
• Program administered through Nationwide.
• Tax-deferred retirement investments through payroll deductions.

Contact Us:

Persons with a disability may request a reasonable accommodation such as a sign language interpreter or an alternative format by emailing [e-mail].
Requests should be made as early as possible to allow time to arrange the accommodation. The State of Arizona is an Equal Opportunity/Reasonable Accommodation Employer.