Senior Enterprise Data Architect and Business Analyst

Salary: $75,644.00 - $110,758.00 Annually
Location : West Windsor and Trenton, NJ
Job Type: Full-Time
Job Number: 202500023
Division: Information Technology Services
Department: Enterprise Information Services
Opening Date: 04/02/2025

JOB SUMMARY AND DUTIES

If you are considering a new job, work environment or career opportunities you should look at Mercer County Community College. MCCC is a publicly supported college that is open to all and dedicated to student success. In order to support that mission Mercer seeks to attract, retain, and support a skilled diverse workforce which is our most valuable resource. We thrive on and are proud of our diversity and open access. Our students and employees find the College large enough for a multitude of offerings yet small enough to keep the "Community" feel for all. The College consists of two campuses, the James Kerney Campus (JKC) in the capital city of Trenton, NJ and a larger 292-acre suburban campus just six miles north of Trenton.

As part of the comprehensive and valuable benefits package the College offers credit course tuition waivers for employees, spouses and dependents. This allows for employees and their families to take advantage of earning a higher education degree without the high cost. The College offers students 69 Degree Program Options and 35 Credit Certificates from which to choose.

JOB DUTIES
Essential functions, as defined under the Americans with Disabilities Act, may include the following tasks, knowledge, skills and other characteristics. This list of tasks is illustrative ONLY and is not a comprehensive listing of all functions and tasks performed by positions in this class. It does not imply that all positions within the class perform all of the duties listed, nor does it necessarily list all possible duties that may be assigned. Please note that assigned tasks and responsibilities on both campuses is required for all MCCC positions.

• This position will work closely with stakeholders across various departments of the college to understand their data needs, develop reports and dashboards, and provide analysis to support strategic initiatives.
• Interpret data, analyze results, and provide insights to help business leaders make informed decisions.
• Working with users in various administrative departments to assess, train and assist with the Business Process Reviews, documentation and implementation of Colleague ERP software solutions.
• Designing and writing functional specifications based on consultations with stakeholders, supervisor and leadership.
• Facilitates and leads interviews, focus groups, and workshops to establish current and future business requirements; coordinates the communication between stakeholders and service owners in order to effectively implement solutions.
• Operational and Regulatory Reporting - Participate in the planning, design, and creation of operational and ad hoc reports of varying complexity per client specification using various reporting, data extraction, and analysis tools.
• Ability to write reports, business correspondence, develops process flows and procedure manuals.
• Data Quality Review and Data Governance - Develop processes to validate data veracity as data flows between business and data systems. Participate in the process of writing and reviewing data specifications, report documentation. Ensure data definitions are maintained. Provide end-to-end testing of new data models, changes to calculated/derived fields, and software upgrades.
• Training end users or technical support staff to use and support programs.
• Participate in special projects and performs other duties as assigned
• Based on the project needs, available after hours and weekend to provide support and services for project implementation and troubleshooting.

ESSENTIAL DUTIES AND RESPONSIBILITIES

• This position will work closely with stakeholders across various departments of the college to understand their data needs, develop reports and dashboards, and provide analysis to support strategic initiatives..
• Working with users in various administrative departments to assess, train and assist with the Business Process Reviews, documentation and implementation of Colleague ERP software solutions.
• Designing and writing functional specifications based on consultations with stakeholders, supervisor and leadership.
• Operational and Regulatory Reporting - Participate in the planning, design, and creation of operational and ad hoc reports of varying complexity per client specification using various reporting, data extraction, and analysis tools.
• Ability to write reports, business correspondence, develops process flows and procedure manuals.
• Data Quality Review and Data Governance - Develop processes to validate data veracity as data flows between business and data systems. Participate in the process of writing and reviewing data specifications, report documentation. Ensure data definitions are maintained. Provide end-to-end testing of new data models, changes to calculated/derived fields, and software upgrades.

SUPERVISORY RESPONSIBILITIES
None

WORKING CONDITIONS
None

ADA AND OTHER REQUIREMENTS
Positions in this class typically require: ability to use a key board, hearing, seeing and repetitive motions.

Sedentary Work: Exerting up to 10 pounds of force occasionally and/or a negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects including the human body. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.
REQUIRED QUALIFICATIONS, KNOWLEDGE, SKILLS & ABILITIES

