Job Closed

This listing is no longer active.

AWS Redshift Data Engineer / Data Architect

Data EngineerData EngineerOtherRemoteSeniorTeam 201-500Since 2008H1B SponsorCompany SiteLinkedIn

Location

California

Posted

120 days ago

Salary

0

Seniority

Senior

Job Description

AWS Redshift Data Engineer / Data Architect

Numentica

• Optimize and modernize Amazon Redshift environments, including consolidation into Redshift Managed Storage (RMS). • Lead or support migration from Provisioned Redshift to Redshift Serverless with zero or minimal downtime. • Analyze and tune Redshift SQL for performance across batch and ad-hoc analytical workloads. • Review and enhance data ingestion pipelines from AWS sources such as RDS, DynamoDB, and Kinesis. • Design data delivery into Apache Iceberg tables and Redshift with minimal duplication and high efficiency. • Collaborate with stakeholders on architecture recommendations and best practices.

Job Requirements

  • Strong hands-on experience with Amazon Redshift (Provisioned, Serverless, RMS).
  • Deep SQL performance tuning and query optimization expertise.
  • Solid AWS data engineering background (RDS, DynamoDB, Kinesis).
  • Experience with modern lakehouse concepts, especially Apache Iceberg.
  • Data architecture and analytical platform design experience.

Benefits

  • Remote Job

Related Categories

Related Job Pages

More Data Engineer Jobs

Data Engineer120 days ago
OtherRemoteTeam 51-200Since 2002H1B No Sponsor

• Engineer Complex Data Transformations: You will lead the development of pipelines that translate unstructured XBRL and securities data into optimized SQL Server environments, making complex financial filings accessible and queryable. • Power High-Visibility Applications: You will architect the backend data layer that serves a suite of web applications, ensuring fast load times and data integrity for a diverse user base at a major federal regulator. • Optimize Cloud-Scale Processing: You will leverage AWS and big data tools to handle increasing data velocity and variety, ensuring our infrastructure scales alongside the evolving needs of the financial markets. • Ensure Data Precision: You will implement rigorous validation and cleansing logic within the pipeline to ensure that the data driving federal oversight is accurate, consistent, and audit-ready.

District of Columbia + 1 moreAll locations: District of Columbia | Washington
Job Closed
Full TimeRemoteTeam 501-1,000H1B No Sponsor

• Build and Maintain Bronze/Silver Layer Pipelines: You will ensure core data sources lands accurately, on time, and with full lineage. • Lead Data Ingestion, Transformation, and Enrichment: You will own the end-to-end pipeline from raw file landing through cleansed, conformed staging tables, including deduplication, standardization, code mapping, and entity resolution. • Develop Automated Ingestion Pipelines: You will use Snowpipe, Matillion, or custom solutions with reliability, observability, and minimal manual intervention in mind. • Implement dbt Models: You will write clean, tested, documented SQL that follows medallion architecture patterns and supports incremental processing at scale. • Establish Scalable Engineering Patterns: You will create reusable templates, macros, and testing frameworks that accelerate onboarding of new data sources without sacrificing quality. • Ensure Data Quality and Observability: You will implement dbt tests, freshness checks, and anomaly detection. You will own the pipeline reliability and respond to data quality incidents. • Collaborate with the Architect and Stakeholders: You will translate business requirements into technical specifications, participate in design reviews, and contribute to ADRs, and you will ensure pipelines align with enterprise standards.

India
Job Closed
Precision Medicine Group logo

Senior Data Engineer

Precision Medicine Group

Moving Science Closer to Health

Data Engineer120 days ago
Full TimeRemoteTeam 1,001-5,000Since 2012H1B Sponsor

• Build and Maintain Bronze/Silver Layer Pipelines: You will ensure core data sources lands accurately, on time, and with full lineage. • Lead Data Ingestion, Transformation, and Enrichment: You will own the end-to-end pipeline from raw file landing through cleansed, conformed staging tables, including deduplication, standardization, code mapping, and entity resolution. • Develop Automated Ingestion Pipelines: You will use Snowpipe, Matillion, or custom solutions with reliability, observability, and minimal manual intervention in mind. • Implement dbt Models: You will write clean, tested, documented SQL that follows medallion architecture patterns and supports incremental processing at scale. • Establish Scalable Engineering Patterns: You will create reusable templates, macros, and testing frameworks that accelerate onboarding of new data sources without sacrificing quality. • Ensure Data Quality and Observability: You will implement dbt tests, freshness checks, and anomaly detection. You will own the pipeline reliability and respond to data quality incidents. • Collaborate with the Architect and Stakeholders: You will translate business requirements into technical specifications, participate in design reviews, and contribute to ADRs, and you will ensure pipelines align with enterprise standards.

India
Job Closed
Earnest logo

Senior Data Engineer

Earnest

At Earnest, we empower you to take control of your career so you can empower students to take control of their finances.

Data Engineer120 days ago
OtherRemoteTeam 201-500Since 2013H1B Sponsor

• Drive the technical strategy and execution for our engineering teams • Lead the development of a scalable, high-performance lending ecosystem from customer onboarding to checkout • Architect and build customer-centric financial products, ensuring a frictionless and optimized user experience and orchestrating large-scale financial transactions • Define and execute the technical vision and best practices for a high-performing engineering team • Lead architectural decisions to enhance scalability, reliability, and efficiency of the lending platform • Collaborate with Product, UX, and Business teams to align technology with strategic goals • Design, build, and maintain customer-facing lending applications using Node.js, TypeScript, React/Redux, Angular, Sequelize, PostgreSQL, and Docker • Develop and optimize high-quality, testable code, implementing unit and integration tests with Mocha, Chai, Sinon, and Sequelize • Ensure performance, security, and scalability through best-in-class software engineering practices • Identify and resolve defects through debugging, profiling, logging, log analysis, tracing, and FullStory session replays • Oversee code deployment to Staging and Production environments • Partner with Quality Engineers to address issues found in testing and improve automated testing coverage • Lead and participate in Agile ceremonies • Break down product requirements into engineering deliverables in Jira • Review and provide critical feedback on Product Requirements Documents, Epics, and User Stories, influencing the technical and business roadmap • Recommend alternative technical solutions to optimize delivery speed, enhance customer experience, and reduce costs • Maintain technical documentation • Contribute to Earnest’s DevOps culture and participate in rotating on-call support for production applications

United States
$207.6K / year
Job Closed