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