EDW Architect/Lead - RedShift & Boomi

Tandym Group; Cambridge (MA); Remote; USD 80,000 - 100,000; Full time

Job summary

A leading company is seeking an Enterprise Data Warehouse Lead to architect a new data warehouse using Redshift and Boomi. This fully remote role requires expertise in SQL, data security, and visualization tools. The ideal candidate will thrive in a mid-senior level position, working independently within a smaller environment, and will have experience supporting Pharma or Medical Device clients. Join us to optimize data processes and enhance reporting capabilities.

Qualifications

• Expertise in Amazon Redshift and Boomi required.
• Experience with data visualization tools like Tableau and Power BI.

Responsibilities

• Architect a new Enterprise Data Warehouse using Redshift.
• Implement data security measures within Redshift.
• Design robust ETL processes for data integration.

Skills

Amazon Redshift

SQL

Data Security

Data Visualization

Tools

Boomi

Tableau

Power BI

Job description

Get AI-powered advice on this job and more exclusive features.

Continue with Google

This range is provided by Tandym Group. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$93.00/hr - $110.00/hr

Our client is seeking an Enterprise Data Warehouse Lead with expertise in Redshift & Boomi. If interested, please apply! Please NO 3rd Parties, only direct candidates!

About the Opportunity:

• Location: Fully Remote (supporting East Coast client)
• Hours: 9-5, Full Time (40 hours/week)

Responsibilities:

• Architect a new Enterprise Data Warehouse using Redshift as the Data Lake, Boomi for ETL, Power BI and Tableau for reporting.
• Implement new Data Lake with Redshift for Manufacturing (MES) and Regulatory data reporting.
• Create efficient data models and database schemas within Redshift, considering data redundancy, normalization, and performance optimization for complex queries.
• Analyze and optimize complex SQL queries to improve query performance and scalability on large datasets within Redshift, leveraging indexing strategies and query optimization techniques.
• Implement data security measures within Redshift to protect sensitive information, adhering to data privacy regulations and access control policies.
• Identify and resolve performance bottlenecks in Redshift queries, analyzing execution plans and proposing improvements to data storage and processing.
• Design and implement robust ETL (Extract, Transform, Load) processes to integrate data from diverse sources into the Redshift data warehouse, ensuring data quality and consistency.
• Create comprehensive technical documentation for data warehouse architecture, data models, and key performance indicators.

Qualification:

• Amazon Redshift expertise with a deep understanding of Redshift architecture, data loading mechanisms, query optimization techniques, and best practices for managing large-scale environments. Experience with Boomi for ETL is required.
• Ideal candidate will have worked independently in smaller environments.
• Some experience supporting Pharma or Medical Device clients in a GMP environment.
• Experience with data visualization tools (e.g., Tableau, Power BI).
• Familiarity with data security and privacy best practices.
• Proficient in SQL with extensive experience writing complex SQL queries for data manipulation, aggregation, and analysis within a relational database environment.

Seniority level

• Mid-Senior level

Employment type

• Contract

Job function

• Information Technology

Industries

• Technology, Information and Internet