• Skip to primary navigation
  • Skip to main content
  • Skip to footer

1.844.822.0541

info@nexusgroup.ca

  • Email
  • Facebook
  • Instagram
  • LinkedIn
  • Twitter
  • English
    • Français
  • Consultant Login
  • Find Your Opportunity
Nexus Systems Group

Nexus Systems Group

  • Home
  • What We Do
    • Staffing Solutions Made Easy
    • Contingent Workforce Management and Payroll Solutions
    • Technology Consulting and Delivery
  • Who We Serve
  • Who We Are
    • Our Team
    • News and Awards
    • Associations and Community
  • Contact Us
  • News

ETL Data Engineer

January 5, 2023 by

ETL Data Engineer

Typical Day in Role:
• Implementing data ingestion pipelines / DevOps (on prem and Azure cloud) to move data from source systems to our central data warehouse
• Developing SQL queries / ETL packages using T-SQL and SSIS to ingest data from source systems to integrate with data warehouse
• Design and development of high quality dashboards / reports using tools like Power BI, SSRS, Excel/PowerPivot and Tableau.
• Develop custom reports, analytics and KPI’s for the Business and Collecting business requirements / user stories from clients
• Complete testing to ensure high quality product for clients
• Developing SQL views to enable data consumers to read data from data warehouse
• Integrate systems via REST API, database views, SharePoint lists, sFTP, etc
• Responsible for documenting databases, data process flows and maintain data dictionaries
• Troubleshoot and resolve database and applications defects in a timely manner. Consult with internal and external groups as required
• Coordinating code deployments / production implementations.
• Train and assist users at all levels

Candidate Requirements/Must Have Skills:
1) 3-5 Years of SQL Development experience
2) 2-3 years of experience with Microsoft BI stack SQL Server, T-SQL, SSRS, MS SQL Enterprise Manager
3) Experience with data warehouse, ETL, SSIS to move data / integrate systems
4) Experience in developing BI reports and completing ad hoc queries and data analysis required
5) Expertise with data visualization / BI tools eg. Power BI, SSRS required.

Nice-To-Have Skills:
• Knowledge on Banking / Risk related systems is a plus
• Experience developing code to consuming REST API services a plus
• Experience integrating systems with COTS Commercial Off The Shelf software packages a plus
• Experience with implementing DevOps / MS Azure Cloud services, Google Cloud Platform etc a plus
• Experience with web development (in ASP.NET / SharePoint / Power Apps / Power Platform ) a plus
• Experience with Azure Data / Synapse / EDL / Hadoop / Hive / Jupyter Notebooks / Tableau a plus

Soft Skills:
• Clear communication and interpersonal skills required
• Attention to detail and feedback from clients on dashboards and reports must be completed rapidly
• Experience with Agile / Waterfall environments

Degrees or certifications:
• Bachelor’s degree in a technical field such as computer science, computer engineering or related field required

  • Apply Now
  • See All Jobs

Footer

ABOUT NEXUS SYSTEMS GROUP

Nexus is one of North America’s leaders in the provision of technology staff augmentation and strategic resource consulting. With a team of talented professionals using best of breed methodologies, Nexus consistently over delivers with quick, quality and trusted results to its clients and consultants.

LATEST OPPORTUNITIES

  • Delivery Lead February 1, 2023
  • Technical Lead February 1, 2023
  • Manager of Digital Marketing Journey February 1, 2023
  • Business Analyst Specialist February 1, 2023

SOCIAL

  • Email
  • Facebook
  • Instagram
  • LinkedIn
  • Twitter
Report on Business Canada's Top Growing Companies - Nexus Group
Nexus Group Growth 500 2019
Nexus Systems Group Growth 500 2018
NEXUS GROUP SYSTEMS GROUP INC. NEXUSGROUP.CA
  • Contact Us
  • Terms & Conditions
  • Privacy Policy