Data Warehouse ETL Developer

company banner
Charles Schwab & Co., Inc.
Full Time

Job Description

Your Opportunity

At Schwab, the Data and Rep Technology (DaRT) organization governs the strategy and implementation of the enterprise data warehouse, Data Lake, and emerging data platforms. Our mission is to drive activation of data solutions, rep engagement technology (Sales, Marketing and Service) and client intelligence to achieve targeted business outcomes, address data risk and safeguard competitive edge. We help Marketing, Finance, Risk and executive leadership make fact-based decisions by integrating and analyzing data.

As part of the Business Data Delivery team, you will partner with our Business stakeholders and Data Engineering team to design and develop data solutions for data science, analytics and reporting. We are a team of passionate data engineers and SMEs who bring a lot of energy, focus and fresh ideas that support our mission to provide value by seeing the world "Through Clients' Eyes". ETL Developers work with large teams, including onshore and offshore developers, using best-in-class technologies including Teradata, Informatica, Hadoop and BigQuery. You will design, development and implement enterprise data integration solutions with opportunities to grow in responsibility, work on exciting and challenging projects, train on new technologies and work with other Developers to set the future of the Data Warehouse.

What you are good at

  • Designing, Developing and implementing new data ingestion workflows by practical application of existing and new data engineering techniques
  • Developing data ingestion workflows across wide variety of data sources and data ingestion patterns such as batch, near real-time and real time
  • Leading small projects for successful delivery
  • Working with business analysts to understand business/new data requirements and use cases
  • Crafting and updating ETL specifications and supporting documentation
  • Working with technical directors, Data Modelers and cross-functional teams to ensure an accurate and efficient implementation of requirements and following standards
  • Defining and executing quality assurance and test scripts
  • Guiding the ETL delivery team with technical expertise
  • Reviewing ETL delivery from 3rd party vendor teams
  • Advocating for agile practices to increase delivery efficiency
  • Ensuring consistency with published development, coding and testing standards

What you have

  • Demonstrated ability as an ETL Developer with a track record of delivering code with minimal defects
  • 3-5 years of hands-on experience with data integration tools such as Informatica Power Center and Talend
  • 3-5 years in Data Warehouse platforms such as Teradata and BigData/Hadoop
  • At least 2 years of experience in data modeling (logical and/or physical)
  • 3-5 years of hands-on experience working with near real-time and/or real-time data ingestion techniques
  • Expertise in schema design and proven ability to work with complex data is required
  • Strong SQL experience with the ability to develop, tune and debug complex SQL applications is required
  • Experience with Google Cloud Platform, BigQuery and Informatica Intelligent Cloud Services (IICS) highly desirable
  • Experience with scheduling tools (eg. Control M, ESP)
  • Proven experience in working in large environments such as RDBMS, EDW, NoSQL, BigData etc. is preferred
  • Prior experience interfacing with various partners, including vendors, offshore development teams and internal groups
  • Ability to quickly learn & become proficient with new technologies
  • Strong analytical, problem-solving, influencing, prioritization, decision-making and conflict resolution skills
  • Exceptional interpersonal skills, including teamwork, communication, and negotiation

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.

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 : 2022-85808
Originally Posted : 2 months ago

Similar Positions at Charles Schwab & Co., Inc.

Data Engineer
  • Westlake, TX
  • 1 day ago
Data Engineer
  • Westlake, TX
  • 1 day ago
Data Engineer Solutions Architect
  • Westlake, TX
  • 1 day ago
Senior Data Protection Risk Engineer
  • Westlake, TX
  • 1 day ago
Software Developer 3
  • Westlake, TX
  • 1 day ago
Data Engineer
  • Englewood, CO
  • 1 day ago
Specialist - Data Governance Developer
  • Lone Tree, CO
  • 1 day ago