Career Opportunity

Analytics/Business Intelligence Engineer - Finance and Information Technology - SF Municipal Transportation Agency (9976)

Recruitment: RTF0135754-01152794

Published: July 14, 2023

Apply using SmartRecruiters, the City and County of San Francisco's application portal.

About:

In addition to submitting your application, you MUST submit the supplemental questionnaire.

Applicants must complete the supplemental questionnaire prior to starting the online application process. Your application will not be reviewed without the completion of the supplemental questionnaire.

Role description

APPOINTMENT TYPE: Permanent Exempt - This position is excluded by the Charter from the competitive Civil Service examination process and shall serve at the discretion of the Appointing Officer.

Application Opening: July 14, 2023

Deadline to Apply: August 4, 2023

Recruitment ID: 135755

Salary: $143,026 to $179,946 annually

Please Note: A resume must be attached to the online application.

Division: Finance and Technology

Section/Unit: Technology

Work Location: 1 South Van Ness Avenue, 3rd Floor, San Francisco, CA

Work Schedule: Monday – Friday, 8:00 am – 5:00 pm

The San Francisco Municipal Transportation Agency (SFMTA) Technology section strives to be a premier provider of technical services enabling the SFMTA to be the premier transportation agency in the country. The Data Services team is responsible for processing and structuring data for analytics and reporting as well as maintaining cloud-based and on-premise data infrastructure.

Position Description:

This is the perfect opportunity for a data professional with deep skills in Business Intelligence plus experience and interest in traditional data engineering.

As the Analytics/BI Engineer, you will implement and manage a semantic layer atop our Synapse/Azure Data Lake warehouse in the form of Power BI datasets. You will play a key role in multifaceted teams consisting of data engineers, transportation planners, financial analysts, project managers and others. Your 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. 

You will help ensure data in our lake and Synapse pools are properly structured, optimized, and secured to support analytics in our Power BI environment. Additionally, you will build out, manage, and maintain our semantic layer (i.e., Power BI workspaces and datasets/models).

Examples of 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.
• Assist with building data pipelines.
• Assist with migration of legacy datasets/models to our lakehouse.
• Other duties and responsibilities as assigned.

How to qualify

Minimum Qualifications:

1. An associate degree in computer science or a closely related field from an accredited college or university OR its equivalent in terms of total course credits/units [i.e., at least sixty (60) semester or ninety (90) quarter credits/units with a minimum of twenty (20) semester or thirty (30) quarter credits/units in computer science or a closely-related field]; AND

2. Three (3) years of experience analyzing, installing, configuring, enhancing, and/or maintaining the components of an enterprise network.

Substitution:

Additional experience as described above may be substituted for the required degree on a year-for-year basis (up to a maximum of two (2) years). One (1) year is equivalent to thirty (30) semester units/ forty-five (45) quarter units with a minimum of 10 semester / 15 quarter units in computer science or a closely related field.

Desirable Qualifications:  

• Experience working with Spatial data .
• Ability to create and manage data pipelines using at least one technology (e.g., Databricks, Airflow, Data Factory, Talend, etc.).
• Experience with Azure data related services including Synapse, Azure Data Lake, Data Explorer, Purview, and Cosmos.
• Familiarity with Transportation related data operations.
• Python, Julia, Java, or equivalent language.
• Strong SQL skills.
• Strong Power BI modeling skills.
• Ability to create complex measures and columns using both DAX and Power Query.
• Data warehouse related skills (e.g., understands star schemas, slowly changing dimensions, etc.).
• Comfortable working with relational database systems such as SQL Server, Oracle, or PostgreSQL databases or SQL Server.
• Familiarity with Azure or other cloud platforms (e.g., Amazon AWS, Google Cloud, etc.).

What else should I know?

Verification:

Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. More information can be found at: https://sfdhr.org/information-about-hiring-process#verification. Falsifying one’s education, training, or work experience or attempted deception on the application may result in disqualification for this and future job opportunities with the City and County of San Francisco.

Selection Process:

Applications will be screened for relevant qualifying experience.  Additional screening mechanisms may be used to determine candidates' qualifications.  Only those applicants who most closely meet the needs of the Agency will be invited to move forward in the selection process.

• Information About the Hiring Process
• Conviction History
• Employee Benefits Overview
• Equal Employment Opportunity
• Disaster Service Worker
• ADA Accommodation
• Right to Work
• Copies of Application Documents
• Diversity Statement

For questions or inquiries, please contact the analyst, Lisamarie Chavis at Lisamarie.Chavis@sfmta.com.

CONDITION OF EMPLOYMENT:  All City and County of San Francisco employees are required to be fully vaccinated against COVID-19 as a condition of employment. Someone is fully vaccinated when 14 days have passed since they received the final dose of a two-shot vaccine or a dose of a one-shot vaccine. Any new hire must present proof of full vaccination status to be appointed. Any new hire who will be routinely assigned or occasionally enter High-Risk Settings, must provide proof of having received a COVID-19 booster vaccine by March 1, 2022, or once eligible.

The City and County of San Francisco encourages women, minorities and persons with disabilities to apply. Applicants will be considered regardless of their sex, race, age, religion, color, national origin, ancestry, physical disability, mental disability, medical condition (associated with cancer, a history of cancer, or genetic characteristics), HIV/AIDS status, genetic information, marital status, sexual orientation, gender, gender identity, gender expression, military and veteran status, or other protected category under the law.