Senior Data Analytics Engineer (Snowflake/DBT)

Role Overview

The Senior Data Analytics Engineer will be part of the BI Platform Change project and work with members of the SF Reports & Analytics Team to design, build, and manage the new business intelligence platform using tools such as dbt, sql, and Snowflake database source and target.

What You Will Do

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.

Why It Might Be a Fit

The ideal candidate will have experience in designing, building, and managing complex systems, analyzing business processes, and developing reporting requirements and data structures.

Requirements

• Three (3) years of experience analyzing, installing, configuring, enhancing, and/or maintaining the components of a system or platform.
• Three (3) 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.
• Two (2) years of hands-on experience administering and developing on Snowflake managed cloud data platform and with Oracle databases
• Two (2) years of Demonstrated expertise in writing advanced, performant SQL, and using dbt for 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
• Hands on experience with Snowflake data warehouse functionality including Snowpipe, SnowSQL, Snowpark and Snowflake optimization configuration
• Strong skills in Python (with libraries like pandas, PySpark) for data processing and automation
• Experience in building and deploying data pipelines using orchestration tools
• Experience with CI/CD & DevOps a plus
• Experience in development of APIs to interface PeopleSoft data with other enterprise applications
• 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) or PeopleSoft Capital Human Resources (HCM) experience performing data analysis, design and testing.
• Understanding of OBIA 11g (with ODI 11g), including the following:
• Oracle ODI Load Plans from PeopleSoft 9.2 FSCM (GL, AP, AR, BI, Contracts, PO, Project Costing) and HCM (Human Resources, Position Management, Time and Labor, Payroll)
• Working with DBAs, BI Dev, 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.
• Desirable experience of building AI agents

Benefits

• Dental insurance
• Vision insurance
• Health insurance
• Retirement plan
• Paid time off
• Paid holidays
• Life insurance
• Disability insurance
• Flexible work arrangements
• Professional development opportunities
• Employee discounts
• Commuter benefits
• Wellness programs
• Employee recognition and reward programs

Tagged as: Data Analysis, Snowflake