Business Intelligence Architect

Responsibilities

• Perform analysis, development, preparation, implementation, and evaluation of complex standard and ad hoc reports supporting data collection, access, changes, retrieval and retention for Medicaid and FoodShare programs

• Determine report specifications and assist in preparing necessary queries to obtain required data using SQL/SAS to extract and manipulate data from MES and IM databases

• Perform rigorous testing and evaluation of report outputs to ensure accuracy and data integrity

• Collaborate with internal and external stakeholders, management staff, and colleagues to define reporting requirements and refine system modifications

• Translate complex policy language into user-friendly logic flows and technical specifications

• Review design layouts and file structures, providing recommendations for resource allocation and optimization

• Review and analyze changes in federal and state rules and regulations for impact on policy and processes, including system software support for reporting

• Implement necessary revisions to reporting frameworks to ensure 100% compliance with shifting regulations

• Evaluate standard reports for cost improvements and operational efficiencies

• Prepare written comprehensive system and data requirements, flowcharts, and draft formal work directives for vendors

• Develop end-user documentation, program manuals, and user guides to ensure seamless adoption of reporting tools

• Lead small to medium-sized project teams through problem-solving and implementation phases

• Provide detailed status report updates to Project Manager

• Analyze and document the current state of existing data repositories and associated data reporting environments

• Assess end-to-end data integration workflows and systems operational dependencies

• Create and maintain technical documentation such as data flows, interface control documents, entity relationship diagrams and data catalogs

• Gather and analyze end user requirements for new and existing data loads for the enterprise data warehouse

• Create technical specifications to load data from disparate source systems into the enterprise data warehouse for reporting and analysis

• Required Qualifications

• 3-5 years of experience performing a business analyst role supporting State Medicaid and MMIS, or similar health care business and system

• Certified Business Analysis Professional (CBAP)

• Experience in one or more of the following functional areas: Provider management, Member (recipient) eligibility and enrollment, Claims and encounters, Benefit plan administration, Service authorization, Financial services, Decision support system/data warehouse, Pharmacy benefit management, Program integrity and utilization management

• Experience with Data Analysis and Report Development (3-5 years)

• Experience with Stakeholder Engagement and Requirements Gathering (3-5 years)

• Experience with Regulatory Compliance & Policy Integration (3-5 years)

• Experience with Documentation & Project Leadership (3-5 years)

• Experience working in system environments with relational databases (SAS, MySQL, Oracle, MS SQL, DB2, etc.)

• Knowledge of data reporting platforms (MS SSRS, MS Access, SAS, etc.)

• Knowledge of data visualization tools (SAS Visual Analytics, Power BI, Tableau, etc.)

• Ability to grasp technical concepts (Data Warehouse, ETL, Transactional Batch Processing, Data Schemas, Secured Transport) and communicate to System Delivery Teams

• Excellent interpersonal communication skills

• Excellent organization and time management skills

• Experience with business process reengineering and identifying new applications of technology to business problems

• Experience with business analyst and testing industry standards, current and emerging technologies, business process mapping, and reengineering

• Facilitation skills: Efficiently plan and execute meetings, establish agenda and set meeting objectives, document and distribute meeting decisions and action items, timely follow-up on all action items

• Elicitation skills: Efficiently and effectively divine business requirements from business area staff

• Documentation skills: Use established business requirement templates, produce clear and concise requirements documentation, create traceability to RFP requirements

• Validation skills: Effectively and efficiently review and validate documented business requirements with business area staff and owners, review, analyze, and evaluate business systems and user needs

Testing skills: Document clear test plans and create test cases traceable to business, functional, non-functional, and transition requirements; effectively execute test plan and document test results; document defects and collaborate with business analysts and developers to resolve and execute regression testing; facilitate review of test results with project stakeholders