Logo for Veracity Software Inc

Cognos + ETL Lead

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.

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.

Preferred Qualifications:

  • Nice to have knowledge of Azure Synapse and Azure Data Factory.
  • Experience in cloud-based data solutions.
  • Exposure to Agile development methodologies.

Related jobs

Other jobs at Veracity Software Inc

We help you get seen. Not ignored.

We help you get seen faster — by the right people.

🚀

Auto-Apply

We apply for you — automatically and instantly.

Save time, skip forms, and stay on top of every opportunity. Because you can't get seen if you're not in the race.

✨

AI Match Feedback

Know your real match before you apply.

Get a detailed AI assessment of your profile against each job posting. Because getting seen starts with passing the filters.

Upgrade to Premium. Apply smarter and get noticed.

Upgrade to Premium

Join thousands of professionals who got noticed and hired faster.