Senior Analyst, Data Management

3201 S 323rd St,Federal Way,Washington,98001-5023,United States of America GENERAL PURPOSE OF THE JOB This position is responsible for supporting process improvements, metric/report design and development, special projects, and providing detailed revenue valuation analysis to ensure departmental goals and objectives are achieved. The analyst will utilize one or more of the following - MS Applications, SQL Server, SSIS, Oracle, VBA, Tableau, and other approved technologies as needed to support department goals. This includes supporting processes for accounting for center and divisional revenue review, accounts receivable, cash and related transaction analysis, account reconciliation and preparing financial reports for corporate and field operations management, and joint venture partners, as well as internal and external audit agencies. ESSENTIAL DUTIES AND RESPONSIBILITIES The following duties and responsibilities generally reflect the expectations of this position but are not intended to be all-inclusive. Technical / Reporting / Analytics: Builds data systems, data models or assists in the building of database through proficiency in technical skills needed (ex. Data modeling in Tableau, SQL, Oracle, Netezza) Independently exports, transforms and loads data tables into data repositories to support maintenance of multiple databases Using SQL/SSIS/MS Excel/MS Access prepare, design, modify, and develop selected recurring and ad-hoc financial schedules and related revenue trends and fluctuations for management reporting Manage the team's data sources by identifying system and process opportunities and investigating data inconsistencies Become proficient in all areas of the revenue cycle and able to support and provide recommendations, via business acumen and technical knowledge Design and create tools and processes using Tableau/VBA/SQL/MS Access used to assist accounting team Problem solving and critical thinking: Exercise sound judgement to determine appropriate actions that will assist in breaking down complex problems to develop and implement solutions. Demonstrated ability to function in a team environment as well as independently and have the ability to build strong relationships across departments/teams. Inquisitive and self-started with a high degree of initiative, urgency, attention to detail, and follow through. Project & Stakeholder management: Effectively coordinates working sessions & facilitates interactions between business team and/or Accounting/IT teams (ex. Requirement review sessions, project status meetings & post-deployment feedback session); synthesizes and sends meeting recaps induing next steps. Directs & executes on next steps to progress own work stream; identifies & recommends new opportunities to improve existing processes. Maintains up to date documentation of data/process dependencies for a lane of business and needed requirements/updates for data systems. Proactively communicates around deadlines & roadblocks. Qualifications Bachelor's degree preferably in STEM, Economics, Statistics, Computer Science, Business. At lease 3 years experience as a data or reporting analyst. Experience with data modeling in various data systems like Tableau and/or with data relationships and data migration from data repositories to source systems (ex. SQL, Netezza, Oracle) Strong written, verbal and interpersonal communication skills with ability to probe, question, and listen attentively. Database and analysis experience with ability to manipulate large volumes of data and to work effectively at both detail and big-picture levels. Background experience in using Tableau, SQL, SSIS, MS Access and VBA (or other coding, ex. Python). Organizational and time management skills with the ability to manage multiple projects simultaneously with tight deadlines. Preferred rel