Business Intelligence Analyst | Austin, Texas

Tech Mirrors; Austin (TX); On-site; USD 120,000 - 160,000; Full time

Job summary

Tech Mirrors is seeking a senior Business Intelligence Analyst in Austin to translate complex business needs into technical specifications and reliable BI solutions. You will collaborate with stakeholders across IT and business units, analyze data with SQL, and deliver dashboards in Power BI or Tableau to inform strategic decisions.

The role requires extensive experience in analytics, data governance, and creating robust test plans.

Qualifications

• 10+ years of Business Analysis and Systems Analysis experience.
• 10+ years gathering business requirements and translating complex operational needs.
• 10+ years working with complex analytics and reporting environments.
• 10+ years of advanced SQL for data extraction and manipulation.
• 10+ years creating reports, dashboards, and visualizations.
• Extensive experience with Power BI and/or Tableau.
• Strong experience developing test plans, test cases, and acceptance criteria.
• Excellent communication and stakeholder management skills.
• Ability to explain technical concepts to non-technical users.

Responsibilities

• Gather business, technical, and data requirements from stakeholders.
• Translate business requirements into technical specifications and test documentation.
• Develop comprehensive test plans, test cases, and traceability matrices.
• Analyze complex datasets using SQL.
• Create and validate dashboards and reports using Power BI and/or Tableau.
• Work with business users to understand reporting needs and data requirements.
• Develop AI prompts and query strategies for accurate data retrieval.
• Create reusable AI prompt libraries and reporting templates.
• Validate AI-generated outputs and identify potential inaccuracies or hallucinations.
• Collaborate with Data Engineering, IT, and business teams to resolve data issues.
• Ensure compliance with data governance, reporting standards, and agency regulations.
• Conduct AI and data literacy training sessions for non-technical users.
• Prepare documentation, user guides, and training materials.
• Support Agile sprint activities including requirements, testing, and delivery.

Skills

Business Analysis

SQL Proficiency

Data Visualization

Power BI/Tableau

Stakeholder mgmt

Tools

Power BI

Tableau

SQL

Python

Job description

Job Title

Business Intelligence Analyst

Location

Austin, Texas

Key Responsibilities

• Gather business, technical, and data requirements from stakeholders.
• Translate business requirements into technical specifications and test documentation.
• Develop comprehensive test plans, test cases, and traceability matrices.
• Analyze complex datasets using SQL.
• Create and validate dashboards and reports using Power BI and/or Tableau.
• Work with business users to understand reporting needs and data requirements.
• Develop AI prompts and query strategies for accurate data retrieval.
• Create reusable AI prompt libraries and reporting templates.
• Validate AI-generated outputs and identify potential inaccuracies or hallucinations.
• Collaborate with Data Engineering, IT, and business teams to resolve data issues.
• Ensure compliance with data governance, reporting standards, and agency regulations.
• Conduct AI and data literacy training sessions for non-technical users.
• Prepare documentation, user guides, and training materials.
• Support Agile sprint activities including requirements, testing, and delivery.

Required Skills & Experience

• 10+ years of Business Analysis and Systems Analysis experience.
• 10+ years gathering business requirements and translating complex operational needs.
• 10+ years working with complex analytics and reporting environments.
• 10+ years of advanced SQL for data extraction and manipulation.
• 10+ years creating reports, dashboards, and visualizations.
• Extensive experience with Power BI and/or Tableau.
• Strong experience developing test plans, test cases, and acceptance criteria.
• Excellent communication and stakeholder management skills.
• Ability to explain technical concepts to non-technical users.

Technical Skills

• SQL
• Power BI
• Tableau
• Business Intelligence
• Data Warehouse
• Data Analysis
• Data Visualization
• Agile Methodology
• Waterfall Methodology
• Test Planning
• Test Case Development
• Requirements Gathering
• AI Prompt Engineering
• Streamlit (Preferred)
• Python (Preferred)
• Data Governance
• Data Quality
• Reporting & Analytics