Revenue Data Engineer-CA

About this role

Clients engage RGP for expertise in delivering large and complex projects to strengthen their business. As Revenue Data Engineer, you will work on a diverse range of projects. Through relevant experience, you will have been exposed to multiple and ideally complex (global) projects and businesses and be able to adapt these to our clients' unique environment.

KEY DELIVERABLES

• Data Engineering & SQL Development
• Refactor and rebuild existing SQL scripts, tables, and workflows to improve performance, scalability, and maintainability.
• Design and develop new SQL-based data pipelines where needed, following data engineering best practices.
• Establish consistent coding standards, data modeling conventions, and architectural patterns across SQL artifacts.
• Ensure all development aligns with structured SDLC processes when modifying or replacing legacy assets.
• SDLC, Quality & Stability
• Implement and operate within structured development processes including:
• Requirements definition
• Design and development
• Testing and validation
• Controlled production deployments
• Improve reliability by introducing stronger testing frameworks and change management practices.
• Data Pipelines, Workflows & Dashboarding
• Build and maintain end-to-end data pipelines, including scripting, workflow orchestration, table creation, and downstream data consumption.
• Architecture & Best Practices
• Replace fragmented or speed-optimized legacy solutions with scalable, well-documented data architectures.
• Serve as a resource for SQL development and data engineering best practices within a finance-focused environment.

EXPERIENCE REQUIRED

• Expert-level SQL, with the ability to design complex queries and pipelines from scratch.
• Strong data engineering experience, comparable to a senior data engineer role.
• Hands-on experience working within the Google data and analytics ecosystem, including tools such as Big Query, PLX, Piper, or similar Google development environments.
• Ex...