Data Analyst

2 months ago

Rhinebeck, United States The Omega Institute Full time

Data Analyst & Programmer

Department: Information Technology

Reports to: Information Technology Associate Director

Classification: Exempt

JOB DESCRIPTION

Summary

The Data Analyst & Programmer is responsible for the development of, integrity, maintenance, and reporting from our central database, as well as other internal and third-party databases. This individual will use advanced database access methods (including SQL, custom software, third-party software, advanced Excel spreadsheets, and other tools) to provide information and analysis to Omega management.

Essential Functions

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

Data management

  • Oversee the management and hygiene of Omegas Enterprise Resource Planning and Customer Relationship Management software, Microsoft Dynamics Business Central/NAV, including periodic USPS updates and other processes using outside vendors.
  • Ensure data usage is in compliance with our privacy policies.
  • Conduct periodic manual updates to clean and standardize data, including merging duplicate records.
  • Conduct periodic refreshers in data entry standards for various departments.
  • Help coordinate and streamline the data flow between various departments, databases, and vendors, e.g. reservations, guest activity, and accounting data.
  • Facilitate the data flow from the central NAV database to the donor relationship management database used by the Omega Development team.
  • Suggest improvements to the design of our central NAV database to improve data organization and management.
Data analysis & reporting
  • Provide the CFO and other leadership team members with Jet reports and other data that shows trends in Omega's business including performance of guest days, profit centers, online learning, membership, and fundraising.
  • Prioritize and respond in a timely manner to internal report requests, e.g. data patterns, demographics, and trends.
  • Evaluate, research, and improve the toolsets that Omega staff use to access data.
  • Create reporting dashboards to provide easy access to useful data for staff, including utilizing a data warehouse to bring together disparate datasets.
  • Assist with marketing strategies with data analysis and reporting for campaigns including direct mail, customer feedback, and contact segmentation.
  • Support Google Analytics reporting by helping with setups and providing other support as needed.
Programming
  • Design and develop code, functionality, and user interfaces for Omegas Microsoft Dynamics Business Central/NAV instance.
Supervisory Responsibility

This position has no supervisory responsibilities.

Work Details
  1. This position functions in Omegas administrative offices on the Omega campus.
  2. Physical demands:
    • Must be able to remain in a stationary position 50% of the time.
    • Must be able to position self to perform diverse job tasks as necessary.
    • Frequently move items that weigh 20 pounds for various needs
    • The ability to communicate information and ideas so others will understand. Must be able to exchange accurate information in these situations.
    • The ability to observe details at close range.
    • Must be able to traverse a hilly campus in diverse weather conditions.
  3. This is a full-time position.
  4. The typical days and hours of work are Monday through Friday, 9 a.m. to 5 p.m. This schedule may vary when special needs and projects arise.

Qualifications
  • Strong command of SQL and SQL server tools.
  • Experience with data analytics and data warehousing concepts and tools.
  • At least two years of coding experience with one or more programming languages.
  • Ability to learn new programming languages.
  • Solid organization skills, including attention to detail and multitasking skills.
  • Excellent written and oral communications skills; ability to translate highly technical processes and information to a lay audience.
  • Bachelors degree in computer or information science, or equivalent experience.
  • Ability to work both independently and as an effective team member.
  • Alignment and understanding of Omegas mission, goals, and core values.
Preferred Education and Experience
  • Experience with the Microsoft proprietary programming languages of C/AL, AL, and C/SIDE.
  • Experience with Google Analytics.

Other Duties

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time, with or without notice.

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed above are representative of the knowledge, skill, and/or ability required. Omega complies with the Americans with Disabilities Act (ADA), as amended by the ADA Amendments Act, and all applicable New York State or local laws. Consistent with those requirements, Omega will reasonably accommodate qualified individuals with a disability if such accommodation would allow the individual to satisfactorily perform the essential functions of the job, unless doing so would create an undue hardship.

Omega Institute for Holistic Studies, Inc. (Omega) is an equal opportunity employer and complies with all applicable federal, New York State, and local laws. We celebrate diversity and are committed to creating an inclusive environment for all. As a community of learners, we are committed to putting our organizational aspirations into practice, as outlined in our Justice Equity Diversity Inclusion (JEDI) Statement.

Omega strictly prohibits and does not tolerate discrimination against employees, applicants, or any other covered persons because of actual or perceived race; color; creed; age; religion; national origin; citizenship status; sex (including pregnancy, childbirth, and related medical conditions); gender (including gender identity); sexual orientation; disability; marital status; partnership status; familial status; status as a victim of domestic violence, stalking, or sex offenses; genetic predisposition; veterans status; military status; or any other basis protected under applicable federal, state, or local laws, regulations, or ordinances. All Omega employees, other workers, and representatives are prohibited from engaging in unlawful discrimination. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, training, promotion, discipline, compensation, benefits, and termination of employment.

TO APPLY:
After carefully reviewing the requirements above, qualified individuals are invited to apply. A resume and well-crafted cover letter should be attached that serves as an introduction and includes following:
1. Why are you applying for this role?
2. What can you offer Omega?
3. What do you imagine this role will offer you professionally and personally?
4. How do you know Omegas work? Have you experienced us on campus or in some other way?
5. In what way has your professional life reflected Omega's mission statement?