Technology Analyst III, Business Intelligence

WHO WE'RE LOOKING FOR

The Business Intelligence Technology Analyst III is responsible for the administration, support, and enhancement of enterprise data and business intelligence systems. Working in partnership with departmental business system analysts and business stakeholders, this role delivers actionable insights through the development of complex reports, dashboards, and data solutions. The position analyzes business reporting needs, develops advanced BI queries and analytics, automates and schedules data outputs, ensures data integrity, and resolves data-related issues to support informed decision-making across the organization.

WHAT YOU'LL DO

Business Intelligence & Analytics

Partner with departments across the agency to promote and expand the effective use of enterprise business intelligence, serving as a trusted advisor on data, reporting, and technology solutions.

Analyze, mine, and interpret enterprise data to design and deliver reports, dashboards, scorecards, visualizations, extracts, and spatial data solutions that support operational and strategic decision-making.

Collaborate with business systems analysts, data analysts, and end users to understand business requirements, develop reporting solutions, resolve data issues, and support data access and governance needs.

Data Warehouse & Integration Management

Design, develop, test, monitor, and maintain data warehouse environments and related integration processes, including data extraction, transformation, loading (ETL), cleansing, validation, and ongoing optimization.

Identify emerging data requirements and new data sources; develop and implement integrations and enhancements that align with established architecture, standards, and best practices.

Application, System & Vendor Management

Assume full technical and functional ownership of assigned systems and applications, ensuring reliable operation, continuous improvement, and alignment with business objectives.

Lead technology initiatives and projects, providing technical expertise while coordinating with internal stakeholders, vendors, and implementation partners to deploy and support enterprise solutions.

Manage software licensing, maintenance, renewals, and vendor compliance activities, and participate in after-hours support and on-call rotations as required.

System Reliability, Security & Risk Management

Ensure the availability, performance, and security of business intelligence and related systems through proactive monitoring, maintenance, performance tuning, patch management, and implementation of alerts and controls.

Lead security, risk management, disaster recovery, backup, and compliance activities, including access reviews, risk assessments, investigation and remediation of security issues, recovery testing, and adherence to security standards and policies.

Governance, Documentation & User Enablement

Lead change management activities by assessing impacts, planning, and deploying system changes, conducting testing, and communicating updates to stakeholders.

Develop, maintain, and enhance 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.

CapMetro SMS Support & Other Duties Assigned

Support Capital Metropolitan Transportation Authority’s Safety Management Systems (SMS) process by ensuring staff follows safety and security policies, considers safety in every action, and ensures safety and security concerns are reported.

Perform other duties as required and/or assigned in support of the Capital Metro Strategic Goals and the IT Vision, Mission, and Objectives aligned to these goals.

WHAT YOU BRING

Bachelor’s degree in Computer Science or related field. Additional related experience may substitute for degree on a year for year basis up to four (4) years.

Six (6) years of experience in Information Technology or related field, including four (4) years of progressively responsible experience designing, implementing, and supporting enterprise data warehouses, data integrations, data extractions, reports, dashboards, and analytics solutions using Microsoft technologies.

Knowledge, Skills, and Abilities

Hands-on experience using ETL (Extract- Transform-Load) tools.

Experience in SQL programming Experience in Python and/or Java script Programming

Experience working in cloud nvironments, 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.

Demonstrated ability to troubleshoot and resolve complex technical, data, and application issues. Experience providing direct end-user support and delivering 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.

Self-motivated with a commitment to continuous learning, process improvement, and innovation.

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.

Demonstrated leadership, initiative, and sound decision-making skills.

Strong customer service orientation and commitment to delivering high-quality solutions and support.

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.

WORK ENVIRONMENT AND PHYSICAL DEMANDS Work is generally performed in an office environment in which there is only minimal exposure to unpleasant and/or hazardous working conditions. This position works with multiple project timelines and is responsible for managing employees performing work of a complex nature.

Incumbent must be able to stand and sit frequently throughout an eight-hour period, reach vertically for overhead use and horizontally. Must be able to use a telephone or headset equipment. Incumbents must be able to lift and move material weighing up to 20 lbs., perform work at a computer terminal for 6-8 hours a day, and function in an environment with constant interruptions. Regular and predictable attendance at assigned work location is an essential function.

Reasonable accommodation may be made to enable individuals with disability to perform the essential functions as previously described.

WORK AUTHORIZATION Visa sponsorship is not available for this position. All applicants must be currently authorized to work in the United States.

Mobility Status: As a Hybrid position, onsite presence is guided by team collaboration needs, customer and front-line team member interactions, and role responsibilities. People leaders will set expectations for onsite presence; however, incumbents are generally encouraged to work 8 to 12 days in office per month. Mobility status is subject to change at any time based on business needs or organizational decisions.

COMMITMENT TO EQUAL EMPLOYMENT OPPORTUNITY CapMetro is an equal employment opportunity employer and committed to creating a welcoming environment for all employees. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, pregnancy, age, or any other protected characteristic as outlined by federal, state, or local laws. CapMetro makes hiring decisions based solely on qualifications, merit, and organization needs at the time.

SECURITY SENSITIVE POSITION This position has been identified as a “Security Sensitive” position. CapMetro will conduct annual background checks on incumbents in this position. A position is “Security Sensitive” if the incumbent handles currency, has access to sensitive, computerized databases, has access to master keys, or works in an area of the Capital Metro that has been designated as a security-sensitive area.