Job Description

NO THIRD PARTIES . This is almost entirely remote. Individual will only need to work onsite at the Northbrook location 1 day per week. The selected individual will work closely with cross-functional teams, including data engineers, analysts, and business stakeholders, to ensure the successful implementation of data models, ETL pipelines and data processing.

Responsibilities:

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

Required Skills:

• 5+ years of experience in designing, developing, and optimizing data solutions using Amazon Redshift .
• Strong experience with SQL , including complex queries, stored procedures, and functions.
• Knowledge of data modeling best practices (logical, star schema, snowflake schema).
• Proficiency in Amazon Web Services (AWS) ecosystem, especially Redshift.
• Experience with AWS S3 and other AWS services for data storage and processing.
• Experience with Tableau or other comparable tool 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.

Job Tags

Similar Jobs