This person will create and maintain source to target designs and mappings, provide detailed data analysis, and manage metadata in support of the development and/or implementation of new or enhanced systems projects or programs. The Database Analyst works with subject matter experts from the project team to determine data requirements for analytical systems, develop these requirements into functional specifications and detailed data flow design documents, and participates in the full development process life-cycle from concept, through testing, to implementation. This includes identifying necessary data, reconciling with the new application and the legacy data sources and ensuring a successful implementation. This will include communicating business term definitions, establishing data quality rules, researching and analyzing data in support of business functions, process and workflow knowledge, and user acceptance testing.

Exceptional analytical and quantitative skills with ability to interpret and summarize complex data that drive actionable plans that add value to the business

Expert in MS Excel

3-5 years of professional experience using advanced SQL in a cloud data warehouse environment (such as Redshift, Snowflake or Hive), including window functions and CTEs

Conduct hands-on modeling/analytics retrieving, compiling, and analyzing large volumes of data from disparate databases into distilled, actionable information and insights