Data Analyst

Paycom - ATS; Milwaukee (WI); On-site; USD 65,000 - 90,000; Full time

Job summary

Next Door is seeking a Data Analyst to join our Information/Technology team in Milwaukee, Wisconsin. The successful candidate will help create and maintain master data sets, develop reports, and troubleshoot data issues to support agency-wide decision making.

Qualifications include a Bachelor's degree in computer science and 1–3 years of data analysis experience. Proficiency in Microsoft Excel and at least one BI tool is expected, with strong attention to detail and the ability to translate

Qualifications

• Bachelor’s degree in computer science.
• 1–3 years of data analyst experience.
• Proficiency in Excel and BI tools.
• Strong attention to detail and data quality.
• Ability to translate business requirements into technical specs.

Responsibilities

• Manage master data sets (create/update/delete).
• Provide QA of imported data.
• Develop and analyze data from multiple sources.
• Create reports and dashboards for stakeholders.
• Troubleshoot reporting database environment.

Skills

Data analysis

Attention to detail

Stakeholder communication

Requirements translation

Master data management

SQL basics

Education

Bachelor's degree in computer science

Tools

Microsoft Excel

Power BI

Tableau

SQL

Job description

Position OverviewWe 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/Duties/Functions/TasksManage 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 RequirementAll 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.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 RequirementsThe 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 RequirementsOther duties as assigned.Safety and HealthNext 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 DemandsPrimarily active work; occasionally lifting up, holding or moving up to 50 lbs.Physical ActivityBending, stooping, walking/transporting, handling.Work EnvironmentMainly office setting and travel to various sites for meetings.Personal/PhysiologicalAbility 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.