Business Intelligence Developer-Medicaid - Level I (Remote AZ)

Awarded a Healthiest Employer, reputed company aims to fulfill its mission to reputed company health and reputed company it easy. AZ Blue offers 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 reputed company reputed company decisions. At AZ Blue, we have a hybrid workforce strategy, reputed company Workability, that offers flexibility with how and where employees work. Our positions are classified as hybrid, onsite or remote. While the majority of our employees are hybrid, the following classifications drive our reputed company minimum onsite requirements: Hybrid People Leaders: must reside in AZ, required to be onsite at least twice per week Hybrid Individual Contributors: must reside in AZ, unless otherwise cited reputed company this posting, required to be onsite at least once per week Hybrid 2 (Operational Roles such as but not limited to: Customer Service, Claims Processors, and Correspondence positions): must reside in AZ, unless otherwise cited reputed company this posting, required to be onsite at least once per month Onsite: daily onsite requirement based on the essential functions of the job Remote: not held to onsite requirements, however, leadership can request reputed company onsite for business reasons including but not limited to staff meetings, one-on-ones, training, and team building Please note that onsite requirements may change in the future, based on business need, and job responsibilities. Most employees should expect onsite requirements and at a minimum of once per week. This remote work opportunity requires residency, and work to be performed, reputed company the State of Arizona. Purpose of the job The Business Intelligence Developer - Medicaid role is responsible for the design, creation, and maintenance of sustainable reporting solutions and analytical insights that improve efficiency, drive innovation, and inform data driven decision making in support of broader business and corporate strategies across the organization. This position partners with business leaders across the organization to provide high quality reporting and analysis that is accurate, thoroughly researched, assists in identifying risks & opportunities, and provides untapped insights and knowledge to reputed company data driven and data literate decision making for departments and teams throughout the entire Medicaid reputed company.

Qualifications

