Apply on Employer Site

Amity Foundation · 4 weeks ago

Data Specialist -(IT)

3763 South Hill St. LA CA 90007

Full-time

Onsite

Entry, Mid Level

$50K/yr - $60K/yr

2+ years exp

Amity Foundation is an internationally acclaimed Teaching and Therapeutic Community seeking a compassionate Data Analyst. In this role, you will be responsible for the efficient extraction, transformation, and loading of data, creating insightful visualizations, and ensuring data governance and quality for informed decision-making.

CommunitiesNon ProfitSocial Impact

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

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

Qualification

ETL developmentData visualizationData governancePower BIPythonProblem-solvingCommunication skillsCollaboration skillsAdaptabilityProject management

Required

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

Preferred

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