ETL Architect Redshift / SQL / BI Integration :: Stamford, CT (Only On-Site)

Stamford, CT, US • Posted 4 hours ago • Updated 4 hours ago

Contract Independent

Contract Corp To Corp

Contract W2

No Travel Required

On-site

Depends on Experience

Fitment

Dice Job Match Score™

🎯 Assessing qualifications...

Job Details

Skills

ETL architecture
Redshift
MicroStrategy
Spark
SQL
ETL pipelines
stored procedures
SQL development
data warehouse

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: 8914309
Posted 4 hours ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Data Architect (Stamford, CT)

Stamford, Connecticut

•

11d ago

Onsite : City of Stamford CT Data Architect: Bachelors degree in Computer Science, Information Systems, Data Engineering, or a related technical field. A Masters degree is preferred. 10+ years of experience in data architecture, data engineering, data warehousing, or enterprise data management. Experience working in U.S public sector municipal agency environments, with understanding of public-sector procurement and compliance processes. Demonstrated experience with data warehousing concepts, E

Easy Apply

Full-time, Third Party

Depends on Experience

BI Analyst IV

Fairfield, Connecticut

•

Today

This position is for a BI Analyst located in Stamford, CT, focusing on improving customer experiences through analyzing network impacts. The role is hybrid, allowing flexible work conditions. About the Opportunity: Hybrid or Remote: Hybrid, 4 in-office, 1 remote Setting: Service Reliability organization Responsibilities: The BI Analyst will be responsible for: Supporting the Service Reliability organization Improving customer experience through analytics Analyzing impacts of network outages, imp

Easy Apply

Contract

$55 - $65 per hour

Google Cloud Platform DATA ENGINEER - New Jersey, Onsite. Must be strong expertise in Google Cloud Platform services, Cloud environment, BigQuery, Cloud storage, Cloud run, Dataflow, Cloud SQL, AlloyDB, Cloud Balancer, PubSub, IAM, Logging and Monitoring, SQL, Python and Linux scripting, ETL tools such as Datastage, Informatica, SSIS, data modeling (star/snowflake) and data warehouse concepts, CI/CD, version control (Git), and Infrastructure as Code (Terraform) and Google Cloud Platform Professional Data Engineer or Cloud Architect certification is a plus.

Jersey City, New Jersey

•

3d ago

Need min 5 Years exp in USA JD for Google Cloud Platform DATA ENGINEER Job Summary: We are seeking a skilled Google Cloud Platform (Google Cloud Platform) Data Engineer to design, build, and optimize data pipelines and analytics solutions in the cloud. The ideal candidate must have hands-on experience with Google Cloud Platform data services, strong ETL/ELT development skills, and a solid understanding of data architecture, data modeling, data warehousing and performance optimization. Key Respo

Easy Apply

Contract, Third Party

Depends on Experience

Remote- Power BI Developer (with Data Engineering Skills)

New York, New York

•

Today

Power BI Developer (with Data Engineering Skills) Duration:Contract / Contract to Hire Work Type:Onsite / Hybrid (based on client requirements) Job Overview We are seeking aPower BI Developer with strong Data Engineering capabilitiesto design and maintain enterprise reporting solutions while supporting modern data pipelines in the Azure ecosystem. The ideal candidate will have experience buildingPower BI dashboards, datasets, dataflows, and SSRS reports, along with hands-on experience d

Easy Apply

Third Party, Contract

Depends on Experience

Search all similar jobs