Prudential’s purpose is to be partners for every life and protectors for every future. Our purpose encourages everything we do by creating a culture in which diversity is celebrated and inclusion assured, for our people, customers, and partners. We provide a platform for our people to do their best work and make an impact to the business, and we support our people’s career ambitions. We pledge to make Prudential a place where you can Connect, Grow, and Succeed.
PCALT is going through a digital transformation and the goal is to become a data-driven company that unified data platform project is on going to be ready in one year. the data engineer is required for the organization to provide a better quality of data platform service during the platform implementation and future maintenance.
About the Role:
Join our global insurance leader as an Analytical Engineer! We're looking for a data-savvy individual with strong engineering skills to bridge the gap between data and business insights. You'll be instrumental in transforming raw data into actionable knowledge, directly impacting business decisions, and driving value creation.
Job Responsibilities:
Applies data extraction, transformation and loading techniques in order to connect large data sets from a variety of sources
Creates data collection frameworks for structured and unstructured data
Develops and maintains infrastructure systems (e.g., data warehouses, data lakes) including data access APIs
Prepares and manipulates data using Hadoop or equivalent MapReduce platform
- Current Context:
- Conduct in-depth business analysis using data, identifying trends, patterns, and opportunities for improvement.
- Develop and maintain complex SQL queries and data transformations within BigQuery to extract and prepare data for analysis and optimized for analytical and AI/ML use cases.
- Build interactive dashboards and reports using data visualization tools (e.g., Power BI) to communicate insights effectively.
- Build data pipelines to support AI/ML model development, including basic model prototyping.
- Implement data quality checks and contribute to data lineage within our data governance framework.
- Collaborate with business stakeholders to understand their needs and translate them into data-driven solutions.
- Proactively identify and investigate data anomalies, ensuring data quality and accuracy.
- Develop and maintain data documentation and best practices for analytical work.
- Partner with cross-functional teams globally, communicating platform updates effectively.
Job Qualification:
- Technical Skills:
- Python: Python skills for data manipulation and scripting.
- SQL: Expert in SQL, with extensive experience in BigQuery for data analysis and transformation.
- Cloud Development: Hands-on experience with GCP and BigQuery.
- Data Visualization: Build data visualization dashboard.
- Non-Technical Skills & Mindset:
- Impact-Driven & Results Focused:
- Value-Oriented: Focused on delivering solutions that generate significant business value (millions USD impact).
- Impact Conscious: Prioritizes work with the greatest technical and business impact. A focus on enabling data consumption through API creation is a plus.
- Growth & Learning Mindset:
- Cross-Functional Learner: Eager to learn and understand cross-functional knowledge beyond core expertise.
- Technology Agnostic Learner: Willing to learn new technologies and adapt to evolving landscapes.
- Efficient Learner: Able to leverage AI tools to maximize productivity and accelerate learning.
- Best Practice Pragmatist: Loves to follow best practices but understands trade-offs and works around limitations when necessary. Demonstrated pro-activeness through contributions to open-source projects is highly valued.
- Collaborative & Global Communicator:
- Team Player: Collaborates effectively in global team environments. Adaptable and comfortable working within an Agile environment.
- Excellent Communicator (English & Chinese): Fluent in both English and Chinese (Mandarin) to effectively communicate with global teams and stakeholders.
- Financial industry & BA/PM experience is a plus
- Technical Concepts: We're looking for candidates with a strong grasp of:
- Fundamental computer science knowledge
- Root cause finding methodologies
- Systematic/architectural thinking
- Clean code/clean architecture principles and an aversion to over-design
- Tech Stacks:
- Compute & Hosting: GKE & GCE (RedHat), GCP Cloud Run & Cloud Functions
- Data Orchestration: GCP Cloud Composer (Airflow)
- Data Lakehouse: BigQuery
- Data Streaming: Kafka Ecosystem (Confluent Cloud, Debezium, Qlik)
- Monitoring & Observability: GCP Monitoring/Logging/Metrics, OpenTelemetry
- CI/CD: GitHub Actions, Jenkins
- Infrastructure as Code: Terraform
- Security: VPC SC & Policy Tags, Customer-Managed Encryption Keys (CMEK), Vault
- Containers: Docker, Kubernetes
- Data Governance: Informatica
- Data Visualization: Power BI
What You Can Expect:
- Global Impact: Work in a cross-country, multi-lingual environment, collaborating with teams across the globe.
- Massive Scale: Contribute to solutions that impact a large volume of customers.
- Strategic Focus: Be at the forefront of a company that strategically focuses on AI and data to drive significant value and impact.
- Cross-Functional Collaboration: Work closely with first-line business users, gaining direct insights into their needs and shaping technology solutions that address real-world challenges.
- Meaningful Technology: Make technology truly impactful, driving innovation and solving critical business problems.
- Role Briefly: Data Pipeline Development, Business Analysis, Data Analysis, BigQuery Expert, SQL, Data Visualization, Value Delivery
- Expectations for Three Months: Become familiar with our existing technology stacks, not only within your specific role but across the broader data platform ecosystem.
- Expectations Within One Year: Become a trusted advisor to business stakeholders, providing data-driven insights and recommendations that drive significant business impact. Specific contributions can be discussed.
Prudential is an equal opportunity employer. We provide equality of opportunity of benefits for all who apply and who perform work for our organisation irrespective of sex, race, age, ethnic origin, educational, social and cultural background, marital status, pregnancy and maternity, religion or belief, disability or part-time / fixed-term work, or any other status protected by applicable law. We encourage the same standards from our recruitment and third-party suppliers taking into account the context of grade, job and location. We also allow for reasonable adjustments to support people with individual physical or mental health requirements.