Data Analytics Engineer (SnowflakeDBT) (1042) Controller's Office (168329)

Business Intelligence Platform Change Project

The Controllers Office is working in a multi-year project to migrate the Reports and Analytics solution into a unified Snowflake-based platform. The BI Platform Change will provide departments with secure streamlined access to PeopleSoft data improving efficiency governance and standardizing data sharing citywide. By replacing outdated processes this modern framework supports transparency accountability collaboration better service delivery strategic growth and public trust.

Job Description:

This IS Engineer position will be part of the BI Platform Change project and will work with members of the SF Reports & Analytics Team Functional Teams and other City and County staff to support the project. The analyst will perform both functional (business process and systems analysis) and technical (report query and dashboard development data extract load and transformation metadata modeling tuning and troubleshooting) tasks.

This position will be supporting the current Oracle BI platform but it will also collaborate in the building of the new business intelligence platform using tools such as dbt SQL and other tools with a Snowflake data warehouse source and target.

Essential duties include but are not limited to: 

• Analyze the interrelationships of business processes complex financial data human resources data and systems to develop reporting requirements and data structures.
• Perform fit/gap analysis to evaluate reporting and data needs.
• Develop and maintain OBIEE/OAS dashboards analyses and BI Publisher reports.
• Design and enhance RPDs (Physical BMM & Presentation Layers).
• Support Subject Areas Logical Table Sources (LTS) and metadata models.
• Develop ETL solutions using ODI perform query optimization cache management and performance tuning support production issues enhancements and troubleshooting activities
• Write business and system process and technical documentation.
• Identify manage and escalate issues and risks throughout software development life cycle.
• Performing other duties as assigned.

Qualifications :

Education: An associate degree in computer science computer engineering information systems 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 one of the fields above or a closely-related field.

Experience: One (1) year of experience analyzing installing configuring enhancing and/or maintaining the components of a system or platform.

Substitution: One year of additional experience as described above may be substituted for the required degree; or Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree.

• One-year full-time employment is considered equivalent to 2000 hours (2000 hours of qualifying work experience is based on a 40-hour work week). Any overtime hours that you work above forty (40) hours per week are not included in the calculation to determine full-time employment.
• Applicants must meet minimum qualification requirements by the final filing date unless otherwise noted. 
• Every application is reviewed to ensure that you meet the minimum qualifications as listed in the job ad. Please review our articles on Employment Application and Minimum Qualifications and Verification of Experience and/or Education for considerations taken when reviewing applications. 

DESIRABLE QUALIFICATIONS:

Technical Knowledge

• Working expertise in OBIEE OAS ODI BI Publisher SQL and Data Warehousing.
• Hands-on experience in RPD development dashboard creation performance tuning security implementation
• One (1) years of experience in the information systems field including system analysis business process design development and implementation of business application solutions or IT project management.
• One (1) year of hands-on experience administering and developing on Oracle databases and experience with Snowflake managed cloud data platform
• One (1) years of Demonstrated expertise in writing advanced performant SQL using SQL-based data transformation and modeling
• Experience with layered data architecture (staging intermediate marts) using dbt best practices to support analytics and reporting use cases including parameterized and dynamic dbt models using Jinja templating to support reusable transformations across multiple datasets and environments
• Hands-on experience in GitHub for code change management and collaboration with other team members
• Experience in building and deploying data pipelines using orchestration tools
• Understanding the process to build and deploy data pipelines using orchestration tools
• Deep understanding of data warehouse concepts data modeling and modern ETL principles
• Understanding of data governance data security and data privacy principles
• Understanding of PeopleSoft applications such as PeopleSoft Financials and Supply Chain Management (FSCM) PeopleSoft Capital Human Resources (HCM) experience performing data analysis design and testing.
• Working with DBAs BI Development team PeopleSoft and Security teams to improve performance and data quality using Agile sessions
• Working knowledge of business process flows used to support a complex accounting system and experience in developing and executing application test plans.

Collaboration and Communication Skills

• Strong problem-solving skills with ability to design practical and effective data solutions
• Excellent verbal and written communication skills including the ability to explain technical concepts to non-technical stakeholders
• A collaborative mindset with enthusiasm to work across diverse cross-functional teams

Mission alignment

• Commitment to equity transparency and ethical data use
• Passion for public service using data to improve government services

Additional Information :

Selection Procedures 

The selection process will include evaluation of applications in relation to minimum requirements. Candidates whose qualifications most closely meet the needs of the Department will move forward in the recruitment process.

Additional Information Regarding Employment with the City and County of San Francisco:

• 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

Where to Apply

All job applications for the City and County of San Francisco must be submitted through our online portal. Please visit to begin your application process.

Computers are available for the public (9:00 a.m. to 4:00 p.m. Monday through Friday) to file online applications in the lobby of the Dept. of Human Resources at 1 South Van Ness Avenue 4th Floor and at the City Career Center at City Hall 1 Dr. Carlton B. Goodlett Place Room 110.

Ensure your application information is accurate as changes may not be possible after submission. Your first and last name must match your legal ID for verification and preferred names can be included in parentheses. Use your personal email address not a shared or work email to avoid unfixable issues.

Applicants will receive a confirmation email from that their online application has been received in response to every announcement for which they file. Applicants should retain this confirmation email for their records. Failure to receive this email means that the online application was not submitted or received.

If you have any questions regarding this recruitment or application process please contact the Nancy Giang at Recruitment ID: RTF09490

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.

Remote Work :

No

Employment Type :

Full-time