Job Description
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 contribute by seeing the world “Through Clients' Eyes”. ETL Developers work with large teams, including onshore and offshore developers, using best-in-class technologies including BigQuery, Teradata, Informatica, and Hadoop. You will design, development and implement enterprise data integration solutions with opportunities to grow in responsibility, work on exciting and meaningful projects, train on new technologies and lead other Developers to set the future of the Data Warehouse.
Designing, Developing and implementing new data ingestion workflows by practical application of existing and new data engineering techniques- Leading large complex projects for successful delivery
- Developing data ingestion workflows across wide variety of data sources and data ingestion patterns such as batch, near real-time and real time
- Working with business analysts to understand business/new data requirements and use cases
- Crafting and updating ETL specifications and supporting documentation
- Developing solution design by 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
- Applying data integration best practices for data quality and automation
- Working with product vendors to identify and manage open product issues.
Demonstrated ability as an ETL lead with a track record of delivering projects with minimal defects- 7+ years of hands-on experience with data integration tools such as Informatica Power Center and Talend
- 7+ years in Data Warehouse platforms such as Teradata and BigData/Hadoop
- At least 5 years of experience in data modeling (logical and/or physical)
- At least 5 years of hands-on experience working with near realtime and/or real-time data ingestion techniques
- Expertise in schema design and demonstrable 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) helpful. Experience with scheduling tools (eg. Control M, ESP)
- Demonstrable experience in working in large environments such as RDBMS, EDW, NoSQL, BigData etc. is preferred
- Prior experience collaborating 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
- Outstanding interpersonal skills, including collaboration, communication, and negotiation
- Ability to help drive processes, run projects and solve highly complex problems using innovative solutions
- Ability to work independently with little instruction on day-to-day work and lead multiple projects requiring cross-team and external collaboration
- Ability to coach and mentor individuals on technical matters by sharing knowledge Ability to train and handle delivery with a team of developers.