Senior Data Engineer

company banner
Charles Schwab & Co., Inc.
Data Warehouse, Sales, Teradata, Informatica, Project, Management, QA, SQL, UNIX, Java, Python
Full Time

Job Description

Your Opportunity

As a company, we were established by Chuck 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 hardworking, innovative and driven people who believe they can help themselves, and our clients, create a better future.

Would you like to join a Data Warehouse team handling over 120 terabytes of data and building the next generation analytics platform for a leading financial firm? At Schwab, the Global Data Technology (GDT) organization governs the strategy and implementation of the enterprise data warehouse and emerging data platforms. We help Sales, Marketing, Finance and executive leadership make fact-based decisions by integrating and analyzing data.

We're in search of a lead data engineer who has passion for data integration technologies and comes with data warehousing background. Someone who has experience in designing and coding ETL and one who wants to be part of a team that is actively delivering projects in Teradata, Big Data and working towards migrating to cloud technology.

What you are good at

  • Creating/updating ETL specifications and supporting documentation
  • Developing ETL utilizing tools such as Informatica workflows, scripting and load utilities, Talend, etc.
  • Knowledge of big data ingestion using Talend, Scoop, Hive etc
  • Implementing data flow scripts using technologies such as Unix /Sqoop / Hive QL / Pig scripting
  • Designing schemas, data models and data architecture
  • Designing, building and support data processing pipelines to transform data in Big Data or Teradata platforms
  • Work with business analysts to understand business requirements and use cases
  • Problem solving and fixing technical issues
  • Lead day-to-day activities and influence team members to use, follow and support Agile software development practices
  • Collaborate with product owner and key partners in Project Management, Business, QA and Technology Operations to ensure high quality delivery of software projects on time and budget


What you have

  • 6+ years of experience in understanding of standard methodologies for building and designing ETL code
  • Strong SQL experience with the ability to develop, tune and debug complex SQL applications is required
  • Knowledge in schema design, developing data models and demonstrable ability to work with complex data is required
  • Experience in ETL tools such as Informatica, Talend or any other tools is required
  • Strong Teradata coding and utilities experience is a plus
  • Experience in working in large environments such as RDBMS, EDW, NoSQL, etc. is a plus
  • Hands-on experience with Hadoop, MapReduce, Hive, SPARK, Kafka and HBASE is a strong plus
  • Understanding of Hadoop file format and compressions
  • Experience with scheduling tools (eg. Control M, ESP)
  • Understanding of standard methodologies for building Data Lake and analytical architecture on Hadoop is preferred
  • Scripting / programming with UNIX, Java, Python, Scala etc. is preferred
  • Exposure to cloud data platforms such as Google Cloud Platform/Big Query would be a plus
  • Knowledge in real time data ingestion is helpful
  • Experience collaborating with business and technology partners and offshore development teams
  • Good interpersonal, analytical, problem-solving and organizational skills
  • Excellent written/verbal communication skills


Why work for us?

Own Your Tomorrow embodies everything we do! We are committed to helping our employees ignite their potential and achieve their dreams. Our employees get to play a central role in reinventing a multi-trillion-dollar industry, creating a better, more modern way to build and manage wealth.

Benefits: A competitive and flexible package designed to empower you for today and tomorrow. We offer a competitive and flexible package designed to help you make the most of your life at work and at home-today and in the future. Explore further .

Schwab is committed to building a diverse and inclusive workplace where everyone feels valued. As an Equal Opportunity Employer, our policy is to provide equal employment opportunities to all employees and applicants without regard to any status that is protected by law. Please click here to see the policy.

Schwab is an affirmative action employer, focused on advancing women, racial and ethnic minorities, veterans, and individuals with disabilities in the workplace. If you have a disability and require reasonable accommodations in the application process, contact Human Resources at or call .

TD Ameritrade, a subsidiary of Charles Schwab, is an Equal Opportunity Employer. At TD Ameritrade we believe People Matter. We value diversity and believe that it goes beyond all protected classes, thoughts, ideas, and perspectives.


Company Information

At Schwab, we inspire the driven; individuals who want to take ownership of their career and their future. You are appreciated for your work, respected for your unique strengths and rewarded for the possibilities you create for our clients. Working in Schwab Technology is not just a job; it's an opportunity to do the best work of your life. This team drives Schwab's mission to harness the power of data to deliver the next gen client experience. They relentlessly pursue simplification and modernization, laying the foundation for the digital enterprise. They act boldly together to provide security for our clients and enterprise, safeguarding client trust all while delivering on their core commitments to availability, capacity and project execution with excellence and efficiency. If you are looking to be challenged with projects that stretch and grow your abilities, and push you towards further developing your expertise, apply to one of our openings today.
Dice Id : 10228622
Position Id : 2021-72701
Originally Posted : 4 months ago

Similar Positions at Charles Schwab & Co., Inc.

ETL Tech Lead - Informatica
  • Lone Tree, CO
  • 2 days ago
Senior Data Engineer
  • Phoenix, AZ
  • 2 days ago
Data Engineer
  • Westlake, TX
  • 2 days ago
Senior Manager, Data Engineering
  • Westlake, TX
  • 2 days ago
Big Data / ETL Engineer, Senior
  • Westlake, TX
  • 2 days ago
Data Warehouse/ETL Support Engineer
  • Westlake, TX
  • 2 days ago
Data Warehouse/ETL Support Engineer
  • Westlake, TX
  • 2 days ago