> Markdown version of [/jobs/ext/2499725-senior-data-engineer-dbt-redshift](https://www.wearedevelopers.com/jobs/ext/2499725-senior-data-engineer-dbt-redshift). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Data Engineer - DBT & Redshift - **Company:** SYSTECH RETAIL SYSTEMS (USA) INC - **Location:** Glendale, CA, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Sql Data Warehouse, Application Frameworks, Microsoft Azure, Bash Shell, Big Data, Databases, Continuous Integration, Data Architecture, Information Engineering, Data Governance, Data Transformation, Data Security, Data Systems, Data Warehousing, Database Queries, Dimensional Modeling, Python (Programming Language), Performance Tuning, Windows PowerShell, Cloud Services, SQL Stored Procedures, SQL Databases, Data Streaming, Systems Integration, Data Ingestion, Analytic Functions, Git, Data Lakes, Data Analytics, Enterprise Integration, Non-relational Database, Data Management, Video Streaming, Data Pipelines, Amazon Redshift - **Published:** August 24, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=35214e13f0757c04 ## About the Role * Excellent hands-on knowledge of dbt architecture, configuration, user setup, and administration. * Experience with enterprise-level dbt installation and configuration. * Hands-on experience configuring role-based user access within dbt. * Strong experience integrating dbt with Amazon Redshift datasets. * Experience integrating dbt with existing Azure DevOps (ADO) configurations and enterprise development workflows. * Strong understanding of managing authentication and authorization across dbt and underlying Redshift data access. * Experience implementing or supporting Natural Language / Conversational BI capabilities through an analytics interface connected to dbt and Redshift. * Ability to ensure conversational analytics access honors the underlying user's credentials, roles, and data access permissions. * Strong understanding of security requirements for PII and PCI data, including controlled and authorized access to sensitive datasets. * Hands-on dbt development experience, including development and maintenance of transformation models and associated dbt components., * Strong proficiency in SQL, including complex queries, analytical functions, stored procedures, and performance optimization. * Strong understanding and hands-on experience with modern data architecture, including Data Lake, Lakehouse, Cloud Data Warehouse, Medallion Architecture, and ELT patterns. * Strong understanding of data warehousing and data modeling, including dimensional modeling, fact/dimension design, and Slowly Changing Dimensions (SCD). * Hands-on experience with cloud data platforms and modern data engineering technologies. * Experience working with relational and non-relational databases, data ingestion, and streaming technologies. * Understanding of data quality, governance, security, and observability practices. * Proficiency in Python, Shell, PowerShell, or equivalent scripting and automation technologies. * Experience with Git, CI/CD, and Agile delivery practices. * Strong analytical, troubleshooting, and problem-solving skills with the ability to independently diagnose and resolve complex technical issues. * Excellent communication, documentation, collaboration, and stakeholder management skills, with a strong sense of ownership and accountability. ## Description The Data Engineering role requires designing, implementing, configuring, and supporting enterprise dbt environments integrated with Amazon Redshift. The role involves managing the dbt platform, configuring users and roles, establishing integrations with existing data and development environments, and developing dbt-based data transformation solutions. The individual will also support secure access to data through natural language and conversational analytics capabilities, ensuring that user access permissions are consistently enforced across the analytics interface, dbt, and underlying Redshift datasets., We are looking for a Senior Data Engineer to design, develop, and optimize scalable, reliable, and secure data platforms and pipelines. The role requires strong expertise in modern data engineering, cloud data platforms, data architecture, data modeling, and database technologies, with the ability to translate business requirements into high-quality, production-ready data solutions. The candidate will work closely with cross-functional teams to build and evolve data products, optimize performance and cost, ensure data quality and governance, and contribute to engineering standards and best practices across the organization., * Design, develop, and maintain end-to-end data pipelines, data platforms, and integration solutions across batch and streaming workloads. * Translate business, functional, and technical requirements into maintainable, production-ready data solutions. * Build data flows across structured, semi-structured, and unstructured sources using appropriate ingestion and integration patterns. * Develop data transformation and processing workflows to support large data volumes and evolving business requirements. * Implement data quality, validation, reconciliation, testing, and observability practices across data pipelines. * Optimize data pipelines and processing workloads for performance, scalability, and cost efficiency. * Implement security, privacy, access control, and data governance throughout the data lifecycle. * Monitor pipelines and platform components, troubleshoot failures, perform root-cause analysis, and implement corrective actions. * Collaborate with architects, stakeholders, application teams, and QA/UAT teams to deliver solutions aligned with business objectives. * Contribute to CI/CD, automation, reusable frameworks, development standards, mentoring, and continuous improvement initiatives. ## Related Videos - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Branch your database like your code: How schema changes and pull requests go hand in hand](https://www.wearedevelopers.com/videos/350-branch-your-database-like-your-code-how-schema-changes-and-pull-requests-go-hand-in-hand) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)