Data Analyst
At a glance
Mid-level Data Analysis & BI role at Sapsol Technologies Inc. Winnipeg · contract.
Pay not stated Data Analyst salary
dataroles summary, based on the employer's posting.
What you'll do
- Examine PHP systems and embedded SQL to uncover the logic behind existing reports
- Trace reports back to their data sources, dependencies and business requirements
- Write SQL queries and extracts, then shift reports to warehouse or lake data sources
- Enhance PHP applications with JavaScript and record their data structures, workflows and reporting logic
- Check requirements with stakeholders, test data accuracy and performance, and support production transitions
What you bring
- You can analyze PHP applications that contain embedded SQL
- You can build SQL queries and data extracts for reporting needs
- You can validate data and test systems for accuracy and performance
Who this fits
This is a contractor position based on-site in Winnipeg. It suits someone who can work across legacy reporting, data migration and PHP application changes. Your work supports reporting across faculties and departments in a university environment.
From the employer
You will support a critical operational reporting and data initiative within a university environment. This role focuses on modernizing legacy reporting systems, improving data access, and enabling better decision-making across faculties and departments.
Responsibilities
- Analyze legacy PHP applications with embedded SQL to understand system logic
- Reverse engineer reports to identify data sources, dependencies, and requirements
- Develop SQL queries and data extracts to support reporting needs
- Redesign and migrate reports to new data sources (Data Warehouse/Data Lake)
- Build and enhance PHP applications with supporting JavaScript
- Document data structures, workflows, and reporting logic
- Collaborate with stakeholders to validate business requirements
- Perform data validation and testing to ensure accuracy and performance
- Produce migration specifications and technical documentation
- Support deployment and transition of reports to production
Data Analysis & BI work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Analysis & BI
Find me workBy the team behind dataroles.