At TD AMERITRADE you'll find state-of-the-art tools, outstanding personal service, affordable pricing and innovative technology. As an independent investor, or as an associate, you know where you want to go. We're committed to helping you get there by empowering your path to pursue your goals.
TD AMERITRADE is an equal opportunity employer
TD AMERITRADE is a leading organization that has provided brokerage and investment services for over 30 years. Listed in Forbes as one of America's best big companies1, the Company offers a full spectrum of investment services, including a leading active trader program, intuitive long-term investment solutions and a national branch system. Through our brokerage subsidiaries, we provide innovative, powerful online trading tools and services to individual investors.
Our associates are at the heart of what we do. We believe in teamwork, putting clients first, building strong relationships, achieving quality results and working with integrity.
This position can be filled in Omaha, NE or Jersey City, NJ
Role:
The Enterprise Data Warehouse/Business Intelligence Sr. Manager position requires hands-on participation and a solid data architecture background. This position is critical as the technical lead for building a strong foundation to a long term Enterprise Data Warehouse. Responsibilities will include development oversight for developers, project development work, physical data modeling, system architecture, knowledge of evolving technologies and architectures, and technical vision.
Responsibilities:
Define and maintain the Data Warehouse and BI Target Architecture
Help build and maintain a rolling plan to achieve the target architecture
Deliver components through Development project, Architecture projects, and Infrastructure projects
Provide depth and direction through development of standards, policies, architecture patterns, and frameworks
Socialize on a recurring basis, the target architecture along with standards and policies
Demonstrate solid understanding of the business and ensure close alignment to stakeholder needs
Provide technology leadership
Maintain expertise in the area of data warehousing, including industry trends, strategies, and products. Provide leadership and direction through subject matter expertise.
Determine product suitability and provide recommendations for effective use of assets and investments
Provide technical oversight to Data Warehouse and business intelligence design and development activities
Perform ETL development for complex procedures and performance tuning of database and ETL processes
Coach and mentor peers and associates in the area of Data Warehouse architecture and Data Management
Maintain strong and effective working relationships with Product Management, Engineering, and application development teams as well as our business partners
Requirements:
Bachelors degree or equivalent work experience in Computer Science or related discipline
Strong experience using SQL, including complex stored procedures, functions, query optimization, indexing strategy
Experience working with a business team to define requirements for a BI/DW initiative.
5 years experience in Data Warehouse ETL Development
3 years experience in Data Modeling for Data Warehouse
2 years experience in Data Warehouse Architecture
Preferred Experience:
Masters degree in Computer Science or Information Systems, or Business Administration (MBA)
Prior experience designing and building enterprise conceptual or logical data models
Knowledge and experience using architecture modeling tools
Minimum of 7-10 years related experience with emphasis in Data Warehouse engineering and development life cycles with at least 3 years experience involving architectural responsibility
Working knowledge of Data Management and Data Warehousing technologies related to data modeling, database administration and performance tuning, archiving and disaster recovery
Depth of knowledge with industry trends related to Data Warehousing, Data Management, metadata, Master Data Management, unstructured data and data quality practices
Experience managing and leading virtual, cross-functional teams, including defining requirements, developing designs and project plans, and delivering results
Ability to effectively communicate at different levels in and across the organization and to articulate to non-technical audiences the advantages and disadvantages of using various technologies and standards
Experience working with multi-terabyte data sets
Experience with implementation and/or management of the Netezza Data Warehouse appliance
Solid oral and written communication, problem solving, and project management skills.
Must be resourceful and quick learners, and display the ability to understand both business and technological issues.
The ability to actively manage project tasks, resources and deadlines are essential.
TD AMERITRADE is an Equal Opportunity Employer. We value diversity and offer a quality workplace.
1Forbes award information available at www.forbes.com/platinum . TD AMERITRADE, Inc., member FINRA/SIPC is a subsidiary of TD AMERITRADE Holding Corporation. TD AMERITRADE is a trademark jointly owned by TD AMERITRADE IP Company and The Toronto-Dominion Bank. Used with permission.
