Technology Analyst III, Business Intelligence

CapMetro

. Partner with departments across the agency to promote effective use of enterprise business intelligence .

Posted 10/31/2026full-timeAustin • Texas • United StatesMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing, implementing, and supporting enterprise data warehouses and integrations, with a strong focus on Microsoft technologies and cloud environments. Proficient in data analysis, visualization, and providing user support while ensuring data accuracy and security.

Highest-signal resume keywords

Enterprise Data Warehouse DesignETL Tools ExperienceSQL ProgrammingMicrosoft Azure ProficiencyPower BI Expertise

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data AnalysisData IntegrationData VisualizationRelational Database DesignData ModelingPython ProgrammingJavaScript ProgrammingSnowflake AdministrationPerformance TuningData Troubleshooting

Soft Skills

Analytical SkillsProblem-Solving SkillsExcellent Communication SkillsCollaboration SkillsAttention to Detail

Tools & Technologies

Power BITableauETL ToolsMicrosoft AzureSnowflake

Industry Keywords

Business IntelligenceData GovernanceRisk ManagementDisaster RecoveryCompliance

Tech Stack

Tools & technologies

AzureCloudETLJavaScriptPythonSnowflakeSQLTableau

About the role

Key responsibilities & impact

Partner with departments across the agency to promote effective use of enterprise business intelligence
Analyze, mine, and interpret enterprise data to deliver reports, dashboards, scorecards, visualizations, extracts, and spatial data solutions
Collaborate with business systems analysts, data analysts, and end users to understand requirements, develop reporting solutions, resolve data issues, and support data access and governance
Design, develop, test, monitor, and maintain data warehouse environments and ETL/integration processes
Identify emerging data requirements and sources; develop integrations and enhancements aligned with architecture and standards
Own assigned systems and applications, ensuring reliable operation and continuous improvement
Lead technology initiatives and projects while coordinating with stakeholders, vendors, and implementation partners
Manage software licensing, maintenance, renewals, and vendor compliance; participate in after-hours support and on-call rotations as required
Monitor and maintain system availability, performance, and security, including performance tuning, patch management, alerts, and controls
Lead security, risk management, disaster recovery, backup, compliance, access reviews, risk assessments, issue remediation, and recovery testing
Lead change management, testing, deployment, and stakeholder communications
Develop technical documentation, metadata, user guides, training materials, and operating procedures
Provide user training, encourage technology adoption, establish best practices, and deliver reports and recommendations to management
Support Capital Metro’s Safety Management Systems process and perform other assigned duties aligned with strategic and IT objectives

Requirements

What you’ll need

Bachelor’s degree in Computer Science or related field; additional related experience may substitute for the degree on a year-for-year basis up to four years
Six years of experience in Information Technology or a related field, including four years of progressively responsible experience designing, implementing, and supporting enterprise data warehouses, data integrations, data extractions, reports, dashboards, and analytics solutions using Microsoft technologies
Hands-on experience using ETL tools
Experience in SQL programming
Experience in Python and/or JavaScript programming
Experience working in cloud environments, preferably Microsoft Azure, including data storage, integration, analytics, security, and platform services
Experience developing in and administering Snowflake, including security, access, performance, and resource management
Experience with business intelligence and data visualization platforms; Power BI required and Tableau experience preferred
Ability to troubleshoot and resolve complex technical, data, and application issues
Experience providing direct end-user support and excellent customer service in a technology environment
Strong knowledge of relational database design, administration, and data modeling concepts
Strong analytical, problem-solving, and data troubleshooting skills
Excellent written and verbal communication skills, with the ability to present technical information to non-technical audiences
Ability to work effectively in a collaborative, matrixed environment with business and technical stakeholders
Ability to manage multiple priorities, projects, and deadlines in a fast-paced environment
Knowledge of systems development, implementation, and support methodologies
Ability to gather business requirements and translate them into effective technology and data solutions
Strong attention to detail and commitment to data accuracy, integrity, and security
Ability to stand and sit frequently throughout an eight-hour period, reach vertically and horizontally, use telephone or headset equipment, lift and move up to 20 lbs., work at a computer terminal for 6–8 hours daily, and function amid constant interruptions
Regular and predictable attendance at the assigned work location
Currently authorized to work in the United States; visa sponsorship is not available

Benefits

Comp & perks

Hybrid work arrangement; generally encouraged to work 8 to 12 days in office per month
Reasonable accommodation for individuals with disabilities
Annual background checks for incumbents in this security-sensitive position