Senior Snowflake Data Engineer

Rexel USA is recognized as a Great Place to Work!

Rexel USA is a leading distributor of electrical supplies, services, and solutions, which includes the following companies: Rexel, Gexpro, Platt & Mayer.

A career with us offers professional growth, career advancement, unlimited opportunities to learn, and a fun, inclusive culture. We are committed to creating a diverse workplace where everyone is valued, treated with dignity and respect, and empowered to do their best work. 

Our values are the foundation for how we operate with our employees, customers, and suppliers. We strive to Deliver the Best Customer Experience, Join Forces for Success, Encourage Innovation, Engage People to Develop Their Talents, Trust Each Other, and Enjoy Making a Difference.

If you're driven by collaboration and delivering quality work, join  Rexel USA as a  Senior Snowflake Data Engineer!

The position of Senior Snowflake Data Engineer 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. Expertise in Snowflake and Azure cloud platforms along with ETL tools. In-depth understanding of the current state of data architecture and design, and the ability to develop the target data model on cloud as well as data integration pipelines using various tools such as Informatica, Snowflake native tools, and scripting languages (Python). The Data Engineer will ensure optimal performance of the data objects and data pipelines in Snowflake. 

What You’ll Do

• Design and develop data pipelines, ETL workflows to populate the cloud Data Lake and Data Warehouse on Snowflake and Azure using tools such as Informatica Power Center, Informatica Intelligent Data Management Cloud (IDMC), Snowflake native tools (Snowpipe, Snowpark), and Python
• Build ETL/ELT processes to ingest data from multiple data sources, including Oracle, SQL Server, and APIs, into Snowflake
• Design, develop, document, and maintain scalable data models for Snowflake Data Warehouse and Azure Data Lake
• Design and develop Snowflake data objects (tables, views, stored procedures etc.)
• Perform performance tuning and query optimization in Snowflake. Ensure good performance of the data pipelines. Ensure optimal storage and compute costs in Snowflake by designing efficient data objects and data pipelines
• Optimize queries, storage, and compute resources in Snowflake to maximize performance and cost-efficiency
• Implement best practices for data partitioning, caching, and clustering in Snowflake
• Ensure data quality, consistency, and security throughout all stages of the ETL pipeline
• Develop and implement data security policies and procedures in Snowflake. Create and manage user accounts and roles in Snowflake
• Develop and implement data governance policies and procedures in Snowflake
• Collaborate with stakeholders to understand data requirements and develop data solutions
• Research and stay up-to-date on Snowflake best practices and new features
• Other duties as assigned

The information contained in this job description is intended to describe the essential job functions required of those assigned to this job. It is not intended to be an exhaustive list of all responsibilities, duties, knowledge, skills, and abilities needed to perform the job. Please note that management retains the right to assign or reassign duties and responsibilities to this job at any time. The ability to competently perform all the essential duties of the position, with or without reasonable accommodation, demonstrate commitment to effective customer service delivery, integrity, and the ability to work productively as a member of a team or work group are basic requirements of all positions at Rexel USA.

What You’ll Need

• Bachelor's Degree or Equivalent    
• 8+ years of experience in data engineering for data warehouses, data lakes, and business intelligence solutions
• 8+ years of experience designing and developing ETL and data pipelines for data warehouses
• 2+ years of hands-on experience in Snowflake Data Warehouse
• Strong experience with SQL and scripting languages like Python
• Experience in Snowflake native tools like Snowpipe, Snowpark
• Preferably 2+ years of experience in Informatica IICS/IDMC
• Experience with data security, including RBAC, encryption, and compliance standards
• Knowledge and experience in Snowflake best practices
• Experience with machine learning workflows and data science integration
• Snowflake certifications highly desirable (such as SnowPro Advanced Data Engineer Certification).

Knowledge, Skills & Abilities

• Knowledge of CI/CD pipelines and version control (e.g., Git, Jenkins)
• Extensive knowledge and understanding of data modeling of data warehousing (star schemas) and data lakes
• Extensive knowledge of data integration, ETL, and data pipelines
• Ability to optimize data processing and storage
• Proficiency in query optimization and performance tuning
• Strong skills in Python scripting and programming
• Ability to troubleshoot data quality issues
• Ability to think critically and solve complex issues
• Ability to work independently, while engaging the customer and providing information to team
• Strong ability to communicate both verbally and in writing with internal and external teams
• Ability to prioritize across multiple projects and meet deadlines
• Work closely with other IT application owners and leaders to communicate, share and implement best practices
• Self-motivated with ability to work independently without close supervision
• Ability to develop and deliver solutions either individually or as part of a development team

Working Conditions and Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Working Environment:    

• Travels to offsite locations    None

Physical Demands:    

• Use hands to finger, handle, or feel: Operates a computer and other office machinery    Frequently – 21% to 50%

“Rexel USA (A VEVRAA Federal Contractor), and its affiliated companies, is an EEO/Disabled/Veterans employer. All qualified candidates will receive consideration for employment without regard to any characteristics protected by law.”
 

Our Benefits Include:

• Medical, Dental, and Vision Insurance
• Life Insurance
• Short-Term and Long-Term Disability Insurance
• 401K with Employer Match
• Paid vacation and sick time
• Paid company holidays plus flexible personal days per year
• Tuition Reimbursement
• Health & Wellness Programs
• Flexible Spending Accounts
• HSA Accounts
• Commuter Transit Benefits
• Additional Optional Insurance such as Pet Insurance, Legal Assistance, Critical Illness, Home and Auto Insurance to name a few.
• Employee Discount Programs
• Professional Training & Development Programs
• Career Advancement Opportunities – We like to promote from within

Senior Snowflake Data Engineer 

150045

Remote, RM 

Rexel USA

IT/Digital/Data

[[filter9]]

Rexel USA is a VEVRAA federal contractor and an EEO/AA employer. (Females/Minorities/Protected Veterans/Individuals with a Disability) We are committed to creating a diverse and inclusive workplace where everyone is valued, treated with dignity and respect, and empowered to do their best work. If you encounter difficulty using our online application system due to disability and would like to request reasonable accommodation, email staffing@rexelusa.com or call (888) 739-3547