Technology Expert I (Analytics/Business Intelligence Engineer) - SF Municipal Transportation Agency - Finance and Information Technology Division (9976)
Number of Position(s): One (1)
Division: Finance & Information Technology
Section/Unit: Technology
Work Location: 1 South Van Ness, 3rd Floor, San Francisco, CA
Work Hours: Monday – Friday, 8:00AM-5:00PM
Please Note: A resume must be attached to the online application.
APPOINTMENT TYPE: Permanent Exempt, Full Time appointment – This position is excluded by the Charter from the competitive Civil Service examination process and shall serve at the discretion of the Appointing Officer.
Annual Salary: $146,250 - $184,002 (Effective 1/6/2024)
Application Opening: December 22, 2023
Application Filling Deadline: January 9, 2024
Recruitment ID: 142765
POSITION DESCRIPTION:
The Analytics/BI Engineer will implement and manage a semantic layer atop our Synapse/Azure Data Lake warehouse in the form of Power BI datasets. They will play a key role in multifaceted teams consisting of data engineers, transportation planners, financial analysts, project managers and others. The work will span a wide range of areas including location based tracking and spatial analytics, asset management, and our real-time customer information system which is used to guide passengers to their destinations via multiple modes of transportation. Over time, you will become a subject matter expert in multiple lines of business for the SFMTA.
The Analytics/BI Engineer will help ensure data in the lake and Synapse pools are properly structured, optimized, and secured to support analytics in our Power BI environment. Additionally, they will build out, manage, and maintain our semantic layer (i.e., Power BI workspaces and datasets/models).
EXAMPLES AND IMPORTANT AND ESSENTIAL DUTIES:
• Leads build-out of semantic layer.
• Works with business units to develop agency-wide best practices for modeling data.
• Ensures datasets are available and reports are performant.
• Supports general data management and governance efforts.
• Leads Power BI related knowledge share efforts via brown bags, presentations, and office-hour sessions.
• Collaborates with business units to define and refine KPIs, metrics, and measures.
• Other job duties and responsibilities as assigned.
