Senior SSRS Developer

Senior SSRS Developer

Job ID: 320878
Location: District Support Services Cntr
Full/Part Time: Full Time
Regular/Temporary: Regular

Salary Range

$88,586.00 - $115,161.00/annually, DOE

Grade

122

Work Schedule

Monday - Friday, 8am - 5pm
Summer Hours: Monday - Thursday, 7am-6pm

Work Calendar

12 Months

Maricopa Summary

Are you looking for a place to work where you can make a real difference in the lives of over 200,000 college students every year?

Would you like to be part of an organization that adds $7.2 billion dollars to the economy and supports nearly 100,000 jobs in the fastest growing county in the United States?

Whether you're teaching, working, or learning Make It Happen At Maricopa County Community Colleges!

About Us

What's Currently Happening at Maricopa

• Many of our campuses have received grant awards through the National Science Foundation to improve undergraduate STEM Education: Hispanic-Serving institutions program (HSI Program).
• Commitment to diversity, inclusion, equity and employee groups to create an environment of shared governance
• One of the largest community college systems in the country
• 2020 Healthy Arizona Worksites Program recipient
• Named 19th Best Employer for Women by Forbes
• 2019 No. 42 in Arizona's Best Employers

Benefits

The Maricopa County Community College District (MCCCD) is committed to providing you with a competitive, comprehensive benefits program that provides the care you and your family need to lead healthy and productive lives. Our benefits are designed to provide support for every life stage and lifestyle in our community.

Benefits & Perks Options:

• 20 paid observed holidays
• Arizona State Retirement System (ASRS) & 12% Employee Contribution Match (Pension, Long Term Disability, and Health Insurance)
• Paid vacation, sick, and personal time
• Maricopa Employee Store: Perks & Gears (exclusive discounts and offers for Maricopa Community Colleges faculty and staff)
• Annual professional development growth funding
• Tuition reimbursement for employees and dependents
• Flexible work schedules
• Maricopa Employee Health & Wellness Program:
  • Sight-On-Site Eye Care Services
  • Diabetes Empowerment Education Program
  • Mobile On-site Mammography Screenings
  • Employee Assistance Program (EAP)
  • Wondr online program that teaches clinically-proven, healthy habits that lead to less stress, better sleep, weight loss, and more.
  • Pre-Retirement Events
• Public Service Loan Forgiveness (may forgive the remaining balance on a federal student loan made directly by the U.S. Department of Education after qualifying).
• 10+ Maricopa Affinity Resource Employee Groups (Celebrates diversity, embraces inclusion, and supports employees, students, and community!)

Job Summary

Information Technology Services (ITS) at the MCCCD is looking for an experienced Senior SQL Server Reporting Services (SSRS) Developer. This role will lead report development and support activities for MCCCD's ten community colleges and District Office. The Sr SSRS Developer will be a technical subject matter expert over report development using SSRS tools, as well as a SQL expert. This role will be the primary contact for development of new reports, changes to existing reports, supporting ETL processes, and managing the documentation of SSRS reports. Additionally, the Sr SSRS Developer will have the opportunity to coach and mentor technical staff and collaborate with college and district staff to provide solutions for business needs.

Come be a part of an award-winning organization and technology team.

Maricopa is a great place to work! Forbes has ranked Maricopa County Community College District (MCCCD) as #42 Best Employer in the State of Arizona in 2023. Additionally, Forbes ranked MCCCD as the #69 Best Employer for Women in August 2022, placing it at #5 in higher education.

Essential Functions

30% - Creates, deploys, and manages SSRS reports to meet customer needs; creates visually appealing and interactive reports to deliver actionable information to business units.

30% - Develops and optimizes SQL queries and creates and updates data flows from various data sources such ERP applications.

10% - Collaborates with functional team members and report users to gather and document report requirements; maintains up-to-date documentation of existing and new reports.

10% - Assists district and college developers with complex technical questions and issues related to accessing data and developing SSRS reports.