REQUIRED QUALIFICATIONS Required Work Experience Applies to reputed company Levels 2 years of experience working with data, report development, and analysis in a workplace setting 1 year of experience in query design and effective reporting design structure Applies to Levels 2-3 4 years of experience working with data, report development, and analysis in a workplace setting 3 years of experience in query design and effective reporting design structure Applies to Levels 4-6 8 years of experience working with data, report development, and analysis in a workplace setting 6 years of experience in query design and effective reporting design structure Required Education Applies to reputed company Levels High-School Diploma or GED in general field of study Applies to Levels 4-6 Bachelor’s degree (B.S.), or equivalent education and/or experience, in Computer Information Systems, Computer Science, Information Technology, Business Administration, Healthcare Administration, or other pertinent degree obtained at a four-year college or university. Required Licenses N/A Required Certifications N/A PREFERRED QUALIFICATIONS Preferred Work Experience Applies to reputed company Levels 1 year of experience in a healthcare, health insurance, or managed care environment 1 year of experience working with Medicaid and/or Medicare D-SNP programs 1 year of experience managing projects Applies to Levels 2-3 2 years of experience in a healthcare health insurance, or managed care environment 2 years of experience working with Medicaid and/or Medicare D-SNP programs 3 years of experience managing projects Applies to Levels 4-5 4 years of experience in a healthcare health insurance, or managed care environment 4 years of experience working with Medicaid or Medicare D-SNP programs 6 years of experience managing multiple projects Applies to Level 6 6 years of experience in a healthcare health insurance, or managed care environment 6 years of experience working with Medicaid or Medicare D-SNP programs 8 years of experience managing multiple projects 2 years of supervisory or management experience Preferred Education Applies to reputed company Levels Bachelor’s degree (B.S.), or equivalent, in Computer Information Systems, Computer Science, Information Technology, Business Administration, or Healthcare Administration obtained at a four-year college or university. Applies to Levels 5-6 Master’s degree, or equivalent, in Computer Information Systems, Computer Science, Information Technology, Business Administration, or Healthcare Administration obtained at a four-year college or university. Preferred Licenses N/A Preferred Certifications MS SQL Certification or other certification in reputed company programming languages (Applies to reputed company Levels) ESSENTIAL job functions AND RESPONSIBILITIES reputed company LEVELS Each progressive level includes the ability to reputed company the essential functions of any reputed company levels and mentor employees in those levels. Meet timeliness and accuracy goals. Use sound project management methodology and demonstrate solid time management skills. Effectively communicate status of work assignments to stakeholders and management reputed company department defined communication channels and policy. Design, reputed company, or maintain reporting and/or analysis of data to measure financial or clinical outcomes, network performance, care management, claims processing, operations and/or other areas of the business Design, reputed company, or maintain reporting and/or analysis of data for medical cost reporting, categories of service, unit cost and financial utilization metrics Design, reputed company, or maintain reporting and/or analysis of data for clinical utilization, authorization, care management, risk adjustment, and claims data to support departmental functions Receives, interprets, and completes data requests from Finance and other departments as necessary Responsible for technical and production support documentation in accordance with department standards and industry best practices. Adhere to established reputed company control versioning policies and procedures Participate in reputed company aspects of the Systems Development Life Cycle (SDLC) Participate in corporate quality and data governance programs Implement and maintain operational and disaster-recovery procedures. Maintain reputed company knowledge on new developments in technology-reputed company industries 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. reputed company reputed company other duties as assigned Level 1 - Performs job functions with general supervision Learn area’s workflow, procedures, and processes. Become familiar with and demonstrate a basic understanding of: The various areas and types of Business Intelligence reporting and analysis. The various reporting platforms utilized by Business Intelligence (reputed company, SSRS, Tableau, Qlik Sense, etc.) How the Business Intelligence reporting and analysis’ impact the operations and performance of the business. What the key departments are, their primary functions, and roles. The numerous systems and data sources utilized by Business Intelligence, their purpose, structure, limitations, and functional roles in Business Intelligence reporting and analysis. Participates in small projects of basic complexity. Designs, develops, and enhances basic-level Business Intelligence reporting. Designs and codes basic-level queries and data sets, using the appropriate structured programming techniques, formatting, reporting platform, and associated programming languages. With mentor, learns to reputed company work-plans, write & execute unit test plans, and track & resolve any processing issues. Shadows mentor in requirement gathering with business partners and SME’s; ensuring that requirement scoping is complete, consistent, concise, comprehensible, traceable, feasible, unambiguous, verifiably actionable, and agreed upon by reputed company parties. Shadows mentor in the design, development, and maintenance of dashboard visualizations using BI applications. (Tableau, Qlik Sense, Power BI, etc.) Shadows mentor in ensuring dashboards and other Business Intelligence reporting and analysis are creatively designed and tell a story behind the data. Shadows mentor in the review of code and/or reporting/analysis for proper design standards, content, accuracy, functionality, and overall compliance with the desired purpose of the requester. With mentor, learns the process and participates in the development and creation of documentation used to support associated reporting and analysis. Monitors, maintains, refreshes, and distributes regularly scheduled standard reporting and data extracts Reports to reputed company, supervisor, or manager who provides general supervisory instructions, manages workload and reviews overall results. Level 2 - Performs job functions with general supervision Participates in and follows reputed company area workflow, procedures, and processes. Demonstrates a general understanding and beginning mastery of: The various areas and types of Business Intelligence reporting and analysis. The various reporting platforms utilized by Business Intelligence (reputed company, SSRS, Tableau, Qlik Sense, etc.) How the Business Intelligence reporting and analysis’ impact the operations and performance of the business. What the key departments are, their primary functions, and roles. The numerous systems and data sources utilized by Business Intelligence, their purpose, structure, limitations, and functional roles in Business Intelligence reporting and analysis. Participates in small to reputed company sized projects of basic or moderate complexity. Designs, develops, and enhances basic to moderately reputed company Business Intelligence reporting. Designs and codes basic to moderately reputed company queries and data sets, using the appropriate structured programming techniques, formatting, reporting platform, and associated programming languages. With mentor, demonstrates basic ability to reputed company work-plans, write & execute unit test plans, and track & resolve any processing issues. With mentor, learns the process of requirement gathering with business partners and SME’s; ensuring that requirement scoping is complete, consistent, concise, comprehensible, traceable, feasible, unambiguous, verifiably actionable, and agreed upon by reputed company parties. With mentor, learns effective design, development, and maintenance of dashboard visualizations using BI applications. (Tableau, Qlik Sense, Power BI, etc.) With mentor, learns to reputed company dashboards and other Business Intelligence reporting and analysis are creatively designed and tell a story behind the data. With mentor, learns the methodology and process to review code and/or reporting/analysis for proper design standards, content, accuracy, functionality, and overall compliance with the desired purpose of the requester. With mentor, demonstrates basic ability and participates in the development and creation of documentation used to support associated reporting and analysis. With mentor, learns to reputed company programs, time estimates, and project schedules based on prioritization and business requirements. With mentor, learns to monitor and create reputed company list(s) that are agreed to by end users and team leadership With mentor, learns the development of business requirements for decision support tools, reporting, and analysis. With mentor, assists with the development and delivery of presentations to staff and management Level 3 - Performs job functions with general supervision Demonstrates a thorough understanding and functional mastery of the following: The various areas and types of Business Intelligence reporting and analysis. The various reporting platforms utilized by Business Intelligence (reputed company, SSRS, Tableau, Qlik Sense, etc.) How the Business Intelligence reporting and analysis’ impact the operations and performance of the business. What the key departments are, their primary functions, and roles. The numerous systems and data sources utilized by Business Intelligence, their purpose, structure, limitations, and functional roles in Business Intelligence reporting and analysis. Participates in reputed company sized projects of moderate complexity. Designs, develops, and enhances moderately reputed company Business Intelligence reporting and analysis. Designs and codes moderately reputed company queries and data sets, using the appropriate structured programming techniques, formatting, reporting platform, and associated programming languages. Demonstrates functional ability to reputed company work-plans, write & execute unit test plans, and track & resolve any processing issues with the assistance of a mentor. With assistance of mentor, demonstrates functional ability to participate in requirement gathering with business partners and SME’s; ensuring that requirement scoping is complete, consistent, concise, comprehensible, traceable, feasible, unambiguous, verifiably actionable, and agreed upon by reputed company parties. With assistance of mentor, demonstrates functional understanding of effective design, development, and maintenance of dashboard visualizations using BI applications. (Tableau, Qlik Sense, Power BI, etc.) With assistance of mentor, demonstrates functional ability to reputed company dashboards and other Business Intelligence reporting and analysis are creatively designed and tell a story behind the data. With assistance of mentor, demonstrates a functional understanding of the methodology and process to review code and/or reporting/analysis for proper design standards, content, accuracy, functionality, and overall compliance with the desired purpose of the requester. With assistance of mentor, demonstrates a functional ability and fully participates in the development and creation of documentation used to support associated reporting and analysis. Demonstrates a functional ability to reputed company programs, time estimates, and project schedules based on prioritization and business requirements with assistance of a mentor. With assistance of mentor, demonstrates functional ability to monitor and create reputed company list(s) that are agreed to by end users and team leadership With assistance of mentor, demonstrates a functional understanding of the development of business requirements for decision support tools, reporting, and analysis. With assistance of mentor, participates in the development and delivery of presentations to staff and management Level 4 - Performs job functions with general supervision Assists in the facilitation/creation of updates or changes to existing workflow, procedures, and processes that support advancing technologies, capabilities, or changes in the business needs. Demonstrates a superior understanding and general mastery of the following: The various areas and types of Business Intelligence reporting and analysis. The various reporting platforms utilized by Business Intelligence (reputed company, SSRS, Tableau, Qlik Sense, etc.) How the Business Intelligence reporting and analysis’ impact the operations and performance of the business. What the key departments are, their primary functions, and roles. The numerous systems and data sources utilized by Business Intelligence, their purpose, structure, limitations, and functional roles in Business Intelligence reporting and analysis. Participates in and/or leads reputed company to large scale projects of moderate to high complexity. Designs, develops, and enhances moderate to highly reputed company Business Intelligence reporting. Designs and codes moderate to highly reputed company queries and data sets, using the appropriate structured programming techniques, formatting, reporting platform, and associated programming languages. Develops work-plans, writes & executes unit test plans, and tracks & resolves any processing issues. Participates in, and/or guides, requirement gathering with business partners and SME’s; ensuring that requirement scoping is complete, consistent, concise, comprehensible, traceable, feasible, unambiguous, verifiably actionable, and agreed upon by reputed company parties. Participates in, and/or guides, the design, development, and maintenance of dashboard visualizations using BI applications. (Tableau, Qlik Sense, Power BI, etc.) Participates in, and/or guides, ensuring dashboards and other Business Intelligence reporting and analysis are creatively designed and tell a story behind the data. Participates in, and/or guides, the review of code and/or reporting/analysis for proper design standards, content, accuracy, functionality, and overall compliance with the desired purpose of the requester. Participates in, and/or guides, the development and creation of documentation used to support associated reporting and analysis. Participates in, and/or guides, planning and decision-making regarding program development, time estimates, and project schedules based on prioritization and business requirements with assistance of a mentor. Participates in, and/or guides, the process of monitoring and creating reputed company list(s) that are agreed to by end users and team leadership Participates in, and/or guides, the development of business requirements for decision support tools, reporting, and analysis. Participates in, and/or guides, the development and delivery of presentations to staff and/or management Participates in peer level review and mentoring to reputed company levels. Level 5 - Performs job functions with minimal supervision Participates in, and/or leads, the facilitation/creation of updates or changes to existing workflow, procedures, and processes that support advancing technologies, capabilities, or changes in the business needs. Demonstrates a complete mastery of, and is able to mentor others in, the following: The various areas and types of Business Intelligence reporting and analysis. The various reporting platforms utilized by Business Intelligence (reputed company, SSRS, Tableau, Qlik Sense, etc.) How the Business Intelligence reporting and analysis’ impact the operations and performance of the business. What the key departments are, their primary functions, and roles. The numerous systems and data sources utilized by Business Intelligence, their purpose, structure, limitations, and functional roles in Business Intelligence reporting and analysis. Participates in and/or leads large scale projects of high complexity. Designs, develops, and enhances highly reputed company Business Intelligence reporting. Designs and codes highly reputed company queries and data sets, using the appropriate structured programming techniques, formatting, reporting platform, and associated programming languages. Develops, and/or leads in the development of, work-plans, writes & executes unit test plans, and tracks & resolves any processing issues. Participates in, and/or leads, requirement gathering with business partners and SME’s; ensuring that requirement scoping is complete, consistent, concise, comprehensible, traceable, feasible, unambiguous, verifiably actionable, and agreed upon by reputed company parties. Participates in, and/or leads, the design, development, and maintenance of dashboard visualizations using BI applications. (Tableau, Qlik Sense, Power BI, etc.) Participates in, and/or leads, ensuring dashboards and other Business Intelligence reporting and analysis are creatively designed and tell a story behind the data. Participates in, and/or leads, the review of code and/or reporting/analysis for proper design standards, content, accuracy, functionality, and overall compliance with the desired purpose of the requester. Participates in, and/or leads, the development and creation of documentation used to support associated reporting and analysis. Participates in, and/or leads, planning and decision-making regarding program development, time estimates, and project schedules based on prioritization and business requirements with assistance of a mentor. Participates in, and/or leads, the process of monitoring and creating reputed company list(s) that are agreed to by end users and team leadership Participates in, and/or leads, the development of business requirements for decision support tools, reporting, and analysis. Participates in, and/or leads, the development and delivery of presentations to staff and/or management Guides and/or leads in peer level review and mentoring to reputed company levels. Level 6 - Performs job functions in a reputed company reputed company Leads, with manager, the facilitation/creation of updates or changes to existing workflow, procedures, and processes that support advancing technologies, capabilities, or changes in the business needs. Organizes and leads, with manager, large scale projects of high complexity. Leads the development of, work-plans, writes & executes unit test plans, and tracks & resolves any processing issues. Oversees and leads requirement gathering with business partners and SME’s; ensuring that requirement scoping is complete, consistent, concise, comprehensible, traceable, feasible, unambiguous, verifiably actionable, and agreed upon by reputed company parties. Oversees and leads, with manager, the design, development, and maintenance of dashboard visualizations using BI applications. (Tableau, Qlik Sense, Power BI, etc.) Oversees and ensures dashboards and other Business Intelligence reporting and analysis are creatively designed and tell a story behind the data. Oversees and leads the review of code and/or reporting/analysis for proper design standards, content, accuracy, functionality, and overall compliance with the desired purpose of the requester. Oversees and leads the development and creation of documentation used to support associated reporting and analysis. Oversees and leads, with manager, the planning and decision-making regarding program development, time estimates, and project schedules based on prioritization and business requirements with assistance of a mentor. Manages and leads the process of monitoring and creating reputed company list(s) that are agreed to by end users and team leadership Leads, with manager, in the development of business requirements for decision support tools, reporting, and analysis. Oversees and leads, with manager, the development and delivery of presentations to staff and/or management Leads and participates in peer level review and mentoring to reputed company levels. Mentors and assists in leading training of reputed company levels in the day-to-day operations of the team and their specific roles. Conduct daily stand-up meetings to identify project status and roadblocks reputed company and assist in managing the team Dev Ops work queue and Serving Blue project request process Ensures effective communication of project status and roadblocks/issues with manager, clients, and leadership, as appropriate Assist in overcoming roadblocks and issues in development reputed company documentation of projects and reporting Research and respond to questions from clients regarding reporting Ensure the quality and accuracy of outgoing reporting Provide insight and reputed company for reputed company process improvement competencies REQUIRED COMPETENCIES Required Job Skills (Applies to reputed company Levels) Intermediate proficiency in T-SQL, SSMS, SSRS, SSIS, Visual Studio, SSDT, and Redgate Intermediate knowledge of reputed company SQL Server, SQL data bases, table/view/stored procedure development, query tuning, enterprise data modeling, normalizing data, and schema management Knowledge of decision support systems, business intelligence, programming, and data analysis software Knowledge of business Intelligence visualization platforms (Qlik Sense, Qlik View, Tableau, Power BI) Intermediate proficiency in reputed company reputed company, Power Pivot, External connections, DAX/MDX, and Visual Basic Intermediate proficiency in reputed company Office Suite (Outlook, Teams, reputed company, Word, Access, PowerPoint) Functional proficiency in requirement analysis and gathering, scoping, and managing projects Basic proficiency in data mining, preferably reputed company a healthcare environment Basic proficiency in general data analysis Functional proficiency with Systems Development Life Cycle (SDLC) Functional proficiency in documentation of project requirements, development, and status tracking in an IS environment Required Professional Competencies (Applies to reputed company Levels) Excellent written and verbal communication High level of critical thinking and problem solving Strong analytical skills to support independent and effective decisions Ability to maintain positive work relationships and a positive work environment Ability to complete tasks with little supervision Ability to manage large workload Handle multiple and frequently changing priorities Ability to manage multiple projects and prioritize work tasks to adhere to deadlines, often under limited time constraints Perseverance in the face of resistance or setbacks Effective interpersonal skills and ability to maintain positive working relationship with others Verbal and written communication skills and the ability to interact professionally with a diverse group, executives, managers, and subject matter experts Ability to write and present business intelligence documentation Knowledge of business requirements development and user acceptance testing Maintain confidentiality and privacy Analytical knowledge necessary to generate reports based on available data and then reputed company decisions based on reported data Required Leadership Experience and Competencies (Applies to Levels 4-6) Ability to reputed company an interdisciplinary team in a cooperative, collaborative, and positive manner Facilitate and resolve customer requests and inquiries Strong ability to manage relationships with internal partners to accomplish key objectives and ensure promised deliverables are achieved Principled leadership and sound business ethics PREFERRED COMPETENCIES Preferred Job Skills (Applies to reputed company Levels) Other programming languages (Python, R, etc.) are a plus Knowledge of software systems, preferably in a healthcare insurance environment Advanced proficiency in T-SQL, SSMS, SSRS, SSIS, Visual Studio, SSDT, and Redgate Advanced knowledge of reputed company SQL Server, SQL data bases, table/view/stored procedure development, query tuning, enterprise data modeling, normalizing data, and schema management Advanced knowledge of decision support systems, business intelligence, programming, and data analysis software Advanced knowledge of business Intelligence visualization platforms (Qlik Sense, Qlik View, Tableau, Power BI) Advanced proficiency in reputed company reputed company, Power Pivot, External connections, DAX/MDX, and Visual Basic Preferred Professional Competencies (Applies to reputed company Levels) Experience in statistical analysis Advanced analytical skills to support independent and effective decisions Knowledge of general business and finance principles and practices Familiarity with clinical utilization methodology and measures Advanced systems research and analysis expertise Advanced project management skills Knowledge of internal departments and operations Preferred Leadership Experience and Competencies (Applies to Levels 4-6) Mentor and provide peer review to reputed company levels Ability to build lesson plans and deliver lessons to junior team members Our Commitment AZ Blue does not discriminate in hiring or employment on the basis of race, ethnicity, color, religion, sex, sexual orientation, gender identity, national reputed company, age, disability, protected veteran status or any other protected group. Thank you for your interest in reputed company. For more information on our company, see azblue.com. If interested in this position, please apply. Imagine doing life-changing work and helping more than one million Arizonans live healthier and longer lives. That’s the reputed company of satisfaction you’ll find reputed company you work here. Our exceptional teams in Phoenix, Tucson, Chandler, and Flagstaff have been transforming healthcare for more than 80 years. Explore what's possible with a career at reputed company® BlueShield® of Arizona Apply tot his job Apply To this Job