Cloud Data Engineer

About Us:

We are a leading global asset management firm with over 3,000 employees across 20 offices in 15 countries; we help millions of investors around the world pursue their financial goals.

We hire critical thinkers. People who thrive in a collaborative culture like ours where we solve real problems while building the future of finance.

You

• Are excited to be part of a vibrant engineering community that values diversity, hard work, and continuous learning.
• Love solving complex real-world business problems.
• Recognize that cross-functional collaboration is a core component of success for the team.
• Believe there are multiple ways to solve most technical problems and are willing to debate the trade-offs.
• Have become a stronger engineer by making mistakes and learning from them.
• Are a doer, someone who wants to grow their career and gain experience across technologies and business functions.

We

• Continuously invest in a high-performance and inclusive culture, in which a diversity of backgrounds, experiences and viewpoints are celebrated and valued.
• Encourage career mobility, so you can benefit from learning different functions and technologies, and we gain the benefits of your experience across teams.
• Run technology pro bono programs that help the non-profit community and give our engineering community opportunities to volunteer and participate.
• Offer education reimbursements and ongoing training in technology, communication, and diversity & inclusion.
• Embrace knowledge sharing through lunch-and-learns, demos, and technical forums.
• Consider our people to be our greatest asset-we will help you learn what PIMCO Technology has to offer so you can participate in activities that benefit your career while delivering impactful technology solutions.

Position Description:

As a Cloud Data Engineer on the Client Data team, you will help shape PIMCO's data architecture

Summary:

• Build data pipelines and data models to support Analytics, Business Intelligence and Data Science use-cases
• Build revers ETL pipelines to make data warehouse data available in operational systems
• Design, develop and maintain the warehouse, automate manual processes, optimize data delivery for reporting and re-design infrastructure for greater scalability
• Collaborate with other technology teams to source data from a wide variety of data sources using SQL, Airflow, DBT, Fivetran and Python
• Research data questions, identify root causes and interact closely with analysts and other engineers
• Define and build metadata and data quality rules associated with data pipelines
• Integrate solution with data governance tools
• Contribute to advancing the team's design methodology and engineering best practices.
• Collaborate with BI engineers, data engineers, product managers and data analysts to assist with data-related technical issues, migrations, upgrades and infrastructure needs.

Position Requirements:

• Strong knowledge of the Snowflake ecosystem
• 3+ year experience designing highly scalable ELT/reverse ETL processes with complex data transformations, data formats including error handling and monitoring.
• Bachelor's degree in Engineering, Information Technology, Computer Science or a related field from an accredited college/university
• Experience with projects relating to cloud modernization, data migration, data warehousing in enterprise space
• Cloud Certification (AWS) would be advantageous
• Strong programming skills using Python, SQL
• Source control tools such as Git
• Solid understanding of database design, architectural principles and methodologies
• Ability to work independently, with attention to detail.
• Strong decision-making skills, problem resolution, negotiation, and decision-making skills
• Effectively communicates technical actions and expectations to the appropriate partners

Benefits:

PIMCO is committed to offering a comprehensive portfolio of employee benefits designed to support the health and well-being of you and your family. Benefits vary by location but may include:

• Medical, dental, and vision coverage
• Life insurance and travel coverage
• 401(k) (defined contribution) retirement savings, retirement plan, pension contribution from your first day of employment
• Work/life programs such as flexible work arrangements, parental leave and support, employee assistance plan, commuter benefits, health club discounts, and educational/CFA certification reimbursement programs
• Community involvement opportunities with The PIMCO Foundation in each PIMCO office