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 Data management Oversee the management and hygiene of Omega’s 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 Omega’s Microsoft Dynamics Business Central/NAV instance. 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. Bachelor’s degree in computer or information science, or equivalent experience. Ability to work both independently and as an effective team member. Alignment and understanding of Omega’s 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.

#J-18808-Ljbffr