Software Developer – ETL (Intermediate)

Position: Software Developer – ETL (Intermediate)
Contract Length: [Insert duration]
Location: Hybrid (Toronto, Ontario, Canada – 2x per week onsite)

·        Key Responsibilities:
·        Design, develop, and support ETL processes that power business intelligence software solutions.
·        Create customized query applications that help analyze critical business data and drive actionable insights.
·        Develop guided analysis, drill-down functionality, report scheduling, and notifications for seamless reporting.
·        Lead the way in identifying and fixing data issues by analyzing source systems for data cleanliness, including missing values, duplicates, and invalid data.
·        Collaborate with clients to provide tailored approaches for managing business data, ensuring data quality, and supporting quantitative analysis.
·        Develop and maintain robust ETL scripts for daily and initial loads, ensuring smooth data extraction, transformation, and load functionality.
·        Implement scheduling, error notification, and monitoring processes to keep data flows running smoothly.
·        Build and automate extraction, cleansing, and loading scripts to streamline data processing.
·        Generate insightful research models and reports, both scheduled and ad-hoc, based on business needs.
·        Troubleshoot complex data issues and optimize data processes using your analytical skills.

Must-Have Skills & Experience:
·        6+ years of progressive experience with Azure Data Lake, Databricks, SQL, Power BI, and data integration tools.
·        6+ years of hands-on experience in software development/architecture, with a focus on ETL processes.
·        6+ years of expertise in data quality and ingestion, specifically within the Azure platform.
·        Proven experience in process decomposition/mapping, business process re-engineering, and data modeling (UML).
·        Experience in developing and maintaining enterprise architecture deliverables (business, logical, and physical models).
·        Strong troubleshooting, analytical, and problem-solving skills.
·        Experience with development tools, business re-engineering software, and data analysis applications.
·        Understanding of Information Management principles, concepts, and policies.

Why Join Us?
·        Work with cutting-edge technologies in a collaborative, hybrid work environment.
·        Be a part of a forward-thinking group that values your expertise
·        Make an immediate impact in a role that directly influences key business decisions.
If you’re ready to take on this exciting challenge and work with a passionate team, send your resume to jim.nickolson@noramtec.com today! Only qualified applicants will be contacted.