ETL Developer – Information Management Analyst

ETL Developer – Information Management Analyst for non for profit community services agency client, downtown Toronto.

Marberg Job Number:  2047.
Job Type:  Temporary.
Initial Term:  August 21 2023 to November 17 2023, with possibility of extension.
Compensation:  $45.84 per hour.
Regular Work Hours:  FULL TIME HOURS – currently 8:30 am to 4:30 pm, not including 1 hour unpaid lunch break, Monday to Friday (35 work hours per week). Shift will change to 9 am to 5 pm not including 1 hour unpaid lunch after Labour Day.
Work Location: 100% onsite at client’s downtown office, near TTC station.

Responsibilities Summary:  
To utilize deep knowledge of ETL, data modeling, database development and SQL programming to maintain and sustain existing data warehouse, design and expand its functionality, test and troubleshoot for ETL issues, and build dashboards and reports to satisfy data queries and requests.

• Daily maintenance of data warehouse, accessing and loading data from multiple data sources, and ensuring ETL functionality.
• Adjust SSIS packages to accommodate data source changes.
• Develop and refine SSIS and SSAS cubes/data marts.
• Build, develop and refine reports and dashboards using Power BI.
• Troubleshoot ETL issues.
• Additional BI and ETL functions and responsibilities as required. 

Qualifications: 
Education:  Post secondary Degree or Diploma in Information Management, Math, Statistics, Software Development, Business Administration, Health Administration, or related discipline.
Preferred Work Experience:  At least 3+ years of progressive work experience in the field of BI development, SQL programming, and data reporting and analytics.
Preferred Sector Experience:  Experience in health care or social services sector an asset.  

Technical and Language Skills Requirements:  

• Advanced SQL programming skills (may be tested).
• Advanced proficiency in Power BI (may be tested).
• Strong knowledge of ETL processes and methodologies.
• Familiarity with Azure Platform.
• Cognos Reporting an asset.
• .Net. an asset.
• Proficiency with additional Business Intelligence Tools an asset.
• Strong English communication skills, both written and verbal, including advanced level technical and business writing skills, and proficient verbal presentation skills suitable for a range of audiences.   

Task -Based Qualifications and Additional Attributes:     

• Demonstrated working experience with ETL and developing SSIS, SSAS cubes/data marts.
• Demonstrated data analysis and reporting capabilities
• Demonstrated record of professional conduct and character. Responsible, reliable and works to deadlines. 
• Pleasant and courteous.  Demonstrated commitment to client service and professional representation of the organization.  
• Proven ability to professionally handle confidential information and exercise good judgement in the interpretation and application of instructions and organization policy.
• Superior attention to detail, and organized, methodical approach to completion of tasks.
• Demonstrated ability to work well both independently and collaboratively, and in an advisory capacity, and liaise effectively with a wide and diverse range of internal and external stakeholders.
• Demonstrated ability to apply project management principles, methodologies and best practices.
• Demonstrated successful experience of prioritizing work, making decisions and communicating with others within a values framework of respect, equity, anti-racism, diversity and inclusivity.

Additional Requirements:    

• Must be legally entitled to work in Canada, providing satisfactory documentation upon request.
• Ability to work 100% onsite, abiding by organization health and safety policies.
• Ability to declare personal Non-Conflict of Interest in execution of assignment responsibilities.
• Provision of certification of AODA and OHSA online training course completion prior to assignment start.
• Satisfactory Background Checks, Technical Skills Evaluations, and Employment References.

We thank all applicants for their interest but wish to advise that only those selected for an interview will be contacted.

Please note that Marberg Staffing updates job posts regularly, and external job boards may not reflect these changes in a timely fashion. Please refer to https://marberg.com/career-portal for the most current information including salary range.

Please note that Marberg Staffing only accepts applications through Indeed.ca, LinkedIn and marberg.com.

Marberg is committed to supporting workplace diversity and inclusivity, to reflect the demographic profile of all Ontarians.  Applications are encouraged from equity seeking groups including people of colour, Indigenous people, individuals with disabilities, and people from the LGBTQ2S community.