website-hero-image2

2754 Data Engineer-Warehouse

Location: Remote

Description:
Our client has helped students rent and buy textbooks affordably since 1999. They are looking for a Warehouse Data Engineer to help architect and develop their evolving data platform. The Warehouse Data Engineer role will be part of the growing data team, interfacing closely with software engineering. If you are a highly independent worker and have excellent organizational and problem-solving skills, this is the job for you. If you’d be interested, please send your resume to careers@itmotives.com. We value diversity in the workplace and encourage women, minorities, and veterans to apply. Thank you!

Job Type: FTE

Additional Information:
You will be working closely with business partners, and software engineering teams playing a vital role in the design, build, and maintenance of OLTP data stores; providing timely, accurate, and reliable information to all aspects of the business. As we incrementally improve and expand our company, you will be building new systems from the ground up or replacing legacy systems outright, free from supporting legacy code bases.

Duties and Responsibilities
· Development, construction, and maintenance of data models within Data Warehouse(s) (Dimensional modeling/Kimball)
· Conduct testing on large scale data platforms
· Handle error logs and build robust data pipelines
· Ingest and transform structured and semi-structured data into data models
· Administration of Data Warehouse(s)
· Manage data lake(s)
· Translate business requirements into technical specifications
· Participate in all design reviews and requirement sessions, as required
· Understand database design, programming concepts, cloud architecture patterns, and data modeling
· Communicate ideas to both technical and non-technical people in all levels of the organization
· Create or update technical documentation for transition to support teams, including data flows and transformations
· Develop automated data audit, testing, and validation processes
· Stay up to date on ever-evolving technologies

Minimum Job Requirements
· 3 years of data warehousing experience
· Expert SQL skills and database ETL/ELT
· Proficient with GIT
· Experience with public cloud solutions (i.e., AWS (preferred), Azure, GCP)
· In-depth knowledge of relational databases (e.g. PostgreSQL, MSSQL)

Preferred Qualifications
· Experience in delivering solutions based on Agile principles
· Experience with DBT
· Experience with Snowflake
· BS in Computer Science, Engineering, or related field, or equivalent job experience