Data Analyst - IT

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:

• ETL (Extract, Transform, Load):
  • 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.
• Data Visualizations:
  • 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
• Data Governance:
  • 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.
• Documentation and Training:
  • 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.
• Continuous Learning and Innovation:
  • 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.

Education and Experience:

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

ADA Information:

Physical Requirements:

• Occasionally adjusts or moves objects up to 50lbs. in all directions.
• Constantly remains in a stationary position often standing or sitting for prolonged periods.
• Repeats motions that may include the wrists, hands and / or fingers.
• Constantly moves from one work yard to another daily.
• Frequently walks on hard or uneven surfaces.
• Required to communicate verbally and in written form.
• Uses all types of vision, such as close vision, distance vision, color vision, peripheral vision, and depth perception, to complete daily tasks.
• Assesses the accuracy, neatness and thoroughness of the work assigned.
• Occasionally required to climb, bend, stretch, reach, or stoop.
• Required to wear comfortable and location appropriate clothing and shoes.

Mental Demands:

• Ability to change directions as a priorities shift.
• Ability to thrive in environment that require the ability to adapt to changing circumstances,
• Ability to cope with occasionally difficult or temperamental students and faculty.
• Ability to cope with mental and emotional stress related to the position.

Work Conditions:

• Generally, in an indoor setting.
• Occasionally works in outdoor elements such as precipitation, snow, and wind.
• Work is in an incarcerated setting.

Environmental Conditions:

• The noise level in the work environment is usually moderate but can be loud.
• The temperature in the work environment is generally moderate, however can range from hot to cold seasonally.
• Seldom may be exposed to non-lethal chemical agents as administered in necessary use of force security instances.

Travel:

• Occasionally travels locally and operates motor vehicles.