Data Analyst

UrBench; University (FL); Remote; USD 60,000 - 100,000; Full time

Job summary

An innovative organization is seeking a talented Data Analyst to enhance its digital transformation efforts. This role involves designing and maintaining robust data pipelines, performing detailed data analysis, and collaborating with cross-functional teams to deliver actionable insights. The ideal candidate will possess a strong foundation in data engineering practices and a passion for leveraging data to improve services. Join a dynamic team that values creativity and efficiency, while contributing to the evolution of government services in the digital age. This is a unique opportunity to make a significant impact in a forward-thinking environment.

Benefits

Flexible Work Hours

Remote Work Options

Professional Development Opportunities

Health Insurance

Paid Time Off

Qualifications

• Experience as a Data Analyst or Data Engineer with strong analytical skills.
• Knowledge of ETL processes and cloud platforms like AWS and GCP.

Responsibilities

• Design and maintain data pipelines for efficient data processing.
• Perform data analysis and develop reports to support business decisions.

Skills

Data Analysis

Data Engineering

SQL

ETL Processes

Cloud Platforms (AWS, GCP)

Statistical Analysis

Data Visualization

Education

Bachelor's Degree in Computer Science or IT

Tools

Power BI

Azure

AWS

GCP

SQL Server

Job description

Description: Project Overview
The Government of Alberta ("GoA") has embarked on transforming the work of government to deliver simpler, more efficient, and better services for the citizens of Alberta, thereby ensuring that the needs of Albertans are effectively met in the digital age. As part of this role, the Province is expanding the GoA's digital delivery of services with the view of simplifying and providing better user experiences with interactions with the GoA. The Digital Design and Delivery Division ("3D"), formerly the Digital Innovation Office ("DIO"), is the Province's new centre for digital delivery. It was established to maximize capability and confidence in modern digital practice by ensuring service quality and value through standards and controls. This includes utilizing human-centred design approaches together with agile methodology and modern data practices.

The Province requires seven (7) Data Analyst, Data to work with 3D on service innovation, program review and digital transformation projects across the GoA. The Data Analyst will work as part of cross-functional program review or product delivery teams. These teams, led by GoA product owners and 3D work collaboratively and collectively participate in a full range of activities including: field research, backlog definition and refinement, and sprint planning and execution. Digital transformation projects review the current state of services, identify future opportunities, and then deliver new services that are efficient, effective and affordable.

We are seeking a talented and versatile Data Analyst to join our dynamic team. The ideal candidate will have a strong foundation in data engineering practices, combined with the analytical skills necessary to derive actionable insights from data. This role involves designing, implementing, and maintaining robust data pipelines and architectures, as well as performing detailed data analysis to support business decisions.

Scope of Services
It is anticipated that the Full Stack Developer will be required for one (1) year; however, the Province may extend the contract for up to twenty-four (24) months on the same terms and conditions.

The Data Analyst will be required on a full time basis (7.25 hour work day), working across two (2) to three (3) projects. Time, location and frequency of work will vary depending on the needs of the particular project. At the end of each term, it is expected that the Data Analyst may work a maximum of 1,960 hours, unless otherwise agreed upon with the Province. However, a Data Analyst may be required to work fewer or more hours depending on the nature and needs of their work, as directed by the Province.

Services and project deliverables should evolve as the work progresses, in response to emerging user and business needs, as well as design and technical opportunities. However, the following must be delivered (iteratively) over the course of the project:

Data Engineering:

- Design, develop, and maintain scalable data pipelines to ingest, transform, and store large volumes of data both on-premises (SSIS etc.) and in the cloud (Azure, AWS, GCP)

- Ensure data integrity, accuracy, and availability for analytical and operational use.

- Collaborate with software engineers, data scientists, and business stakeholders to understand data requirements and implement solutions.

- Optimize and improve existing data workflows and ETL processes.

- Implement data governance and security best practices.

- Manage data storage solutions, such as data lakes and data warehouses.

- A successful history of manipulating, processing and extracting value from large, disconnected datasets.

- Deploy data solutions in the cloud and with database tools (SQL, NoSQL).

Data Analytics:

- Perform exploratory data analysis to identify trends, patterns, and insights.

- Develop and maintain reports, dashboards, and visualizations using BI tools (e.g., Power BI, SaaS VA).

- Conduct statistical analysis and modeling to support business strategies.

- Communicate findings and recommendations to stakeholders in a clear and concise manner.

- Use SQL and other query languages to extract and manipulate data from various sources.

- Create plans and strategies to integrate data models and improve service delivery.

- Develop and share service metrics and performance dashboards.

- Facilitate the frequent delivery of services and deliverables to ensure the successful creation of the target state while mentoring Agile Teams to grow their analytics fluency.

- Support corporate priorities with data-driven evidence using analytics, visualizations, and data modeling.

The Province and the Contractor shall determine changes to Services and Materials as required. The Province and the Contractor will determine changes to Services and Materials through the Artifacts.

Location of Work

