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.