[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.ResponsibilitiesMeet timeliness and accuracy goalsUse sound project management methodology and demonstrate solid time management skillsEffectively communicate status of work assignments to stakeholders and management via department defined communication channels and policyDesign, 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 businessDesign, develop, or maintain reporting and/or analysis of data for medical cost reporting, categories of service, unit cost and financial utilization metricsDesign, develop, or maintain reporting and/or analysis of data for clinical utilization, authorization, care management, risk adjustment, and claims data to support departmental functionsReceives, interprets, and completes data requests from Finance and other departments as necessaryResponsible for technical and production support documentation in accordance with department standards and industry best practicesAdhere to established source control versioning policies and proceduresParticipate in all aspects of the Systems Development Life Cycle (SDLC)Participate in corporate quality and data governance programsImplement and maintain operational and disaster-recovery proceduresMaintain current knowledge on new developments in technology-related industriesThe 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 requirementsPerform all other duties as assignedSkills2 years of experience working with data, report development, and analysis in a workplace setting1 year of experience in query design and effective reporting design structureHigh-School Diploma or GED in general field of studyIntermediate proficiency in T-SQL, SSMS, SSRS, SSIS, Visual Studio, SSDT, and RedgateIntermediate knowledge of Microsoft SQL Server, SQL data bases, table/view/stored procedure development, query tuning, enterprise data modeling, normalizing data, and schema managementKnowledge of decision support systems, business intelligence, programming, and data analysis softwareKnowledge 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 BasicIntermediate proficiency in Microsoft Office Suite (Outlook, Teams, Excel, Word, Access, PowerPoint)Functional proficiency in requirement analysis and gathering, scoping, and managing projectsBasic proficiency in data mining, preferably within a healthcare environmentBasic proficiency in general data analysisFunctional proficiency with Systems Development Life Cycle (SDLC)Functional proficiency in documentation of project requirements, development, and status tracking in an IS environmentExcellent written and verbal communicationHigh level of critical thinking and problem solvingStrong analytical skills to support independent and effective decisionsAbility to maintain positive work relationships and a positive work environmentAbility to complete tasks with little supervisionAbility to manage large workloadHandle multiple and frequently changing prioritiesAbility to manage multiple projects and prioritize work tasks to adhere to deadlines, often under limited time constraintsPerseverance in the face of resistance or setbacksEffective interpersonal skills and ability to maintain positive working relationship with othersVerbal and written communication skills and the ability to interact professionally with a diverse group, executives, managers, and subject matter expertsAbility to write and present business intelligence documentationKnowledge of business requirements development and user acceptance testingMaintain confidentiality and privacyAnalytical knowledge necessary to generate reports based on available data and then make decisions based on reported data1 year of experience in a healthcare, health insurance, or managed care environment1 year of experience working with Medicaid and/or Medicare D-SNP programs1 year of experience managing projectsBachelor'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 universityMS SQL Certification or other certification in current programming languagesOther programming languages (Python, R, etc.) are a plusKnowledge of software systems, preferably in a healthcare insurance environmentAdvanced proficiency in T-SQL, SSMS, SSRS, SSIS, Visual Studio, SSDT, and RedgateAdvanced knowledge of Microsoft SQL Server, SQL data bases, table/view/stored procedure development, query tuning, enterprise data modeling, normalizing data, and schema managementAdvanced knowledge of decision support systems, business intelligence, programming, and data analysis softwareAdvanced 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 BasicExperience in statistical analysisAdvanced analytical skills to support independent and effective decisionsKnowledge of general business and finance principles and practicesFamiliarity with clinical utilization methodology and measuresAdvanced systems research and analysis expertiseAdvanced project management skillsKnowledge of internal departments and operationsCompany OverviewBlue Cross Blue Shield of Arizona is a non-profit company that offers health insurance and financial services. It was founded in 1939, and is headquartered in Phoenix, Arizona, USA, with a workforce of 1001-5000 employees. Its website is https://www.azblue.com.