Lead BA/Data Analyst with Medicare/FoodShare experience Remote (1 day a month onsite in Madison)

Other Jobs To Apply

Lead BA/Data Analyst with Medicare/FoodShare experience Location: Remote (1 day a month onsite in Madison) Interview mode: Virtual Job Description:

REQUIRED SKILLS: (Need All)

  • 3-5 years Data Analysis and Report Development:
    • Analyze and document the current state of existing data repositories and the 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
    • Assist in clearly defining the future state of enterprise data analytics capabilities
    • Ability to grasp technical concepts such as Data Warehouse, ETL, Transactional Batch Processing, Data Schemas, Secured Transport, etc., and communicate them to System Delivery Teams
    • 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
    • Experience working in system environments with relational databases, including either SAS, MySQL, Oracle, MS SQL, DB2, etc.
    • Knowledge of data reporting platforms, including either MS SSRS, MS Access, SAS, etc.
    • Knowledge of data visualization tools, including either SAS Visual Analytics, Power BI, Tableau, etc.
  • 3-5 years Stakeholder Engagement and Requirements Gathering
  • 3-5 years Regulatory Compliance & Policy Integration
  • 3-5 years Documentation & Project Leadership
  • 3-5 years of experience performing a business analyst role supporting State Medicaid and MMIS, or similar health care business and system 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

NICE TO HAVE SKILLS:

  • Experienced with business process reengineering and identifying new applications of technology to business problems to make businesses more effective
  • Experience with business analysis and testing industry standards, current and emerging technologies, business process mapping, and reengineering
  • Prepare Risk Identification
  • Prepare Fiscal Analysis, including cost/benefit, ROI, and buy/build
  • Certified Business Analysis Professional (CABP) preferred.
  • Document clear test plans and create test cases that are traceable to business, functional, non-functional, and transition requirements

INTERVIEW PROCESS:

  • MS Teams Video
  • At least 1 round

DESCRIPTION OF ROLE:

Our client is looking for a lead Business Analyst.

The resource will join the Integrated Data & Analytics Section (ID&AS) to support complex data initiatives for the Client's programs. This role is responsible for the end-to-end lifecycle of data reporting-from gathering requirements with stakeholders to the technical development and implementation of ad hoc and standard reports. The ideal candidate bridges the gap between policy and technology, ensuring that all data outputs comply with state and federal regulations.

Key Responsibilities with 3 to 5 years of experience:

  • Data Analysis and Report Development
    • Perform analysis, development, preparation, implementation, and evaluation of complex standard and ad hoc reports that support data collection, access, changes, retrieval, and retention related to Medicaid and FoodShare programs.
    • Determine report specifications and assist in preparing necessary queries to obtain required data for reports, to complete technical queries 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.
  • Stakeholder Engagement and Requirements Gathering
    • Collaborate with internal and external stakeholders, management staff, and other 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.
  • Regulatory Compliance and Policy Integration
    • Review and analyze changes in federal and state rules and regulations for impact on policy and processes, including system software support, especially those necessary for reporting.
    • Implement necessary revisions to reporting frameworks to ensure 100% compliance with shifting regulations.
    • Evaluate standard reports for cost improvements and operational efficiencies.
  • Documentation and Project Leadership
    • 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.

      KEYS AMPLIFIED WOULD TARGET IN CANDIDATES:

      • 7+ Years with more recent roles as Data Lead/Analyst
        • Data Analysis
        • Report Development
        • Leadership
        • State Medicaid and MMIS systems
      • Candidate must be willing to relocate to Madison, WI at start of this contract (can be remote most of the time; 1 day a month onsite in Madison)
      • CBAP is a bonus

Best Regards,

Shivam Kumar

IT Technical Recruiter

Stellent IT Phone: 201-503-2666

Linkedin

Email: shivam@stellentit.com
Gtalk: shivam@stellentit.com

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...