Data Analyst

Next Door Milwaukee; Milwaukee (WI); On-site; USD 60,000 - 90,000; Full time

Job summary

Next Door Milwaukee is seeking a Data Analyst to join its Information/Technology team. You will help create and manage the master data set, develop reports, and troubleshoot data issues, requiring a sharp eye for detail and hands-on experience with data analysis tools and databases.

Responsibilities include QA of data, building and interpreting reports and dashboards, supporting data integrity, and training end users.

Qualifications

• Bachelor’s degree in computer science.
• 1–3 years of work experience in data analytics or related field.
• Ability to work with stakeholders to assess potential risks.
• Ability to analyze existing tools and databases and provide software solution recommendations.
• Translate business requirements into non-technical terms.
• Adept at queries, report writing and presenting findings.
• Strong analytical skills with handling large data sets and relational databases.
• Expert in Microsoft Excel and various business intelligence, analytical and data visualization tools.

Responsibilities

• Manage master data sets, including creation, updates, and deletion.
• Provide quality assurance of imported data.
• Process confidential data according to guidelines.
• Develop and analyze data from multiple sources and provide detailed analyses.
• Interpret data and provide ongoing reports.
• Explain data meaning to teams and stakeholders for process improvement.
• Create statistical models depicting agency-wide trends.
• Test and validate data sets.
• Design and manage the reporting environment and metadata.
• Support reporting requirements and data integrity initiatives.
• Assist with testing/new systems and strategic decisions.
• Generate reports from multiple systems and troubleshoot reporting environments.
• Train end users on new reports and dashboards.

Skills

Data analysis

Stakeholder communication

SQL queries

Excel BI tools

Attention to detail

Education

Bachelor’s degree in computer science

Tools

SQL

Reporting tools

BI tools

Job description

Position Overview

We are looking to hire a Data Analyst to join our Information/Technology team. The ideal candidate will assist in creating/managing our master data set, developing reports, and troubleshooting data issues. To do well in this role the candidate will need a very fine eye for detail, have experience as a data analyst, and a deep understanding of popular data analysis tools and databases.

Responsibilities

• Manage master data sets, including creation, updates, and deletion.
• Provide quality assurance of imported data.
• Process confidential data and information according to guidelines.
• Develop and analyze data from multiple data sources and provide detailed analysis in a comprehensive way to team and all stakeholders.
• Interpret data, analyze results using statistical techniques, and provide ongoing reports.
• Determine the meaning of data and explain how various teams and stakeholders can leverage it to improve processes.
• Create statistical models that depict agency-wide trends.
• Perform tests and validation of data sets.
• Manage and design the reporting environment, including data sources and metadata.
• Support employees in identifying and revising reporting requirements.
• Support initiatives for data integrity and normalization.
• Assist with testing and implementing new or upgraded software and assist with strategic decisions on new systems.
• Generate reports from single or multiple systems.
• Troubleshoot reporting database environment and reports.
• Assist with training end users on new reports and dashboards.

Accountability and Performance Requirement

All staff members are accountable for knowing and performing the responsibilities associated with their individual position in an efficient and effective manner, understanding that each of us plays an integral role in the success of our mission. All staff will support the agency mission, vision, standards of conduct/code of ethics and strategic directions and support administrative decisions. This must be demonstrated by maintaining a positive work environment, and by behaving and communicating in an appropriate manner with children, families, coworkers, supervisors and the public while achieving performance expectations.

Qualifications

• Bachelor’s degree from an accredited university or college in computer science.
• At least 1-3 years of work experience in a data analyst or in related field.
• Ability to work with stakeholders to assess potential risks.
• Ability to analyze existing tools and databases and provide software solution recommendations.
• Ability to translate business requirements into non-technical, lay terms.
• Adept at queries, report writing and presenting findings.
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
• Demonstrated experience in handling large data sets and relational databases.
• Expert in Microsoft Excel and various business intelligence, analytical and data visualization tools.
• Understanding of addressing and metadata standards.
• High-level written and verbal communication skills.
• Keen attention to detail.
• Perform other duties as assigned.

Special Position Requirements

• The incumbent must have access to a personal vehicle to use on a daily basis, maintain a valid driver’s license and automobile insurance with liability limits of $300,000 (bodily injury) and $25,000 (property damage for each occurrence). Ability to work under tight deadlines and good writing required.

Work Requirements

• Other duties as assigned.

Safety and Health

Next Door is committed to providing a safe work environment and to fostering the well-being and health of its employees. An essential part of each employees’ job is the development of safe working practices and the observance of safety rules, including:

• Following safety warnings and directions at all times.
• Using personal safety devices when required.
• Reporting any unsafe conditions to supervisor.
• Following process for reporting suspected child abuse and neglect.
• Reporting unsupervised children, after ensuring child’s safety.
• Implement active supervision practices at all times, including transition times.
• Ensure knowledge of each assigned child’s location at all times.

Physical Demands

• Primarily active work; occasionally lifting up, holding or moving up to 50 lbs.

Physical Activity

• Bending, stooping, walking/transporting, handling.

Work Environment

• Mainly officesetting and travel to various sites for meetings.

Personal/Physiological

• Ability to make frequent, significant decisions to understand and react to the development process of children.
• Ability to respond quickly and competently to an emergency or crisis situation in order to keep children safe.