Job Description
This job was selected by the SpringCube team to help AI, Data and Cloud Engineers discover relevant San Francisco Bay Area employers. Sign up to view the full employer details and apply directly with the hiring company.
Company Overview
A public-sector organization responsible for maintaining financial integrity, transparency, accountability, and efficient government operations in a major San Francisco Bay Area city. Its technology and systems teams manage enterprise applications, business intelligence platforms, financial systems, and analytics solutions supporting thousands of employees, departments, retirees, and vendors.
Responsibilities
- Support a multi-year initiative to migrate an existing business intelligence and reporting environment to a unified Snowflake-based platform.
- Work with business intelligence, functional, technical, and other project teams to support the development and implementation of the new analytics platform.
- Perform both functional and technical analysis, including business process analysis, systems analysis, report development, query development, dashboard development, and data transformation.
- Design, build, and manage business intelligence solutions using Snowflake, dbt, SQL, and related technologies.
- Develop data extracts, loading and transformation processes, metadata models, and optimized reporting solutions.
- Analyze relationships between business processes, complex financial data, and enterprise systems to establish reporting requirements and data structures.
- Perform fit-gap analysis to evaluate reporting, analytics, and data requirements.
- Define and implement application configuration settings.
- Collaborate with project teams on transition plans for redesigned business processes.
- Analyze and test security roles, permissions, and access controls.
- Develop functional and technical specifications based on business and system requirements.
- Design and build technical solutions based on detailed specifications.
- Develop and execute system testing and user acceptance testing plans, and evaluate test results.
- Troubleshoot complex systems, data, reporting, and integration issues.
- Provide user support and training through individual sessions, phone support, and workshops.
- Create business process, system process, and technical documentation.
- Identify, manage, and escalate project issues and risks throughout the software development lifecycle.
Qualifications
- Associate degree in computer science, computer engineering, information systems, or a closely related field from an accredited college or university, or an equivalent number of qualifying college credits.
- At least 3 years of experience analyzing, installing, configuring, enhancing, and/or maintaining system or platform components.
- Experience with business intelligence, analytics, reporting, data transformation, or enterprise data platforms.
- Strong SQL skills and experience working with Snowflake or comparable data platforms.
- Hands-on experience with dbt and modern data transformation workflows.
- Experience developing reports, queries, dashboards, data extracts, and data transformation processes.
- Ability to analyze complex business processes and data to develop effective reporting requirements and data structures.
- Experience performing fit-gap analysis and translating business requirements into technical specifications.
- Experience designing, developing, testing, and troubleshooting enterprise technology solutions.
- Understanding of system security roles, permissions, and access controls.
- Experience developing system and user acceptance testing plans and evaluating test results.
- Strong documentation and communication skills, including the ability to explain technical concepts to business and non-technical stakeholders.
- Ability to collaborate with cross-functional teams during large-scale technology implementations and system transitions.
- Strong analytical, troubleshooting, planning, and problem-solving abilities.
- Ability to manage issues and risks throughout the software development lifecycle.
Education Substitution
- One year of additional qualifying experience may be substituted for the required degree.
- Completion of an applicable Information Systems Trainee Program may also satisfy the degree requirement.
- Qualifying full-time employment is calculated at 2,000 hours per year based on a 40-hour work week.
Disclaimer
SpringCube curates tech job listings from various company websites to support tech professionals globally.
- No Endorsement: SpringCube does not endorse or recommend any company or position listed.
- No Client Relationship: Listing a position does not mean SpringCube has a client, partnership, or employment relationship with the hiring company.
- To Apply: Use the Apply button to apply directly through the relevant hiring company’s application process.
- No Liability: SpringCube is not responsible for the hiring process, employment terms, recruitment decisions, or outcomes associated with any listed position.
