AWS Data Engineer

We are seeking a skilled data engineer to work closely with our cross-functional teams. This is an almost entirely remote position, with occasional on-site work at our Northbrook location.

Responsibilities

• Design and implement scalable data models and architecture using Amazon Redshift.
• Collaborate with business and data teams to translate requirements into data models.
• Develop and optimize SQL queries and stored procedures.
• Create and maintain ETL pipelines to ingest and process data from various sources, including Salesforce.com and Dynamics 365.
• Ensure smooth integration of data from multiple sources, including cloud-based and on-prem environments.
• Monitor the performance of the Redshift environment and optimize queries, tables, indexes, etc.
• Apply Redshift best practices to optimize query performance.
• Maintain data integrity, quality, and consistency across the Enterprise Data Warehouse.
• Document data models, ETL processes, and Redshift configurations.
• Troubleshoot issues related to data extraction, transformation, and loading processes.

Requirements

• 5 years of experience in designing, developing, and optimizing data solutions using Amazon Redshift.
• Strong expertise in SQL, including complex queries, stored procedures, and functions.
• Knowledge of data modeling best practices (logical, star schema, snowflake schema).
• Proficiency in the Amazon Web Services (AWS) ecosystem, especially Redshift.
• Experience with AWS S3 and other AWS services for data storage and processing.
• Experience with Tableau or comparable tools like Power BI or AWS QuickSight.
• Prior experience using ServiceNow for building, configuring, and testing new releases.
• Understanding of database optimization techniques (e.g., indexing and query optimization).

Technical Skills

AWS Redshift, EDW (Enterprise Data Warehouse), AWS S3, SQL, Tableau, Power BI, PostgreSQL, ETL Development, Queries, Stored Procedures, ServiceNow, Oracle, and Jitterbit.