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.