SSIS - Data Integration Lead

Our client is a fast-growing automation-led next-generation service provider delivering excellence in IT, BPO, and consulting services. They are driven by a combination of robust strategies, passionate teams, and a global culture rooted in innovation and automation.

Our client’s Digital offerings have helped clients achieve operational excellence and customer delight. Their focus lies on taking a leadership position in helping clients attain customer intimacy as their competitive advantage. They are now on a journey of metamorphosing the experiences of the customer’s customers by leveraging our industry-leading delivery and execution model, built around the strategy— Automate Everything™, Cloudify Everything™, Transform Customer Experiences™.

Powering our client’s complex technology solutions and services is the Bottom-Up Disruption, a disruptive crowdsourcing initiative that brings about innovation and improvement to everyday complexities and, ultimately, growing the client’s business. The digitally empowered workforce of our client represents various nationalities, comprising 19,833 employees, and lives the company’s philosophy of ‘customer success, first and always’. The company reported a 2020 global revenue of USD $845.04 Mn.

We are currently searching for a Data Integration Lead (SSIS and Snowflake):

Responsibilities:

• Proven experience with data warehousing and data modeling, specifically building/understanding Microsoft data storage structures.
• Proven ability to build out, enhance, and maintain the company data environment, including modifications and maintenance of various ETLs, transactional data sets, and company data assets.
• Manage data access, data quality, and data delivery tasks within the framework of specific client BI and IT projects.
• Ability to validate and ensure production-level functionality/style is thoroughly tested, and the code reflects current standards.

Requirements:

• 8+ years of IT experience and 5+ years of experience in Data Warehousing technologies and Data Engineering.
• Strong expertise in SSIS and Snowflake as primary tools.
• Experience managing and developing SQL Analysis Services.
• At least 3+ years of team lead experience in a Data Warehouse/BI data environment, including project management, resource assignment, and architectural design.
• Extensive experience with SQL Databases: Stored Procedures, Views, and T-SQL.
• 3–5 years of experience using Microsoft data integration tools, including SSIS/IR, ADF, and ADO.
• Experience with Azure DevOps and Azure Data Factory (ADF) pipelines, including running SSIS packages from ADF and building native ADF pipelines.
• Hands-on experience with Azure Factory (Mandatory).

Desired:

• Extensive experience building Data Warehouses.
• Extensive experience creating data models and translating them into a DW design and Analysis Services model to support analytical requirements.
• Experience managing all technical aspects of a production DW: monitoring, error handling, data quality validation, and support.

Languages

• Advanced Oral English.
• Native Spanish.

Note:

• Remote, Mexico General.

If you meet these qualifications and are pursuing new challenges, Start your application to join an award-winning employer. Explore all our job openings | Sequoia Career’s Page: reers/ .

Keywords:
SSIS (SQL Server Integration Services), Snowflake, Azure Data Factory (ADF), Data Warehousing, ETL (Extract, Transform, Load)

REQUIREMENTS

None