Business Intelligence Analyst Specialist

Ampcus Incorporated

Austin, TX

JOB DETAILS
SKILLS
Acceptance Testing, Agile Programming Methodologies, Analysis Skills, Artificial Intelligence (AI), Business Analysis, Business Intelligence, Business Services, Business Solutions, Communication Skills, Consulting, Data Analysis, Data Quality, Data Sets, Data Visualization, Data Warehousing, Department of Health and Human Services, Healthcare, Leadership, Literacy, Maintain Compliance, Medicaid, Mentoring, Performance Analysis, Performance Management, Power BI, Presentation/Verbal Skills, Python Programming/Scripting Language, Query Optimization, Regulatory Reports, Regulatory Requirements, Reporting Dashboards, Reporting Skills, Requirements Management, SQL (Structured Query Language), Strategic Planning, Systems Analysis, Tableau, Test Case, Test Plan/Schedule, Test Requirements, Test Strategy, Traceability, Training/Teaching, User Documentation
LOCATION
Austin, TX
POSTED
8 days ago

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.

About the Company

A

Ampcus Incorporated

Ampcus Inc is a global technology and business consulting firm specializing in Digital Transforrmation, Big Data, Analytics, Cyber Security, Testing, IV&V, Infrastructure Management and Enterprise Solutions. Ampcus Inc is an SBA 8(a) certified Women and Minority Owned global Provider of broad range of consulting Services. From strategy to execution, our disciplined yet flexible approach starts and ends with our clients. By listening hard and working harder, their goals become our goals. We are an ISO 9000, ISO 20000, ISO 27000 and CMMi Level certified company.

Ampcus consultants have significant business, engineering and technology experience. Our consultants have over 20 years of business experience and an average of over 10 years of engineering and technology experience. This means that the project teams understand how systems work and how the technology impacts the business processes of organizations.

We believe that success of an engagement is determined by strong project management, clear communication and mutual commitment working collaboratively. Our methodology begins by listening to the customer needs, then working with their teams to gain a clear understanding of the requirements, while providing a knowledge transfer of best practices for the organization. As a recognized leader providing customized software services, management and engineering solutions to companies around the world, our ability to deliver is a "granted"​ that makes companies put their trust in us to answer their day-to-day business challenges and put them on a path for greater success. We are the choice for our clients because we look at our clients business from a growth perspective.

Industry: Information Technology and Services

Specialties: Digital Transformation, Big Data and Analytics, Infrastructure Management Services, Testing and IV&V, Cyber Security, Active Directory and E-mail Infrastructure, Project Management, Training, and ERP, CRM. EAI, BI

COMPANY SIZE
500 to 999 employees
INDUSTRY
Staffing/Employment Agencies
WEBSITE
http://www.ampcus.com