Posted on:
October 27, 2024
Rexel USA is recognized as a Great Place to Work! As a leading distributor of electrical supplies, services, and solutions, our career offerings include professional growth, career advancement, and a fun, inclusive culture. We are committed to fostering a diverse workplace where everyone is valued and empowered to do their best work. Our company values guide our operations, striving to deliver the best customer experience, encourage innovation, engage people, and enjoy making a difference. If you're driven by collaboration and delivering quality work, consider joining us as a Senior Snowflake Data Engineer! This position will be remote.
Summary
The Senior Cloud Data Engineer is responsible for the design, development, and maintenance of scalable data pipelines/ETL workflows and data objects in Snowflake Data Warehouse. Candidates should possess expertise in Snowflake and Azure cloud platforms along with ETL tools, and have an in-depth understanding of data architecture and design.
What You’ll Do
- Design, develop, and maintain data pipelines and ETL workflows to populate the cloud Data Lake and Data Warehouse using:
- Informatica Power Center, Informatica Intelligent Data Management Cloud (IDMC)
- Snowflake native tools (Snowpipe, Snowpark)
- Python
- Build ETL/ELT processes to ingest data from multiple sources (Oracle, SQL Server, APIs) into Snowflake.
- Design and maintain scalable data models for Snowflake Data Warehouse and Azure Data Lake.
- Optimize performance and storage costs in Snowflake while ensuring data quality, security, and adherence to governance policies.
- Collaborate with stakeholders to understand data requirements and develop solutions.
What You’ll Need
- Bachelor’s Degree or equivalent with 8+ years in data engineering for data warehouses and business intelligence solutions.
- 8+ years of experience in designing and developing ETL/data pipelines; 2+ years of hands-on experience with Snowflake Data Warehouse.
- Strong SQL skills and proficiency in scripting languages like Python with experience in Snowflake native tools (e.g., Snowpipe, Snowpark) and ETL tools like Informatica IICS/IDMC.
- Knowledge of data security (RBAC, encryption) and data governance, as well as familiarity with machine learning workflows and data science integration.
- Snowflake certifications (e.g., SnowPro Advanced Data Engineer Certification) are highly desirable.
Knowledge, Skills & Abilities
- Expertise in data modeling (star schemas), data integration, and ETL/data pipelines.
- Proficiency in query optimization and performance tuning.
- Ability to troubleshoot data quality issues and think critically to resolve complex problems.
- Effective communication skills, strong prioritization abilities across projects, and competencies in both independent and team-oriented tasks.
Working Conditions and Physical Demands
- Work Environment: Primarily remote, with occasional travels to offsite locations.
- Physical Demands: Operate a computer and other office machinery, typically performed frequently (21% to 50% of the time).
Benefits Include:
- Medical, Dental, and Vision Insurance
- Life Insurance, Short-Term and Long-Term Disability Insurance
- 401K with Employer Match
- Paid vacation, sick time, and company holidays, plus flexible personal days
- Tuition Reimbursement and Wellness Programs
- Flexible Spending Accounts, HSA Accounts
- Additional Optional Insurances (Pet Insurance, Legal Assistance, etc.)
- Employee Discount Programs and Professional Training & Development
- Career Advancement Opportunities with a promotion-from-within philosophy.
Rexel USA is an EEO/Disabled/Veterans employer. All qualified candidates will receive consideration for employment without regard to any characteristics protected by law. If you experience difficulty using our online application system due to a disability and would like to request reasonable accommodation, please email staffing@rexelusa.com or call (888) 739-3547.