Data Solutions Analyst

3 weeks ago

Edmonton, Canada Government of Alberta Full time

**Job Information**

Job Requisition ID: 53303
Ministry: Treasury Board & Finance
Location: EDMONTON
Full or Part-Time: Full Time
Hours of Work: 36.25 hours per week
Permanent/Temporary: Ongoing
Scope: Open Competition
Closing Date: February 12, 2024
Classification: Program Services 4

**Salary**: $ 2,757.39 to $3,604.16 bi-weekly ($71,967 - $ 94,068 annually)

Reporting to the Manager, Data Services, the Data Solutions Analyst will be responsible for analyzing complex data sets, developing scalable data pipelines, and optimizing data storage and retrieval systems.

As a Data Solutions Analyst, you will be responsible for designing, building, optimizing, and maintaining the OSI’s data infrastructure. This will include developing processes to extract, transform, and load data (ETL) from various sources and systems, design and implement data models, and optimize data storage and retrieval systems for performance and scalability.

By leveraging your expertise in data modeling, ETL processes, database architecture and knowledge on diverse data sources, you will play a key role in enhancing the data-driven analysis of social, economic, and demographic data in Alberta. You will work on challenging and complex initiatives that make an impactful difference on the lives of Albertans.

**Role Responsibilities**:
Reporting to the Manager, Data Services, the Data Solutions Analyst will be responsible for analyzing complex data sets, developing scalable data pipelines, and optimizing data storage and retrieval systems.

As a Data Solutions Analyst, you will be responsible for designing, building, optimizing, and maintaining the OSI’s data infrastructure. This will include developing processes to extract, transform, and load data (ETL) from various sources and systems, design and implement data models, and optimize data storage and retrieval systems for performance and scalability.

By leveraging your expertise in data modeling, ETL processes, database architecture and knowledge on diverse data sources, you will play a key role in enhancing the data-driven analysis of social, economic, and demographic data in Alberta. You will work on challenging and complex initiatives that make an impactful difference on the lives of Albertans.

**The key accountabilities for this role are varied and challenging, such as**:

- extract and transform data from multiple data sources to storage and use in the database.
- clean, aggregate, and organize data from disparate sources and transfer them to database.
- clean, structure and format datasets to make data consumable for analysis and reporting.
- assemble large, complex data sets that meet function business requirements.
- manage data and meta-data stored in the data warehouse.
- implement and oversee robust data security measures to protect sensitive government information and ensure compliance with relevant security requirements.
- monitor and optimize ETL processes to ensure optimal performance and scalability; identify and resolve issues, errors, and bottlenecks in the ETL process.
- monitor data processing systems, APIs, and external sources to ensure data quality and troubleshoot any issues that arise. This involves handling data quality, standardization, and enrichment processes.
- Incorporate visualization tools to effectively present information and data to both internal and external stakeholders.
- review data initiatives and project plans to recommend data sources or identify potential data gaps.
- support data acquisition, delivery, publishing, security, license agreements, and analytical support, relating to data from Statistics Canada, Canada Revenue Agency, other GoA departments, and external stakeholders.
- Strong problem-solving skills as well as an ability to establish and sustain effective working relationships with stakeholders.
- Proven time management skills and experience in managing several projects simultaneously.
- A unique mix of analytical, consultative and communication skills and abilities, to seamlessly blend the world of analytics and data with the business needs and data literacy of the organization.
- Ability to motivate others to deliver quality, value-adding services.

**Qualifications**:
**Requirement**:

- University Degree in Computer Science, Engineering, Applied Mathematics, Statistics, Economics, or a related field. Master’s degree is considered an asset.
- At least 4 years’ experience in building and optimizing data extraction, transformation, and loading (ETL) pipelines.

Equivalencies will be considered based on one-year experience for one year of education or one year of education for one year of experience.

