Senior Data Warehouse Analyst

Needham, MA | Freelance | Job ID #43238 |
This job is no longer available.
You can view related vacancies or set-up an email alert notification when similar jobs are added to the website using the buttons below.


Firm based in the General Boston Mass area is seeking a Senior Data Warehouse Analyst to join a 3+ month project ASAP. Must be local as a Face to Face/Onsite Interview is required. 

What You’ll Do:

  • Study and understand the business processes and data needs, related to business areas such as website product development, back end web and native app operations, financial planning and forecasting, business development, and marketing
  • Design and support the components of the Flights data management systems, such as data marts, ETL processes, tables, reports, and reporting environments
  • Drive strategic projects to create opportunity for data driven decision making. For example, identifying areas where existing data may be insufficient then researching and crafting a plan for improvement
  • Manage tactical improvements to a complex data infrastructure. For example, overseeing a project to centralize and standardize similar data coming from different sources
  • Propose and create processes for capturing and maintaining metadata. Recommend ways to reduce manual work and recover efficiency
  • Create data QA plans, anomaly detection measures, and validation to spot and correct errors in the data. Ensure that data loaded into the warehouse systems is accurate
  • Translate business questions and data requirements into specifications for detailed website tracking and logical data models. Effectively communicate business requirements to technical stakeholders and technical requirements to business stakeholders with ease
  • Test and verify tracking for new product features from the live site all the way downstream to reporting
  • Forensic data investigation—investigating and diagnosing often complex data interaction issues
  • Use internally developed tools to create new or enhance existing ETL workflows
  • Establish system documentation and ensure it is continually accurate and sustained


  • Bachelor’s degree in computer science or related technical field
  • Five years of work experience in database systems.
  • Solid RDBMS operational knowledge and outstanding SQL skills, both querying as well as data modeling with large, complex datasets
  • Experience using Hadoop/Hive and writing efficient Hive queries a plus. Experience with developing Oozie jobs is also a plus
  • Knowledge of basic application development and programming practices is a plus
  • ETL expertise
  • Experience with data modeling and architecture
  • Experience with Jira and/or an agile development cycle is a plus
  • Excellent research, analysis and problem-solving skills
  • Ability to understand and communicate business needs. Strong listening skills (important for communicating to technical and nontechnical team members)
  • Ability to work with and support multiple stakeholders
  • Strong verbal and written communication skills


  • The client is unable to support 1099 / Corp-to-Corp or Independent Contractor arrangements at this time. All freelancers will be paid as W2 employees.
  • In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire.
Turn on email alerts for this search

This job has now been filled but you may be interested in:


About Onward Search

Onward Search helps connect digital, creative and marketing talent with choice jobs at the nation's most recognized companies and digital agencies. We offer a full range of recruitment and staffing solutions to include contract, temp-to-perm, and permanent / executive search placement.

Onward Search is an equal opportunity employer, dedicated to a policy of non-discrimination in an employment with regard to race, color, religion, gender, sexual orientation, national origin, age, disability, genetic information, veteran status or any other classification protected by federal, state and local laws and ordinances, nationally and internationally. Candidates must be at least 18 years old to be considered for employment. AA/EOE/M/F/D/V