DATA ANALYTICS AND SYSTEM ADMINISTRATION SPECIALIST

Catholic Charities; City of Rochester (NY); On-site; USD 68,000 - 70,000; Full time

Benefits offered by this job

Competitive salary

403b plan

Generous time off

Comprehensive benefits

Growth opportunities

Meaningful impact

Job summary

Catholic Charities is seeking a Data Analytics and System Administration Specialist to maintain data dashboards, administer systems, and collaborate with program leaders to define data requirements.

The role involves developing new data sets, implementing ETL processes, and training users while upholding confidentiality and trauma-informed care guidelines.

Qualifications

• Bachelor’s degree in business, data sciences, IT, or related field.
• Three years of IT or business analytics experience with Power BI and ETL.
• Experience with Microsoft 365 suite including SharePoint, Power Automate, Forms and Teams.
• Knowledge of working with secure data environments and data security.

Responsibilities

• Maintain and document current data analytics dashboards.
• Develop new data sets and dashboards in collaboration with program leaders.
• Serve as primary contact for troubleshooting data analytics platforms.
• Design data tools to support programmatic decisions.
• Implement automated ETL processes to improve operations.
• Develop and support SharePoint and Teams intranet usage.

Skills

Power BI

DAX

SQL

Python

Data Analytics

Education

Bachelor’s degree in business, Data Sciences, IT, or related field

Tools

SharePoint

Teams

Power Automate

Forms

Job description

Description

We are Hiring!

Catholic Charities Family and Community Services (CCFCS) has been serving our community for over 100 years. We walk with people when they are at their most vulnerable as they journey toward independence to reach their full human potential. We proudly serve and employ people from all backgrounds and experiences.

If you're looking for more than just a job, if you're passionate about making a meaningful impact on the lives of others, join a team that changes lives every day. Be a part of something truly special.

Employment Type:

Full-Time

Schedule:

M-F, 8-4

Salary:

$68k-70k

Top Benefits and Perks:

• Competitive salary and 403b retirement plan
• Generous time off package and work-life balance
• Comprehensive benefits package
• Supportive and collaborative environment
• Opportunities for growth and development
• Intrinsic reward of truly making a difference in people's lives

Qualifications

Education: Bachelor’s degree in business, Data Sciences, Information Technology, System Administration, or related field. Equivalent combination of education and experience will be considered.

Experience: Three years of experience working in IT or Business position demonstrating Process and Data Analytics deliverables. Experience in Power BI, Microsoft Office 365 suite including SharePoint, Power Automate, Forms and Teams. Experience with extract/transform/load (ETL) processes.

Experience working with highly secure data environments. Programming experience: DAX (required); other desirable: C#, SQL, Python. Experience with Comply Track, Financial Edge and EHR systems is highly desirable. A combination of education and experience will be considered.

About the role:

Activities will be performed under general supervision and will follow the Agency’s guidelines to maintain confidentiality. The Data Analytics and System Administration Specialist provides ongoing maintenance of currently data sets and dashboards, system administration and support development of new data sets and dashboards by partnering with functional and program leaders to identify business process requirements and data analytics to address ongoing operational and process improvement needs. Effectively supports ongoing and collaborative communication amongst all program staff and is responsible for ensuring a trauma informed care environment.

Key Responsibilities

• Updates, operates, and documents maintenance activities for current data analytics dashboards.
• Assists with the development and tests use of newly formed data sets and dashboards.
• Serves as primary contact for trouble shooting and problem solving with data analytics platforms and dashboards
• Participates in meetings with agency leaders and functional programs to design, develop and establish data tools to assist program leaders in meeting requirements and/or making programmatic decisions
• Assists with implementing structure data analytics utilizing data automation (extract/transform/load, ETL) processes to minimize day to day operational intervention and ensure data security
• Develops, maintains and serves as primary contact for agency SharePoint and Teams Intranet suite
• Serves as lead system administration to commercial or funder platforms as assigned
• In coordination with leadership and/or administrative services, develops automated processes using Microsoft Office Suite tools and data platforms
• Assists in the development of data operations and analytics standards and processes.
• Develops and provides data analytic reports to leadership as requested.
• Develops and facilitates training for targeted users of data analytics to ensure ease of understanding and utilization of data analytics.
• Develops and facilitates training for assigned platforms and serving as system administrator
• Provides guidance for data analytics and reporting within multiple data systems used throughout the agency.
• Participates in relevant Agency meetings and/or trainings
• Actively pursues development of professional competencies related to job role performance through reading, supervision, in-service training and attendance at conferences and workshops.
• Awareness and active support of the Agency's Mission, Vision, Values and Strategic Plan. Including, but not limited to, supporting the Agency's Core Competency initiatives of being Collaborative and Community Focused, Innovative and Entrepreneurial, and Culturally Competent and Diverse
• Other duties as assigned

Note: The above description is illustrative of tasks and responsibilities. It is not meant to be all inclusive. Employees are required to follow appropriate supervisory direction and perform other related duties as required.