The Data Analyst will primarily work remotely; however, the Data Analyst may be required to attend meetings or work sessions in Edmonton on reasonable notice from the Province. At the time of providing such notice, the Province will advise of the expected duration of any such meetings or work sessions. However, time to travel and any associated expenses to and from Edmonton will be at no cost to the Province.

The Province reserves the right to alter this work arrangement on reasonable notice to the Data Analyst. The Contractor and the Data Analyst will be consulted about the alteration in work arrangement; however, the Province retains ultimate discretion as to the appropriate work arrangement.

Some travel within Alberta may be required to conduct field research and user interviews. The Province will make arrangements for travel for field research and user interview purposes where possible at no cost to the province.

Work must be done within Canada

Facilities

In the event that the Data Analyst is directed to work remotely, the Data Analyst shall be responsible for providing all of its equipment, including computers, software, printers, supplies, desks and chairs. However, the Province shall ensure that the Data Analyst have the necessary access and credentials to the GoA system.

In the event that, the Digital Architect(s) are directed to work in-person, the Province shall provide the requisite office space, furniture and office supplies. However, the Digital Architect(s) shall continue to be responsible for providing computers and software.

Criminal Records Checks

Upon request by the Province, the Data Analyst shall, at no cost to the Province, provide a current criminal record check. A Data Analyst may be rejected if, in the opinion of the Province, the criminal record is unacceptable.

Should a Data Analyst be assigned to a team working for Justice, prior to performing Services, the Data Analyst must provide the Province with an "Enhanced Security Clearance". Data Analyst, which in the opinion of the Province have an unacceptable "Enhanced Security Clearance" or equivalent, shall be rejected. The Province does not receive any information specific to the reason an enhanced clearance may be rejected. Participating law enforcement agencies only identify if an applicant's clearance is not accepted.

Data Analyst should be aware that over the course of the SOW, Data Analyst may be required to complete higher-level security clearances, such as the "Royal Canadian Mounted Police Top Secret Clearance." Please ensure applicants are eligible to apply if required by the ministry.

Acceptance by the Province of all Data Analyst requires written approval from the Province following acceptable security clearances.

Evaluation
The evaluation criteria will be distributed within the following categories. Subject to the requirements of FOIP, the evaluation of Responses shall be confidential, and not released to any party.

Qualifications- 20%
Other Mandatory Requirements- 20%
Interview - 50%
Pricing - 10%

Other Mandatory Requirements

Two (2) project examples must be provided for each proposed resource, which exemplify/demonstrate the proposed resource's expertise in the selected service area. Project examples need to be added to the bottom of the resume. Questions 1 through 5 must be answered for each project example. The Evaluation Team must be able to determine which project any given answer relates to. Where the answer to a Question is the same for both projects, this must be clearly stated.

1. Provide an overview of the project/assignment the proposed resource or the proposed
resource's team was engaged in that demonstrates expertise in the selected service area and role.
2. Describe the sector(s) (i.e. public, private or other) the project/assignment served.
3. Identify the project/assignment size in dollar value (i.e. less than $100,000, less than $500,000, less than $1,000,000 or greater than $1,000,000).
4. Describe the approach for the design, development, mitigation of risk and delivery of the project/assignment, including any special considerations with respect to methodology or processes. In providing a response consider quality assurance and communication across the cross functional team.
5. Provide a list of specific skills, tools and/or technology used within the project/assignment.

Incumbency:
There are incumbents for 4 out of 7 positions requested. Please note however, for this and all other opportunities, the Ministry seeks the best person to fill the role.

Mandatory Training Courses:
Once hired the resource will be required to complete all mandatory training which includes but not limited to Freedom of Information and Protection of Privacy Act, Security/Cybersecurity, Information Management, and Respect in the Workplace. There may also be other mandatory and/or optional training.

Anticipated Interviews dates
May 22, 20

Must Have
Education
Yes/No - Bachelor degree in Computer Science, IT or related field of study.	Yes
Work Experience
Duration - Experience as a Data Analyst, Data Engineer or in a similar role.	4 years
Duration - Experience with cloud platforms, including AWS (EC2, S3, RDS), GCP (BigQuery, Cloud)...	2 years
Duration - Experience with data marts, data warehousing, BI tools, etc	2 years
Duration - Experience working with querying data with Microsoft Transact-SQL Server.	4 years
Duration - Knowledge of ETL processes and tools, with hands-on experience designing and implement...	2 years
Nice to Have
Work Experience
Duration-Experience integrating DevOps practices to the development workflow using CI/CD...	1 years
Duration - Experience with data pipeline and workflow management tools such as Data Factory, API...	1 years
Duration - Experience with object-oriented/object function scripting languages such as R, Python...	1 years
Duration - Experience with the GOA IT infrastructure, business direction, strategies, shared serv...	1 years
Maximum Extension Term (Months)	24

UrBench is an equal opportunity employer and is committed to creating a diverse environment. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, pregnancy, status as a parent, disability, age, veteran status, or other characteristics as defined by federal, state or local laws.