Technology Analyst III, Business Intelligence

• 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.

• 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., Visa sponsorship is not available for this position. All applicants must be currently authorized to work in the United States.