Nonprofit Data and Reporting Analyst at IOCP

Full-timeDescriptionIOCP is searching for its next Data and Reporting Analyst. Please read on below for more information about this position and how you can apply!Why usStar Tribune Top Workplace!Full-time benefits eligibleMedical Dental Vision Life Insurance Long Term Disability FSA HSA 401(k)Nine paid holidaysGenerous PTO (starting at 21 days annually)Hybrid work environmentCompensation: $61266 - $64329 annuallyWhy youYou are a great teammate; you love working with people in a team environmentYou are optimistic fun and energeticYou want to be at IOCP. You want to be about our mission. You want to do this work with this team in this communityYou are not a coder but you have strong analytical skills experience and comfort working with structured data within business systemsYou know how to make data tell the story through spreadsheets and visualizationsWhat is the workReporting and AnalysisUtilize database ClientTrack (CT) query tool to extract data from databaseCollaborate with internal teams to understand reporting needsUtilize reporting tools including Excel to model analyze and visualize dataPrepare structure and validate data to ensure accuracy before reportingEnsure high data quality by identifying and resolving data and reporting issuesMaintain update and deliver required reporting on monthly quarterly and annual cyclesCreate dashboards to demonstrate program and agency impactCommunicate results with stakeholders so data is understood and actionableClientTrack Database AdministrationManage CT database system configurationPartner with Director of Client Experience Client Data Analytics Manager and Client Services team to define and prioritize database changes that meet program processes and provide required dataManage database user access and administrative tasksMaintain and update CT user documentationCollaborate with external data consultant to maintain database and ensure it is meeting core functionsTroubleshoot and solve database issues encountered by end usersAbout IOCPWe are a human service nonprofit that provides services in food case management emergency financial assistance employment services and childcare resources to those residing in our service area. Our clients and staff come from all walks of life! Inclusionary relationships are core to our role as an employer service provider partner and community leader. We embrace diversity and are committed to promoting an inclusive environment across all types of difference. Our work environment is client centered values driven team oriented diverse and focused on learning and professional development. We have a strong internal culture of collaboration and team support and a deep commitment across staff to our mission and values. Supervisors are extremely supportive of self-care will help you grow and give you a platform to do amazing work. Our team is tight knit supportive and has fun together! Learn more about us here: youd be a great fit for our team Please complete our application including submission of a resume. Candidates are considered as submissions arrive. Position is open until filled.IOCP values a diverse work environment.People of color and people from other underrepresented communities are strongly encouraged to apply.IOCP is an Equal Opportunity Employer.RequirementsRequired Work Experience:3 years of related work experience with data-focused responsibilities and delivering reportsAdvanced computer skills including use of Microsoft Office and data reporting toolsAdvanced proficiency with Excel including but not limited to: advanced formulas lookups tables and pivot tablesExperience in data quality review and report developmentAbility to explain analytical results to non-technical audiencesLogical thinker; ability to critically analyze informationEffective oral and written communication and interpersonal skillsDetail-oriented high accuracy in work productAbility to multitaskSalary Description$61266 - $64329 annuallyRequired Experience:IC Key Skills Cognos,Microsoft Access,SQL,Crystal Reports,Financial Report Writing,Power BI,Pivot tables,ssrs,Tableau,Regulatory Reporting,SAS,Data Analysis Skills Employment Type : Full-Time Experience: years Vacancy: 1 Yearly Salary Salary: 61266 - 64239