Data Analyst — ETL & Power BI (On-Site 3 Days/Week)

Lever, Inc.; New York (NY); On-site; USD 65,000 - 75,000; Full time

Job summary

Amity Foundation is seeking a Data Analyst (IT) to manage ETL processes, build Power BI visualizations, and enforce data governance. You will document data sources and collaborate with stakeholders to ensure data quality, security, and accessibility for decision-making.

The role focuses on ETL development, dashboards, and governance within an environment supporting prison and re-entry programs, emphasizing accuracy and actionable insights.

Qualifications

• 2-5 years experience or related work and/or Bachelor’s degree in a technical or other applicable discipline.
• 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.

Responsibilities

• 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.
• Data Visualizations: Create interactive and visually appealing dashboards, reports, and data visualizations using Power BI, or other relevant software.
• Data Governance: Implement and enforce data governance practices, including data quality standards, data lineage, and metadata management.
• Documentation and Training: Document ETL processes, API endpoints, and Power BI reports for knowledge sharing and troubleshooting.
• Continuous Learning and Innovation: Stay updated with the latest industry trends, tools, and techniques in data analysis and visualization.
• Performs other related duties as assigned.

Skills

ETL

Data Visualization

Data Governance

Documentation

Continuous Learning

Education

Bachelor’s degree in a technical or applicable discipline

2-5 years experience in data analytics

Tools

Tableau

Power BI

Apache NiFi

Python

Job description

Amity Foundation is seeking a Data Analyst (IT) to manage ETL processes, build Power BI visualizations, and enforce data governance. You will document data sources and collaborate with stakeholders to ensure data quality, security, and accessibility for decision-making.

The role focuses on ETL development, dashboards, and governance within an environment supporting prison and re-entry programs, emphasizing accuracy and actionable insights.