Data Engineer II

Apply now »

Date: Jan 11, 2019

Location: Irvine, CA, US, 92618

Company: Capital Group

Req ID:  29066
Experience Level: Professional 
Other Location(s): N/A   

Come grow with us

At Capital Group, how we work is defined by shared values that include absolute integrity, respect and collaboration. But it’s more than that. It’s smart and highly driven people united in purpose to serve our investors and one another.

Bring your energy and unique perspective to Capital and you’ll have the opportunity to grow with us professionally, personally, and financially. You’ll be part of a team that genuinely cares about helping you succeed. You’ll work alongside talented colleagues, many of whom build long careers while progressing through multiple roles, establishing lifelong friendships and making a difference in our communities. In return for your contributions, you’ll receive premier compensation and benefits, and a company-funded retirement plan that ranks among the most generous.

 

Capital group is continually evolving its reliance on data, insights and advanced analytics to drive business outcomes. Our Information Delivery team is an exciting and fast-growing team focused on delivering data and analytics solutions, while also advancing Machine Learning use cases to achieve business goals. Our solutions range from traditional data warehouse and business intelligence solutions, to solving big data problems and deploying data science models.  
 
As a Data Engineer in the Information Delivery Group, you’ll be responsible for all aspects of the delivery of data and analytics solutions by consolidating, storing, and retrieving structured and non-structured data from multiple applications and sources.   You will partner with the business to achieve business priorities and provide leadership through innovation, critical thinking, collaboration and proactive risk management.  
 
Responsibilities: 
  • Consults with business users to gather requirements through understanding of business users’ data/analytics needs and challenges  
  • Demonstrates an understanding of the business area and supported datasets across different source systems and how they relate to each other
  • In collaboration with more senior associates, leads different parts of data solution delivery along with internal technology, vendor and business partners. 
  • Performs the analysis and design of features across multiple layers of the data platform, according to data platform and machine learning environment standards.
  • Is a hands on independent contributor to all aspects of development across multiple layers of the data platform, including DevOps tooling and cloud infrastructure
  • Executes quality assurance activities for the assigned area; performs testing of both functional and non-functional aspects, leveraging automation and a test-early and often approach
  • Participates in research with business, technology, and/or vendor partners to identify options, analyze pros and cons, and assists in making recommendations to business and IT stakeholders.
  • Works with more senior associates to identify new data-related technologies that could drive positive change, and suggests appropriate areas of future enhancement.
  • Serves as a project analyst for projects by establishing scope, estimates and work break down activities on projects.
  • Proactively identifies and communicates issues, risks, progress to business and IT stakeholders, providing options and next steps. 
  • Troubleshoots and supports the entire product, across all layers of the data platform.
Qualifications: 
  • Minimum of 2-4 years delivering data solutions, including data warehousing, reporting and analytics. 
  • Data analysis, data modelling, Business Intelligence/Reporting and visualization skills (e.g. Tableau, SQL Server Reporting Services)
  • Understanding of traditional RDBMS’ and some understanding of large scale compute  and storage platforms like MPP Databases (e.g. Azure SQL Data Warehouse, Teradata, Redshift), Hadoop, and Spark
  • Knowledge of ETL and ELT technologies and implementation experience with SQL tools, Informatica, Alteryx, and some R/Python
  • Solid technical knowledge of performance tuning and query optimization across large data sets, and exposure to bottlenecks at the storage, network or compute layers
  • Solid leadership, interpersonal, and problem solving skills with the ability to continually learn new concepts and technologies and effectively apply them
  • Experience with Microsoft MPP database and Azure analytic platform services is desirable

 

Company Overview:
Founded in 1931, Capital Group is one of the world’s largest and most trusted investment management companies and home to the American Funds. We manage more than US$1.7 trillion in assets, and our 7,500 associates make our clients their first priority every day. When we do our job right, millions of investors around the world fulfill their dreams and financial goals, from home ownership and higher education, to a comfortable retirement. Our long-term investment results and outstanding service set us apart from our competitors, while our workplace sets us apart from other employers. 
 
We are an equal opportunity employer, which means we comply with all federal, state and local laws that prohibit discrimination when making all decisions about employment. As equal opportunity employers, our policies prohibit unlawful discrimination on the basis of race, religion, color, national origin, ancestry, sex (including gender and gender identity), pregnancy, childbirth and related medical conditions, age, physical or mental disability, medical condition, genetic information, marital status, sexual orientation, citizenship status, AIDS/HIV status, political activities or affiliations, military or veteran status, status as a victim of domestic violence, assault or stalking or any other characteristic protected by federal, state or local law. 


Nearest Major Market: Irvine California
Nearest Secondary Market: Los Angeles

Job Segment: Database, Business Intelligence, Data Warehouse, SQL, Technology, Research