Remote

Data Engineer

GOJO Industries
United States, Ohio, Akron
Feb 07, 2025
Information about #31949 Data Engineer Work Location: This role can work remotely, within the continental US, provided that Eastern standard time core business hours are maintained We are unable to offer citizenship sponsorship or transfer assistance for this role. *Formulated to Care* For more than 75 years, GOJO, Makers of PURELL has been powered by people who are energized by helping the world experience greater health and well-being. The positive impact of our PURELL hand and surface hygiene solutions is driven by our global community of highly collaborative and talented team members who love to learn, innovate, care for each other, and deliver our Purpose of Saving Lives and Making Life Better. Role Objective The Data Engineer is primarily responsible for data movement and data availability within the enterprise. Under guidance from senior team members within the Data Team, the Data Engineer will work across the enterprise (Manufacturing, Finance, Quality, HR, etc.) to support the business data needs. Working with everyone from engineers on the shop floor to VPs, we must adjust our communication style to meet the needs of the business user, supporting manufacturing of product to enterprise level financial analysis. GOJO also has databases implemented in Azure, SQL Server and Oracle, requiring knowledge across multiple vendors. Essential Functions and Responsibilities Understand, write and modify SQL queries, stored procedures, materialized views and views in MS SQL Server, Oracle Database, Azure Database and Azure Synapse. Know the difference between the different technologies and what functions are available in which, ie. getdate() vs sysdate, substring vs substr, lpad vs left/replicate. Monitor and manage scheduled jobs, addressing failures and communicating as appropriate. Jobs are in Azure Data Factory (ADF), SQL Server Agent (on-prem), and Oracle Enterprise Manager (OEM). Design, develop, and maintain ETL and/or ELT (dependent upon requirements) processes for efficient data movement via Azure Data Factory. Assist users with connection issues/granting permissions. Follow security standards and ensure permissions are not granted without authorization. Publish/deploy Azure Data Factory code via DevOps Release Pipelines. Perform SQL Server database upgrades/migrations. Participate in afterhours/on-call support for production environments. This will include supporting upgrades or troubleshooting activities that must take place outside of standard working hours. Collaborate with data analysts and business users to understand data requirements and assist in data modeling. Ability to multi-task and manage workload in accordance with priorities. Maintain Power BI Semantic Model and Design, Develop, Maintain Power BI dashboards as required. Creation of Power BI workspaces with applicable security. Be a backup for Database Administrators. #LI-Remote Education and Experience Minimum two (2) years of SQL experience required Minimum four (4) years' experience in a technical role or a degree in a technical discipline (math included) required Excellent written and verbal communication skills (English) ETL/ELT experience required Familiarity with data visualization tools Ability to be platform agnostic (Oracle, SQL Server, Azure) Understanding of different platforms and the ability to bounce between them seamlessly Manufacturing knowledge/understanding is a plus SAP and/or Salesforce knowledge is a plus Supervision/Coordination Coordinates tasks, schedules, and projects Guidance and direction provided by Data Architecture Manager This role does not directly supervise other team members Travel Requirements Overnight Travel - sporadic - required. To Apply: To apply for this position, please complete the online application process. You will have an opportunity to include your resume and a cover letter. GOJO is an Affirmative Action/Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status or status as an individual with a disability. Applicants must be lawfully authorized to work in the United States. Recruiters, Search Agencies or others referring candidates to GOJO Industries, Inc. without written authorization from GOJO Industries, Inc. Human Resources will not be compensated in any way for their online referral even if GOJO Industries, Inc. hires the candidate. GOJO does not seek or respond to unsolicited resumes for positions that are not listed in the Careers section.