This position is responsible for developing and supporting new and existing datasets and ETL scripts to support operational reporting, management decision support, and advanced analytics.

The associate is part of a team responsible for conducting a broad range of analytics data management functions including development, scheduling, job optimization, version control management, data quality management, and issue resolution. This associate works closely with analytics teams and technology partners as part of a complete data and analytics lifecycle.

RESPONSIBILITIES:

• Create and implement datasets for BI tools to support management and operational reporting needs
• Develop custom datasets to support ad hoc analyses and data science initiatives
• Collect and refine data from disparate data sources to support business requirements
• Access and create new data sources to supplement existing dat a
• Maintain library of automated SQL scripts to support Service Level Agreements and Expectations
• Manage multiple versions of code in an iterative development environment
• Provide support to analysts on data management tools and techniques
• Partner with analysts to optimize operational processes
• Collaborate with analysts and data scientists to use expanded data sets and query techniques
• Conduct code reviews to optimize various ETL/ELT scripts
• Review, test and document changes to processes, tools and architecture
• Troubleshoot and resolve data issues and alerts
• Participate in activities to enhance the level of data management knowledge and skills
• Provide data quality monitoring and documentation per Data Governance team policies and guidelines
• Support Data Governance in the adoption of data quality, metadata, data profiling, and MDM tools and practices

REQUIREMENTS:

• 4 year college degree required in any of the following concentrations: Computer Science, Information Systems, Data Science, Engineering, Mathematics, or Business required
• Minimum 2 years related experience required
• Experience with data movement (ETL, ELT) techniques
• Experience in managing data sets
• Experience in data profiling, data mining and analysis
• Working knowledge of data warehouses and related data platforms
• Ability to develop and tune Postgres SQL
• Ability to adapt to and work with multiple programming tools and languages including SQL, Python, C#, C++, VBA, JavaScript, ExtJS, Neo4J, AngularJS, R and SAS
• Experience with various data management tools including EBX, Adaptive, Global IDs and Informatica
• Ability to read and understand query execution plans
• Ability to analyze large and/or unstructured datasets
• Interest in using big data tools and techniques including NoSQL, Hadoop and open source big data tools
• Experience with or aptitude to work with IBM Puredata (Netezza) analytics data warehouse appliance
• Ability to develop datasets to support advanced analytics and reporting
• Must be Business-Centric, Data-Oriented, Analytically Minded and Results Driven
• Strong levels of curiosity and perseverance
• Must be a natural self-starter with ability to work autonomously
• Must be able to effectively plan and manage responsibilities
• Effective communication skills to manage expectations and challenges
• Solid critical thinking skills to scope and frame problems
• Displays excellent judgement to understand and support business needs
• Effective interpersonal and relationship building skills to effectively work with teammates and business partners
• Military education or experience may be considered in lieu of civilian requirements listed

At TD Ameritrade we help individual investors pursue their financial goals through our brokerage subsidiaries. For more than 40 years we have been serving individual investors – from the first-time investor to the sophisticated trader, and from the “do-it-yourself” to the “do-it-for-me” investor. We offer a broad range of investment tools and services – all at a great value.

We engage with our clients in many different ways including online, on-the-go via mobile applications, over the phone or through independent registered investment advisors. Our clients choose how they want to work with TD Ameritrade – not the other way around.