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

Blue Cross Blue Shield of Arizona•Phoenix, AZ

1d•Remote

About The Position

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 enable data driven and data literate decision making for departments and teams throughout the entire Medicaid segment.

Requirements

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

Nice To Haves

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
Other programming languages (Python, R, etc.) are a plus
Knowledge of software systems, preferably in a healthcare insurance environment

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
Perform all other duties as assigned
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 (Excel, 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 develop 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 all 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 lead, supervisor, or manager who provides general supervisory instructions, manages workload and reviews overall results.