Lead Data Warehouse Engineer (Redshift)

Key Skills

Aartificial intelligence, Amazon Simple Storage Service (S3), AWS, Data Warehousing, Design, DynamoDB, Generative AI, Lambda, Leadership Skill, MLOps tools, Python Programming, SQL

Job Description

WE ARE

SoftServe is a global digital solutions company with headquarters in Austin, Texas, founded in 1993. Our team consists of passionate innovators working on over 2,000 cutting-edge projects around the globe from the USA and Europe to the Asia-Pacific region.

As Big Data & Analytics Center of Excellence, a data consulting and data engineering branch of SoftServe we collaborate with our client, a titan in the energy sector who is dedicated to innovating and investing in clean energy electrifying across 49 states in North America. Their storied history of corporate responsibility, operational excellence, and relentless innovation has not only earned them widespread recognition but also solidified their commitment to pioneering new technologies in the energy landscape.

SoftServe embarks on this thrilling journey with the client, therefore we are assembling an elite AI and Data project team of professionals to drive innovations in the energy and logistics domain.

IF YOU ARE

• Proficient in SQL and Python
• Experienced in big data technologies
• Accustomed to working with cloud platforms, specifically AWS
• Familiar with ETL tools and processes
• Equipped with excellent analytical and problem-solving abilities
• A strong communicator with demonstrated leadership skills
• Capable of thriving in a fast-paced, dynamic environment

AND YOU WANT TO

• Analyze, design, develop, test, debug, implement, maintain, integrate, customize, and enhance Redshift database components
• Ensure optimal performance, scalability, and reliability, including managing tables, views, stored procedures, and distribution keys
• Design, develop, and implement ETL processes to load or expose data from various sources like S3, RDS, or other data sources into Redshift
• Implement best practices for data governance, access control, data encryption, and user roles to ensure data security and compliance
• Apply best practices for proactively identifying and resolving issues or errors
• Monitor system logs, implement backup and recovery strategies, and stay updated on AWS Redshift patches
• Understand how AWS services interact with Redshift, including S3, Glue, IAM roles, CloudWatch, EventBridge, RDS, DynamoDB, Lambda, and CloudFormation
• Apply Agile or other development methodologies, system development lifecycles, tools, and technology
• Collaborate with a team of data-focused engineers specializing in ML, MLOps, analytical AI, GenAI, large data engineering efforts, and AWS
• Participate in the entire project lifecycle, from initial design through PoCs and MVP to full-scale implementation
• Design and implement data and analytics solutions in AWS
• Elicit customer requirements, translate them into technical architecture, and present your decisions and proposals to the customer
• Visit the client’s offices in Warsaw, Poland, and Florida, USA

TOGETHER WE WILL

• Address different business and technology challenges, engage in impactful projects, use top-notch technologies, and drive multiple initiatives as a part of the Center of Excellence
• Support your technical and personal growth — we have a dedicated career plan for all roles in our company
• Investigate new technologies, build internal prototypes, and share knowledge with the SoftServe data community
• Upskill with full access to Udemy learning courses
• Pass professional certifications, encouraged and covered by the company

SoftServe is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment regardless of race, color, religion, age, sex, nationality, disability, sexual orientation, gender identity and expression, veteran status, and other protected characteristics under applicable law. Let’s put your talents and experience in motion with SoftServe.