23 Aug
|
Systech Solutions
|
Chennai
23 Aug
Systech Solutions
Chennai
Company Description : Systech Solutions, Inc. is an end-to-end data and analytics firm providing cloud, data engineering, AI, and machine learning solutions to global clients. With 30 years of experience, Systech helps organizations unify their data landscape and build resilient, data-driven enterprises.
The company focuses on solving complex business problems at the intersection of data, business, and digital technologies, maintaining a customer retention rate above 90% over the past five years. Systech partners with leading technology providers and serves multiple industries, including finance, retail, manufacturing, healthcare, and insurance. A global delivery center, robust training programs, and industry recognition by Inc.
Magazine underscore its commitment to innovation, collaboration, and measurable outcomes.
Experience: 7+ Years
Primary Skills: Amazon Redshift,,
Secondary Skills: Azure DevOps,,
Role Description: 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.
Role Responsibility
- 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
Role Requirement:
- 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.
- Solid 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
📌 Data Engineer - DBT Redshift (Chennai)
🏢 Systech Solutions
📍 Chennai