Senior Data Analyst or Data Engineer to design, implement, and maintain robust data pipelines and to perform detailed data analysis to support business dec

Our client is seeking a Senior Data Analyst or Data Engineer to design, implement, and maintain robust data pipelines and to perform detailed data analysis to support business decisions (580)

This is a primarily remote role but may require occasional travel within Alberta may be required to conduct field research and user interviews at consultant's own experience.

Required Experience:

• 4+ years' experience Data Analyst, Data Engineer or in a similar role.
• 2+ years' experience with cloud platforms with a focus on deploying scalable data solutions and optimizing data pipelines for a range of projects.
• AWS (EC2, S3, RDS), GCP (BigQuery, Cloud Storage)
• Azure (Azure SQL Database, Blob Storage)
• 2+ years' experience with data marts, data warehousing, BI tools, etc
• 4+ years' experience working with querying data with Microsoft Transact-SQL Server
• 2+ years' experience with ETL processes and tools, with hands-on experience designing and implementing data pipelines for transforming and loading data from multiple sources into data warehouses.
• Bachelor's degree in computer science, IT or related field of study.

Additional Experience Required:

• Experience integrating DevOps practices to the development workflow using CI/CD best practices
• Experience with data pipeline and workflow management tools such as Data Factory, API Management, Talend, etc.
• Experience with object-oriented/object function scripting languages such as R, Python, Java, C++, Scala, etc.
• Experience with the public sector IT infrastructure, business direction, strategies, shared service initiatives and/or applications

Description:

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.

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.
• 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.