Data Modeler/Data Analyst
Core
Develop logical and physical data models, extract, stage, store, migrate, and analyze large datasets to support business strategies and customer insights for TD Bank (USA).
Role type
Senior Data Modeler/Data Analyst
Builds
Operational data models, data marts, and analytical reports for digital channels and product sets
Domain
Banking / Data Engineering & Analytics
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Logical and physical data modeling, SQL, SAS, Oracle, ERWIN, OLTP, RUP, Hadoop, PGP encryption, data extraction/transformation/loading, data governance, data mining, large data manipulation
Preferred skills
Data warehouse background, Tableau/Cognos/Business Objects, Web analytics (Adobe/Omniture/Google Analytics), data sanitization (masking/hashing/obfuscation)
Technologies
Oracle, SQL Server, SAS, ERWIN, Hadoop, Tableau, Crystal Reports, Business Objects, Cognos, WinSQL, PGP, WinZIP
Responsibilities
Develop database models and documentation; define data requirements and business rules; integrate and match data across different sets; analyze trends to interpret customer relationships; support channels initiatives with data extraction and forecasting; define KPIs and web metrics; establish standards for online datamarts; educate business partners on data analytics.
Seniority
Senior, hands-on IC