Job Description
Our Client, an IT Services and Consultant company, is looking for a Data Engineer – Starburst, AWS Redshift & Snowflake for their Johnston, RI location.
Responsibilities:
- Configure and administer Starburst clusters for federated querying across AWS Redshift and Snowflake. Set up and manage Starburst connectors for Redshift and Snowflake, ensuring secure and performant connectivity between both platforms.
- Design and optimize SQL queries to support QA/QC data validation, cross-platform reconciliation, and data comparison workflows.
- Collaborate with QA/QC and data governance teams to define validation rules, reconciliation logic, and exception reporting across Redshift and Snowflake datasets.
- Monitor query performance across federated sources, troubleshoot connector/cluster issues, and tune Starburst for optimal throughput.
- Manage access control, security configuration, and catalog/schema setup for both Redshift and Snowflake connectors within Starburst.
- Document architecture, connector configurations, and best practices for federated querying across the two platforms.
- Partner with data engineering and platform teams to ensure the Starburst deployment aligns with broader enterprise data architecture standards.
Requirements:
- 3+ years of hands-on experience with Starburst.
- Direct experience configuring Starburst connectors for both AWS Redshift and Snowflake.
- Strong SQL skills, with experience in federated/distributed query environments.
- Strong AWS skills, including Redshift, IAM, and networking/VPC configuration for connector setup.
- Familiarity with data quality, reconciliation, or QA/QC frameworks in an enterprise data environment.
- Understanding of connector configuration, catalog management, and cluster performance tuning in Starburst.
- Ability to collaborate with cross-functional data governance and QA teams.
- Preferred Qualifications:
- Experience in banking/financial services data environments.
- Familiarity with data governance and metadata management tools.
- Starburst certification, or equivalent hands-on project experience with multi-source federation.
- Years of Experience: 12.00 Years of Experience
Why Should You Apply?
- Health Benefits
- Referral Program
- Excellent growth and advancement opportunities
Numbers & Facts
| Location | Johnston, RI |
| Industry | Management Consulting Services |
| Salary | $16–$55 Per Hour |
| Company Size | 2,000 to 2,499 employees |
| Year Founded | 2000 |
| Website | https://www.iconma.com/ |
Benefits
401K, Employee Referral Program, Life Insurance
About Company
ICONMA is a global information consulting management firm providing Professional Staffing Services and Project-Based Solutions for organizations in a broad range of industries.
- Corporate Headquarters in Troy, Michigan; 20+ locations worldwide.
- Certified Woman-Owned Business Enterprise (WBE); certified by Women’s Business Enterprise National Council, National Women Business Owners Corporation (NWBOC); and California Public Utilities Commission (CPUC).
- Founded in 2000
- 2000+ Employees
The company was founded on the principle that success is derived from delivering high quality service and resources in the most responsive, flexible, and innovative way. ICONMA invests in people and resources with a single goal: To provide our customers with the highest quality service in the most responsive manner. Through its network of offices, ICONMA provides the resources to help clients maintain their competitive advantage.
Skills
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesFree resume builder
Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Free resume builder