Report Developer

Location: Boston, MA

Department: Service Delivery

Type: Full Time

Min. Experience: Mid Level

What we are looking for:

As we continue to grow, Archetype is currently looking for Reporting Developers / Data Analysts to join our Service Delivery team.  We are seeking results-driven, entrepreneurial thinkers who prioritize character, integrity and excellence.  If you are a team player, a collaborative problem solver, enjoy sharing what you have learned, are passionate about technology, love helping clients, and are motivated by their success, then you may be a good fit for our team!

As a Reporting Developer / Data Analyst you will be involved in the following phases of a project: solution implementation, testing/validation, user training and acceptance, and post-deployment reporting and operations. Your primary role will be supporting client reporting (ad-hoc and scheduled) by extracting data from the solution/source system. You will assist with understanding the data model and will need to be able to translate the technical understanding into business impact. Additional activities include troubleshooting data integrity issues, providing daily data status updates, and fulfilling ad-hoc data-related requests from the client or internal project team.

In addition to client work, you will participate in “firm building” initiatives and activities that contribute to the growth of Archetype and our people.  We are not looking for just anyone. We are looking for individuals who have demonstrated the ability to deliver, who can collaborate and work in a team, and who enjoy learning and solving challenging problems.


  • BS in computer science, MIS, math, science, engineering, or related field
  • 1-3 years of Oracle, Microsoft, or MySQL Database Hand’s-on Experience
  • 1-3 years of work experience in related field such as consulting, finance, engineering, or healthcare
  • Proficiency with intermediate/advanced SQL concepts (i.e. various joins, sub queries, analytic functions) a big plus
  • Ability to translate technical jargon into meaningful business language for end users
  • Experience working on Business Intelligence / Data Warehousing projects a plus
  • Ability to communicate effectively - excellent written and oral communication skills. English Fluency required both written and oral.
  • Able and willing to travel up to 50%
  • Must be eligible to legally work in the United States and pass a background check


Ideal Candidate Sketch:

  • Strong problem solving skills
  • Excellent Interpersonal skills and business etiquette
  • Ability to quickly learn complex concepts & methodologies
  • Excellent communication via email, phone, or conversation
  • Person of integrity
  • 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

About the Company

We are a professional services firm focused on helping organizations make better decisions.  We specialize in delivering breakthrough results through Business Intelligence and Enterprise Performance Management solutions.  We offer highly individualized services, sized and managed to each organizations individual context. Working with our clients we help to develop strategic vision, improve and align processes, implement solutions, develop internal expertise, and provide on-going support services.

As a professional services firm it is our people that make the all the difference; our shared dedication and collaborative approach, enables us to deliver innovative results for our clients and makes Archetype a great place to work.

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 2MB) or paste resume

Paste your resume here or attach resume file

Cover Letter*
What’s your citizenship / employment eligibility?*
What’s your highest level of education completed?*
College or University*
Have you ever been convicted of a felony?*
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!
The following questions are entirely optional.
To comply with government Equal Employment Opportunity / Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more.
Veteran/Disability status
Human Check*