Rarefied talent in data science, data technology, and analytics

Senior Consultant - Data Warehouse Architecture

The Ironside Group

Job Description

The Ironside Group has an immediate opening for a Data Architect Consultant.  We are looking for technically savvy, highly motivated, entrepreneurial, strategic thinkers who are interested in an opportunity to fast-track their careers in information management. The Ironside Group is an established market leader with a reputation of delivering the highest quality solutions by way of only the most qualified and experienced consultants. We're looking for the best and brightest to join those ranks and rapidly grow within our tight-knit community.

The main focus of this role entails assisting clients with business intelligence (BI) related database design and/or creation. The individual will be expected to work with clients across multiple markets and industries often playing several different roles within a project lifecycle. Excellent requirements gathering and communication skills are a must.


  • Provide strategic and tactical guidance with respect to data warehousing best practices and attention to quality documentation within large and mid-market organizations.
  • Manage both internal and external resources, timelines, and milestones across a vertical set of industries.
  • Provide overall thought leadership to organizations with regards to creative data profiling and integration recommendations.
  • Responsible for designing and implementing detailed data warehouse models and data mappings.
  • Resolving any and all issues throughout the development lifecycle.
  • Perform performance optimization and tuning on new and/or existing data warehouse implementations.
  • Provide detailed documentation, end user training and knowledge-transfer services to customers.
  • Support annually defined companywide strategic goals aimed at the continued expansion of the Ironside Group.
  • Develop and maintain expertise in advanced and/or emerging data warehouse and analytical information technologies such as Hadoop, in-memory analytics, data warehouse appliances, and data warehouse virtualization.
  • Continue professional and technical growth through corporate and personnel initiatives.


  • A Bachelor’s degree from an accredited college or university in Computer Science, Information Science, or related field.
  • 5 years of experience in a data architecture role.
  • Practical experience using ETL tool (Informatica, Data Stage, Data Manager, SSIS, or other).
  • Working knowledge of modeling tools (Erwin and/or Rational Rose) in addition to hands-on experience with business intelligence tools.
  • Excellent data profiling abilities.
  • Expert knowledge of SQL and related SQL procedure languages.
  • OLAP experience is a plus.
  • Excellent organizational, interpersonal, and oral/written communication skills.
  • Experience in managing data warehouse project and lifecycle initiatives.
  • Regional travel would be required.
  • Experience working with Teradata, Netezza, DB2 or Hadoop is desired.
  • Subject matter expertise in Insurance or Financial Services (Asset Management, Hedge Funds, Banking) is a plus.


  • The opportunity to join and grow an ever expanding professional network of high profile clients and reputable colleagues.
  • A passionate and approachable leadership team that encourages an entrepreneurial frame of mind and welcomes contribution to business development from all members of the team.
  • A challenging, dynamic and rewarding work environment which fosters rapid professional growth in a space that is at the forefront of information technology.
  • An unparalleled opportunity to gain in depth operational experience across a variety of industries and organizational departments.
  • The opportunity to explore and put into practice cutting edge technology on a regular basis.
  • An incentivized development program that enhances your skill set with professional training and certifications.
  • Big company benefits and competitive merit-based compensation and bonus packages that rapidly reward passionate and driven team members.

About Ironside

Founded in 1999, The Ironside Group is widely regarded as a market leader and perennial innovator in the ever-growing Business Analytics space. We continually uphold our reputation of delivering the highest quality solutions by way of only the most qualified and experienced consultants and we're looking for the best and brightest to join those ranks and rapidly grow within our tight-knit community.

Interested in this position?
Job Location
Philadelphia, PA
Additional Job Details
Employment Type:
Full Time