Database Analyst - Remote

Locus Recruiting is a nimble, experienced recruiting team specializing in information security, cloud computing, and networking and infrastructure. We are determined to find the best possible solutions for companies in search of top talent, while offering job candidates an expedited and precise recruiting process. We are focused on supporting the goals of both our clients as well as the candidate community to offer an experience that supports and stimulates the growth of our stakeholders. We take a full service approach with our process, understanding our clients and candidates needs in order to find each the right fit from a skillset and a cultural perspective. Locus is currently searching for a Database Analyst for our client. This is a full time remote role. Responsibilities: OpenAir Administration - responsible for administration, support, and on-going configurations & customizations of their NetSuite OpenAir system and new business applications. Create mock screens and modules to demonstrate the effectiveness of usage of financial modules in OpenAir. Customize the existing modules to ongoing changes required by the Organization. Other responsibilities include creating new users, user permissions, saved searches, custom reports, dashboards, and workflows. Perform integration, configuration, data migration and user access control settings involving NetSuite. Tech/Functional skill-set to handle all back-end development along with the ability to work with key executives of the organization. Optimizing the NetSuite ERP & eCommerce platform & automating key business processes, creating workflows, saved searches, & dashboards. Coordination with NetSuite on outages, software updates, etc. and partnership with appropriate GBT system owners for communication & coordination Handle support function within OpenAir - Technology Project creation, Task allocation, Budget allocation & adjustment, User profile activation and Deactivation, WIP adjustments, Forecast correction, Project closure, Timesheet rejection, Task creation, Update Work Schedules, create new reports, Update OPC 3rd Party cost Project Management other support function - creation of Workday dashboard to leaders, support onboarding/offboarding process for hiring managers, maintain issue track within JIRA for the technology portfolio. · Reporting - Provide Weekly, Monthly reports to Leadership and PM community on the financial health status of the projects. Monitor project progress by tracking activity; resolving problems; publishing progress reports; recommending actions. · Timesheet analysis - Monitor Timesheet and provide periodic reports to Organization highlighting Submitted, Approved and Pending timesheet information. Adhoc timesheet analysis to validate accuracy & adherence. · Financial Analysis - monitor and report variances to plan · Creation of project financial reports to Technology Project Managers and Directors · Support for vendor and Workforce Logiq billing reconciliation · Ensure that program activities operate within the policies and procedures of the organization · Create Financial Management templates for various reporting needs · Develop meaningful metrics that measure the effectiveness of IT delivery and identify and implement improvements · Monitor program risks through an on-going process of identifying, assessing, tracking, developing and executing risk mitigation strategies. · Designed and conducted regular audits to maintain data integrity and security. · Implement the on-boarding policies, procedures and practices of new members to the organization · Provide references for users by writing and maintaining user documentation; providing help desk support; training users Requirements: OpenAir strongly preferred Workday strongly preferred Employee onboarding Financial experience Tech projects with understanding flow Bachelors degree preferred Experience in managing financials Budgeting Excel, pivot table, VLOOKUP, match function, conditional formatting, Advanced Charting, Advance formulae, Functions, VBA & Macros, Data Tables, Simulations & solverBenefits: Locus offers medical, dental, vision, life, 401k, and paid time off to all full time employeesLocus is committed to the principles of equal employment. We are committed to complying with all federal, state, and local laws providing equal employment opportunities, and all other employment laws and regulations. It is our intent to maintain a work environment that is free of harassment, discrimination, or retaliation because of age, race, color, national origin, ancestry, religion, sex (including sexual orientation and gender identity), pregnancy, physical or mental disability, genetic information, veteran status, uniformed service member status, or any other status protected by federal, state, or local laws.