Data Engineer

Charles Schwab Corporation; Southlake (TX); On-site; USD 120,000 - 180,000; Full time

Benefits offered by this job

Bonus potential

Job summary

Charles Schwab Corporation seeks a senior data engineer to help build the next-gen data and analytics platform for Client Analytics. You will collaborate with data engineering and analytics teams to design, deploy data assets, and support data scientists, while mentoring junior engineers and upholding compliance and standards.

The role emphasizes real-time data pipelines, cloud technologies, and agile delivery, with on-site collaboration in Texas.

Qualifications

• 5+ years translating requirements into dimensional data models with Erwin.
• 5+ years of complex SQL and performance tuning.
• GCP expertise and data engineering fundamentals.
• 3+ years building near real-time data pipelines with cloud tech like BigQuery, Airflow.
• 3+ years on agile teams delivering data solutions.
• 1+ years working with omni-channel customer data and downstream partners.
• Strong communication and problem-solving in distributed systems.

Responsibilities

• Collaborate with business partners to define data requirements and design dimensional models.
• Capture, model, and document enterprise data views at multiple abstraction levels.
• Design and maintain data services and real-time pipelines using current tech.
• Partner with platform architects to meet published principles and standards.
• Mentor team members and promote agile practices to improve delivery.

Skills

Erwin data modeling

SQL performance tuning

GCP

BigQuery

Airflow

Java

Python

.Net

Data governance

Data quality

Education

Bachelor’s degree in Computer Science or Data Engineering or Analytics

Tools

Informatica IDMC

Job description

Your Opportunity

At Schwab, you’re empowered to make an impact on your career. Here, innovative thought meets creative problem solving, helping us “challenge the status quo” and transform the finance industry together.

We believe in the importance of in-office collaboration and fully intend for the selected candidate for this role to work on site in the specified location.

Schwab Technology Services enables the future of how clients manage their money by providing innovative and reliable technology products and services as part of our ongoing commitment to democratize access to investing and financial planning.

Would you like to be part of a new team chartered to build the next generation data & analytics platform supporting Customer Analytics? As part of Schwab's Client Analytics Technology team, you will contribute to the development and deployment of data assets instrumental in capturing our clients' activity, which is used to inform critical business decisions and elevating our clients' experiences. You’ll collaborate with data engineering & analytics teams to design and deliver new data pipelines, support data analysts and data scientists, maintain documentation and ensure compliance with published policies and standards, while mentoring junior team members and supporting their technical and professional growth.

• Collaborating with business partners to understand data requirements and use cases for a portfolio of applications, provide prescriptive design guidance on the best fit schema design, data movement, processing, and analytical patterns for dimensional data
• Capturing, modeling, and documenting views of enterprise data at contextual, conceptual, and logical levels of abstraction using Erwin
• Designing, implementing, and maintaining data services, interfaces, and real-time data pipelines via the practical application of existing, new, and emerging technologies and data engineering techniques
• Partnering with platform architects to ensure implementations meet published platform principles, guidelines, and standards
• Mentoring, motivating, and supporting the team to achieve objectives and goals
• Advocating for agile practices to increase delivery throughput
• Designing and maintaining solutions consistent with published standards

What you have

To ensure that we have fulfilled our promise of "challenging the status quo," this role has specific qualifications that successful candidates should have.

Required Qualifications

• 5+ years of experience working with partners documenting business requirements and translating those requirements into dimensional data models using Erwin
• 5+ years of experience writing complex SQL and advanced performance tuning
• Current Expertise with GcP

• 3+ years of experience designing, building, testing, and supporting near real-time data pipelines and analytical solutions using modern cloud technologies such as BigQuery, Airflow, Informatica IDMC, etc.
• 3+ years of experience working on agile teams delivering data solutions
• 1+ years of experience working with omni channel customer interaction data, translating requirements into data models, pipelines, coordinating with downstream partners and assisting them with any of their consumption requirements
• Strong written and verbal communication skills, ability to clearly convey complex ideas, deliver feedback, and influence teams across organizational boundaries
• Ability to define and solve complex problems with ambiguous or incomplete data in distributed systems
• Demonstrated ability to lead medium/large projects, coordinating activities of other personnel and delegating work appropriately to ensure delivery on-time, as promised
• Commitment to quality—driving high standards including writing and executing tests at all levels
• Demonstrated mindset of continuous improvement and learning

Preferred Qualifications

• Experience using object-oriented languages (.Net, Java, Python) to deliver data for near real-time, streaming analytics
• Experience with data quality and data governance frameworks
• Experience writing automated unit, integration, and acceptance tests for data interfaces & data pipelines
• Ability to quickly comprehend the functions and capabilities of new technologies, and identify the most appropriate use for them
• Bachelor’s degree in computer science, Data Engineering, Mathematics, Analytics, or related field

In addition to the salary range, this role is also eligible for bonus or incentive opportunities