Data Warehouse Solution Architect

Location: Boston, MA

Department: Sevices Delivery

Type: Full Time

Min. Experience: Experienced

Who we are looking for:

As we continue to grow, Archetype is currently looking for an experienced Data Warehouse Solutions Architect to join our Services Delivery team.  We are seeking results-driven, entrepreneurial thinkers who prioritize character, integrity and excellence.  Specifically, we're looking for someone who is both able to design and develop data warehouses and the ETL processes that feed them.  This will be a client-facing position and therefore, you should enjoy working as part of a team to effectively communicate and deliver creative solutions.  If this describes you, you may be a great fit for our company.  

What’s in it for you?

An opportunity to work with great people in a fun, entrepreneurial, rewarding environment, delivering creative solutions, where employees are not only provided with competitive benefits, but are also recognized for their outstanding character, integrity and excellence.

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

Archetype Values:

Archetype was founded by two principal consultants who believed at their core that they, if committed to the right priorities, could build a highly valued, extremely competitive firm and have fun doing it.  The following list of core values reflects what was important to our founders and they continue to shape our culture and define the character of our organization today.  These are not values that change from time to time, situation-to-situation or person-to-person, these values are the soul of our Company.

Integrity – Be ethically unyielding. Let both your words and behavior be consistent, honorable and of the highest moral standards. Do the right thing, no matter what.
Personal Responsibility – Take the initiative whenever appropriate. Never put things off that should be done now. Delegate but never abdicate responsibility. Say what you mean, mean what you say. Let your word be your bond.
Work the problem, not the hours – We create value through solving key problems on behalf of our customers. Our customers ask us back only if we effectively and efficiently solve problems, both those we plan for and those we don’t plan for.
Customer Centricity – Our goal is to drive shareholder value for our clients through innovative solutions that increase efficiency and effectiveness. This is only possible though an intimate understanding of their business, their leadership and their goals.
One Team, Winning Team – Being right without being understood is fruitless. Being wrong, without listening and adapting is inexcusable. The greatest success is driven through identifying the right thing, doing it and demonstrating it to others. Our clients deserve leadership and the maturity necessary to drive consensus and get things done. Often times this requires bridge building, hatchet burying and an appetite for crow.
Be Humble – "Fullness of knowledge always and necessarily means some understanding of the depths of our ignorance, and that is always conducive to both humility and reverence.” – Robert A. Millikan 

We are an Equal Opportunity employer committed to delivering the compensation and employment benefits commensurate with the caliber of people we seek.

Forward this Position
Recipient email address (one)
Your name
Your email address
Enter a message (optional)
Apply for this Position
* Required fields
First name*
Last name*
Email address*
Location *
Phone number*

Attach resume as .pdf, .doc, or .docx (limit 5MB) or paste resume

Paste your resume here or attach resume file

Cover Letter*
Who referred you to this position? Enter their first and last name here.
What’s your citizenship / employment eligibility?*
What’s your highest level of education completed?*
College or University*
What languages do you speak fluently?
Have you ever been convicted of a felony?*
If “Yes”, you have been convicted of a felony, please explain the circumstances around the conviction:*
In 150 characters or fewer, tell us what makes you unique. Try to be creative and say something that will catch our eye!*
Problem #1
Think back to your college days. No, not to the late nights of "studying", but from a more holistic perspective. If you're helping your alma mater build a data warehouse, would you know where to start?
- What would the end data warehouse look like (which fact or dimension tables would be needed)?
- What source systems would be used to populate the data warehouse?
- How would you get the information from the source systems to the data warehouse?
- How would you ensure that the data is properly and holistically captured, while maintaining quality data that leads to useful information?*
Problem #2
Let's say you have a table in your favorite RDBMS with the month populated in the rows. Would you know how to pivot the information to have the months be the column headers using SQL? Can you do this without using pre-defined pivot functions?*
Problem #3
Buzzwords and acronyms, do you know them (and not just of them)?
Attribute, Change Data Capture, Data Cleansing, Data Mart, Data Warehouse, Degenerative Dimensions, ETL, Foreign Key, INTERSECT, Junk/Garbage Dimensions, Informatica, MINUS, Multistar Schema, OBIEE, ODI, ODS, OLAP, OLTP, Primary Key, SAP BO, Slowly-Changing Dimensions, Snowflake Schema, Star Schema, Surrogate Key, Time Variant, UNION, Unique Constraint*
How did I do?
- "I know some of these words" - This is probably not the right position for you.
- "I had to look a few things up, but got all three problems" - Depending on your definition of a few, take a chance and apply. We'd love to meet you. If this isn't the right position for you, we may consider you for our BI/SQL Consultant position.
- "Is that all you got?" - This was just a warm-up, but we think you would likely be a good general skills match for this position. Apply now for some more challenges!
Human Check*