Design, build, tune and maintain enterprise data structures and databases. Gather and document business and technical requirements, perform data profiling, mapping and validation, support ETL and data warehouse implementations, coordinate testing and production rollout, provide ad-hoc datasets and reporting, and participate in data governance and control reporting.
Company Description
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)
A senior data analyst is required to develop, design, construct, and maintain data structures, models and physical databases. The data analyst will collaborate across stakeholders (product managers, project managers, business analysts, and testers) to elicit and analyze requirements. The analyst will analyze, design, tune, maintain and test data and database solutions.
- Meet with business stakeholders and other technical team members to gather and analyze application data requirements.
- Design and build data solutions to satisfy application (business and technical) requirements.
- Perform data analysis where requirements need to be derived from available documentation, user interviews, and file specifications/samples.
- Perform data analysis activities (data profiling, creation of data dictionaries, data transformation rules, integration requirements)
- Support and apply data standardization policies
- Responsible for requirements gathering and BRD/SRD preparation.
- Has thorough knowledge of the Software Development Life Cycle.
- Conducts reviews of the test Plan and test Data.
- Ensures that expected application performance levels are achieved.
- Contributes to defining time tables and project plans.
- Analyze and document upstream financial and risk measures
- Validate new datasets for completeness and correctness
- Coordinate acceptance testing and production roll-out
- Provide custom datasets for analysis and ad hoc reporting
- Participate in control reporting and data governance development
- Help to enforce data integrity
- Research and document data mapping from source to target systems
- Assist with data modeling as necessary
- Work closely with Project Management, Data Architects, Data Modelers, other analysts and ETL Development Team to design and implement the requirements for the Enterprise Data Warehouse.
- Work closely with business users to verify data requirements and access needs.
- A senior data analyst is required to develop, design, construct, and maintain data structures, models and physical databases. The data analyst will collaborate across stakeholders (product managers, project managers, business analysts, and testers) to elicit and analyze requirements. The analyst will analyze, design, tune, maintain and test data and database solutions.
- Meet with business stakeholders and other technical team members to gather and analyze application data requirements.
- Design and build data solutions to satisfy application (business and technical) requirements.
- Perform data analysis where requirements need to be derived from available documentation, user interviews, and file specifications/samples.
- Perform data analysis activities (data profiling, creation of data dictionaries, data transformation rules, integration requirements)
- Support and apply data standardization policies
- Responsible for requirements gathering and BRD/SRD preparation.
- Has thorough knowledge of the Software Development Life Cycle.
- Conducts reviews of the test Plan and test Data.
- Ensures that expected application performance levels are achieved.
- Contributes to defining time tables and project plans.
- Analyze and document upstream financial and risk measures
- Validate new datasets for completeness and correctness
- Coordinate acceptance testing and production roll-out
- Provide custom datasets for analysis and ad hoc reporting
- Participate in control reporting and data governance development
- Help to enforce data integrity
- Research and document data mapping from source to target systems
- Assist with data modeling as necessary
- Work closely with Project Management, Data Architects, Data Modelers, other analysts and ETL Development Team to design and implement the requirements for the Enterprise Data Warehouse.
- Work closely with business users to verify data requirements and access needs.
- PLEASE NOTE THAT WE ARE NOT ABLE TO WORK WITH CANDIDATES ON H1B VISAS OR CANDIDATES REPRESENTED BY THIRD PARTIES.
- Must have at least 6-8 years of experience in data analysis. Experience in the securities or financial services industry is a plus
- Minimum 5 years’ experience working with Oracle, SQL Server Databases, and SQL
- Minimum 5 years of experience gathering business requirements
- Experience in both design and develop of enterprise level operational and data warehouse database systems
- Experience in both design and develop of enterprise level operational and reporting systems and dashboards
- Strong database design experience and experience with data modeling tools like Erwin etc.
- Experience leading design sessions
- Experience leading business requirements sessions
- Mathematical background with knowledge of pricing, risk calculation, etc.
- Solid experience with SQL, R programming experience a plus.
- Excellent communication and presentation skills
- Must be a self-starter that does not require direct supervision
- Have a strong fundamental understanding of project management, specifically in the SDLC and Agile methodologies
- Have expert level skills in Microsoft products that include Outlook, Word, Excel, PowerPoint, Visio
- Excellent written and verbal communication skills to enable them to:
- Facilitate meetings with technical peers regarding the requirements definition
- Communicate effectively with business, vendor, and project management staff
- Participate in ongoing decisions regarding study design, data collection, data analysis, and methodology
PLEASE NOTE THAT WE ARE NOT ABLE TO WORK WITH CANDIDATES ON H1B VISAS OR CANDIDATES REPRESENTED BY THIRD PARTIES.
Similar Jobs
Artificial Intelligence • Cloud • Security • Software • Cybersecurity
Lead product design across Datadog’s security products, managing and coaching designers across multiple offices. Set design direction, maintain quality, develop security-focused design systems, and partner with Product and Engineering leaders on roadmaps and cross-platform experiences. Drive product and business outcomes while bringing AI fluency to design workflows and software development. The role requires extensive design leadership, complex product experience, technical fluency, and hands-on use of AI coding tools.
Top Skills:
Ai Coding ToolsCloud Infrastructure
eCommerce • Fashion • Retail • Sales • Wearables • Design
Leads sales-floor operations, coaches and develops retail teams, drives sales targets and KPIs, delivers exceptional customer experiences, supports recruiting and performance evaluations, enforces company policies, and provides HR and conflict-resolution support. The role also analyzes sales trends, implements company initiatives, builds clienteling practices, and maintains an inclusive, customer-centric store culture. Requires physical ability to maneuver the sales floor and stockroom and lift up to 50 pounds occasionally.
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Leads teams in designing and deploying scalable AI and machine learning solutions for consulting clients. Responsibilities include data wrangling, complex analysis, data modeling, AI system implementation, data pipeline and infrastructure oversight, deep learning, neural networks, data quality validation, and stakeholder collaboration. The manager coaches team members, manages performance, supports innovation, and applies Python, Java, and cloud technologies to build production-ready AI applications.
Top Skills:
AWSCloud PlatformsData PipelinesDatabricksDeep LearningGCPJavaMachine Learning LibrariesAzureNatural Language Processing (Nlp)Neural NetworksPythonSnowflake
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
