PURPOSE OF POSITION:
The purpose of this position is to oversee the Organization’s data collection, trend analysis and reporting on outcomes measurement tools. Acts as advisor to Senior Leadership Team regarding metrics data management. Coordinates and provides training reporting to Leadership Team. May also prepare dashboards for Board Members. Works collaboratively across departments on the development of dashboards, Power Bi cards, statistics and marketing materials. This position may also work on other projects as assigned.
SUPERVISION RECEIVED:
Reports directly to the Vice President of Information Technology.
SUPERVISION EXERCISED:
None.
MINIMUM JOB REQUIREMENTS:
1. Bachelor's degree in a quantitative or technical field (e.g., Computer Science, Statistics, Mathematics, Economics, Information Systems, Business Analytics), or equivalent professional experience.
2. Minimum 2+ years of professional experience in a data analyst, business intelligence, or analytics engineering role.
3. Strong proficiency writing SQL against relational databases, including joins, window functions, CTEs, and query performance tuning.
4. Demonstrated experience building reports and dashboards in Microsoft Power BI, including data modeling and DAX.
5. Working proficiency in Python for data manipulation and analysis (e.g., pandas, NumPy).
6. Hands-on experience designing or maintaining data pipelines in Azure Data Factory (or a comparable ETL/ELT tool).
7. Experience working with Azure SQL or other Microsoft SQL Server environments.
8. Minimum two years relevant experience in Data Analyst or similar environment preferred.
9. The ability to design, build, and maintain data pipelines in Azure Data Factory to ingest data from point of sales, production, ecommerce, and other systems.
10. The ability to develop and optimize SQL queries, stored procedures, and views against Azure SQL databases.
11. The ability to use Python and SQL to conduct ad-hoc analysis, data exploration, and automation of recurring tasks.
12. The ability to monitor data pipelines for errors, latency, and data quality issues; troubleshoot and remediate as needed.
13. Excellent interpersonal communication skills such as courtesy, sensitivity, politeness, and thoughtfulness in order to interact with all levels of management, employees, program participants, and the public.
14. Ability to write accurate, concise, grammatically correct letters, memos, reports, etc.
15. Proficient PC skills including current versions of Microsoft Office and Excel.
16. Valid California driver’s license, liability insurance, and a DMV record acceptable to Goodwill's insurance company.
Skills Required
- Bachelor's degree in a quantitative or technical field or equivalent professional experience
- Minimum 2+ years professional experience in data analyst, business intelligence, or analytics engineering
- Strong proficiency writing SQL against relational databases, including joins, window functions, CTEs, and query performance tuning
- Experience building reports and dashboards in Microsoft Power BI, including data modeling and DAX
- Working proficiency in Python for data manipulation and analysis (pandas, NumPy)
- Hands-on experience designing or maintaining data pipelines in Azure Data Factory or comparable ETL/ELT tool
- Experience working with Azure SQL or other Microsoft SQL Server environments
- Minimum two years relevant experience in Data Analyst or similar environment
- Ability to design, build, and maintain data pipelines to ingest data from POS, production, ecommerce, and other systems
- Ability to develop and optimize SQL queries, stored procedures, and views against Azure SQL databases
- Ability to use Python and SQL to conduct ad-hoc analysis, data exploration, and automation of recurring tasks
- Ability to monitor data pipelines for errors, latency, and data quality issues and remediate as needed
- Excellent interpersonal communication skills to interact with all levels of management and the public
- Ability to write accurate, concise, grammatically correct letters, memos, reports, etc.
- Proficient PC skills including current versions of Microsoft Office and Excel
- Valid California driver's license, liability insurance, and acceptable DMV record
What We Do
Our Mission: We help people achieve their goals through a journey of personal support, work experience, and career development. Our Vision: We envision a caring and connected community where everyone has access to meaningful career opportunities. We believe the power of work changes lives. We are Orange County’s leading nonprofit provider of education, training, and career services for people with disabilities as well as those with other barriers to independence. We enhance the dignity and quality of life of individuals, families, and communities by eliminating barriers to opportunity and helping them reach their fullest potential through powerful programs and services. Through the revenue generated from donated goods sold in our stores throughout Orange County including shopgoodwill.com, we strengthen our capacity to achieve our mission through this unique social enterprise. In addition to retail operations, diverse revenue streams also include document destruction services, e-waste collections, packaging and assembly services and workforce development.