5% - Oversees report organization, report access, and user security on the SSRS report portals; SSRS Liaison for the district office for governance that provides SSRS operational report services to ten colleges and the district offices.

5% - Ensures the SSRS apps, developer tools, and security certificates are upgraded on a regular basis according to vendor releases and business requirements.

5% - Troubleshoots, tests, and resolves related support issues; performs system upgrades and patches.

5% - Performs other related duties as assigned.

Minimum Qualifications

Bachelor's Degree in information technology or directly related field and four (4) full-time equivalent years of technical experience in programming, systems analysis, design and development of system software and applications.

OR

An equivalent combination of the conferred degree, education, certification and directly related full-time work experience as described above sufficient to successfully perform the essential duties of the job such as those listed above, unless otherwise subject to any other requirements set forth in law or regulation, may be considered.

Desired Qualifications

1. Experience building reports using enterprise reporting tools such as Microsoft SQL Server Reporting Services (SSRS) or Power BI.
2. Experience working with relational databases such as advanced query writing, table creation and manipulation, query optimization, or code debugging.
3. Experience gathering and documenting report requirements and translating them to operational reports/dashboards.
4. Experience with enterprise applications data such PeopleSoft Campus Solutions, Human Capital Management, and Financials Management.
5. Experience managing customer service requests through a ticketing system such as JIRA, SysAid, or Team Dynamics.
6. Experience independently managing complex projects.

Special Working Conditions

This position is located in Tempe, AZ, and requires at least two days onsite.

MCCCD does not sponsor individuals for any type of work visas.

May be required to sit for a prolonged period of time; viewing a computer monitor.

How to Apply

Applicants are strongly encouraged to submit a cover letter that details how the applicant meets the minimum and desired qualifications. A cover letter may further highlight an applicant's knowledge, skill and abilities. All minimum requirements must be met at the time of the application.

Additional materials will not be accepted after the job posting has closed.

Missing materials or incomplete employment history will not be considered.

Please ensure your materials clearly provide the following information.

• Clearly illustrate how prior experience, knowledge and education meet the minimum and desired qualifications for this position.
• Indicate whether former or current employment is Full-Time or;
• Part-Time employment (must include number of hours worked)
• Provide employment history in a month/year format (e.g., 09/07 to 10/11) including job title, job duties, for each position held and name of employer for each position.
• Three professional references, preferably current and/or former supervisors. If references are not provided in resume upon application, they will be requested at time of interview.

Posting Close Date

Open until filled.

First Review: Monday, January 6th, 2025.

Applications received after the review date may not be screened.

EEO, Title IX, & Clery Act

Maricopa County Community College District (MCCCD) will not discriminate, nor tolerate discrimination in employment or education, against any applicant, employee, or student because of race, color, religion, sex, sexual orientation, gender identity, national origin, citizenship status (including document abuse), age, disability, veteran status or genetic information.

Title IX of the Education Amendments of 1972, states: "No person in the United States shall, on the basis of sex, be excluded from participation in, be denied the benefits of, or be subjected to discrimination under any education program or activity receiving Federal financial assistance."

The policy of the MCCCD is to provide an educational, employment, and business environment free of gender discrimination. Incidents of misconduct should be reported to the college Title IX Coordinator, as outlined in policy, contact information is available at this link Title IX Coordinators.

The Clery Act is a Federal law requiring United States Colleges and Universities to disclose information about crime on and around their campuses. Crime reporting data for each of the Maricopa Community Colleges, as required under the Clery Act, is available at this link Clery Act.

To apply, visit https://jobs.maricopa.edu/psp/MCPAHPRD/EMPLOYEE/HRMS/c/HRS_HRAM_FL.HRS_CG_SEARCH_FL.GBL?Page=HRS_APP_JBPST_FL&Action=U&FOCUS=Applicant&SiteId=1000&JobOpeningId=320878&PostingSeq=1

jeid-dc28fc37039d894d8d0009f32584c710

Location: Guadalupe, AZ, US

Posted Date: 12/22/2024