• Bachelor degree in Information Technology, Computer Science, or closely related data or computer-related field from an accredited institution
• Atleast seven (7) years of relative work experience.
• Familiarity with logical data design and data mapping or data conversion and ETL (Extract, Transform, Load) processes.
• Five (5 ) years experience in writing SQL sciprts and strong working knowledge of MSsql database.
• Familiarity with data quality and governance issues and requirements.
• Effective team collaboration and communication skills. Ability to set competing priorities and meet critical deadlines.

PREFERRED QUALIFICATIONS, KNOWLEDGE, SKILLS & ABILITIES

PREFERRED QUALIFICATIONS

• Master degree in Information Technology, Computer Science, or closely related data or computer-related field.
• Seven or more years of relevant experience with data visualization and/or building analytical dashboards.
• Experience with Ellucian Colleague ERP.
• Extract, transform, and load data from various sources into data warehouses or data lakes.
• Collaborate with data architects and analysts to understand data requirements and ensure data quality.
• Extensive knowledge of database scripting languages such as T/SQL, SQL, and including advanced query writing, stored procedures, views, and database design principles; proficient in optimizing complex queries and automating database tasks.

KNOWLEDGE, SKILLS & ABILITIES

• Ability to communicate effectively both orally and in writing
• Excellent analytical and problem-solving skills with the demonstrated ability to review, analyze, and evaluate institutional information systems and user needs.
• Advanced skills in creating reports, dashboards, and OLAP cubes ( i.e. PowerBI, Informer, SAP).
• Ability to assess own strengths and weaknesses; pursues training and development opportunities; strives to continuously build knowledge and skills; shares expertise with others.
• Treats people with respect; keeps commitments; inspires the trust of others; works with integrity and ethics upholds organizational values.
• Interpersonal skills sufficient to work with both technical and non-technical personnel at various levels in and outside the organization. (i.e., faculty, staff, students, teaching assistants, affiliates, etc.) Ability to elicit and communicate technical and non-technical information in a clear and concise manner.
• Strong problem-solving skills; identifies and resolves problems in a timely manner; gathers and analyzes information skillfully; develops alternative solutions; works well in group problem-solving situations; uses reason even when dealing with emotional topics
• Follows policies and procedures; completes administrative tasks correctly and on time; supports organization's goals and values; benefits organization through outside activities; supports affirmative action and respects diversity.

CORE COMPETENCIES

To perform the job successfully, an individual should demonstrate the following competencies:

Adaptability: Maintaining effectiveness when experiencing major changes in work tasks or the work environment; adjusting effectively to work within new work structures, processes, requirements, or cultures.

Building Trust: Interacting with others in a way that gives them confidence in one's intentions and those of the organization.

Customer Focus: Making customers and their needs a primary focus of one's actions; developing and sustaining productive customer relationships.

Decision Making: Identifying and understanding issues, problems, and opportunities; comparing data from different sources to draw conclusions; using effective approaches for choosing a course of action or developing appropriate solutions; taking action that is consistent with available facts, constraints, and probable consequences.

Contributing to Team Success: Actively participating as a member of a team to move the team toward the completion of goals.

Diversity & Inclusion: Working with situations involving different cultures/languages and responding to the ambiguity of unexpected/unfamiliar approaches.

Initiating Action: Taking prompt action to accomplish objectives; taking action to achieve goals beyond what is required; being proactive.
Full Time Employee Benefits

• Health Care
• Prescription Drug Plan
• Dental
• Vision
• Retirement Savings Plan
• Optional Tax Deferral Plans (403b and 457b plans)
• Flexible Spending Accounts
• Life Insurance
• Long-Term Disability
• Tuition Reimbursement
• Mercer County Community College Tuition Waiver
• Employee Assistance Program, Recreation Pass to College's Pool and Fitness Center
• 14 Holidays
• 3 Personal days
• 2 Floating Holidays
• 12 Vacation days in first year
• 15 Vacation days after secnd year
• 12 Sick days per year
• Paid Jury Duty
• Bereavement Leave
• Military Leave
• Various employee discounts include Mercer County Community College Bookstore, Kelsey Theatre, NJM Insurance and Corporate Offers - "Best Pricing" to theme parks, theatre and sporting events.