Data Analyst — Power BI, Python & Azure Data Pipelines

Goodwill Industries of Orange County CA; Santa Ana (CA); On-site; USD 70,000 - 90,000; Full time

Job summary

Goodwill Industries of Orange County CA is seeking a Data Analyst - IT to oversee data collection, trend analysis, and reporting on outcomes measurement tools. You will advise senior leadership on metrics data management and may prepare dashboards for Board Members.

You will collaborate across departments to develop dashboards and Power BI cards, statistics, and marketing materials, while working on related projects as assigned.

Qualifications

• Bachelor’s degree in a quantitative or technical field, or equivalent experience.
• Minimum 2+ years in data analytics, BI, or analytics engineering.
• Strong SQL with joins, window functions, CTEs, and tuning.
• Experience building Power BI reports/dashboards, data modeling and DAX.
• Proficiency in Python for data manipulation and analysis.
• Experience designing/maintaining data pipelines in Azure Data Factory.
• Experience with Azure SQL or Microsoft SQL Server.
• Minimum two years relevant data analyst experience.
• Ability to design/build/maintain data pipelines ingesting POS, production, ecommerce data, etc.
• Ability to develop/optimize SQL queries, stored procedures, and views against Azure SQL databases.
• Use Python and SQL for ad-hoc analysis, data exploration, and automation.
• Monitor data pipelines for errors, latency, and data quality; troubleshoot as needed.
• Excellent interpersonal communication with all levels of management, staff, and public.
• Ability to write accurate, concise memos and reports.
• Proficient with MS Office and Excel.
• Valid California driver’s license, liability insurance, and DMV record acceptable.

Responsibilities

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

Skills

SQL

Python

Interpersonal communication

Education

Bachelor’s degree in quantitative/technical field

Tools

Power BI

Azure Data Factory

Azure SQL

Job description

Goodwill Industries of Orange County CA is seeking a Data Analyst - IT to oversee data collection, trend analysis, and reporting on outcomes measurement tools. You will advise senior leadership on metrics data management and may prepare dashboards for Board Members.

You will collaborate across departments to develop dashboards and Power BI cards, statistics, and marketing materials, while working on related projects as assigned.