208642 / Sr. Data Analyst
AI summary of the role
Senior data analyst role focused on designing, building, and maintaining data structures and databases for an enterprise data warehouse.
No longer in the current catalog. Last included 2026-09-09. Check the employer’s posting for availability.
What you’ll do
- Design and build data solutions to satisfy application (business and technical) requirements.
- Perform data analysis activities including data profiling, creation of data dictionaries, and data transformation rules.
- Work closely with Project Management, Data Architects, Data Modelers, and ETL Development Team to design and implement requirements for the Enterprise Data Warehouse.
- Analyze and document upstream financial and risk measures.
What you’ll bring
- Must have at least 6-8 years of experience in data analysis.
- 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.
Technologies
Oracle · SQL Server · SQL · Erwin · R · ETL · Agile · SDLC · Visio · Excel
About Procom
Canada's largest Canadian-owned IT staffing and consulting firm, placing contract and permanent tech talent into enterprises and governments across North America.
Bootstrapped · 1000–2000 people
Source and classification
Internal deployment & tooling · Evidence for this classification:
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
More from the job description
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) Job Description 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 [... source excerpt omitted ...] ntation, 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 [... source excerpt omitted ...] 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
Employer postings · Data from · Sources