Return To Job Search

Data Architecture Analyst
JN -022018-47971

The role of the Data Architecture team is to ensure we build and deliver the highest quality analytic databases to support complex analytics and data-driven applications. As a Data Analyst you will work closely with the business to assess data related issues to convert problems into metric and data driven opportunities. You will be hands-on managing internal business projects from data assessment and analysis to delivering and providing continuing support for final analytic dataset sources and analytical solutions. 


Common Tasks:

  • Profile internal data from a multitude of sources for usefulness in analytics and architectural ways to wrangle and join this data together such that it can be easily used by the internal customer
  • Transform raw data (structured and unstructured) into meaningful and useful analysis or new data structures for internal customer consumption
  • Provide continued support for data structures and/or solution platforms delivered to internal customers
  • Partner with and provide analytical support to teams across the organization
  • Document existing data structures, data usage, and business requirements for past and ongoing data initiatives
  • Data mapping, identification, and application of business rules to data sets and resolving varying data granularities.
  • Review data with internal customer via Excel, PowerPoint, data visualization tools, et cetera
  • Manage data collection from internal customers, data review and quality checks of incoming data to ensure high quality data is used in database processing
  • Profile data using different query and visualization tools (SQL, Python, Excel, et cetera)
  • Communicate technical requirements to development teams
  • Work with development teams to answer questions and resolve ambiguities
  • Manage workstreams and priorities for internal projects
  • Organizing messy aspects of projects


  • Knowledge, Skills and Abilities (KSAs)
  • Expert proficiency in SQL query language required
  • Intermediate Proficiency in at least one additional data analysis language required (Python preferred)
  • Expert proficiency in MS Excel user required (VBA preferred)
  • Expert proficiency with the Microsoft Office Suite
  • Proficiency in data visualization techniques required
  • General aptitude for data manipulation and usage
  • Experience with cloud platforms and cloud data solutions (APIs a big plus)
  • Experience with reporting design, remote dashboards, and portal products
  • Experience in data architecture methods and tools
  • Process mapping experience preferred
  • Data mapping experience preferred
  • Some advanced mathematics knowledge required
  • Examples of “extra-curricular” projects a big plus
  • Competency Profile
  • Excellent diagnostic skills to analyze and identify discrepancies within data sets and identify solutions
  • Ability to communicate complex technical and abstract ideas to non-technical personnel
  • Ability to actively engage in project requirement dialogue with non-technical personnel
  • Ability to work on a problem from the analysis phase to the implementation of a practical solution
  • Ability to manage multiple projects in a fast-paced, results-oriented environment
  • Ability to work collaboratively with cross-functional teams at varying levels
  • Detail and accuracy oriented while still able to pull up and see the big picture
  • Keen ability to distinguish what matters from what doesn't, including a thorough understanding of the ways in which data can mislead
  • Resilient work ethic with the capability to adapt to the situation, flexibility and nimbleness in terms of work planning, and the ability to think quickly on your feet
  • Excellent communication skills, both written and verbal
  • Background Experiences
  • 3 years minimum business experience applying analytics, data collection, data analysis, and quality assurance (50% or more of role)
  • Experience working with multiple business units of an eCommerce organization a plus
  • Experience in a voluntary benefits environment a plus

© Talent Rover. All Rights Reserved.