Data Specialist -(IT) at Amity Foundation

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. 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   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. What you will do: • 1. ETL (Extract, Transform, Load): • a) 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. • b) Collaborate with data engineers to optimize ETL pipelines for scalability, reliability, and performance. • c) Monitor and troubleshoot ETL processes to ensure data quality and consistency. • d) Automate ETL workflows to streamline data integration and reduce manual intervention. • 2. Data Visualizations: • a) Create interactive and visually appealing dashboards, reports, and data visualizations using Power BI, or other relevant software. • b) Connect Power BI to various data sources, including databases, APIs, and online services. • c) Transform raw data into meaningful insights, trends, and actionable information. • d) Collaborate with stakeholders to understand their reporting needs and provide tailored Power BI • 3. Data Governance: • a) Implement and enforce data governance practices, including data quality standards, data lineage, and metadata management. • b) Ensure compliance with data security and privacy regulations, including access controls and encryption. • c) Establish data retention policies and manage data archiving and purging processes. • d) Provide data-driven strategies that enhance operational efficiency and drive improvements. • 4. Documentation and Training: • a) Document ETL processes, API endpoints, and Power BI reports for knowledge sharing and troubleshooting. • b) Collaborate with department Data Manager to provide training and support to end-users and stakeholders on data access, API usage, and Power BI reporting. • 5. Continuous Learning and Innovation: • a) Stay updated with the latest industry trends, tools, and techniques in data analysis and visualization. • b) Identify opportunities for process improvement and automation to enhance data analysis efficiency. • 6. Performs other related duties as assigned. What You Will Bring: • 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. • • Certifications or Licenses: • Required: None • Preferred: None What we bring: • Medical, Dental, Vision. • Paid vacation, sick time, & holidays. • 401K, HSA, & Life insurance programs. • Organization committed to community action. • Community oriented workplace.