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.

Responsibilities:

• 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

Qualifications:

• 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.