Data Warehouse Analyst

Reports to : Senior Vice-President, Finance & Operations

Location : Remote

Contract Duration : 3 Months

Hourly Wage Range : $30.22 – $32.97

At United Way Centraide Windsor-Essex Chatham-Kent we are reimagining what it means to serve our community in the digital age. While our promise to support children and families from cradle to career remains steadfast, we are driving change through innovation – modernizing our systems, harnessing data to deepen our impact, and exploring new and sustainable ways to fund our mission. Every role in our organization plays a part in this transformation toward a smarter, more sustainable future for our community.

POSITION SUMMARY

The Data Warehouse Analyst supports warehouse operations and contributes to the development of the Neighbourhood Opportunity Index (NOI). This role focuses on designing and maintaining ETL processes to integrate diverse datasets and prepare them for analysis, loading program and community data from partners into the warehouse, and supporting mapping and visualization tasks. Experience with QGIS and spatial data formats is considered an asset.

KEY FUNCTIONS

40% – Writing and optimizing SQL queries for data extraction, validation, and reporting.

30% – Designing and maintaining ETL workflows to integrate warehouse, program, and geospatial datasets.

20% – Loading partner data into the warehouse and preparing exports for program reporting.

10% – Supporting mapping and visualization tasks for NOI and operational dashboards.

CORE COMPETENCIES & DUTIES

Core Competencies –

Analytical Thinker : Ability to interpret complex data and identify trends to support decision‑making

Detail‑Oriented : Ensures accuracy and integrity in all data processes

Collaborative : Works effectively with technical and non‑technical stakeholders

Results‑Driven : Focused on delivering actionable insights that improve warehouse operations and community outcomes

Duties –

• Load program and community data from external partners into the data warehouse and ensure proper formatting for reporting
• Develop and maintain ETL processes to extract, transform, and load data from multiple sources (warehouse systems, demographic datasets, geographic layers)
• Prepare and structure data for the Neighbourhood Opportunity Index (NOI), ensuring proper integration of socio-economic indicators and spatial boundaries
• Support mapping and visualization tasks using tools such as QGIS (asset) or equivalent for layering geographic datasets
• Write and optimize SQL queries stored procedures for data analysis and reporting
• Create dashboards and reports using Power BI or similar tools to visualize warehouse KPIs and NOI metrics
• Collaborate with stakeholders to define KPIs, spatial boundaries, and reporting requirements.
• Ensure data quality and integrity across all systems and geospatial layers.
• Document workflows and provide training to enhance data literacy.

Technical Skills – In addition to the competencies outlined above, you are proficient in the use of the following tools and technologies :

EDUCATION & EXPERIENCE

APPLICATION PROCESS & ACCOMMODATIONS

If you have the above-mentioned qualifications, please submit your resume and cover letter by 6pm, January 12, 2026, to tocareers@weareunited.com. We thank all applicants for their interest; however, only those selected for an interview will be contacted.

United Way recognizes that a diverse team strengthens our impact. We encourage applications from Indigenous peoples, racialized individuals, persons with disabilities, 2SLGBTQ+ candidates, and those with lived experiences relevant to our mission. If you require accommodations at any stage of the hiring process, please contact us at careers@weareunited.com to ensure an inclusive recruitment experience.

#J-18808-Ljbffr