The College of Charleston
Charleston, South Carolina
Institutional Research Data Architect*
Posting Details
POSTING INFORMATION
Internal Title
Institutional Research Data Architect*
Position Type
Classified
Faculty / Non-Faculty / Administration
Non-Faculty
Pay Band
7
Level
1
Department
Institutional Research
Job Purpose
Institutional Research Data Architect designs systems for and manages complex data to support the data-driven decision-making functions of the institution. This position serves to support the Office of Institutional Research in providing a first-class reporting structure for national and state accountability reporting including IPEDS and SC CHE . The Office of Institutional Research serves a critical function for the College of Charleston in providing data to senior administrators, the College community, and external agencies.
Minimum Requirements
Bachelor’s degree in business administration, computer science, mathematics/statistics, engineering, management information science, data processing or related field and experience with Tableau, Cognos/Argos, SQL , and/or SAS is required. Experience with data mining, including techniques of data extraction, documentation, analysis, and reporting is required. Experience working in a higher education environment is preferred. Candidates with an equivalent combination of experience and/or education are encouraged to apply.
Required Knowledge, Skills and Abilities
Required:
Experience with Tableau, Cognos/Argos, SQL , and/or SAS . Advanced SAS programming experience is preferred.
Working knowledge and practitioner of methods and techniques of data extraction, documentation, analysis, and reporting.
Proficiency with MS Office including Outlook, Word, Excel, Teams, SharePoint and PowerPoint.
Knowledge and understanding of the data and information that is important to an academic institution.
Ability to establish and maintain effective working relationships with staff and to communicate effectively.
Must be able to work well under strict deadlines and have exceptional attention to detail.
Ability to manage multiple projects with shifting priorities in a fast-paced environment.
Must understand the significance of maintaining data integrity and confidentially with student records; knowledge of and adherence to FERPA regulations.
Preferred:
Exceptional organizational skills and experience managing and documenting complex projects.
Knowledge of higher education information systems such as Ellucian Banner and related data systems and repositories such as Salesforce, IPEDS , US News, and CSRDE .
Additional Comments Regarding Position
Limited overnight travel may be required to attend professional development conferences and meetings. Some weekend and evening activities may be required. *This position may be eligible for limited remote telecommuting. Please visit the College’s Telecommuting page and Academic Affairs divisional guidelines for more information: https://hr.cofc.edu/telecommuting/index.php .
Special Instructions to Applicants
Please complete the application to include all current and previous work history and education. A resume will not be accepted nor reviewed to determine if an applicant has met the qualifications for the position.
**Salary is commensurate with education/experience which exceeds the minimum requirements.
Offers of employment are contingent upon a successful background check.
All applications must be submitted online https://jobs.cofc.edu .
Salary
**$54,974 - $78,343
Posting Date
03/26/2024
Closing Date
04/19/2024
Benefits
Insurance: Health/Dental/Vision
Life Insurance
Paid Leave: Sick/Annual/Parental
Retirement
Long Term Disability
Paid Holidays
Free CARTA Bus Service
Employee Tuition Assistance Program ( ETAP )
Employee Assistance Program ( EAP )
Full Benefits Package – Click Here
Open Until Filled
No
Posting Number
2024045
EEO Statement
The College of Charleston is an Affirmative Action/Equal Opportunity employer and does not discriminate against any individual or group on the basis of gender, sexual orientation, gender identity or expression, age, race, color, religion, national origin, veteran status, genetic information, or disability.
Quicklink for Posting
https://jobs.cofc.edu/postings/15174
Job Duties
Job Duties
Activity
Designs and maintains database and reporting applications in various environments (i.e., SQL , SAS ) to run against the ERP system (Banner). Maintains and updates all Institutional Research data marts and scheduled processes to support external and internal decision support, accountability, and performance reporting needs. Monitors scheduled processes for successful completion and uses or sets up alerts for unsuccessful jobs. Analyzes current processes and procedures against best industry practices and to determine efficiencies or cost savings.
Essential or Marginal
Essential
Percent of Time
25
Activity
Designs and maintains complex systems for the extraction, compilation, analysis, processing and presentation of institutional data to fulfill annual IPEDS and SC CHE reporting requirements. Coordinates with the Assistant Director for Reporting and Data Management on successful generation and delivery of daily data integrity processing.
Essential or Marginal
Essential
Percent of Time
20
Activity
Works with the Executive Director and IR colleagues to design and maintain applications that utilize academic departmental data, finance, and human resource data from the College’s ERP system and other related data sources. Analyzes the reporting needs to determine the best data source and reporting tool. Develops data architecture and report structures in various formats including but not limited to Cognos, Argos, SAS and Tableau.
Essential or Marginal
Essential
Percent of Time
20
Activity
Maintains documentation (metadata) of all IR data architecture. Prepares flowcharts, block diagrams, and other documentation to illustrate programs and procedures and prepares user documentation. Routinely updates Tableau and Cognos/Argos report metadata and assists with archiving obsolete work.
Essential or Marginal
Essential
Percent of Time
15
Activity
Serves as a subject matter expert and resource for data stewards and on various implementation and integration projects (i.e. CRM Advise, PeopleAdmin, Salesforce.) Researches and reports on the impacts of system changes on the College’s data integrity and business processes. Guides the campus community on data standards and best practices in data management.
Essential or Marginal
Essential
Percent of Time
10
Activity
Supports and assists IR colleagues on projects such as: accreditation reporting; senior leadership and executive requests; maintaining the OIR website; and dashboard development and reporting using Tableau.
Essential or Marginal
Essential
Percent of Time
10
Institutional Research Data Architect*
Posting Details
POSTING INFORMATION
Internal Title
Institutional Research Data Architect*
Position Type
Classified
Faculty / Non-Faculty / Administration
Non-Faculty
Pay Band
7
Level
1
Department
Institutional Research
Job Purpose
Institutional Research Data Architect designs systems for and manages complex data to support the data-driven decision-making functions of the institution. This position serves to support the Office of Institutional Research in providing a first-class reporting structure for national and state accountability reporting including IPEDS and SC CHE . The Office of Institutional Research serves a critical function for the College of Charleston in providing data to senior administrators, the College community, and external agencies.
Minimum Requirements
Bachelor’s degree in business administration, computer science, mathematics/statistics, engineering, management information science, data processing or related field and experience with Tableau, Cognos/Argos, SQL , and/or SAS is required. Experience with data mining, including techniques of data extraction, documentation, analysis, and reporting is required. Experience working in a higher education environment is preferred. Candidates with an equivalent combination of experience and/or education are encouraged to apply.
Required Knowledge, Skills and Abilities
Required:
Experience with Tableau, Cognos/Argos, SQL , and/or SAS . Advanced SAS programming experience is preferred.
Working knowledge and practitioner of methods and techniques of data extraction, documentation, analysis, and reporting.
Proficiency with MS Office including Outlook, Word, Excel, Teams, SharePoint and PowerPoint.
Knowledge and understanding of the data and information that is important to an academic institution.
Ability to establish and maintain effective working relationships with staff and to communicate effectively.
Must be able to work well under strict deadlines and have exceptional attention to detail.
Ability to manage multiple projects with shifting priorities in a fast-paced environment.
Must understand the significance of maintaining data integrity and confidentially with student records; knowledge of and adherence to FERPA regulations.
Preferred:
Exceptional organizational skills and experience managing and documenting complex projects.
Knowledge of higher education information systems such as Ellucian Banner and related data systems and repositories such as Salesforce, IPEDS , US News, and CSRDE .
Additional Comments Regarding Position
Limited overnight travel may be required to attend professional development conferences and meetings. Some weekend and evening activities may be required. *This position may be eligible for limited remote telecommuting. Please visit the College’s Telecommuting page and Academic Affairs divisional guidelines for more information: https://hr.cofc.edu/telecommuting/index.php .
Special Instructions to Applicants
Please complete the application to include all current and previous work history and education. A resume will not be accepted nor reviewed to determine if an applicant has met the qualifications for the position.
**Salary is commensurate with education/experience which exceeds the minimum requirements.
Offers of employment are contingent upon a successful background check.
All applications must be submitted online https://jobs.cofc.edu .
Salary
**$54,974 - $78,343
Posting Date
03/26/2024
Closing Date
04/19/2024
Benefits
Insurance: Health/Dental/Vision
Life Insurance
Paid Leave: Sick/Annual/Parental
Retirement
Long Term Disability
Paid Holidays
Free CARTA Bus Service
Employee Tuition Assistance Program ( ETAP )
Employee Assistance Program ( EAP )
Full Benefits Package – Click Here
Open Until Filled
No
Posting Number
2024045
EEO Statement
The College of Charleston is an Affirmative Action/Equal Opportunity employer and does not discriminate against any individual or group on the basis of gender, sexual orientation, gender identity or expression, age, race, color, religion, national origin, veteran status, genetic information, or disability.
Quicklink for Posting
https://jobs.cofc.edu/postings/15174
Job Duties
Job Duties
Activity
Designs and maintains database and reporting applications in various environments (i.e., SQL , SAS ) to run against the ERP system (Banner). Maintains and updates all Institutional Research data marts and scheduled processes to support external and internal decision support, accountability, and performance reporting needs. Monitors scheduled processes for successful completion and uses or sets up alerts for unsuccessful jobs. Analyzes current processes and procedures against best industry practices and to determine efficiencies or cost savings.
Essential or Marginal
Essential
Percent of Time
25
Activity
Designs and maintains complex systems for the extraction, compilation, analysis, processing and presentation of institutional data to fulfill annual IPEDS and SC CHE reporting requirements. Coordinates with the Assistant Director for Reporting and Data Management on successful generation and delivery of daily data integrity processing.
Essential or Marginal
Essential
Percent of Time
20
Activity
Works with the Executive Director and IR colleagues to design and maintain applications that utilize academic departmental data, finance, and human resource data from the College’s ERP system and other related data sources. Analyzes the reporting needs to determine the best data source and reporting tool. Develops data architecture and report structures in various formats including but not limited to Cognos, Argos, SAS and Tableau.
Essential or Marginal
Essential
Percent of Time
20
Activity
Maintains documentation (metadata) of all IR data architecture. Prepares flowcharts, block diagrams, and other documentation to illustrate programs and procedures and prepares user documentation. Routinely updates Tableau and Cognos/Argos report metadata and assists with archiving obsolete work.
Essential or Marginal
Essential
Percent of Time
15
Activity
Serves as a subject matter expert and resource for data stewards and on various implementation and integration projects (i.e. CRM Advise, PeopleAdmin, Salesforce.) Researches and reports on the impacts of system changes on the College’s data integrity and business processes. Guides the campus community on data standards and best practices in data management.
Essential or Marginal
Essential
Percent of Time
10
Activity
Supports and assists IR colleagues on projects such as: accreditation reporting; senior leadership and executive requests; maintaining the OIR website; and dashboard development and reporting using Tableau.
Essential or Marginal
Essential
Percent of Time
10
League of Conservation Voters
Flexible
Title: Salesforce Database Manager
Department: Development
Status: Exempt
Reports to: Senior Director of Fundraising Data and Operations
Positions Reporting to this Position: None
Location: Flexible (the employee may decide whether to work remotely or from an LCV office)
Travel Requirements: Up to 20%
Union Position: Yes
Job Classification Level: D
Salary Range (depending on experience): $72,328 - $88,283
General Description :
LCV believes our earth is worth fighting for because everyone has a right to clean air, water, and a safe, healthy community. To ensure those rights are protected, we help people use their power to shape policy, hold politicians and polluters accountable, and influence elections.
For more than 50 years, LCV has grown into a potent political force for protecting our planet and everyone who inhabits it. We have built a powerful national movement with 30 state affiliates, and grassroots and community organizing programs across the country.
LCV is hiring a Database Manager who will support the Senior Director of Fundraising Data and Operations in maintaining and managing LCV’s Salesforce database and ensuring the integrity of its data. This position will take the lead in conducting fine-grained tasks to improve the functionality and intuitiveness of the database. This role will support a large Development department in their use of Salesforce. The Database Manager will also work with other software systems used by the fundraising team. This role is a great opportunity for someone who has experience with the backend of Salesforce and is looking to take the next step to becoming a Salesforce administrator.
Responsibilities:
Document and maintain consistent procedures for data input to ensure accurate data.
Create processes for training and onboarding new users to Salesforce.
Develop strategies for monitoring and maintaining the completeness and accuracy of records.
Perform routine data integrity tasks, including mass updating contact record fields and mass merging duplicate accounts.
Analyze and pinpoint sources of data anomalies within Salesforce.
Maintain and develop user interfaces such as custom fields, workflow and validation rules, and page layouts in Salesforce.
Support Senior Data Director in a variety of advanced reporting tasks using Salesforce reports, SQL, and Tableau.
Assist Senior Data Director with the maintenance of third-party integrations with Salesforce, including EveryAction, Acoustic, Swoogo and Capitol Canary (formerly Phone2Action).
Work with third party tools to maintain accurate demographic data that enhances LCV’s ongoing work on analyzing and expanding the racial diversity of the donor and activist base.
Maintain users, profiles, and public groups in Salesforce.
Optimize functionality of databases by staying up-to-date on future improvements and by researching applications to identify possible areas of innovation.
Identify opportunities for improvement and make constructive suggestions for change.
Travel up to 20% for staff retreats, trainings, and conferences.
Perform other duties as assigned.
Qualifications :
Work Experience: Required - At least 4 years of experience working with Salesforce, with at least 2 years experience as an advanced user or administrator. Familiarity with both Salesforce Lightning and Classic. Preferred - Experience in a non-profit or political organization. Certified Salesforce Administrator.
Skills: Required - Strong database management skills. High level of proficiency in Excel. Attentive to details, and adept at maintaining systems for easy access to information and data. Ability to document and communicate technical information to a non-technical audience. Ability to create fields, manage profile administration and familiarity with workflows and/or Process Builder. Solid judgment; critical thinking skills; a sense of teamwork and community; ability to handle multiple tasks and work for several people; highly organized. Preferred - Experience with SQL, Tableau, Civis and data integrations.
Cultural Competence: Demonstrated awareness of one’s own cultural identity, views about difference, and the ability to learn and build on varying cultural and community norms. Commitment to equity and inclusion as organizational practice and culture. Understands how environmental issues intersect with racism, economic and social inequality in the U.S. and has a passion for working to dismantle these systems.
Working Conditions: This job operates in a professional office environment, and routinely uses standard office equipment such as computers, phones, photocopiers, and audiovisual systems. This position is largely sedentary, often standing or sitting for prolonged periods. The person in this position frequently communicates with partners and must be able to exchange accurate information. Must be willing and able to occasionally work beyond scheduled office hours, as needed. Applicants need to be located in and legally authorized to work in the United States. LCV requires all employees working from our offices or participating in in-person meetings or events to be fully up-to-date on their COVID-19 vaccinations, subject to reasonable accommodation as required by law.
To Apply: Send cover letter and resume to hr@lcv.org with "Database Manager" in the subject line by June 20, 2022. No phone calls please.
LCV is an Equal Opportunity Employer committed to a racially just, equitable and inclusive workplace. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, veteran status, or genetic information, or any other protected status. LCV is committed to providing access, equal opportunity and reasonable accommodation for individuals with disabilities in employment, its services, programs, and activities. If you require reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employee selection process, please contact hr@lcv.org.
Title: Salesforce Database Manager
Department: Development
Status: Exempt
Reports to: Senior Director of Fundraising Data and Operations
Positions Reporting to this Position: None
Location: Flexible (the employee may decide whether to work remotely or from an LCV office)
Travel Requirements: Up to 20%
Union Position: Yes
Job Classification Level: D
Salary Range (depending on experience): $72,328 - $88,283
General Description :
LCV believes our earth is worth fighting for because everyone has a right to clean air, water, and a safe, healthy community. To ensure those rights are protected, we help people use their power to shape policy, hold politicians and polluters accountable, and influence elections.
For more than 50 years, LCV has grown into a potent political force for protecting our planet and everyone who inhabits it. We have built a powerful national movement with 30 state affiliates, and grassroots and community organizing programs across the country.
LCV is hiring a Database Manager who will support the Senior Director of Fundraising Data and Operations in maintaining and managing LCV’s Salesforce database and ensuring the integrity of its data. This position will take the lead in conducting fine-grained tasks to improve the functionality and intuitiveness of the database. This role will support a large Development department in their use of Salesforce. The Database Manager will also work with other software systems used by the fundraising team. This role is a great opportunity for someone who has experience with the backend of Salesforce and is looking to take the next step to becoming a Salesforce administrator.
Responsibilities:
Document and maintain consistent procedures for data input to ensure accurate data.
Create processes for training and onboarding new users to Salesforce.
Develop strategies for monitoring and maintaining the completeness and accuracy of records.
Perform routine data integrity tasks, including mass updating contact record fields and mass merging duplicate accounts.
Analyze and pinpoint sources of data anomalies within Salesforce.
Maintain and develop user interfaces such as custom fields, workflow and validation rules, and page layouts in Salesforce.
Support Senior Data Director in a variety of advanced reporting tasks using Salesforce reports, SQL, and Tableau.
Assist Senior Data Director with the maintenance of third-party integrations with Salesforce, including EveryAction, Acoustic, Swoogo and Capitol Canary (formerly Phone2Action).
Work with third party tools to maintain accurate demographic data that enhances LCV’s ongoing work on analyzing and expanding the racial diversity of the donor and activist base.
Maintain users, profiles, and public groups in Salesforce.
Optimize functionality of databases by staying up-to-date on future improvements and by researching applications to identify possible areas of innovation.
Identify opportunities for improvement and make constructive suggestions for change.
Travel up to 20% for staff retreats, trainings, and conferences.
Perform other duties as assigned.
Qualifications :
Work Experience: Required - At least 4 years of experience working with Salesforce, with at least 2 years experience as an advanced user or administrator. Familiarity with both Salesforce Lightning and Classic. Preferred - Experience in a non-profit or political organization. Certified Salesforce Administrator.
Skills: Required - Strong database management skills. High level of proficiency in Excel. Attentive to details, and adept at maintaining systems for easy access to information and data. Ability to document and communicate technical information to a non-technical audience. Ability to create fields, manage profile administration and familiarity with workflows and/or Process Builder. Solid judgment; critical thinking skills; a sense of teamwork and community; ability to handle multiple tasks and work for several people; highly organized. Preferred - Experience with SQL, Tableau, Civis and data integrations.
Cultural Competence: Demonstrated awareness of one’s own cultural identity, views about difference, and the ability to learn and build on varying cultural and community norms. Commitment to equity and inclusion as organizational practice and culture. Understands how environmental issues intersect with racism, economic and social inequality in the U.S. and has a passion for working to dismantle these systems.
Working Conditions: This job operates in a professional office environment, and routinely uses standard office equipment such as computers, phones, photocopiers, and audiovisual systems. This position is largely sedentary, often standing or sitting for prolonged periods. The person in this position frequently communicates with partners and must be able to exchange accurate information. Must be willing and able to occasionally work beyond scheduled office hours, as needed. Applicants need to be located in and legally authorized to work in the United States. LCV requires all employees working from our offices or participating in in-person meetings or events to be fully up-to-date on their COVID-19 vaccinations, subject to reasonable accommodation as required by law.
To Apply: Send cover letter and resume to hr@lcv.org with "Database Manager" in the subject line by June 20, 2022. No phone calls please.
LCV is an Equal Opportunity Employer committed to a racially just, equitable and inclusive workplace. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, veteran status, or genetic information, or any other protected status. LCV is committed to providing access, equal opportunity and reasonable accommodation for individuals with disabilities in employment, its services, programs, and activities. If you require reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employee selection process, please contact hr@lcv.org.