Data Engineer Senior

Work Location Type:Remote

Imperial Supplies, a Grainger Company, is a national distributor of quality maintenance products. Serving the fleet maintenance industry since 1958, Imperial has formed lasting relationships with customers by tailoring our services to meet their changing needs.

Our welcoming workplace enables you to learn, grow and make a difference by keeping businesses running and their people safe. As a Great Place to Work-Certified company, we're looking for passionate people to join our team as we continue leading the industry.

We are seeking a highly skilled and experienced Senior Data Engineer to join our growing team at Imperial Supplies. In this critical role, you will develop and maintain the company's data architecture to enhance business intelligence, improve decision-making processes, and optimize data accessibility. Working closely with solution and cloud architects, business partners, and external service providers, you will ensure that analytics capabilities align with our data architecture and meet the evolving needs of the organization.

Imperial Supplies, a Grainger company, is a national distributor of quality maintenance products. Serving the fleet maintenance industry since 1958, Imperial has formed lasting relationships with customers by tailoring our services to meet their changing needs.

Why should you join Imperial?

• Competitive salary
• Hybrid / Remote schedule
• Monday - Friday work schedule, no nights, or weekends!
• Immediate medical, dental, vision; 12 hours of PTO for every full month worked,6 paid holidays and 6% of annual earnings contributed to your retirement, immediately vested

Key Responsibilities:

• Design, recommend, and implement the organization's data architecture and data accessibility strategy.
• Create a scalable data foundation to support future investments in business intelligence and collaboration.
• Collaborate with business partners, analysts, and solution delivery teams to maximize the value of data across the organization.
• Mentor and guide junior data engineers on best practices and technical problem-solving.
• Develop and maintain logical data models and physical database designs for optimized data storage, processing, and accessibility.
• Lead the design and development of data warehouses and new business intelligence (BI) solutions.
• Implement and manage ETL processes to ensure smooth data integration and processing.
• Conduct system performance assessments and recommend infrastructure improvements to optimize end-user experience.
• Create and promote standards, tools, and process flows for mapping data sources and documenting data movement across the enterprise.
• Define and enforce metadata governance and best practices in collaboration with the analytics governance committee to ensure data accuracy, consistency, and reusability.

Minimum Education:

• Bachelor's degree in Computer Science, Management Information Systems, or a related discipline.

Preferred Education:

• Degree in Software or Computer Engineering, Applied Math, Physics, Statistics, or a related field.
• Relevant certifications such as Associate Big Data Engineer (ABDE), AWS Certified Data Analytics, Google Professional Data Engineer, or Microsoft Certified: Azure Data Engineer Associate are highly desirable.

Minimum Experience:

• At least five years of experience in data architecture or seven years in equivalent roles.

Preferred Experience:

• Ten+ years as a data engineer with expertise in data accessibility strategy, using MS SQL Server, Snowflake, AWS Redshift, DBT (Data Build Tool), and Google BigQuery.

Required Skills:

• Proven experience with ETL tools and frameworks.
• Strong background in software development and data architecture design.
• Proficient in SQL, R, and Python for data transformation and analysis.
• Excellent data analysis, problem-solving, and communication skills.
• Knowledge of data modeling, taxonomy creation, and data policy formation.
• Experience with cloud data warehouse technologies (Snowflake, AWS RedShift, Google BigQuery) and querying tools (SQL, AWS QuickSight, Google Data Studio).
• Familiarity with business intelligence tools such as PowerBI and Tableau.
• Experience with data integration from multiple sources and Big Data technologies.
• Understanding of machine learning toolkit integration is a plus.

We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex (including pregnancy), national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or expression, protected veteran status or any other protected characteristic under federal, state, or local law. We are proud to be an equal opportunity workplace.

We are committed to fostering an inclusive, accessible work environment that includes both providing reasonable accommodations to individuals with disabilities during the application and hiring process as well as throughout the course of one's employment, should you need a reasonable accommodation during the application and selection process, including, but not limited to use of our website, any part of the application, interview or hiring process, please advise us so that we can provide appropriate assistance.