Business Intelligence Analyst Specialist

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Job Title: Business Intelligence Analyst Specialist

Location(s): Austin, TX

Position Summary:
Seeking a senior Business Intelligence Analyst Specialist to support Medicaid reporting initiatives within a Performance Management & Analytics System (PMAS). This role combines business analysis, systems analysis, data analytics, testing, reporting, and emerging AI-enabled data analysis. The ideal candidate will bridge business and technical teams, gather and document requirements, develop testing strategies, create reports and dashboards, and enable business users to leverage AI for accurate data analysis and reporting.

Key Responsibilities:

• Gather business, technical, and data requirements from stakeholders.
• Translate business requirements into technical specifications and SQL queries.
• Lead testing efforts, including test plans, test cases, traceability matrices, and user acceptance testing (UAT).
• Analyze large and complex datasets using SQL.
• Develop and validate reports, dashboards, and visualizations using Power BI or Tableau.
• Support Medicaid reporting and data curation initiatives.
• Create AI prompts and reusable prompt libraries for reporting and analytics.
• Validate AI-generated outputs and identify inaccuracies or hallucinations.
• Develop documentation, user guides, and training materials.
• Train non-technical users on AI-assisted data analysis and reporting.
• Collaborate with data engineers, developers, business teams, and program stakeholders.
• Ensure compliance with data governance, reporting standards, and regulatory requirements.

Required Qualifications:

• 10+ years of Business Intelligence, Business Systems Analysis, or Data Analysis experience.
• 10+ years of experience gathering business and technical requirements.
• 10+ years of experience writing and optimizing SQL queries for data extraction and analysis.
• 10+ years of experience translating complex business requirements into technical solutions.
• 10+ years of experience creating reports, dashboards, and data visualizations.
• Strong experience with Power BI and/or Tableau.
• Experience leading testing activities, including test plans, test cases, and requirements traceability.
• Excellent communication, presentation, and stakeholder management skills.
• Ability to explain technical concepts to non-technical audiences.

Preferred Qualifications:

• Experience with Business Intelligence/Data Warehouse environments.
• Experience in healthcare, Medicaid, Health & Human Services, or another highly regulated environment.
• Knowledge of data governance and data quality principles.
• Experience developing and delivering training for non-technical users.
• Experience mentoring users with varying levels of data literacy.
• Experience creating AI prompt libraries using Streamlit and Python.
• Understanding of Responsible AI principles and AI governance.

Technical Skills:

• SQL
• Power BI
• Tableau
• Business Analysis
• Systems Analysis
• Data Analysis
• Data Visualization
• Requirements Gathering
• Test Planning
• Test Case Development
• User Acceptance Testing (UAT)
• Data Warehousing
• Agile
• Waterfall
• Data Governance
• Data Quality
• AI Prompt Engineering
• Streamlit (preferred)
• Python (preferred)

Ideal Candidate Background:

• Senior Business Intelligence Analyst
• Senior Data Analyst
• Business Systems Analyst
• Data Warehouse Analyst
• BI Consultant
• Healthcare Data Analyst
• Medicaid Reporting Analyst
• Reporting and Analytics Lead

Must-Have Skills:

• 10+ years of Business Intelligence or Data Analysis experience
• Advanced SQL
• Business and systems analysis
• Requirements gathering
• Power BI or Tableau
• Test planning, test cases, and UAT
• Dashboard and report development
• Strong stakeholder communication
• Data reporting and analytics

Nice-to-Have Skills:

• Medicaid or healthcare reporting
• Business Intelligence/Data Warehouse experience
• AI prompt engineering
• Streamlit
• Python
• Responsible AI
• Data governance
• Training and mentoring end users

Experience Required:

• 10+ years.

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.