Information Technology Lead

5 days ago

Vancouver BC, Canada Globant Full time

Position Summary:

Seeking a motivated and experienced back end and ETL Business Intelligence Engineer Lead who will be responsible for integrating, transforming, and consolidating data from various structured and unstructured data systems into structures that are suitable for building analytics solutions using technologies such as Microsoft, Snowflake and Informatica.

Major Responsibilities:

Responsible for working within the framework of a team and performing the following activities:

  • Help stakeholders understand the data through exploration, building and maintaining secure and compliant data processing pipelines by using different tools and techniques to produce cleansed and enhanced datasets for analysis.
  • Ensure that data pipelines and data stores are high-performing, efficient, organized, and reliable, given a specific set of business requirements and constraints.
  • Deal with unanticipated issues swiftly and minimizes data loss by performing data analysis required to troubleshoot data related issues and assist in the resolution of data issues.
  • Design, implement, monitor, and optimize data platforms to meet the data pipeline needs ensuring production data is always accurate and available for key stakeholders and business processes that depend on it.
  • Provides bridge between existing SSIS DW and future of Azure Data Factory & Azure Synapse Analytics solutions.
  • Support & maintenance of existing data flow solutions.
  • Collaborates with analytics and business teams to improve data models that feed business intelligence tools, increasing data accessibility and fostering data-driven decision making across the organization.
  • Writes unit/integration tests, contributes to engineering wiki, and documents work.
  • Works closely with a team of frontend and backend engineers, product managers, and analysts.
  • Design data integrations and data quality framework.
  • Understanding of use cases for semi-structured & relational data tech a plus.
  • Data modeling of combined business data (ERP) and specialty system data in Power BI to engineer shared datasets for self-service reporting via Power BI & Excel

Critical Competencies

  • Significant experience in developing and troubleshooting Azure Data Factory Gen 2 solutions from pipelines to integration runtimes, managing triggers, and logging integrations.
  • Proficient in navigating the Azure Portal to review, configure and troubleshoot data platform and supporting resources such as Storage Containers, SQL Server Managed Instances, and Log Analytics workspaces.
  • Strong understanding of Microsoft SQL Server and supporting tools including SQL Server Management Studio (SSMS), SQL Server data tools in Visual Studio, and Integration Services (SSIS).
  • Enterprise experience in data warehouse development and management: ETL vs ELT, star schemas, incremental load patterns, etc.
  • Experience in designing, developing and maintaining data pipelines from SAP HANA, Oracle database, Snowflake using Informatica data management cloud.
  • Proficient in writing and interpreting complex SQL queries and in developing SQL Server objects such as stored procedures, views, and indexes.
  • Comfortable using Power BI reporting and ad hoc integrations with semantic models via Excel to perform data analysis.
  • Able to assess data quality and automate data cleanup as part of continuous improvement of data load solutions.
  • Commitment to following and iterating on specific, measurable validating testing procedures before production changes are made.
  • Experienced in branching strategy strategies and integrating with GitHub via Visual Studio and ADF.
  • Knowledge of best practices and IT operations in an always-up, always-available service
  • Excellent independent problem solving and troubleshooting skills.
  • Process oriented with great documentation skills.
  • Excellent oral and written communication skills with a keen sense of customer service.

Required Education / Experience / Skills:

  • BS or MS degree in Computer Science or a related technical field
  • 10+ years of technical experience with Data Warehousing, data engineering using ETL (or ELT) techniques with Microsoft and Informatica ETL tools
  • Expert at SQL
  • Thorough understanding of data warehousing concepts including schema design and dimensional data modeling
  • Experience developing Microsoft BI Solutions including SSIS, Azure Data Factory, Informatica, data models and OLAP cube solutions using Visual Studio
  • Ability in managing and communicating data warehouse plans to internal clients
  • Experience in Snowflake is a plus
  • Experience in Power BI is a plus

