Data Admin & Analyst

IISTL; St. Louis (MO); On-site; USD 60,000 - 85,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

PTO

Retirement benefits

Job summary

The International Institute in Saint Louis, MO is seeking a Data Admin & Analyst to ensure accurate database management, reporting, and quality control within a fast-paced social services setting. The role is funded through MO-ORA and supports staff with reliable information across systems.

This position emphasizes data integrity, reporting accuracy, and collaboration with program managers to improve outcomes and program evaluation. Strong SQL/DBA experience is preferred.

Qualifications

• Bachelor's degree in data analytics or information technology.
• Minimum of five (5) years of progressive related experience.
• Experience coding in SQL preferred.
• Experience as Database Administrator is highly desired.
• Experience with Bonterra Penelope, ClientTrack, and/or Salesforce is highly desired.
• Proficient with Microsoft Excel including V lookups, pivot tables, and quantitative analysis.

Responsibilities

• Assist in research and implementation of best practices for quality assurance and program evaluation. Running and reviewing quality assurance reports on a monthly basis.
• Be the main point of contact/source of knowledge for two client management software systems. Provide training and troubleshooting to program staff on these platforms.
• Collect, organize, and deliver data relevant to ORR program participation to MO-ORA. The major deliverables will be due each April and November.
• Create monthly, quarterly and other periodic programmatic reports to enhance monitoring of programs, including ad hoc reports as needed.
• Track grant submissions, deadlines, and funder reporting requirements. Lead and synthesize results from various departments in satisfying those reports.
• Review issues needing attention with the appropriate program managers, and follow-up to ensure issues are addressed and resolved within a timely manner.
• Work closely with management staff to build evaluation tools for programs and communicate internal and external results.
• Maintain statistics on department performance and task load.

Skills

SQL

DBA experience

Penelope

ClientTrack

Salesforce

Excel

SharePoint

Data analysis

Training staff

Communication

Education

Bachelor's degree in data analytics or IT

Tools

Bonterra Penelope

ClientTrack

Salesforce

Excel

SharePoint

Job description

The International Institute has job openings in St. Louis, MO and Springfield, MO.

International Institute is seeking mature-self starters who are well-organized, detail-oriented, able to work in fast-paced social services environment. Qualifications for each position vary. Candidates of diverse backgrounds are strongly encouraged to apply. Full-time positions include medical, dental, vision, PTO and retirement benefits.

EOE/AA. (Please no telephone inquiries.)

Position:Data Admin & Analyst

Location: Saint Louis, MO

Job Id:117

# of Openings:1

Position Summary

The Data Admin & Analyst is also known as the Regional Data Specialist, a position funded through Missouri Office of Refuge Administration (MO-ORA), a partner agency of IISTL. They are responsible for ensuring accurate database management, including reporting, tabulation, and quality control. This position manages database systems the organization uses to ensure staff have accurate and useable information that is held in systems that are efficient and reliable.

This position is responsible for upholding the International Institute’s mission, vision, goals, and objectives.

Details of Responsibilities

Essential Responsibilities:

• (5%) Assist in research and implementation of best practices for quality assurance and program evaluation. Running and reviewing quality assurance reports on a monthly basis.
• (30%) Be the main point of contact/source of knowledge for two client management software systems. Provide training and troubleshooting to program staff on these platforms.
• (20%) Collect, organize, and deliver data relevant to ORR program participation to MO-ORA. The major deliverables will be due each April and November.
• (20%) Create monthly, quarterly and other periodic programmatic reports to enhance monitoring of programs, including ad hoc reports as needed.
• (10%) Track grant submissions, deadlines, and funder reporting requirements. Lead and synthesize results from various departments in satisfying those reports.
• (5%) Review issues needing attention with the appropriate program managers, and follow-up to ensure issues are addressed and resolved within a timely manner.
• (5%) Work closely with management staff to build evaluation tools for programs and communicate internal and external results.
• (5%) Maintain statistics on department performance and task load.

Additional Responsibilities:

• Perform other tasks as required. This work may include, but is not limited to:
• Interacting with community members relative to current projects and initiatives.
• Participating in IISTL and MO-ORA, departmental, and organizational meetings and events.
• Performing other assigned duties as necessary for the successful operation of the organization.

Qualifications

Minimum Education & Experience Requirements:

