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:
SQL and MS SQL Server – strong working knowledge of database querying, management, and data analysis.
ETL tools and data integration techniques – experience extracting, transforming, and loading data from multiple sources.
Microsoft Excel and Power BI – skilled in using advanced Excel functions and creating data visualizations and dashboards in Power BI.
Familiarity with QGIS – working knowledge of spatial data tools and formats such as Shape files and GeoJSON is considered an asset.
Understanding of demographic and socio-economic datasets – including census and population-level data used in community-based analysis and reporting.
EDUCATION & EXPERIENCE   Post‑secondary degree or diploma in Data Analytics, Computer Science, GIS, or related field
Minimum 1–2 years of experience in data analysis or ETL development (warehouse and/or geospatial experience preferred)
Strong problem-solving and communication skills
APPLICATION PROCESS & ACCOMMODATIONS   If you have the above-mentioned qualifications, please submit your resume and cover letter by 6pm, January 12, 2026, to  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, 2

SLGBTQ+ 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  to ensure an inclusive recruitment experience.

#J-18808-Ljbffr