Globant is an EOE M/F/D/V. For many positions, relocation is available if needed. Globant does not accept unsolicited third party resumes.

  • Information Technology Lead

    1 week ago

    Vancouver, BC, Canada Aquanow Full time

    IT Lead Aquanow, a leading infrastructure and liquidity provider that provides institutional and enterprise application platforms for digital assets, is looking for an IT Lead to join our technology team. This is a unique opportunity to work alongside a highly-experienced team and contribute to the development of a high-growth trading and technology...

  • Information Technology Lead

    1 month ago

    Vancouver, BC, Canada Aquanow Full time

    IT LeadAquanow, a leading infrastructure and liquidity provider that provides institutional and enterprise application platforms for digital assets, is looking for an IT Lead to join our technology team. This is a unique opportunity to work alongside a highly-experienced team and contribute to the development of a high-growth trading and technology company....

  • Information Technology Support Engineer

    6 days ago

    Cassidy, BC, Canada AVASO Technology Solutions Full time

    Job Title: IT Support Engineer (Freelancer) Location: Cassidy, British Columbia, Canada (Onsite) Type: Part-Time Contract Company Overview: AVASO Technology Solutions is a global IT service provider, supporting leading national and international clients across 170+ countries. We offer cutting-edge IT solutions, and as a team member, you’ll play a...

  • Information Technology Support Engineer

    5 days ago

    Cassidy, BC, Canada AVASO Technology Solutions Full time

    Job Title: IT Support Engineer (Freelancer) Location: Cassidy, British Columbia, Canada (Onsite) Type: Part-Time Contract Company Overview: AVASO Technology Solutions is a global IT service provider, supporting leading national and international clients across 170+ countries. We offer cutting-edge IT solutions, and as a team member, you’ll play a...

  • Information Technology Lead

    6 days ago

    Vancouver, BC, Canada Globant Full time

    Position Summary: Seeking a motivated and experienced back end and ETL Business Intelligence Engineer Lead who will be responsible for integrating, transforming, and consolidating data from various structured and unstructured data systems into structures that are suitable for building analytics solutions using technologies such as Microsoft, Snowflake and...

  • Information Technology Support Engineer

    6 days ago

    Cassidy, BC, Canada AVASO Technology Solutions Full time

    Job Title: IT Support Engineer (Freelancer) Location: Cassidy, British Columbia, Canada (Onsite) Type: Part-Time Contract AVASO Technology Solutions is a global IT service provider, supporting leading national and international clients across 170+ countries. We offer cutting-edge IT solutions, and as a team member, you’ll play a crucial role in...

  • Information Technology Lead

    1 month ago

    Vancouver, Canada Aquanow Full time

    IT Lead Aquanow, a leading infrastructure and liquidity provider that provides institutional and enterprise application platforms for digital assets, is looking for an IT Lead to join our technology team. This is a unique opportunity to work alongside a highly-experienced team and contribute to the

  • Information Technology Lead

    13 hours ago

    Vancouver, Canada Aquanow Full time

    IT LeadAquanow, a leading infrastructure and liquidity provider that provides institutional and enterprise application platforms for digital assets, is looking for an IT Lead to join our technology team. This is a unique opportunity to work alongside a highly-experienced team and contribute to the development of a high-growth trading and technology company....

  • Information Technology Lead

    5 hours ago

    Vancouver, Canada Aquanow Full time

    IT LeadAquanow, a leading infrastructure and liquidity provider that provides institutional and enterprise application platforms for digital assets, is looking for an IT Lead to join our technology team. This is a unique opportunity to work alongside a highly-experienced team and contribute to the development of a high-growth trading and technology company....

  • Information Technology Lead

    1 month ago

    Vancouver, Canada Aquanow Full time

    IT Lead Aquanow, a leading infrastructure and liquidity provider that provides institutional and enterprise application platforms for digital assets, is looking for an IT Lead to join our technology team. This is a unique opportunity to work alongside a highly-experienced team and contribute to the development of a high-growth trading and technology...

  • Information Technology Lead

    1 month ago

    Vancouver, Canada Aquanow Full time

    IT LeadAquanow, a leading infrastructure and liquidity provider that provides institutional and enterprise application platforms for digital assets, is looking for an IT Lead to join our technology team. This is a unique opportunity to work alongside a highly-experienced team and contribute to the development of a high-growth trading and technology company....

  • Information Technology Lead

    1 month ago

    Vancouver, Canada Aquanow Full time

    IT LeadAquanow, a leading infrastructure and liquidity provider that provides institutional and enterprise application platforms for digital assets, is looking for an IT Lead to join our technology team. This is a unique opportunity to work alongside a highly-experienced team and contribute to the development of a high-growth trading and technology company....

  • Information Technology Lead

    3 weeks ago

    Vancouver, Canada Aquanow Full time

    IT LeadAquanow, a leading infrastructure and liquidity provider that provides institutional and enterprise application platforms for digital assets, is looking for an IT Lead to join our technology team. This is a unique opportunity to work alongside a highly-experienced team and contribute to the development of a high-growth trading and technology company....

  • Information Technology Instructor

    3 months ago

    Vancouver, Canada Canadian College of Technology and Business (CCTB) Full time

    **Program**:Cybersecurity **Location**:Vancouver, BC**:2 days** **Onsite, 2 days Remote** **Job Type**:Contract, Part-Time **Job Summary** The Canadian College of Technology and Business (CCTB) is an educational institution specializing in career development, certification and technical training in business and information systems Our principal...

  • Information Technology Support Engineer

    2 months ago

    Prince Rupert, BC, Canada AVASO Technology Solutions Full time

    AVASO Technology Solutions is currently seeking an IT Support Engineer with a passion for the IT area.As an AVASO employee, you will be part of a global organization that provides IT Services to big national as well as international clients across multiple industries.We are an IT solution provider with coverage in more than 170 countries as well as global...

  • Information Technology Support Engineer

    2 months ago

    Prince Rupert, BC, Canada AVASO Technology Solutions Full time

    AVASO Technology Solutions is currently seeking an IT Support Engineer with a passion for the IT area.As an AVASO employee, you will be part of a global organization that provides IT Services to big national as well as international clients across multiple industries.We are an IT solution provider with coverage in more than 170 countries as well as global...

  • Information Technology Lead

    3 weeks ago

    Vancouver, British Columbia, British Columbia, Canada Aquanow Full time

    IT LeadAquanow, a leading infrastructure and liquidity provider that provides institutional and enterprise application platforms for digital assets, is looking for an IT Lead to join our technology team. This is a unique opportunity to work alongside a highly-experienced team and contribute to the development of a high-growth trading and technology company....

  • Information Technology Project Manager

    2 days ago

    Vancouver, BC, Canada Insight Global Full time

    An employer is looking for a Technical Project Manager to join one of Canada's largest athletic retailers located in Vancouver, BC, on a 6-month contract basis. In this role, you will be joining the digital org and will be responsible for leading all the project delivery aspects while concurrently driving the scrum master responsibilities (scrum ceremonies,...

  • Information Technology Support Specialist

    5 days ago

    Williams Lake, BC, Canada AVASO Technology Solutions Full time

    AVASO Technology Solutions is currently seeking an IT Support Engineer with a passion for the IT area. As an AVASO employee, you will be part of a global organization that provides IT Services to big national as well as international clients across multiple industries. We are an IT solution provider with coverage in more than 170 countries as well as...

  • Head of Information Technology

    4 weeks ago

    Vancouver, British Columbia, Canada ITIQ Full time

    IT/IQ Tech Recruiters is in search of a Head of Information Technology to join a dynamic organization. Why consider this opportunity? Join a reputable and expanding firm. Collaborate with a close-knit IT team. Enjoy a hybrid and flexible working arrangement. Work under a President who is deeply committed to IT advancements and recognizes the importance...