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.  The ideal candidate should have demonstrated experience adding value to the business through front-end reporting solution delivery.  Knowledge of industry best practices and the latest technology trends is critical, and advanced analytics is a plus.  This will be a client-facing position and therefore, you should be comfortable working as part of a team to effectively communicate complex information and deliver creative solutions to all levels of a client organization. 

We are looking for are a collaborative problem solver who enjoys both learning from others and sharing what you have learned with the team and with our clients.  

What’s in it for you?

An opportunity to work on diverse and cross-functional teams in a fun, fast-paced environment delivering creative solutions to Fortune 500 clients.  Archetype employees are provided with competitive benefits and regularly recognized for their outstanding character, integrity and excellence.

Desired Skills and Experience

  • Experience leading Business Intelligence / Data Warehousing projects in all phases of the solution design and delivery.  This includes requirements gathering, tool and vendor selection, project/sprint planning, development and testing/validation, user training, user acceptance/validation testing, and documentation
  • 5-8 years of relational and/or multi-dimensional database experience
  • Data modeling of relational and dimensional databases Metadata management, data lineage, data governance, especially as related to Big Data Structured, Unstructured, Semi-Structured Data techniques and processes
  • 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
  • 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
  • Ability to install/configure/troubleshoot software and hardware as well as conduct performance tuning.
  • 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 at all levels of business and IT - 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
  • Develop and maintain knowledge of the Archetype solutions portfolio and specific practice area offerings.  Act as sales/engineering support for newly identified opportunities.  Lead process improvement and innovation to the Professional Services methodology and services.
  • Experience in leading data integration and enterprise performance management projects are preferred
  • Ability to implement ETL concepts using native database utilities and third-party tools (ODI, Talend, SSIS, Informatica, SQL*Loader, Custom PL SQL packages)
  • Familiar with predictive analysis and data visualization techniques using relevant tools (e.g. Tableau, D3.js and R.)
  • Ability to manage data and metadata migration Experience with database platforms, including MySQL, MS SQL Server, Snowflake and AWS Redshift Understanding of Web services (SOAP, XML, UDDI, WSDL) Experience with data processing flow charting techniques Qualifications Continuous delivery and deployment using Agile Methodologies. 
  • Data Warehouse and DataMart design and implementation NoSQL environments such as MongoDB, Cassandra
  • 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
  • Hands-on experience delivering Data Warehouse solutions at scale, and ability to quickly learn new technologies, 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
  • Strong analytical problem solving and decision-making skills.  Willingness to coach or challenge client thinking when and where appropriate.
  • 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:

At Archetype we believe that a consistent commitment to the right priorities results in a high value and competitive firm.  The following list of core values reflects what is important to our founders to guide our culture and define the character of our organization.  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.

Apply for this Position
* Required fields
First name*
Last name*
Email address*
Location *
Phone number*

Attach resume as .pdf, .doc, .docx, .odt, or .rtf (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*