Data Analyst - IT

Amity Foundation•3763 South Hill St. LA CA 90007, WA

46d•Hybrid

About The Position

Amity Foundation is seeking a compassionate and enthusiastic Data Analyst (IT) to join their team. This role will involve working with prison and re-entry programs, enhancing training and experience in the field. The Data Analyst will be responsible for the efficient extraction, transformation, and loading (ETL) of data from various sources, creating and maintaining documentation of all data sources, and developing insightful data visualizations using business intelligence tools such as Power BI. The role is essential in ensuring that data is accurate, accessible, and actionable for informed decision-making for all key stakeholders.

Requirements

2-5 years experience or related work and/or Bachelor’s degree in a technical or other applicable discipline.
Proven experience as a Data Analyst or similar role, with a track record of successfully delivering data-driven insights.
Proven experience in data visualization tools such as Tableau, Power BI, or similar (non-Excel) software.
Proven experience in ETL development, including proficiency with ETL tools (e.g., Apache NiFi, Python).
Understanding of data governance principles, data security, and compliance regulations.
Strong problem-solving skills and attention to detail.
Excellent communication and collaboration skills to work with cross-functional teams and stakeholders.
Ability to adapt to evolving data technologies and industry best practices.

Nice To Haves

Programming skills, including knowledge of scripting languages (e.g., Python, PowerShell) for automation.
Expertise in API development and management, with knowledge of RESTful API design principles.
Demonstrated experience with one or more of the following modern data management concepts - data lakes, nonrelational databases (NoSQL), cloud hosting (AWS), serverless storage or automated database recovery.
Project management.
Certifications or Licenses: None

Responsibilities

Design and implement ETL processes to extract data from diverse sources, transform it into a usable format, and load it into databases or data warehouses.
Collaborate with data engineers to optimize ETL pipelines for scalability, reliability, and performance.
Monitor and troubleshoot ETL processes to ensure data quality and consistency.
Automate ETL workflows to streamline data integration and reduce manual intervention.
Create interactive and visually appealing dashboards, reports, and data visualizations using Power BI, or other relevant software.
Connect Power BI to various data sources, including databases, APIs, and online services.
Transform raw data into meaningful insights, trends, and actionable information.
Collaborate with stakeholders to understand their reporting needs and provide tailored Power BI solutions.
Implement and enforce data governance practices, including data quality standards, data lineage, and metadata management.
Ensure compliance with data security and privacy regulations, including access controls and encryption.
Establish data retention policies and manage data archiving and purging processes.
Provide data-driven strategies that enhance operational efficiency and drive improvements.
Document ETL processes, API endpoints, and Power BI reports for knowledge sharing and troubleshooting.
Collaborate with department Data Manager to provide training and support to end-users and stakeholders on data access, API usage, and Power BI reporting.
Stay updated with the latest industry trends, tools, and techniques in data analysis and visualization.
Identify opportunities for process improvement and automation to enhance data analysis efficiency.
Performs other related duties as assigned.