Key Facts

Remote From:

Full time

English

Hard Skills

IBM Cognos Business Intelligence Microsoft SQL Server Data Engine (MSDE) Data Engineering Data Security Data Integration Data Transformation Python (Programming Language) Data Integrity Data Governance Power BI Stored Procedure Business Intelligence Tools ETL (Extract Transform Load) Data Architecture Azure Synapse Analytics Data Management Azure Data Factory Agile Software Development

Other Skills

•
Troubleshooting (Problem Solving)
•
Communication
•
Collaboration
•
Problem Solving
•
Analytical Skills

Roles & Responsibilities

Bachelor's degree in Computer Science, Information Technology, or a related field.
X+ years of experience in data engineering and ETL development.
Hands-on experience with Cognos, SQL Server (including Stored Procedures).
Experience with TimeXtender Discovery Hub, SSIS, and Python for ETL workflows.

Requirements:

Design, develop, and maintain data pipelines and ETL processes.
Implement and maintain ETL workflows using TimeXtender Discovery Hub, SSIS, and Python.
Create optimized SQL Server Stored Procedures for data transformation and performance tuning.
Ensure data integrity, governance, and security best practices; collaborate with business and analytics teams to meet data needs.

Veracity Software Inc

About Veracity Software Inc

The definition of Veracity is accuracy and habitual truthfulness. This truly defines our brand in simplistic terms. At Veracity, we believe in doing everything in the ‘Right Way’, which means you have to challenge your own innovations and solutions all the time. Our strength lies in our employees, and with the right blend of business and technical expertise, we set the bar high for Veracity. From inception, Veracity focused on building cloud based SaaS solutions while using the latest and most advanced technology stack. We have delivered cloud based customized solutions and services to various clients across both North America and India. We have a global headquarter in Woodbridge, NJ while our offshore office is in Pune, India. We believe in bringing Global talent together, which helps us in delivering cost effective, yet highly scalable and efficient solutions. With the vision of trying to be one of the trusted IT partners as well as one of the most respected solution providers with an onsite/offshore model, Veracity is equipped with the right set of highly skilled individuals who have expertise in delivering the most effective business services and solutions for our clients. Veracity’s mission is to become the Trusted IT Partner for various businesses across globe.

Founded: 2018

Company size: 51 - 200

Website LinkedIn See all jobs →

Job description

Job Title: Cognos + ETL Lead

Location: Canada/ Remote

Duration: Long Term contract

We are seeking a highly skilled ETL Lead with expertise in Cognos, SQL Server, ETL processes, Power BI and scripting for data transformation. The ideal candidate will have hands-on experience with TimeXtender Discovery Hub, SSIS, and Python for ETL workflows. This role also involves working with modern data solutions, with a preference for knowledge in Azure Synapse and Azure Data Factory.

Key Responsibilities:

Extensive Experience in Cognos reporting.
Design, develop, and maintain data pipelines and ETL processes.
Work extensively with SQL Server and create optimized Stored Procedures for data transformation.
Implement and maintain ETL workflows using TimeXtender Discovery Hub.
Develop and optimize data integration solutions using SSIS.
Utilize Python for data transformation and scripting needs.
Work closely with business and analytics teams to understand data needs and optimize performance.
Ensure data integrity, governance, and security best practices are followed.
Troubleshoot and resolve data-related technical issues.
Stay updated with modern data engineering trends and technologies.
knowledge of power BI and other BI tools

Required Skills & Qualifications:

Bachelor's degree in Computer Science, Information Technology, or a related field.
[X+] years of experience in data engineering and ETL development.
Good and hands-on experience with Cognos.
Very good knowledge of SQL Server and Stored Procedures.
Good and hands-on experience with TimeXtender Discovery Hub.
Good and hands-on experience with SSIS.
Good and hands-on experience with Python for ETL workflows.
Strong analytical and problem-solving skills.
Excellent communication and collaboration abilities.