Data Warehouse Solutions Architect-Boston, MA 

Desired Skills and Experience:

  • Experience leading Business Intelligence / Data Warehousing projects
  • 5-8 years of relational and/or multi-dimensional database experience
  • Experience with Oracle, SQL Server, T-SQL, PL/SQL; proficiency with advanced SQL concepts such as complex joins, triggers, cursors, correlated sub queries, analytic functions
  • Ability to implement ETL concepts using native database utilities and third-party tools (ODI, Talend, SSIS, Informatica, SQL*Loader, Custom PL SQL packages)
  • Experience extracting data from a variety of data storage media including relational databases, web services, LDAP querying and a variety of flat file structures
  • Strong problem solving skills; strong multi-tasking skills
  • Understanding of the best-practices in concepts such as change data capture and master data management
  • Understanding of transactional system architectures
  • Ability to communicate effectively with various user groups - excellent written and oral communication skills
  • Ability to translate technical solution designs into tangible benefits for the business
  • Proven ability to apply industry best practices around data warehousing standards
  • Experience in leading data integration and enterprise performance management projects are preferred
  • Minimum BA or BS in a relevant field
  • Able and willing to travel
  • Must be eligible to legally work in the United States

Ideal Candidate Sketch:

  • Excellent interpersonal skills and business etiquette
  • Ability to quickly learn complex concepts & methodologies
  • Excellent communication via email, phone, or in-person
  • Ability to work independently in a fast-paced environment and have excellent relationship management skills
  • Accepts responsibility, proactively problem-solves and goes the extra mile to ensure deadlines are met
  • Open-minded, self-motivated and feels comfortable in a strong team-oriented environment