Procom is a leading provider of professional IT services and staffing to businesses and governments in Canada.
With revenues over $500 million, the Branham Group has recognized Procom as the 3rd largest professional services firm in Canada and is now the largest “Canadian-Owned” IT staffing/consulting company.
Procom’s areas of staffing expertise include:
• Application Development
• Project Management
• Quality Assurance
• Business/Systems Analysis
• Datawarehouse & Business Intelligence
• Infrastructure & Network Services
• Risk Management & Compliance
• Business Continuity & Disaster Recovery
• Security & Privacy
Specialties
• Contract Staffing (Staff Augmentation)
• Permanent Placement (Staff Augmentation)
• ICAP (Contractor Payroll)
• Flextrack (Vendor Management System)
Location: Mount Laurel - will consider 2-3 days a week remote however must be able to come into the office, interviews will be in person so no relocation considered
Manager is seeking a Data Modeler/Data Analytic to join DCTS team.
The Senior Data Analyst will be responsible for extracting, staging, storing, migrating, hashing, and analyzing TD Bank (USA) data across multiple channels and product sets. The successful candidate will develops logical data models, conduct data mining, and integrate/match data across different data sets for analytical purposes, and segmentation methodologies to address a wide array of business issues, objectives and strategies.
Develop database models and supporting documentation in order to meet business requirements. Define data requirements and business rules, perform logical and physical data modeling, implement and test database design. Coordinate data models. Dictionaries and other documentation across multiple applications
Job Responsibilities:
• SME (Subject Matter Expert) to establish, communicate and execute measurement and analytical strategies for TD Bank (USA). Design model/methodology to integrate raw data across different data sources
• Analyze trends & data in both internal and vendor-supplied data to interpret customer relationships and make appropriate recommendations to key stakeholders within the organization.
• Support Channels initiatives for TD Bank (USA) with data extraction, migration, storage, integration, and analysis, business cases and providing monthly trended forecast and plan information.
• Working with key stakeholders and other members of the Digital Customer Insights team define and manage online customer insights through definition of KPIs, web metrics capabilities and reporting.
• Provide value-added data analysis and anticipate the requirements of the Online Channel stakeholders.
• Contribute to presentations for senior management that clearly and concisely present findings and recommendations.
• Working with other members of the Digital team and tech define and establish standards, processes and policies for an online datamart.
• Participate in the education of business partners in the area of data analytics.
• Stay abreast of industry trends and innovations and drive new analytics initiatives that contribute to business goals.
MUST HAVES
Experience in developing logical/physical models for operational systems,
Experience in database administration and impact analysis of data structure changes.
5+ years experience in the following
ERWIN
OLTP
SQL or SAS
RUP
Oracle
MS Office Tools
Must have worked with Large Data - ability to create and manipulate Data Models
1 year experience with Hadoop
PGP encryption
Nice to have
Data ware house background
• Undergraduate university degree in business, statistics or analytically-based discipline, or equivalent experience; having a post graduate degree would be an asset.
• Experience working with Data Warehouse environments and applications
• Data mining and modeling capabilities with a solid background working with large data sets.
• Excellent analytical, organization and presentation skills. A drive to understand the relationships between divergent data metrics.
• Experience with cross-channel and data that spans multiple product groups
• Experience with data sanitization such as masking, hashing, and obfuscation algorithms
• Experience with data extraction, transformation, loading and governance.
• Experience with the following software and tools:
• Microsoft Office
• SAS and SQL
• Business Intelligence software such as Tableau, Crystal Reports, Business Objects or Cognos
• SQL Server
• SAS (PC and Host versions)
• Win SQL
• Encryption products like WinZIP and PGP
• Experience with Web Analytics Applications like Adobe/Omniture, Google Analytics, Coremetrics would be an asset.
• Strong online/web/digital experience and knowledge of the latest user trends and behavior.
• A strong focus on attention to detail, accuracy and on-time delivery
• Ability to work independently as well as a contributing member of the team.
• Ability to prioritize competing tasks in a deadline-driven environment.
• Strong interpersonal skills.
5-7 years experience required.
Additional Information
All your information will be kept confidential according to EEO guidelines.
Skills Required
- Develop logical and physical models for operational systems
- Database administration and impact analysis of data structure changes
- 5-7 years experience in data modeling/analytics
- ERWIN experience
- Experience with OLTP systems
- SQL experience
- SAS experience (PC and Host)
- RUP (Rational Unified Process) experience
- Oracle experience
- Microsoft Office tools proficiency
- Experience working with large datasets and creating/manipulating data models
- At least 1 year experience with Hadoop
- PGP encryption (and other encryption products) experience
- Undergraduate degree in business, statistics or analytically-based discipline or equivalent experience
- Experience with data sanitization (masking, hashing, obfuscation)
- Experience with data extraction, transformation, loading (ETL) and data governance
- Experience with Business Intelligence tools (Tableau, Crystal Reports, BusinessObjects, Cognos)
- SQL Server / Win SQL experience
- Experience integrating and analyzing cross-channel data across product groups
- Experience with web analytics tools (Adobe/Omniture, Google Analytics, Coremetrics)
- Data warehouse background
- Postgraduate degree (asset)
What We Do
Procom is a leading North American provider of IT staffing and contract workforce services. They specialize in connecting businesses with high-quality technical talent through contract staffing, direct hire, and IT consulting. Additionally, Procom provides comprehensive workforce solutions, such as Employer of Record (EOR) and Agent of Record (AOR) services, designed to help organizations manage their contingent workforces and support long-term digital transformation and growth.
.jpg)