• Bachelors’ degree in a related field, including data analytics or information technology.
• Minimum of five (5) years of progressive related experience.

Knowledge, Skills, & Ability Requirements:

• Experience coding in SQL preferred.
• Experience as Database Administrator is highly desired.
• Experience in database systems, especially Bonterra Penelope, ClientTrack, and/or Salesforce highly desired.
• Proficient with Microsoft Excel including V lookups, pivot tables, aggregating data from multiple sources, and quantitative analysis.
• Proficiency with the Microsoft Office suite (including Microsoft SharePoint).
• Experience in layout/form development, particularly within a client management software system is highly desired.
• Excellent communication and interpersonal skills.
• Ability to exhibit a professional, courteous demeanor.
• Ability to meet deadlines and work in a fast-paced environment.
• Excellent planning and organizing skills; ability to anticipate adverse outcomes.
• Excellent problem-solving and analytical skills and acute attention to detail.
• Ability to treat confidential information with sensitivity.
• Ability to be administratively independent and self-supportive.
• Ability to effectively plan work activities, schedules, priorities, and utilization of resources.
• Ability to work both independently and as part of a team.
• Commitment to excellence and high standards.
• Ability to communicate and interact effectively with a diverse group of individuals.
• Versatility, flexibility, and willingness to work within constantly changing priorities.

Other Requirements:

• Appropriate availability consistent with organization established practices and norms; hours not to exceed 40 hours per week without prior supervisor authorization.
• Ability to work at Festival of Nations (last full weekend in August)
• Ability to pass a standard background check.

Environment

This position requires the ability to work in a stationary position for several hours at a time and the ability to move up to 25 pounds, occasionally. The work environment is an air-conditioned, smoke-free, office environment. This position routinely uses standard office equipment such as computers and photocopiers. This position occasionally may require regional travel; no overnight travel is anticipated.

Equal Opportunity

The International Institute is an Equal Opportunity/Equal Access/Affirmative Action employer. The International Institute values diverse perspectives and backgrounds in all positions within the organization and is fully committed to achieving a diverse workforce and complies with all Federal and State laws, and regulations regarding nondiscrimination and affirmative action. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, disability, protected veteran status, national origin, sexual orientation, gender identity or expression (including transgender status), genetic information or any other characteristic protected by applicable law.

Reasonable accommodations may be requested to enable individuals with disabilities to perform the essential functions.

Why you should work at the International Institute?

We believe the cornerstone of the International Institute, employees are our most valuable resource and investment. We plan to invest in our employees by developing and implementing an employee retention plan to better support them. (2022-2024 International Institute’s Strategic Plan)

Be a Part of Our Team

We aspire to make St. Louis an inclusive, diverse, welcoming, and prosperous regionfor all— a region that provides equitable opportunities for everyone to achieve their greatest potential and contribute to the development of this vibrant community.This vision for St. Louis is made possible by individuals, civil society, businesses, and government working together to create pathways for inclusive growth.

The work we do at the International Institute is important and life changing – no doubt, but we are only able to do this work because of the amazing support of our partners.Your support goes a long way to touch and transform lives.

At IISTL, we willserveto the best of our ability. We willadvocatefor a more welcoming region. We willconnectthis community to resources that inspire growth. We willdiversifyour income sources and invest in a sustainable financial model that ensures continued support for immigrants, their families, and the community at large. We willbuildthe capacity to lead our community forward by leveraging the talent and experiences of the immigrant population for our common growth. As we adapt to our ever-changing world, we will uphold the values on which our organization was founded: diversity, democracy, prosperity, and inclusion.We will transform St. Louis into a more inclusive and prosperous community for all.

We are the International Institute of St. Louis.

Commitment to My Team

As your teammate and with our shared goal of providing excellent service to our clients, I commit to the following:

• I will treat each team member with dignity, respect and compassion.
• I will value and respect differences in background, experience, culture, sexual orientation, religion and ethnicity.
• I will view all teammates as equally important members of the Institute team.
• I will be committed to finding solutions.
• I will practice the '3 C’s' (caring, committing and collaborating) with each other.
• I will promote interdepartmental cooperation.
• I will recognize and encourage positive behaviors
• I will provide constructive feedback.
• I will take ownership of the task that they are responsible for.
• I will remember to exercise a commitment to physical, mental, and social wellness.
• I will respect the boundaries each individual has set for their work/life balance.