IT Data Specialist - Data Architect/Modeller
Company Overview About TD Bank, America's Most Convenient Bank®
TD Bank, America's Most Convenient Bank, is one of the 10 largest banks in the U.S., providing more than 8 million customers with a full range of retail, small business and commercial banking products and services at approximately 1,300 convenient locations throughout the Northeast, Mid-Atlantic, Metro D.C., the Carolinas and Florida. In addition, TD Bank and its subsidiaries offer customized private banking and wealth management services through TD Wealth®, and vehicle financing and dealer commercial services through TD Auto Finance. TD Bank is headquartered in Cherry Hill, N.J. To learn more, visit www.tdbank.com. Find TD Bank on Facebook at www.facebook.com/TDBank and on Twitter at www.twitter.com/TDBank_US .
TD Bank, America's Most Convenient Bank, is a member of TD Bank Group and a subsidiary of The Toronto-Dominion Bank of Toronto, Canada, a top 10 financial services company in North America. The Toronto-Dominion Bank trades on the New York and Toronto stock exchanges under the ticker symbol "TD". To learn more, visit www.td.com . Job Description About This Role
We need someone to provide technical leadership covering a range of data analysis functions. These include data modeling, structured query language (SQL), data quality, data profiling, extract-transform-load (ETL), metadata enrichment and management, data provenance and lineage, report design and other specialized data management functions. You're a solid, independent, senior lead equipped to manage and direct activities related to analysis, design and support of technical data management solutions for larger projects.
Meaningful work is fueled by meaningful performance and career development conversations with your manager. Here are the essential job functions of this position:
•Design, build, and maintain the logical and physical data models and complete data lineage.
•Conduct and publish data model reviews with business and technical project teams.
•Capture business data requirements and rules, design the associated logical data models, and create all required documentation to support, communicate, and validate the data model.
•Maintain documentation of data models, including relationships, constraints , and metadata
•Review database design changes with the team to determine the impact to the physical database and other systems.
•Coordinate with development/implementation team to improve data model forms and approaches with regard to implementation issues
•Participate in performance tuning activities including partitioning strategies, indexing strategies, and SQL optimization
•Architect solutions with an eye towards high performance, scalability, and high availability
•Comply with Enterprise design principles and data modeling standards Requirements What can you bring to TD?
Share your credentials, but your relevant experience and knowledge can be just as likely to get our attention. Here are the minimum requirements for this position:
- Undergraduate Degree or Technical Certificate.
- 7+ years relevant experience.
- Subject matter expertise on business processes and procedures, as well as broader organizational issues and technology.
- Advanced knowledge of business, standards, infrastructure, architecture and technology in related areas from a design/ support/ solutions perspective.
- Consult as an expert in multiple areas and consult with clients and project teams with respect to research, analysis, design, hardware/software support, solutions development, serve as a key resource for technical information exchange within project teams, with the business and outside vendors.
- Capacity and eagerness to work independently as a senior/lead role on diverse tasks, and also coach/educate/guide/direct others.
- Ability to direct activities related to analysis, design and support of technical data management solutions on larger projects that are highly complex and multi-faceted.
- Must be eligible for employment under regulatory standards applicable to the position.
Preferred Qualifications - Here are the preferred qualifications for this role:
•Experience modeling complex databases using 3rd party modeling tools such as SAP PowerDesigner
•Experience designing and building large financial services data warehouses with very strong data analysis skills
•Good knowledge of ER/Dimensional modeling and have extensive experience in developing logical and physical data models in complex, multi-application environments
•Hands-on experience in data management, data warehousing, data transformation, metadata and reference data management and business intelligence tools
•Hands-on experience in Data Architecture and Modeling in the Hadoop ecosystem
•Good knowledge of one or more SQL engines on Hadoop, i.e. Spark SQL, HiveQL, Impala, etc.
•Good knowledge of Hadoop ecosystem, including but not limited to Hive, Hbase, Map-Reduce, Kafka, HQL, Spark, HDFS, Parquet, Avro, and other file types
•Experience with advanced SQL query techniques using Hive
•Basic Unix skills
•Experience in capturing Data Lineage and Data Quality in Data Modeling tools or through other tools
•Significant experience with Software Development Life Cycle (SDLC) and Agile methodologies
•Very good communication skills
•Knowledge of Risk and Information Security KRIs related to the banking industry Hours
At TD, we are committed to fostering an inclusive, accessible environment, where all employees and customers feel valued, respected and supported. We are dedicated to building a workforce that reflects the diversity of our customers and communities in which we live in and serve, and creating an environment where every employee has the opportunity to reach their potential.
If you are a candidate with a disability and need an accommodation to complete the application process, email the TD Bank US Workplace Accommodations Program at USWAPTDO@td.com . Include your full name, best way to reach you, and the accommodation needed to assist you with the application process.
EOE/Minorities/Females/Veterans/Individuals with Disabilities/Sexual Orientation/Gender Identity.