Job Closed
This listing is no longer active.
AWS Redshift Data Engineer / Data Architect
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 Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
• 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.
• 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.
• 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.
Senior Data Engineer
EarnestAt Earnest, we empower you to take control of your career so you can empower students to take control of their finances.
• 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




