IT Jobs in Canada
Job Description
Live Assets | IT Staffing Solutions is hiring a Data Analyst for one of its clients from public sector.
Key Responsibilities
- 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).
- 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.
- Deploy data solutions in the cloud and with database tools (SQL, NoSQL).
- 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).
- 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.
Necessary Skills
- Bachelor degree in Computer Science, IT or related field of study.
- 4+ years of experience as a Data Analyst, Data Engineer or in a similar role.
- 2+ years of experience with cloud platforms, including AWS (EC2, S3, RDS), GCP (BigQuery, 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.
- 2+ years of experience with data marts, data warehousing, BI tools, etc.
- 4+ years of experience working with querying data with Microsoft Transact-SQL Server.
- Knowledge of ETL processes and tools, with hands-on experience designing and implementing data pipelines for transforming and loading data from multiple sources into data warehouses.
Nice to Have
- 1+ year of experience integrating DevOps practices to the development workflow using CI/CD best practices.
- 1+ year of experience with data pipeline and workflow management tools such as Data Factory, API Management, Talend, etc.
- 1+ year of experience with object-oriented/object function scripting languages such as R, Python, Java, C++, Scala, etc.
- Experience with the IT infrastructure, business direction, strategies, shared service initiatives, and/or applications.
About Live Assets | Leaders in IT Excellence | Greater Edmonton Area
Live Assets is a premier IT agency dedicated to delivering excellence in tech solutions across various industries.
Our agency is renowned for its expertise in engineering, and we take pride in our track record of delivering outstanding IT projects with precision and innovation.
With a wide spectrum of clients spanning different industries, we cater to both permanent and contract IT opportunities.
Discover more about our agency and stay updated on our latest developments through our social media channels:
LinkedIn – Twitter – Facebook –Youtube – Glassdooor