Sr. Data Architect Consultant

Cleartelligence is seeking a Sr. Data Architect Consultant that will be responsible for defining, articulating, implementing and realizing our data architecture strategy to meet the strategic Data Analytics goals. This role will involve a broad spectrum of application, information, technical, data and business architectures with an Enterprise focus across a global group of stakeholders.



  • Define and implement standards and processes to ensure alignment with the architectural strategy and goals of the business

  • Collaborate with key stakeholders to ensure data architecture alignment with key portfolio initiatives on the basis of cost, functionality and practicality

  • Document and articulate relationships between business goals and information technology solutions

  • Conduct architecture assessments and reviews to ensure alignment with business goals and strategies

  • Provide in-depth technical architectural support during program/project solution analysis and design to ensure road-map alignment

  • Champion data quality and effective use of available information

  • Participate in POC evaluations of technologies and tools

  • Implement data handling, cleansing, and standardization procedures and business transformation rules and logic (ETL).

  • Develop, implement and maintain scripts, functions, stored procedures, and ETL jobs

  • Translate complex business issues and requirements into structured analytics use cases

  • Rapidly develop/test/iterate analyses that will reveal insight and opportunities for the client and build end to end analytical solutions




  • 7+ years of database focused IT or software development experience with extensive integration experience.

  • 5+ years of experience implementing complex queries against large datasets to support business intelligence functions.

  • 5+ years of full lifecycle data warehousing experience or 5+ years of experience in implementing data integration efforts in large scale projects.

  • 5+ years of experience with ETL, application and database performance tuning and debugging.

  • 5+ years minimum experience using standard Informatica PowerCenter.

  • Understanding of Dimensional Modeling and Data Warehouse concepts, such as star schema, snowflakes, dimensions, facts, etc.

  • Experience with Alteryx a plus.

  • Experience following Agile development methodologies.

  • Experience following release management and quality assurance processes.

  • Very strong customer service orientation.

  • College degree in computer science/computer information systems or equivalent business experience.

Ready to Make Analytics Work for You

Learn more about how we can help get your project started

New England Office

275 Grove Street, Suite 2-400

Newton, MA 02466

(617) 340-7740

Tri-State Office

100 Overlook Center, 2nd Floor

Princeton, NJ 08540

(609) 246-0029


  • White LinkedIn Icon
  • White Twitter Icon
  • White Facebook Icon


 © Cleartelligence, Inc. 2018

All Rights Reserved