Azusa Pacific University
Director of Academic Operations Office of the Provost
Azusa Pacific University, Orange, California, United States, 92613
Department(s):
ITS-Enterprise Data and Systems Integrations Reports to:
Manager Information Technology Services FLSA status:
Non
-
Exempt Salary Grade:
N - $95,000 - $155,078 Applications will be accepted on a continuous basis until a sufficient number of qualified applications have been received. The deadline for the first review of applications is on
Monday, December 11, 2023 at 11:59 PM.
Applicants are encouraged to apply early. Applicants that apply after the first review are not guaranteed to be considered for this recruitment. This recruitment may close at any time without notice after the first review date. About CalOptima Health Are you looking for a career that changes lives? As the single largest health plan in Orange County, CalOptima Health serves one in three residents with health insurance programs for low-income children, adults, seniors and people with disabilities. Our 1,500 employees are valued for their individual perspectives and contributions and benefit from flexible work schedules, recognition and opportunities to grow. If you’re looking for a rewarding career supporting a meaningful mission, along with generous benefits and recognition, consider joining us at CalOptima Health! About the Position The Programmer Sr (Data Warehouse) will design, develop and implement software applications and perform complex and analytical assignments. The incumbent will oversee multi-tasking projects and create, modify and maintain data warehouse (DW) related applications. The incumbent will analyze and design existing systems and programs, develop or recommend new systems or modifications and manage the development and implementation of reporting infrastructure. The incumbent will gather and document requirements and design and build solutions for internal and external stakeholders. The incumbent will participate in the design and development of solutions using Structured Query Language (SQL) as well as other processes that utilize Extensible Markup Language (XML), Visual Basic (VB) scripting, C# scripting and/or Python. Duties & Responsibilities: Participates in a mission driven culture of high-quality performance, with a member focus on customer service, consistency, dignity and accountability. Assists the team in carrying out department responsibilities and collaborates with others to support short and long-term goals/priorities for the department. Collaborates with developers, stakeholders and subject-matter experts to establish technical vision and analyze trade-offs between usability and performance needs. Serves as a subject matter expert across the organization and assists users with reporting and analysis activities and tools, including ad-hoc reporting. Provides support and innovative solutions related to modules, researches software and matches with user requirements and advises users on limitations and alternative approaches. Conducts unit tests of new or modified processes ensuring data quality standards are adhered to. Participates in code reviews to represent reviewed work for adherence to standards and specifications. Plans, develops and supports Extract, Transform and Load (ETL) processes to populate the operational data stores, DW and data marts as needed. Designs, develops and implements reports as necessary to fulfill business requirements. Participates in the development of business and functional requirements for DW related projects. Develops and maintains code using Microsoft SQL Server, SQL Server Integration Service (SSIS) and SQL Server Reporting Services (SSRS). Develops and maintains code using XML, Python, VB scripting and/or C# scripting. Expands and maintains designs of complex information systems through formal design techniques. Takes part in Business Intelligence (BI) working sessions, data normalization and governance exercises. Partners with leadership to ensure project activity is customer focused, results oriented, performance driven and in compliance with all applicable internal and external requirements and policies. Researches, evaluates and documents current and future business processes. Supports user training and documentation, along with the roll-out of reports and end-user reporting tools. Completes other projects and duties as assigned. Experience & Education: Bachelor’s degree in Computer Science, Information Science or related field required. 5 years of experience in general relational database and reporting development required. 5 years of experience with data warehousing analysis and development including database design, ETL and reporting required. 5 years of experience using Microsoft SQL Server, Transact-SQL, Integration Services and using reporting tools such as SQL SSRS required. An equivalent combination of education and experience sufficient to successfully perform the essential duties of the position such as those listed above is also qualifying. Preferred Qualifications: 3 years of experience in the health care industry. 2 years of experience with BI tools such as Tableau or Power BI. Experience using modeling techniques as a tool for application design and development. Experience migrating a DW from on-prem to Microsoft Azure or related cloud technologies. Physical Demands and Work Environment: The physical demands and work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Physical demands:
While performing duties of job, employee is required to move about the organization. Employee must be able to sit for extended periods of time, as well as work at the computer for long periods. Employee is required to use hands and fingers, especially for typing on the computer and using the mouse. Must also be able to reach with hands and arms and must occasionally lift heavy office supply boxes. Employee is required to communicate, particularly for phone use and in meetings.
Work Environment:
Cubicle type office environment with minimal to moderate noise levels and controlled office temperatures.
About our Benefits & Wellness options: At CalOptima Health, we know that a healthy and happy workforce is a thriving workforce, which is why we offer a comprehensive benefits package, including participation in the California Public Employees Retirement System (CalPERS), low-cost medical/vision/dental insurance options, and paid time off. To support quality work-life balance, we allow flexible scheduling during core business hours, telework options for some positions, work schedules that allow every other Monday or Friday off (9/80 schedule), and a wellness program featuring diverse activities. Additionally, CalOptima Health contributes 4% of pensionable earnings to a 401(a) retirement program with no required employee contribution. Employees also have access to 457(b) retirement plans with pre/post-tax contribution options. CalOptima Health is committed to attracting, hiring, and retaining a diverse staff, where we will honor your unique experiences, identity, and perspectives. Our organization strives to create and maintain a workplace environment that is inclusive, equitable and welcoming so we can truly be Better Together. __ CalOptima Health is an equal employment opportunity employer and makes all employment decisions on the basis of merit. CalOptima Health wants to have qualified employees in every job position. CalOptima Health prohibits unlawful discrimination against any employee, or applicant for employment, based on race, religion/religious creed, color, national origin, ancestry, mental or physical disability, medical condition, genetic information, marital status, sex, sex stereotype, gender, gender identity, gender expression, transitioning status, age, sexual orientation, immigration status, military status as a disabled veteran, or veteran of the Vietnam era, or any other consideration made unlawful by federal, state, or local laws. CalOptima Health also prohibits unlawful discrimination based on the perception that anyone has any of those characteristics or is associated with a person who has, or is perceived as having, any of those characteristics. __ If you are a qualified individual with a disability or a disabled veteran, you may request a reasonable accommodation if you are unable or limited in your ability to access job openings or apply for a job on this site as a result of your disability.
#J-18808-Ljbffr
ITS-Enterprise Data and Systems Integrations Reports to:
Manager Information Technology Services FLSA status:
Non
-
Exempt Salary Grade:
N - $95,000 - $155,078 Applications will be accepted on a continuous basis until a sufficient number of qualified applications have been received. The deadline for the first review of applications is on
Monday, December 11, 2023 at 11:59 PM.
Applicants are encouraged to apply early. Applicants that apply after the first review are not guaranteed to be considered for this recruitment. This recruitment may close at any time without notice after the first review date. About CalOptima Health Are you looking for a career that changes lives? As the single largest health plan in Orange County, CalOptima Health serves one in three residents with health insurance programs for low-income children, adults, seniors and people with disabilities. Our 1,500 employees are valued for their individual perspectives and contributions and benefit from flexible work schedules, recognition and opportunities to grow. If you’re looking for a rewarding career supporting a meaningful mission, along with generous benefits and recognition, consider joining us at CalOptima Health! About the Position The Programmer Sr (Data Warehouse) will design, develop and implement software applications and perform complex and analytical assignments. The incumbent will oversee multi-tasking projects and create, modify and maintain data warehouse (DW) related applications. The incumbent will analyze and design existing systems and programs, develop or recommend new systems or modifications and manage the development and implementation of reporting infrastructure. The incumbent will gather and document requirements and design and build solutions for internal and external stakeholders. The incumbent will participate in the design and development of solutions using Structured Query Language (SQL) as well as other processes that utilize Extensible Markup Language (XML), Visual Basic (VB) scripting, C# scripting and/or Python. Duties & Responsibilities: Participates in a mission driven culture of high-quality performance, with a member focus on customer service, consistency, dignity and accountability. Assists the team in carrying out department responsibilities and collaborates with others to support short and long-term goals/priorities for the department. Collaborates with developers, stakeholders and subject-matter experts to establish technical vision and analyze trade-offs between usability and performance needs. Serves as a subject matter expert across the organization and assists users with reporting and analysis activities and tools, including ad-hoc reporting. Provides support and innovative solutions related to modules, researches software and matches with user requirements and advises users on limitations and alternative approaches. Conducts unit tests of new or modified processes ensuring data quality standards are adhered to. Participates in code reviews to represent reviewed work for adherence to standards and specifications. Plans, develops and supports Extract, Transform and Load (ETL) processes to populate the operational data stores, DW and data marts as needed. Designs, develops and implements reports as necessary to fulfill business requirements. Participates in the development of business and functional requirements for DW related projects. Develops and maintains code using Microsoft SQL Server, SQL Server Integration Service (SSIS) and SQL Server Reporting Services (SSRS). Develops and maintains code using XML, Python, VB scripting and/or C# scripting. Expands and maintains designs of complex information systems through formal design techniques. Takes part in Business Intelligence (BI) working sessions, data normalization and governance exercises. Partners with leadership to ensure project activity is customer focused, results oriented, performance driven and in compliance with all applicable internal and external requirements and policies. Researches, evaluates and documents current and future business processes. Supports user training and documentation, along with the roll-out of reports and end-user reporting tools. Completes other projects and duties as assigned. Experience & Education: Bachelor’s degree in Computer Science, Information Science or related field required. 5 years of experience in general relational database and reporting development required. 5 years of experience with data warehousing analysis and development including database design, ETL and reporting required. 5 years of experience using Microsoft SQL Server, Transact-SQL, Integration Services and using reporting tools such as SQL SSRS required. An equivalent combination of education and experience sufficient to successfully perform the essential duties of the position such as those listed above is also qualifying. Preferred Qualifications: 3 years of experience in the health care industry. 2 years of experience with BI tools such as Tableau or Power BI. Experience using modeling techniques as a tool for application design and development. Experience migrating a DW from on-prem to Microsoft Azure or related cloud technologies. Physical Demands and Work Environment: The physical demands and work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Physical demands:
While performing duties of job, employee is required to move about the organization. Employee must be able to sit for extended periods of time, as well as work at the computer for long periods. Employee is required to use hands and fingers, especially for typing on the computer and using the mouse. Must also be able to reach with hands and arms and must occasionally lift heavy office supply boxes. Employee is required to communicate, particularly for phone use and in meetings.
Work Environment:
Cubicle type office environment with minimal to moderate noise levels and controlled office temperatures.
About our Benefits & Wellness options: At CalOptima Health, we know that a healthy and happy workforce is a thriving workforce, which is why we offer a comprehensive benefits package, including participation in the California Public Employees Retirement System (CalPERS), low-cost medical/vision/dental insurance options, and paid time off. To support quality work-life balance, we allow flexible scheduling during core business hours, telework options for some positions, work schedules that allow every other Monday or Friday off (9/80 schedule), and a wellness program featuring diverse activities. Additionally, CalOptima Health contributes 4% of pensionable earnings to a 401(a) retirement program with no required employee contribution. Employees also have access to 457(b) retirement plans with pre/post-tax contribution options. CalOptima Health is committed to attracting, hiring, and retaining a diverse staff, where we will honor your unique experiences, identity, and perspectives. Our organization strives to create and maintain a workplace environment that is inclusive, equitable and welcoming so we can truly be Better Together. __ CalOptima Health is an equal employment opportunity employer and makes all employment decisions on the basis of merit. CalOptima Health wants to have qualified employees in every job position. CalOptima Health prohibits unlawful discrimination against any employee, or applicant for employment, based on race, religion/religious creed, color, national origin, ancestry, mental or physical disability, medical condition, genetic information, marital status, sex, sex stereotype, gender, gender identity, gender expression, transitioning status, age, sexual orientation, immigration status, military status as a disabled veteran, or veteran of the Vietnam era, or any other consideration made unlawful by federal, state, or local laws. CalOptima Health also prohibits unlawful discrimination based on the perception that anyone has any of those characteristics or is associated with a person who has, or is perceived as having, any of those characteristics. __ If you are a qualified individual with a disability or a disabled veteran, you may request a reasonable accommodation if you are unable or limited in your ability to access job openings or apply for a job on this site as a result of your disability.
#J-18808-Ljbffr