Senior Data & AI Platform Engineer

Overview of the Role
The Senior Data & AI Platform Engineer will own the end-to-end data pipelines supporting the business, bringing client data, documents, call transcripts, and other information into a centralized PostgreSQL platform on GCP. The role also involves supporting Document AI and LLM solutions that process over 90,000 client files. This is a hands-on Data Engineering position focused on building, operating, troubleshooting, and improving reliable production pipelines rather than data warehousing, big data, or ML model development.

Key Responsibilities:

• Own end-to-end production data pipelines, from design and development through deployment, monitoring, troubleshooting, and ongoing maintenance.
• Build and maintain Python-based data ingestion pipelines that pull information from third-party APIs and other sources such as client data, documents, and call transcripts.
• Consolidate data into a centralized PostgreSQL environment, ensuring data is reliable and accessible to downstream business systems.
• Design, develop, and maintain cloud-based data solutions using GCP and/or AWS, with GCP technologies including: Cloud Run, Cloud Functions, Cloud SQL, Pub/Sub, BigQuery, Cloud Scheduler, and Document AI
• Take primary responsibility for investigating and resolving production pipeline failures, data issues, and integration problems.
• Develop and maintain advanced PostgreSQL solutions, including complex/large views, JSONB structures, migrations, roles, grants, and database-level access controls.
• Build and support document-processing and AI/LLM pipelines, including systems capable of processing large volumes of client documents.
• Implement production LLM features and establish methods for evaluating the quality and accuracy of AI-generated outputs where applicable.
• Build or maintain MCP servers/tools that enable AI applications to interact with business data and answer meaningful business questions.
• Design secure, scoped, fail-closed APIs for accessing sensitive financial information, including parameterized queries, server-side identity verification, SQL-enforced authorization, and versioned API contracts.
• Apply appropriate privacy, security, access controls, and auditability when handling sensitive Australian client financial data.
• Work directly with Pivot Wealth's Sydney-based stakeholders, advisers, brokers, and engineering team to understand business requirements and translate them into reliable technical solutions.
• Operate with a high degree of technical ownership and accountability, particularly in a small engineering environment.
• 5+ years of Python experience is preferred, but strong hands-on skills and relevant Data Engineering experience matter more than tenure. We’re looking for someone with a solid technical foundation and a strong willingness to learn.
• Strong professional experience in Data Engineering, particularly the development and ownership of production data pipelines.
• Experience developing data ingestion & integrations using third-party APIs, rather than relying primarily on low-code/no-code integration tools.
• Hands-on cloud experience with GCP and AWS.
• Strong experience with PostgreSQL, ideally including: JSONB, Complex or large views, Database migrations, Roles and grants, and SQL/database access controls.
• Demonstrated experience owning, troubleshooting, and resolving data pipeline issues in production.
• Experience building and maintaining complex end-to-end data pipelines, including API, document, or similar ingestion workflows.
• Strong understanding of data security, privacy, authentication, authorization, and access control, particularly when dealing with sensitive information.
• 500K per incident HMO coverage + Dental & Optical benefits
• 2-week paid Christmas vacation
• Electricity and Data subsidies
• 25K Educational Assistance
• Training and equipment will be provided
• Fixed Schedule of Mon-Fri from 7 AM to 4 PM