EMPLOYMENT OPPORTUNITY Valley Metro RPTA Business Intelligence Engineer Valley Metro is an Equal Employment Opportunity Employer
SALARY: $73,827.00 - $110,740.00 Annually FLSA: Exempt position, not eligible for overtime compensation. OPENING DATE: 06/22/18
The Business Intelligence Engineer is responsible for the full life cycle development, implementation, production support, and performance tuning of the Enterprise Data Warehouse, Data Mart, and Business Intelligence Reporting environments of Valley Metro. This individual will also be responsible for supporting the integration of those systems with other applications. The Business Intelligence Engineer will design and implement reporting and analytical solutions, including both the design of table structures and the processes used to populate those structures with data from internal and external sources. The data provided by the Business Intelligence Engineer will help Agency teams drive improvement in key operational metrics, ridership experience, and business results. This role will interact with various development teams, project managers, internal and external customers, senior management, and external vendors. The position operates under general supervision reporting to the Manager, Information Technology and serves as a lead to staff. The Business Intelligence Engineer is required to be on call 24/7/365.
MINIMUM QUALIFICATIONS & REQUIREMENTS:
Bachelor's Degree in Engineering, Information Systems, Computer Science or a closely related field and five (5) years' experience in Business Intelligence systems, large scale data analysis, and other advanced business reporting tools OR Equivalent combination of education and/or experience sufficient to successfully perform the essential duties.
Employment is contingent upon the results of a comprehensive background investigation including work experience verification, criminal background check, and a personal credit history review.
Licenses and Certifications:
Valid Arizona driver's license
EXAMPLES OF DUTIES / KNOWLEDGE & SKILLS:
The statements listed below describe the general nature and level of work only. They are not an exhaustive list of all required responsibilities, duties, and skills. Other duties may be added, or this description amended at any time.
Evaluate and select database/data warehouse components, including hardware, relational database management systems, ETL software, metadata management tools, and database design solutions.
Conduct research and make recommendations on business intelligence products, services, and standards in support of procurement and development efforts.
Assess and cultivate long-term strategic goals for business intelligence development in conjunction with end users, managers, clients, and other stakeholders.
Serves as a lead and mentor to staff to include assigning and monitoring work and providing direction.
Direct, organize, and lead projects in the implementation and use of new BI software tools and systems.
Lead the integration efforts for merging business intelligence platforms with enterprise systems and applications.
Design, code, test, and document all new or modified business intelligence systems, applications, and programs.
Assist in the design of databases and data warehouses to ensure interoperability with business intelligence solutions.
Analyze user requirements and, based on findings, design functional specifications for business intelligence front-end applications.
Produce ETL design guidelines to ensure a manageable ETL infrastructure for the business intelligence system.
Design and deliver end-user training and training materials; provide technical support as necessary.
Troubleshoot business intelligence tools, systems, and software; performance-tune these applications as necessary.
Act as liaison for business intelligence benefits across the organization; promote BI usage to relevant departments.
Establish and maintain relationships with vendors and third-party service providers, act as a liaison between such entities and other I.T. personnel to resolve issues.
Maintain professional and technical knowledge by attending educational workshops, reviewing professional publications, establishing personal networks, bench-marking state-of-the-art practices, and participating in professional societies.
Performs other duties of similar nature and level as assigned.
Knowledge and Skills
Data warehouse analysis and design, methodologies, and data modelling;
Analyzing user requirements and building front-end BI applications according to specifications;
Strong understanding of relational database structures, theories, principles, and practices;
Data privacy practices, laws, and security standards (e.g. PCI DSS, NIST SP 800-53, HIPAA);
Project management and development life cycles;
Industry trends involving business intelligence;
Supervising one or more direct reports;
Public Transit or Transportation industries.
Professional communication, both written and verbal, with internal and external clients;
Explaining complicated and technical information in simple, non-technical language;
Attention to detail, time management, and multi-tasking;
Active listening, teamwork, cooperation, and motivation;
Tier-one applications, databases and data warehouses (e.g. Oracle Database, Microsoft SQL Server, SQL Server Reporting Services, SQL Server Integration Services, Crystal Reports, Microsoft Power BI, Tableau, etc.);
Microsoft Windows and Linux operating systems;
Extract, Transform, and Load (ETL) tools;
Relevant scripting languages (e.g. T-SQL, Perl, Python);
Data processing flowcharting techniques;
Database design applications;
Developing custom analytical reports in one or more reporting platform (e.g. Crystal Reports, SSRS, PowerBI);
Microsoft Office software applications (e.g. Word, Excel, PowerPoint, Outlook, OneNote, and Visio);
Analyzing problems, identifying alternative solutions, projecting consequences of proposed actions, Recommending best options and implementing recommendations in support of goals;
Using initiative and independent judgment within established guidelines;
Analyzing and documenting business processes;
Researching, analyzing and evaluating new service delivery methods and techniques;
Exercising initiative and creativity in the improvement, development, and implementation of projects;
Communicating in writing and verbally in order to interact with co-workers, supervisor, and the general public at a level sufficient to exchange or convey information and to receive work direction.
PHYSICAL DEMANDS / WORK ENVIRONMENT:
Positions in this class typically require: climbing, balancing, stooping, kneeling, crouching, crawling, reaching, standing, walking, driving, lifting, fingering, grasping, feeling, talking, and hearing. Valley Metro complies with ADA/EEOC requirements with respect to reasonable accommodation for people with disabilities.
Ability to occasionally lift up to 50 pounds with the assistance of applicable equipment or other employees, and up 20 pounds of force frequently, and/or up to 10 pounds of force constantly to move objects.
Physical ability to perform office and related work, including operating computers and office equipment; stamina to sit for extended periods of time;
Incumbents may be subjected to moving mechanical parts and electrical currents;
Limited local travel will also be required to support customers in remote business units;
May respond to system emergencies and system failures on a 24/7 basis.
Valley Metro Regional Public Transportation Authority RPTA) provides both Bus and Light Rail transportation services for the Phoenix metropolitan area.
Highlights of Valley Metro services include:
*First ever light rail system in Phoenix, Arizona. Began service in 2008.
*Local, Express and RAPID commuter bus service
*Online carpool matching system
*Assistance to local businesses to help them meet the Maricopa County trip reduction goals through alternative modes of transportation (bus, carpool, vanpool, bike, telework, etc.)