Enterprise Data Architect - IQ Clarity
Denver, CO 80229
About the Job
IQ Clarity's client, a notable financial institution, is looking for an Enterprise Data Architect.
Job Summary:We are seeking an experienced Enterprise Data Architect to join our growing team in the financial services sector. The ideal candidate will have extensive experience in designing and implementing data architectures across both Oracle Data Warehouses and modern AWS data solutions such as Redshift, RDS, Aurora, Data Lakes, and ETL/ELT processes. This role requires a deep understanding of data modeling to ensure scalability, performance, and high availability of data solutions. The architect will collaborate with various stakeholders to establish data strategy, governance, and best practices for a modern data architecture.
Key Responsibilities:- Data Architecture Strategy: Develop and maintain the enterprise data architecture blueprint, aligning with business strategies and objectives for financial data systems.
- Data Warehouse Design: Design and manage Oracle-based data warehouses, ensuring data is accessible, performant, and reliable for analytics and reporting.
- Cloud Data Architecture: Architect and implement modern data solutions using AWS services such as Redshift, RDS, Aurora, S3 (Data Lake), Glue, and Lambda, leveraging best practices for scalability and cost efficiency.
- ETL/ELT Process Management: Design, implement, and optimize ETL/ELT pipelines to ingest, transform, and load data from various sources to both on-premise and cloud-based environments.
- Data Modeling: Lead efforts in conceptual, logical, and physical data modeling, ensuring data integrity, normalization, and performance optimization across structured and unstructured datasets.
- Data Governance: Establish and enforce data governance policies, including security, privacy, and compliance, with a focus on financial industry regulations (e.g., SOX, GDPR).
- Collaboration & Leadership: Work closely with business analysts, data engineers, developers, and stakeholders to understand data needs and translate them into effective data architecture solutions.
- Performance Tuning: Perform optimization and tuning of data platforms (e.g., query performance, database partitioning, indexing) for large-scale datasets in both Oracle and AWS environments.
- Innovation: Stay updated on emerging trends in data architecture, big data, and cloud technologies, recommending and implementing innovative data solutions.
- Education: Bachelor’s or Master’s degree in Computer Science, Information Systems, Data Science, or a related field (or equivalent experience).
- Experience:
- 7+ years of experience in enterprise data architecture, with a strong focus on data warehouses, data modeling, and ETL/ELT processes.
- Proven experience with Oracle Data Warehouses and cloud data architectures, specifically in AWS (Redshift, RDS, Aurora, Data Lakes).
- Expertise in designing and managing ETL/ELT processes with tools such as AWS Glue, Lambda, or similar technologies.
- Skills:
- Strong proficiency in data modeling (conceptual, logical, and physical) for relational and dimensional data models.
- Deep experience with cloud-based databases and services like Redshift, RDS, Aurora, S3, and Data Lake architectures.
- Familiarity with Oracle databases, including performance tuning, indexing, and managing large-scale data warehouses.
- Strong understanding of data governance, security, and privacy best practices, especially in financial services.
- Proficient with SQL and database performance tuning across cloud and on-prem environments.
- Ability to lead cross-functional teams and communicate effectively with technical and non-technical stakeholders.
- Experience in the financial services industry or other regulated environments.
- Hands-on experience with big data tools such as Hadoop, Spark, or Presto.
- Experience with real-time data streaming technologies (e.g., Kafka, Kinesis).
- Certifications in AWS or Oracle database technologies.
IQ Clarity is an Equal Opportunity Employer
Applicants MUST be located in or around Denver, CO to be considered for this role
Unfortunately, our client is unable to sponsor visas at this time