Financial Systems and Reporting Analyst I-III
Full Time
Phoenix, AZ 85021
Posted
Job description
Awarded the Best Place to Work 2021, Blue Cross Blue Shield of Arizona helps to fulfill its mission of improving the quality of life of Arizonans by delivering a variety of health insurance products and services to meet the diverse needs of individuals, families, and small and large businesses as well as providing information and tools to help individuals make better health decisions.
Leads or participates in corporate projects as they relate to the Finance division. Acts as a point of reference for complex financial system and processing issues, working with multiple resources to resolve. On behalf of internal and external customers, gathers and documents business requirements, provides research and analysis related to project/production issues, conducts user acceptance testing (UAT), and acts as a liaison between business customers, external customers, project teams, IT, and outside vendors. Communicates with all levels within the division. Supports assigned financial area on day-to-day reporting and system issues.
Develops, designs, maintains, and generates formal and ad hoc reports for the department and the company.
Configures, maintains, tests, analyzes, and enhances departmental and corporate reporting databases.
Configures, maintains, tests, analyzes, and enhances departmental and corporate reporting databases.
REQUIRED QUALIFICATIONS
Required Work Experience
- 2 years of experience in finance or related field as an analyst or technician with experience in system configuration, reporting, and integrations (level 1)
- 1 year of experience developing SQL quires (level 1)
- 5 years of experience in finance, financial systems, claims processing\payment systems, premium payment systems or systems interfacing with Finance field (levels 2-3)
- 3 years of experience in a role with demonstrated ability to communicate with diverse groups of people inside and outside of the business (levels 2-3)
- 3 year of experience developing SQL quires (level 2-3)
- High-School Diploma or GED in general field of study (All Levels)
Required Licenses
- N/A
Required Certifications
- N/A
PREFERRED QUALIFICATIONS
Preferred Work Experience
- 7 years of experience in finance, financial systems, or claims processing systems field
- 5 years of experience on project teams with demonstrated ability to communicate with diverse groups of people inside and outside the business
- 1 year of experience in project management
- Bachelor’s Degree in accounting, business, computer technology, mathematics or related field
- N/A
Preferred Certifications
- N/A
ESSENTIAL job functions AND RESPONSIBILITIES
Level 1
- Develop, design, maintain, and generate formal and ad hoc reports at the departmental and Coporate level.
- Consult and coordinate with business stakeholders to develop and implement ad hoc and operational reporting.
- Establish schedules to generate distribute reports to meet the due dates set by the report owner.
- Conduct and document complex root-cause analysis and propose the corresponding solution.
- Participate in or lead special projects or task teams.
- Develop project plans, business requirements and test plans for enhancements; this includes timeline creation, issue tracking, and progress monitoring.
- Configure, test and coordinate acceptance testing for all database changes within the defined area of responsibility.
- Consult and coordinate with various internal departments and all levels of management to obtain information, design, implement and ensure resolution of customer inquiries regarding report requests.
- Conduct research and analysis for issue resolution relating to financial applications including reporting and process efficiencies. Track all items through to resolution.
- Perform security/system administration duties as required for financial applications.
- Provide first or second level support for internal/external customers.
- Perform data research by developing and enhancing basic SQL queries and interpret the business results to the stakeholders.
- Act as a liaison between external/internal customers and IT; communicate system and process changes to business areas.
Level 2
- Develop moderate complex (e.g. multiple departments/systems) business requirements on large projects and flow specifications with limited management direction.
- Provide support to external customers to onboard EDI processing and achieve HIPAA Transaction and Code Set compliance.
- Provide subject matter expert (SME) advice related to financial systems in the prioritization of workload or issue research.
- Facilitate and/or create new operational procedures and processes resulting from advancing technologies or capabilities.
- Lead small to medium size projects; act as UAT Coordinator including test strategy and plan development.
- Interpret design specifications for comparison against defined business needs to ensure compatibility, consistency and completeness.
- Resolve differences between customers and other team members in order to achieve organizational and project goals.
- Utilize existing reporting tools to develop and execute SQL data queries for ad hoc requests; understand data source structures.
- Support multiple segments of business.
- Mentor Level 1 Analysts.
Level 3
- Develop complex (e.g. multiple departments/systems) business requirements on large projects and flow specifications with little to no management direction.
- Decompose high-level project information and evaluates project components to forecast work effort required.
- Act as lead business analyst for large or complex projects with minimal guidance from manager.
- Interpret business and technical design specifications and resolve conflicts that arise when compared against the defined needs of the business.
- Fully support all business segments.
- Proactively seeks opportunities to improve processes and procedures in support of customer satisfaction and corporate goals.
- Perform data research by developing and enhancing complex SQL queries and interpret the business results to the stakeholders.
- Mentor Level 1 and 2 Analysts.
ALL LEVELS
- Each progressive level includes the ability to perform the essential functions of any lower levels.
- The position requires a full-time work schedule. Full-time is defined as working at least 40 hours per week, plus any additional hours as requested or as needed to meet business requirements.
- Perform all other duties as assigned.
competencies
REQUIRED COMPETENCIES
Required Job Skills
- Strong analytical skills to support independent and effective decisions based on customer input and research
- Strong problem-solving skills
- Strong time management skills
- Basic skills with core MS products: Word, Excel, IE, Outlook, Visio, PowerPoint, SQL
- Basic skills with query tools
- Strong understanding of file handling and data translation
- Excellent verbal and written communication skills and the ability to interact professionally and maintain positive working relationships with a diverse group
Required Professional Competencies
- Detail-oriented with ability to question existing data parameters, definitions and data flows, then track an issue back to its source
- Analytical knowledge necessary to generate reports based on available data and then make decisions based on reported data
- Navigate, gather, input and maintain data records in multiple system applications
- Exercise independent and sound judgment
- Verbal and written communication skills focusing on writing and presenting creative and persuasive solutions
- Establish and maintain working relationships in a collaborative team environment
- Practice interpersonal and active listening to achieve high customer satisfaction and departmental communication standards
- Prioritize tasks and work mulitple priorities, sometimes under strict time constraints
- Ability to build synergy with a diverse team in an ever-changing environment
- Ability to exercise independent judgment and demonstrate creative problem solving techniques
- Anticipates downstream impacts and factors in those considerations appropriately
- Perseverance in the face of resistance or setbacks
Required Leadership Experience and Competencies
- Take appropriate risks, using available data
- Support priorities and direction of corporate leadership.
- Ability to apply sound management decision making skills to perform effectively in the absence of management.
- Effectively deal with conflict.
- Ability to present concepts effectively to varying levels of staff. (Applies to Levels 2 & 3)
PREFERRED COMPETENCIES
Preferred Job Skills
- Intermediate programming language and operating systems
- Advanced word processing, spreadsheet, database, analytic and reporting software
- Intermediate mathematics
- Demonstrates an advanced knowledge of and experience with the development of business requirements, user acceptance testing and their supporting toolsets.
- Familiar with HIPAA compliance validation tools.
- Familiar with financial processes.
- Formal business analyst training.
Preferred Professional Competencies
- Basic project lead or project management skills
- Driven to identify solutions to meet customer needs.
- Ability to work with ambiguous and conflicting information while keeping focused on the end goal.
Preferred Leadership Experience and Competencies
- Facilitate and resolve customer requests and inquiries for all levels of management within the Corporation.
Our Commitment
BCBSAZ does not discriminate in hiring or employment on the basis of race, ethnicity, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status or any other protected group.
Thank you for your interest in Blue Cross Blue Shield of Arizona. For more information on our company, see azblue.com. If interested in this position, please apply.
seankuhnke.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, seankuhnke.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, seankuhnke.com is the ideal place to find your next job.