Data Analyst

We are looking for a **Data Analyst** for a** 3-month contract** position, with possible extensions in **Edmonton, Alberta**. **Must be legally entitled to work in Canada.**

**This is a REMOTE role, with potential travel requirements within Alberta and mandatory meetings in Edmonton with reasonable notice. **The schedule is 7.25 hours per day, 36.25 hours a week.**

**Role Description**

**Role Responsibilities**
**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
- Manipulate, process and extract 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

**Required Skills and Experience**
- **A bachelor’s degree in Computer Science, Information Technology or a related field**:

- **A minimum of 4 years of experience as a Data Analyst, Data Engineer or a similar position**:

- **A minimum of 4 years of experience working with querying data with Microsoft Transact-SQL Server**:

- **A minimum of 2 years of experience with cloud platforms, including AWS (EC2, S3, RDS), GCP (Big Query, Cloud Storage), or Azure (Azure SQL Database, Blob Storage), with a focus on deploying scalable data solutions and optimizing data pipelines for a range of projects**:

- **A minimum of 2 years of experience with data marts, data warehousing, BI tools, etc.**:

- **Knowledge of ETL process and tools with a minimum of 2 years of hands-on experience designing and implementing data pipelines for transforming and loading data from multiple sources into data warehouses**:

- At least 1 year of experience with integrating DevOps practices to the development workflow using CI/CD best practices is preferred
- At least 1 year of experience with data pipeline and workflow management tools such as Data Factory, API Management, Talend, etc. is preferred
- At least 1 year of experience with object-oriented/object function scripting languages such as R, Python, Java, C++, Scala, etc. is preferred

**InSync Systems Inc.** is a privately-owned boutique Canadian Resourcing and Consulting Services Company that works closely with a range of corporate clients across multiple industries to bring them solutions that effectively address their business needs.