We are seeking an experienced Data Engineer with expertise in ETL and BI toolsets to join our Technology Consulting team. You will work with amazing development teams on a variety of assignments with different clients. By gathering requirements, doing analysis, and consulting with clients, you will be able to lay a solid data foundation to perform robust analytics. You will have the opportunity to build your technical skills and expertise in ETL, BI and Cloud as well as expand your consulting skills. You are a team player with a true passion for data and a desire to learn and grow in your career.
What you'll do:
- Design ETL process and data flow from source systems to data warehouses.
- Develop and unit test ETL processes for optimal performance and performance-tune ETL mappings and report queries.
- Design and develop Business Intelligence solutions to meet end user demands.
- Design physical database objects including fact tables, dimensions, staging, materialized views, indexes etc.
What we'd like:
- 7+ years' hands-on experience in tuning ETL jobs to reduce run-time and increase efficiency through code tuning, hardware deployment, and architecture changes.
- Experience designing and building BI visualizations to meet client needs.
- Experience with ETL tools such as Ab Initio, Informatica, Microsoft SSIS, IBM DataStage, SAP Data Services etc.
- Ability to interact with clients and business users and analyze complex business requirements.
- Experience with BI tools such as Tableau, Power BI, and MicroStrategy.
- Practical experience with Windows, UNIX, relational databases (Oracle, SQL Server), SQL, and/or Oracle PL/SQL.
- Strong understanding of data warehousing architectures, core concepts, methodologies, and best practices.
- Detail oriented with analytical and problem-solving skills to recognize and identify issues and take proper action to resolve them.
- Experience using software development tools such as Azure DevOps, JIRA, Confluence, Source Code Management, and CI/CD pipelines is considered an asset.
- Keeping up to date on latest technology trends.
- Experience with AWS, Azure and/or GCP is strongly preferred.
- Expertise in coding with Python is strongly preferred.
- Experience with AI and Machine Learning is an asset.
Similar Jobs
What We Do
We are leading Digital Transformation and Cybersecurity consultancy working with Clients in Canada, USA and EMEA. Our commitment to results sets us apart. #ResultsGuaranteed.
Online is a digital transformation and cybersecurity consultancy. Since 1986 we have been using technology to deliver dramatic business results for companies throughout Canada, USA and EMEA. Our unsurpassed delivery, our people, and the Online culture of loyalty, trust and commitment to mutual success set us apart. Today we have over 350 business and technical consultants throughout Canada, US and EMEA.
Online has been recognized on the “Best Workplaces in Canada” list for 15 consecutive years. While Online is proud of the acknowledgement, we firmly believe that the most important aspect is not the award itself – it’s the amazing team that we work with every day that make it possible!
