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

Note: The job is a remote job and is open to candidates in USA. Blue Cross Blue Shield of Arizona is dedicated to inspiring health and providing various health insurance products and services. The Business Intelligence Developer - Medicaid role focuses on designing, creating, and maintaining reporting solutions and analytical insights to support data-driven decision-making across the organization.

Responsibilities

• 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 via department defined communication channels and policy
• Design, develop, 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, develop, or maintain reporting and/or analysis of data for medical cost reporting, categories of service, unit cost and financial utilization metrics
• Design, develop, 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 source control versioning policies and procedures
• Participate in all 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 current knowledge on new developments in technology-related 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
• Perform all other duties as assigned

Skills

• 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
• High-School Diploma or GED in general field of study
• Intermediate proficiency in T-SQL, SSMS, SSRS, SSIS, Visual Studio, SSDT, and Redgate
• Intermediate knowledge of Microsoft 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 Microsoft Excel, Power Pivot, External connections, DAX/MDX, and Visual Basic
• Intermediate proficiency in Microsoft Office Suite (Outlook, Teams, Excel, Word, Access, PowerPoint)
• Functional proficiency in requirement analysis and gathering, scoping, and managing projects
• Basic proficiency in data mining, preferably within 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
• 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 make decisions based on reported data
• 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
• 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
• MS SQL Certification or other certification in current programming languages
• 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 Microsoft 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 Microsoft Excel, Power Pivot, External connections, DAX/MDX, and Visual Basic
• 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

Company Overview