Senior Data Warehouse Engineer - Pasadena, United States - Winmaxcorp
Description
Senior Data Warehouse Engineer
Aug 31, 2021Pasadena, California
**Senior Data Warehouse Engineer
6 Months contract
Remote Workplace, CA**
Job Description: Senior Data Warehouse Engineer
This position will be essential for the continuous success of the Enterprise Data Warehouse team.
Working side-by-side with existing data warehouse team members as well as analytical and core teams this position will be responsible for creation, support and maintenance of the existing and new ETL/ELT and data management tools and processes.
Using knowledge and expertise with data warehousing industry best practices, as well as ability to think outside of the box, this role will engineer the ELT/ETL and Data architecture and development, design, deployment, and operations of all matters pertaining to the enterprise data warehouse.
Candidates should be hands on and demonstrate strong work ethic, sound engineering practice, and the ability to tackle the most difficult problems facing the team.
Also, this position will require the engineer to perform on-call support on a rotational basis.Responsibilities
Design / Engineer and collaborate with a team of engineers to deliver ETL, ELT, and Data Warehouse solutions to fulfill company business requirements
Design and build a scalable and modern data warehouse environment.
Work with a team to engineer ETL, ELT, and Data Warehouse solutions to fulfill company business requirements
Work with a team to build a scalable and modern data warehouse environment.
Participate in the Architecture and build of the overall ETL, ELT architecture
Interface closely with product, engineering and business divisions.
Combine consultative skills with analytical knowledge to critically evaluate objectives and customer requirements and translate these into technical requirements.
Deliver quality solutions that are optimal in performance and easy to maintain
Help support and keep the existing technical architecture running, help to support the existing ETL and DW processes insuring minimal down time, and meeting SLAs
Constantly improving the existing technical architecture and processes to improve performance, improve time to market, and reduce maintenance.
Provide off hours production support along with a team of engineers.
Skills/Experience:
7 years of relevant experience in architecting, building, and maintaining large scale data systems
1-3 years of advanced SQL
1-3 years of experience developing cloud solutions and utilizing relevant cloud services.
3 years+ experience in scripting languages (like bash/powershell/python/ruby)
3 years of experience in engineering large-scale data-intensive systems.
Bachelor's degree in computer science or related field. Masters degree a plus.
Knowledge of Informatica (Power Center or cloud) required
Expertise in Amazon Redshift preferred.
Deep knowledge in various ETL/ELT tools and concepts, multi-dimensional data modeling, SQL, query performance optimization, OLTP,OLAP, MDM
Knowledge of MPP databases, architecture, and performance tuning a plus
Programming experience is a plus.
Experience with all phases of the software development life cycle (SDLC). Worked with schedulers and source control software like TFS.
Excellent written and verbal communication skills.
Banking/Financial experience is a plus
Strong verbal and written presentation skills are required.
Actively listen to others to understand their perspective and be able to present complex topics and analysis in easy to comprehend manner.
Ability to combine industry knowledge, experience, innovate skills, and user input to create a flexible and an optimized DW infrastructure.
Must be able to simultaneously handle multiple projects and meet deadlines with proven ability to succeed in a high activity/pace environment with managing associated stress.
#J-18808-Ljbffr