Data Analyst

Amity Foundation, an internationally acclaimed Teaching, and Therapeutic Community is seeking compassionate and enthusiastic individuals with a desire to teach, learn and join our community as a Data Analyst (IT). This groundbreaking opportunity will allow you to work with our prison and re-entry programs helping the community and will also enhance your training and experience in the field.   About Amity: Amity Foundation is a safe place where people can change in an environment that fosters trust; where new values can be formed; responsibility developed, and lasting relationships built. Amity is dedicated to the inclusion and habilitation of people marginalized by addiction, homelessness, trauma, criminality, incarceration, poverty, racism, sexism, and violence. Amity is committed to research, development implementation, and dissemination of information regarding community building.   Remembrance, Resolution, Reconciliation, Restoration, Renewal

Job Summary

About the Position: As a Data Analyst, you 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. Your role is essential in ensuring that data is accurate, accessible, and actionable for informed decision-making for all key stakeholders.

About The Position

Essential Duties:

1. ETL (Extract, Transform, Load):
   1. 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.
   2. Collaborate with data engineers to optimize ETL pipelines for scalability, reliability, and performance.
   3. Monitor and troubleshoot ETL processes to ensure data quality and consistency.
   4. Automate ETL workflows to streamline data integration and reduce manual intervention.
2. Data Visualizations:
   1. Create interactive and visually appealing dashboards, reports, and data visualizations using Power BI, or other relevant software.
   2. Connect Power BI to various data sources, including databases, APIs, and online services.
   3. Transform raw data into meaningful insights, trends, and actionable information.
   4. Collaborate with stakeholders to understand their reporting needs and provide tailored Power BI
3. Data Governance:
   1. Implement and enforce data governance practices, including data quality standards, data lineage, and metadata management.
   2. Ensure compliance with data security and privacy regulations, including access controls and encryption.