ETL Architect with Redshift / SQL / BI Integration :: C2H

Stamford, CT, US • Posted 1 day ago • Updated 21 hours ago
Contract Corp To Corp
Contract W2
Contract Independent
No Travel Required
On-site
Depends on Experience
Fitment

Dice Job Match Score™

🤯 Applying directly to the forehead...

Job Details

Skills

  • Amazon Redshift
  • Business Intelligence
  • Data Modeling
  • Data Architecture
  • ETL Architecture
  • Data Warehouse
  • Modeling
  • Reporting
  • SQL
  • Stored Procedures

Summary

Job Role: ETL Architect – Redshift / SQL / BI Integration
Location: Stamford, CT
Hire-Type: Contract
 
 
 
Role Summary
Seeking a senior ETL Architect to design and modernize the enterprise data architecture supporting BI platforms such as MicroStrategy and Spark-based analytics environments. The architect will lead the restructuring of existing data pipelines, optimize Amazon Redshift data models, and establish scalable ETL frameworks that support reporting, commissions, incentives, and operational dashboards.
The role requires both deep technical expertise and architectural vision, ensuring that data structures, ETL processes, and reporting layers are designed for performance, scalability, and future AI-driven analytics capabilities.

Key Responsibilities
  • Design and implement end-to-end ETL architecture supporting BI platforms such as MicroStrategy and Spark analytics environments.
  • Architect and optimize Amazon Redshift data warehouse structures, including schema design, data modeling, and performance tuning.
  • Develop and standardize SQL-based ETL pipelines, stored procedures, and data transformation processes.
  • Lead data restructuring initiatives, including redesigning existing tables, pipelines, and data packages.
  • Automate manual data workflows and improve overall data processing efficiency and governance.
  • Ensure data quality, consistency, and standardization across enterprise reporting systems.
  • Integrate multiple data sources supporting commission systems, incentive platforms, and operational dashboards.
  • Establish data architecture standards, best practices, and governance frameworks for ETL development.
  • Collaborate with business stakeholders to understand reporting requirements and business logic, ensuring solutions align with operational needs.
  • Provide architectural leadership and mentorship to junior ETL developers.

Required Skills
  • Strong expertise in SQL development and optimization
  • Hands-on experience with Amazon Redshift
  • Development of complex stored procedures and data transformation logic
  • Experience designing enterprise-scale ETL pipelines
  • Data modeling for data warehouses and BI environments
  • Experience integrating data into BI platforms such as MicroStrategy
  • Familiarity with Spark-based analytics platforms
  • Strong understanding of data governance, architecture standards, and data lifecycle management

Preferred Capabilities
  • Experience modernizing legacy reporting environments
  • Exposure to AI/analytics integration opportunities
  • Ability to design systems supporting self-service BI and enterprise reporting
  • Experience working with cross-functional stakeholders and business users
 
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10122703
  • Position Id: 8927151
  • Posted 1 day ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Stamford, Connecticut

Today

Easy Apply

Contract

Depends on Experience

Stamford, Connecticut

Yesterday

Easy Apply

Third Party, Contract

Depends on Experience

Stamford, Connecticut

Today

Easy Apply

Contract

Depends on Experience

Stamford, Connecticut

Today

Contract

Search all similar jobs