Data Analyst - IT

Goodwill; Santa Ana (CA); On-site; USD 93,600 - 127,462; Full time

Job summary

Goodwill in Santa Ana, CA is seeking a data analyst - IT to oversee data collection, trend analysis and reporting. The role includes advising senior leadership on metrics and coordinating dashboards and marketing materials across departments.

Responsibilities include building Power BI reports, data modeling, and maintaining data pipelines in Azure Data Factory and Azure SQL. A Bachelor's degree and 2+ years of experience are required.

Qualifications

• Bachelor's degree in a quantitative or technical field or equivalent professional experience.
• Minimum 2+ years of professional experience in a data analyst, BI, or analytics role.
• Strong proficiency writing SQL against relational databases, including joins, window functions, and CTEs.
• Experience building reports and dashboards in Power BI, including data modeling and DAX.
• Proficiency in Python for data manipulation and analysis (pandas, NumPy).
• Hands-on data pipelines experience in Azure Data Factory and Azure SQL environments.

Responsibilities

• Oversee data collection, trend analysis and reporting on outcomes measurement tools.
• Advise Senior Leadership Team regarding metrics data management and report preparation.
• Coordinate and provide training on reporting; prepare dashboards for Board Members.
• Collaborate across departments to develop dashboards, Power BI cards, statistics and marketing materials.

Skills

SQL

Power BI

Python

Azure Data Factory

Azure SQL

Data pipelines

Education

Bachelor's degree in a quantitative or technical field

Tools

MS Excel

Power BI

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Data Analyst - IT

Full Time Professional Santa Ana, CA, US

6 days ago Requisition ID: 2440

Salary Range: $93,600.00 To $127,462.00 Annually

NOTE: Maximum range is provided as an example of the wage/salary range for each position and its earning capacity given factors such as time in position, longevity with the company education level, and performance experience. New employees should expect to enter at the minimum to midrange level, and not the cap which is for employees with tenure and above level skill sets in that position.

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

• Bachelor's degree in a quantitative or technical field (e.g., Computer Science, Statistics, Mathematics, Economics, Information Systems, Business Analytics), or equivalent professional experience.
• Minimum 2+ years of professional experience in a data analyst, business intelligence, or analytics engineering role.
• Strong proficiency writing SQL against relational databases, including joins, window functions, CTEs, and query performance tuning.
• Demonstrated experience building reports and dashboards in Microsoft Power BI, including data modeling and DAX.
• Working proficiency in Python for data manipulation and analysis (e.g., pandas, NumPy).
• Hands-on experience designing or maintaining data pipelines in Azure Data Factory (or a 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 preferred.
• 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.
• The ability to develop and optimize SQL queries, stored procedures, and views against Azure SQL databases.
• The ability to use Python and SQL to conduct ad-hoc analysis, data exploration, and automation of recurring tasks.
• The ability to monitor data pipelines for errors, latency, and data quality issues; troubleshoot and remediate as needed.
• 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.
• 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 a DMV record acceptable to Goodwill's insurance company.