Skip to content

Client Insights Data Engineer Associate

Posted: 05/15/2022

Our Firm

American Century Investments® is a leading global asset manager focused on delivering investment results and building long-term client relationships while supporting research that can improve human health and save lives. Founded in 1958, the firm’s 1,400 employees serve financial professionals, institutions, corporations and individual investors, offering a wide range of investment strategies across a variety of investment disciplines.

We are committed to providing institutional-quality, actively managed solutions with a performance-centered mindset. Our expertise spans global growth equity, global value equity, disciplined equity, multi-asset strategies, global fixed income, alternatives and ETFs.

Privately controlled and independent, we focus solely on investment management. This empowers us to align our decisions with client expectations and concentrate on their long-term money management needs.

Our culture of winning behaviors exemplifies our dedication to clients every single day. Delivering investment results enables us to distribute over 40% of our dividends—more than $1.8 billion — to the Stowers Institute for Medical Research, a 500-person, non-profit basic biomedical research organization with a controlling interest in American Century Investments. Our dividend payments provide ongoing financial support for the Institute’s work of uncovering the causes, treatments and prevention of life-threatening diseases, like cancer.

For more information, please visit americancentury.com.

We are looking for a Client Insights Data Engineer Associate to join our Client Insights and Analytics team. You will be American Century Investment’s Distribution data expert, ensuring our data’s availability and usability for our internal clients.

Responsibilities:

The Client Insights Data Engineer associate will work directly with our internal team members to:

  • Cleanse, combine, and prepare data that’s in our new AWS data lake for use in models, reports, and dashboards

  • Provide guidance and support as a data steward/custodian and/or assist others as required

  • Onboard new data sets into the data lake by crafting the data extractions, transformations and load (ETL) processes and designing Marketing and Distribution’s consumption layer

  • Partner with the IT Data & Analytics Team to ensure Distribution conforms to ACI’s IT policies and procedures

  • Maintain and assist IT in migrating existing legacy data warehouses (SAS, Oracle, Netezza, Microsoft SQL Server) over to AWS

You will translate functional and technical requirements into detailed architecture, design and extensible code. This includes providing technical and analytical guidance for enterprise architecture and implementing standard methodologies in application systems development and network security. This is a client-focused position, where the number one priority is always delivering value and excellent service to our team and the company.

Requirements

  • Solid grasp of Python (with an emphasis on Data Science desired)

  • Advanced SQL (Both SQL and PostgresSQL)

  • Working with a leading analytics or relational database system (Redshift experience highly desired)

  • Using change release processes and tools such as git

  • Experience with preparing/staging large data sets for analysis

  • Developing and implementing data transformation via ETL processes and data pipelines (familiarity with ETL tools such as Alteryx a plus)

  • Minimum of a Bachelor’s degree or Industry Certification in Computer Science, Information Systems, Mathematics or a related field

Other experience that is helpful, but not required:

  • Experience (academic or real-world) with the AWS Tech stack (Glue, Athena, Sagemaker, S3, Spark/Pyspark etc.) highly desired

  • Experience with fuzzy matching methodologies and/or MDM procedures highly desired

  • Knowledge of business intelligence methodologies and tools

  • Experience with predictive modeling and other data science applications

  • Experience with Agile methodology

Additional Requirements:

  • To ensure a safe and welcoming work environment for all employees, clients, and visitors, American Century Investments currently requires all U.S. based new hires to have submitted proof of having received the final dose of an approved COVID-19 vaccine prior to the position start date unless they have obtained a reasonable accommodation.

American Century Investments is committed to complying with the Americans with Disabilities Act and all other applicable Equal Employment Opportunity laws and regulations. As such, American Century strives to provide a reasonable accommodation to any qualified individual under the ADA to perform essential job functions.

American Century Investments believes all individuals are entitled to equal employment opportunity and advancement opportunities without regard to race, religious creed, color, sex, national origin, ancestry, physical disability, mental disability, medical condition, genetic information, marital status, gender, gender identity, gender expression, age for individuals forty years of age and older, military and veteran status, sexual orientation, and any other basis protected by applicable federal, state and local laws. ACI does not discriminate or adopt any policy that discriminates against an individual or any group of individuals on any of these bases.

©2019 American Century Proprietary Holdings, Inc. All rights reserved.

thank you to our sponsors:

Visionary Sponsor

Cornerstone Sponsors

Industry Partners

Scroll To Top