Charles Schwab Lead Data Engineer in Lone Tree, Colorado


Lone Tree - CO, DENR3, 9800 Schwab Way, 80124

Charles Ott Jones


We believe that , when done right, investing liberates people to create their own destiny. We are driven by our purpose to champion every client’s goals with passion and integrity. We respect and appreciate the diversity of our employees, our clients, and the communities we serve. We challenge conventions strategically to create value for our clients, our firm and the world. We live and bring to life the concept of ‘own your tomorrow’ every day. We champion our employee strengths, guide their development, and invest in their long-term success. We hire optimistic, results-oriented, curious, innovative, and adaptable people with the desire to help our clients and one another succeed.

As a company, we were established by Chuck at over 40 years ago to champion Main Street over Wall Street, and to help Americans transform themselves from earners to owners. Through advocacy and innovation, we work to make investing more affordable, accessible and understandable for all. As we enter our fifth decade, we are looking for talented, innovative and driven people who believe they can help themselves, and our clients, create a better future.

Our Opportunity:

Do you want to be part of a Data Warehouse team managing over 150+ terabytes of data and building the next generation analytics platform for a leading financial firm with over $3.2 trillion in assets under management? At Schwab, the Global Data Technology (GDT) organization governs the strategy and implementation of the enterprise data warehouse and emerging data platforms. We help Marketing, Finance and executive leadership make fact-based decisions by integrating and analyzing data.

We are looking for a Lead Data Engineer who has passion for data and comes with data warehousing background. Someone who has experience in designing and coding batch as well as real time ETL(and ELT) and one who wants to be part of a team that is actively designing and implementing the Enterprise Data warehouse solution. Someone who wants to be challenged every day and has passion to keep up to date on new technologies in the Data Engineering space, set new standards and collaborate with the team members along the way.

What you’ll do:

  • You will be an ETL Lead working with a large team that includes onshore and offshore developers using best-in-class technologies including Teradata, Informatica and Hadoop.

  • You’ll have the opportunity to grow in responsibility, work on exciting and challenging projects, train on emerging technologies and work with other Development Leads to set the future of the Data Warehouse.

  • Your detailed duties would include:

  • Creating/updating ETL specifications and supporting documentation. Developing

  • ETL logic utilizing Informatica workflows, scripting and load utilities.

  • Performing testing tasks and code reviews.

  • Working with Business Systems Analysts, Data Modelers and DBAs to ensure a proper and efficient implementation of requirements.

  • Researching new tools and prototyping use cases on new technical platforms.

  • Suggesting modifications to the process and standards to gain more advantage from our toolsets.

  • Building deep understanding of the warehouse data and capabilities.

  • Participating in User communities (in and out of Schwab) to share and build knowledge.

  • You will responsible for mentoring and training junior Data Engineers in the team.

What you have:

  • Hands-on development experience in Informatica 9.x/10.x (minimum 6 years)

  • Hands-on development experience with Teradata database using BTEQ, TPT etc

  • Hands-on experience with Informatica push down optimization feature.

  • Hands-on experience with Linux and shell scripting.

  • Hands on experience with programming language Java/Python/Scala

  • Understanding of best practices for building and designing ETL code

  • Strong SQL experience with the ability to develop, tune and debug complex SQL applications is required

  • Familiarity with Hadoop framework is preferred

  • Expertise in schema design, developing data models and proven ability to work with complex data is required

  • Proven experience in working in large environments such as RDBMS, EDW, NoSQL, etc. is preferred

  • Knowledge of Big Data ETL such as Informatica BDM and/or Talend tools is preferred

What you’ll get:

  • Comprehensive Compensation and Benefits package

  • Financial Health: 401k Match, Employee Stock Purchase Plan, Employee Discounts, Personalized advice, Brokerage discounts

  • Work/Life Balance: Sabbatical, Paid Parental Leave, New Mothers returning to work Program, Tuition Reimbursement Programs, Time off to volunteer, Employee Matching Gifts Program

  • Everyday Wellness: Health and Lifestyle Wellness Rewards, Onsite Fitness Classes, Healthy Food Choices, Wellness Champions

  • Inclusion: Employee Resource Groups, Commitment to diversity, Strategic partnerships

  • Not just a job, but a career, with an opportunity to do the best work of your life

Learn more about Life@Schwab at" .

Charles Schwab & Co., Inc. is an equal opportunity and affirmative action employer committed to diversifying its workforce. It is Schwab's policy to provide equal employment opportunities to all employees and applicants without regard to race, color, religion, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), gender identity or expression, national origin, ancestry, age, disability, legally protected medical condition, genetic information, marital status, sexual orientation, protected veteran status, military status, citizenship status or any other status that is protected by law. Schwab also does not discriminate against applicants or employees because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. At Schwab, we believe that every employee, through their diverse abilities and experiences, can contribute to our growth, innovation and client loyalty. We embrace diversity and are committed to providing equal opportunity to all employees and applicants. If you have a disability, and require reasonable accommodations in the application process, call Human Resources at 800-725-3535. We will be happy to assist you. Schwab will only share your accommodation request with those individuals who have a specific need to know. The request for an accommodation will not affect Schwab's hiring decisions. All other submissions should be performed online.

Job Specifications

Relocation Offered?: No

Work Schedule: Days

Languages: English - spoken

Current Licenses / Certifications: None

Relevant Work Experience: IT-Other Specialty Engineering-6+ yrs

Position Located In: TX - Westlake

Education: BA/BS

Job Type: Full Time

Category:Information Technology

Activation Date: Monday, May 7, 2018

Expiration Date: Wednesday, August 1, 2018

Apply Here