In PersonOnsite in Los Angeles; occasional local travel.
Data & AnalyticsData Engineering, Business Intelligence
About the job
Requirements
At least 2 years of experience or related work, and/or a bachelor's degree in a technical or other applicable discipline.
Proven experience as a Data Analyst or in a similar role, with a track record of delivering data-driven insights.
Proven experience with data visualization tools such as Tableau, Power BI, or similar non-Excel software.
Proven experience in ETL development, including proficiency with ETL tools such as Apache NiFi or Python.
Understanding of data governance principles, data security, and compliance regulations.
Ability to adapt to evolving data technologies and industry best practices.
Ability to adjust or move objects up to 50 pounds in all directions; remain stationary for prolonged periods; perform repetitive wrist, hand, or finger motions; move between work yards daily; walk on hard or uneven surfaces; communicate verbally and in writing; use close, distance, color, peripheral, and depth vision; and occasionally climb, bend, stretch, reach, or stoop.
Ability to change direction as priorities shift and adapt to changing circumstances.
Ability to cope with occasionally difficult or temperamental students and faculty and with mental and emotional stress related to the position.
Ability to work indoors and occasionally outdoors in precipitation, snow, and wind, and to work in an incarcerated setting with noise levels that may be loud and temperatures that vary seasonally.
Ability to travel locally occasionally and operate motor vehicles.
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 dashboards, reports, and data visualizations using Power BI or other relevant software.
Connect Power BI to databases, APIs, and online services.
Transform raw data into meaningful insights, trends, and actionable information.
Collaborate with stakeholders to understand reporting needs and provide tailored Power BI reporting.
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 the department Data Manager to provide training and support to end users and stakeholders on data access, API usage, and Power BI reporting.
Stay updated on industry trends, tools, and techniques in data analysis and visualization.
Identify opportunities for process improvement and automation to enhance data analysis efficiency.
Perform other related duties as assigned.
Desired Qualifications
Programming skills, including knowledge of scripting languages such as Python or 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.
Salary Range: 65000 to 75000 (Currency: USD) (Pay period: per-year-salary)
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.
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.
Note: This job description is intended to describe the general nature and work responsibilities of the position. It is not possible or desirable to commit every detailed aspect of each job to a written description. This job description and the duties of this position are subject to change, modification, and addition as deemed necessary by the company. Job descriptions alone cannot be used as an argument to refuse work assignments. Faculty are required to comply with supervisory instructions and perform other job duties, responsibilities and assignments required by company officials. This job description does not constitute an employment contract between the company and any employee. The job responsibilities of this position may include cross-training in other functions to ensure satisfactory operation.