Note: This position is open exclusively to candidates currently enrolled in the Hiring Our Heroes Fellows Program. Applications from individuals not participating in the program will not be considered.
JOB SUMMARY
The Business Intelligence Technology Analyst III, Information Technology is responsible for the data systems. The role will work with the departmental business system analysts and other users of the system, supporting the Business Intelligence (BI) tools, helping analyze reporting requirements, developing complex BI queries and reports, generate and schedule complex data outputs, develop and manage complex dashboards and troubleshoot data inconsistencies and issues.
PRIMARY RESPONSIBILITIES
- Work cross-functionally with various departments to evangelize and promote use of enterprise business intelligence across the agency.
- Support departmental business systems analysts, data analysts and BI users with their data needs designing and developing BI reporting deliverables, conducting data access audits, and resolve data integrations and data issues.
- Maintain and support BI tools used by users.
- Analyze, mine data in the data warehouse and develop queries, reports, dashboards, charts, scorecards and extracts of data including spatial data.
- Design, develop, test, monitor, manages and validate data warehouse activity, including data extraction, transformation, movement, loading, cleansing and updating processes.
- Identify and analyze new data needs and sources. Extend data warehouse developing new integrations following existing architecture and best practices.
- Document and maintain metadata for data warehouse and integrations. Develop user documentation and FAQ.
- Assist staff with documents necessary to procure required systems, licenses, maintenance, and support. Ensure any renewals are completed before expiration and Capital Metro is compliant with vendor licensing requirements.
- Participate in on-call rotation for after-hours IT support.
- Partner with stakeholders to undertake full IT ownership of the systems and projects assigned and become proficient in the technical and functional aspects of these systems.
- Lead projects and provide technical support on. Successfully assist in tasks or projects as assigned. Provide leadership in working with technology vendors and implementation partners to implement technical solutions.
- Provide periodic reports to management.
- Develop and ensure updates to technical and/or user documentation. Train users on systems and processes. Lead in efforts to encourage system use and adoption with the business areas. Act as an advocate and advisor for the application of technology solutions to the agency.
- Provide leadership in proactively setting up and managing systems in excellent working condition through implementation and monitoring of alerts, regular maintenance activities, performance tuning, software updates and patches. Provide leadership in working with internal IT teams and technology vendors to ensure all systems are available and secure on a 24/7 basis.
- Lead system security efforts by ensuring compliance to security standards and policies, monitoring access privileges, conducting risk assessments, investigating suspicious activities, and remediation of identified security threats or risks.
- Document test cases and perform comprehensive testing during implementation and upgrades.
- Lead the planning and undertaking of periodic risk analysis of systems and mitigate risks wherever possible. Lead in the planning and testing of disaster recovery. Lead implementation, monitoring and verification of backups and issue resolution.
P&C November 2023
- Follow change management and change control processes to plan and deploy system changes. Perform change-impact analysis. Communicate changes to stakeholders and IT.
- Research, develop and implement IT standards and best practice policies or procedures.
- 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.
MINIMUM QUALIFICATIONS
Education and Experience
- 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.
- Five (5) years of experience in Information Technology or related field.
- Four (4) years progressively responsible experience implementing and supporting enterprise data warehouse, data integrations, extractions, queries, reports and dashboards using Microsoft Tools required.
- Strong Relational Database knowledge
- Hands-on experience using ETL(Extract- Transform-Load) tools.
- Experience in SQL programming
- Experience in Phyton and/or Java script Programming
- Experience in Power BI and Tableau is preferred.
- Experience in troubleshooting technical problems.
- Experience with direct end user support in a customer service role.
Knowledge, Skills, and Abilities
- Strong data analytical and data troubleshooting skills.
- Excellent organization abilities, analytical skills and communication skills including the ability to effectively communicate technical information to a non-technical audience.
- Be self-motivated and seek opportunities for continuous improvement of IT skills and processes. Be a catalyst and a willing participant of organizational changes.
- Ability to work in a team environment in a matrix organization, partnering well with employees, management, users, business areas, vendors, contractors and undertake duties and tasks as assigned without close supervision.
- Ability to be a positive and constructive contributor in a team-based environment.
- Knowledge of Information System Implementation Lifecycle desired.
- Ability to effectively manage multiple priorities and diverse groups of people and activities simultaneously.
- Intermediate proficiency using Microsoft Office Suite.
- Demonstrated leadership ability.
- Demonstrated dedication to customer service.
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.
- Reasonable accommodation may be made to enable individuals with disability to perform the essential functions as previously described.
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.