**Assets**
- Familiarity ETL tools like SSIS, Azure data factory etc.
- Familiarity with data tools and platforms, such as SQL Server, PostgreSQL, MySQL, Snowflake, Hadoop etc.
- Proficiency in database design, schema modelling, and performance optimization.
- Experience working with data visualization tools such as Power BI, T

  • Cpic Data Analyst/data Quality Analyst

    7 days ago

    Edmonton, Canada Government of Alberta Full time

    **About Us** **Job Information** Job Requisition ID: 50191 Ministry: Public Safety and Emergency Services Location: Edmonton Full or Part-Time: Full Time Hours of Work: 36.25 hours per week Regular/Temporary: Permanent Scope: Open competition - 2 Positions available Closing Date: December 6, 2023 Classification: Program Services 2 **Salary**: $2,345.14 to...

  • Data Analyst

    4 days ago

    Edmonton, Canada ATCO Group Full time

    **Division: ATCO Gas & Pipelines** **Location: Edmonton AB** **Position: Data Analyst** **Position Summary**: Reporting to the Senior Engineer, Project Services in ATCO’s Gas & Pipelines division, the Data Analyst is pivotal in leveraging data and analytics to benefit engineering and construction projects. This role focuses on working closely with other...

  • Data Analyst

    4 weeks ago

    Edmonton, Canada NAIT Full time

    Reporting to the Manager of Student Information Services (SIS) & Prospect and Applicant Relationship (PAR) Teams, the Data Analyst works closely with the manager, coordinators, team members and ITS, Marketing & Communication, and information asset content owners to develop insights related to the performance of information assets and SIS/PAR business...

  • Data Analyst

    6 days ago

    Edmonton, Canada Flair Airlines Ltd. Full time

    **Want to be part of a team that's changing the way Canada travels?** As Canada’s largest independent ultra-low-cost airline, that’s exactly what we’re doing at Flair Airlines. By consistently offering airfares that are a fraction of the ticket prices of “those other airlines”, we are making air travel an affordable option for millions of...

  • Intermediate Data and Security Analyst

    3 weeks ago

    Edmonton, Canada Englobe Full time

    We offer A full range of benefits (group insurance with shared costs upon hiring, group RRSP); A telemedicine virtual healthcare service; An annual reimbursement of sports expenses; Opportunities for skills development; Flexible hours and ability to compress working hours; Internal policy to encourage teleworking. Choose the path of impact. Join...

  • Data Analyst/Programmer

    3 weeks ago

    Edmonton, Canada Recooty Full time

    The Data Analyst / Programmer fulfils a dual role primarily focused on working with large data sets to answer business questions, availing the results of transformations and analysis to management and users through various reporting tools. The Data Analyst / Programmer is also involved in programming and troubleshooting/maintaining/testing software to...

  • Data Analyst/Programmer

    3 weeks ago

    Edmonton, Canada Recooty Full time

    The Data Analyst / Programmer fulfils a dual role primarily focused on working with large data sets to answer business questions, availing the results of transformations and analysis to management and users through various reporting tools. The Data Analyst / Programmer is also involved in programming and troubleshooting/maintaining/testing software to...

  • Data Analyst/Programmer

    4 weeks ago

    Edmonton, Canada Recooty Full time

    The Data Analyst / Programmer fulfils a dual role primarily focused on working with large data sets to answer business questions, availing the results of transformations and analysis to management and users through various reporting tools. The Data Analyst / Programmer is also involved in programming and troubleshooting/maintaining/testing software to...

  • Data Analyst

    7 days ago

    Edmonton, Canada University of Alberta Full time

    **MED Emergency Medicine**: - Competition No. **S115352599** - Posting Date **Feb 14, 2024** - Closing Date **Mar 06, 2024** - Position Type **Full Time - Grant Funded** - Salary Range **$60,299 to $83,456 per year** - Grade **10** - Hours **35** This position is a part of the Non-Academic Staff Association (NASA). This position has a term length...

  • Data Analyst

    4 days ago

    Edmonton, Canada University of Alberta Full time

    **MED Undergraduate Medical Education**: - Competition No. **S104651539** - Posting Date **Jul 20, 2023** - Closing Date **Jul 29, 2023** - Position Type **Full Time - Operating Funded** - Salary Range **$55,212 to $75,685 per year** - Grade **09** - Hours **35** This position is a part of the Non-Academic Staff Association (NASA). This position...

  • Data Analyst

    6 days ago

    Edmonton, Canada City of Edmonton Full time

    **Data Analyst** **Job Number***: **45388** Under the direction of the Manager, Fleet and Facility Analytics, this position provides analytical support for the Fleet & Facility Services branch by building data sources, developing Tableau dashboards and doing analyses in spreadsheets. The position will be responsible for all aspects of research, data...

  • Data Analyst

    2 weeks ago

    Edmonton, Canada Vantix Systems Inc. Full time

    Our Client is seeking a Data Analyst to supplement an ERP Project team to analyze and implement data migration, reporting and analytics solutions based on business requirements.MUST HAVE - 5+ years experience in the Alberta Public Sector - Government or equivalent. MUST HAVE - 3+ years experience with ERP data migration (PeopleSoft or SAP) Client is in...

  • Data Analyst

    2 weeks ago

    Edmonton, Canada Vantix Systems Inc. Full time

    Our Client is seeking a Data Analyst to supplement an ERP Project team to analyze and implement data migration, reporting and analytics solutions based on business requirements.MUST HAVE - 5+ years experience in the Alberta Public Sector - Government or equivalent. MUST HAVE - 3+ years experience with ERP data migration (PeopleSoft or SAP) Client is in...

  • Data Analyst

    2 weeks ago

    Edmonton, Canada Vantix Systems Inc. Full time

    Our Client is seeking a Data Analyst to supplement an ERP Project team to analyze and implement data migration, reporting and analytics solutions based on business requirements.MUST HAVE - 5+ years experience in the Alberta Public Sector - Government or equivalent. MUST HAVE - 3+ years experience with ERP data migration (PeopleSoft or SAP) Client is in...

  • Data Analyst

    2 days ago

    Edmonton, Canada CGI Full time

    Are you ready to join an outstanding culture that cares about diversity and inclusion, corporate social responsibility and gives the freedom to innovate, influence decisions, and chart an exciting career? CGI is more than just an IT consulting company; be part of a team that supports the local community with the ability draw on global best-in-class talent....

  • Enterprise Data Management Analyst

    5 days ago

    Edmonton, Canada AIMCo (Alberta Investment Management Corporation) Full time

    DEPARTMENT: Data Management - CLOSING DATE: - March 2, 2024 Opportunity We are currently recruiting for the role of an Enterprise Data Management Analyst. This individual will collaborate directly with key stakeholders in business and technology to enforce data management best practices within AIMCo. Furthermore, the Analyst will undertake data quality...

  • Client Solutions Analyst

    4 weeks ago

    Edmonton, Canada CWB Financial Group Full time

    At CWB , we strive to build value for the people who choose us every day: our people, our clients and our investors. We do this by holding true to the values that guide us. We put people first and build relationships with intention. We seek out and embrace new ideas, knowing that better is always possible. We believe that how we do things is as important...

  • Data Analyst/Programmer

    3 weeks ago

    Edmonton, AB, Canada Recooty Full time

    The Data Analyst / Programmer fulfils a dual role primarily focused on working with large data sets to answer business questions, availing the results of transformations and analysis to management and users through various reporting tools. The Data Analyst / Programmer is also involved in programming and troubleshooting/maintaining/testing software to...

  • Senior Data Analyst

    3 weeks ago

    Edmonton, Canada Vantix Systems Inc. Full time

    Our client iis seeking contracting services for a Data Analyst to support the analytics initiatives prioritized by the BISC for 2024 and supplement other work required on the Data Management Program (DMP).The scope of the work will include (but is not limited to):Understand the business requirements to devise a technical solution that aligns with the...

  • Senior Data Analyst

    3 weeks ago

    Edmonton, Canada Vantix Systems Inc. Full time

    Our client iis seeking contracting services for a Data Analyst to support the analytics initiatives prioritized by the BISC for 2024 and supplement other work required on the Data Management Program (DMP).The scope of the work will include (but is not limited to):Understand the business requirements to devise a technical solution that aligns with the...