Data Engineer

Description

DATA ENGINEER

JOB DESCRIPTION

Department:  Information Technology                    

Reports to: Enterprise Applications Manager

Job Status: Full Time                       

Travel Required: None

FLSA:  Exempt                                 

Position Supervised: None

Work Location: The Woodlands, TX                      

Work Schedule: Monday – Friday; 8 a.m. – 5 p.m.   (Overtime as needed)

Position Summary: The Data Engineer is a technical expert in implementing scalable data architectures for system integrations and business analytics.  The Data Engineer works independently to build out data pipelines that operationalize the integration of data from a variety of sources and formats.  The individual has a firm grasp of the technical architecture and tools, including installation and configuration, to support the development of these data solutions.  As a member of a self-organized agile team, the Data Engineer also collaborates with the rest of the team on work alignment, data architecture, and removal of impediments/blockers.  Eventually, the Data Engineer will become an internal subject matter expert (SME) in multiple data domains (e.g., Accounting, Supply Chain, HR) as the individual learns the business logic for these domains and develops relationships with the team and external stakeholders.

ESSENTIAL FUNCTIONS: (The following duties and responsibilities are all essential job functions, as defined by the ADA, except for those that begin with the word “May.”)

• Ability to read, write, and comprehend English. 
• Identify proper design pattern(s) to solve a given problem.
• Implement architecture for data analytics platform (Databricks).
• Develop integrations between systems (e.g., ERP, HRM, CRM, CLM, embedded, and other custom applications) using a variety of methods and data formats.
• Meet regularly with the Lead Developer and the rest of the development team to discuss data architecture decisions.
• Coordinate directly with stakeholders to understand requirements (i.e., write user stories).
• Provide support for existing systems and work with users to resolve issues.
• Contribute to a small, cross-functional team in multiple capacities as needed.
• Model best practices and continuous improvement for other team members.
• Research new technologies and approaches and share knowledge with the team.
• Performs other related duties as assigned to assist with successful operations and business continuity.

POSITION REQUIREMENTS:

• Successfully passes background check.
• Possesses a valid U. S. Driver’s License.
• Daily in-person, predictable attendance.

EDUCATION AND EXPERIENCE:

• Bachelor’s Degree in Information Systems, Computer Science, or related field or equivalent work experience
• 7 years experience in Microsoft T-SQL
• 7 years experience consuming and building web APIs (REST, GraphQL, OData, SOAP)
• 7 years’ experience working with unstructured and semi-structured data formats (e.g., CSV, JSON and XML)
• 5 years experience with Python
• 5 years experience with Power BI
• 3 years experience with Azure Databricks
• 3 years experience with Azure Data Factory (ADF)
• 2 years experience with Kafka and Debezium (preferred)
• 2 years experience with Logic Apps (preferred)

Qualifications

TECHNICAL SKILLS:

• Strong familiarity with established design patterns (e.g., ETL, ELT, CDC) for data integration.

• Strong familiarity with established design patterns (e.g., Kimball and Data Vault) for analytical databases.
• Experience working under an agile methodology (e.g., Scrum, XP, Kanban, Scrumban, etc.) and related tools (e.g., Azure DevOps, Jira Boards).
• Some scripting experience with PowerShell and Azure CLIs.
• Experience developing integrations with ERP systems.
• Demonstrated ability to communicate and partner with stakeholders in a fast-paced environment.
• Problem solver with a process-thinking mindset
• Willingness to help others wherever needed as part of a small, cross-functional team.
• Eagerness to learn new technologies and approaches.
• Experience with Power Platform (preferred)
• Familiarity working with SQL database projects in Visual Studio (strongly preferred)

QUALIFICATIONS FOR ADVANCEMENT: (Promotions may occupy after the following qualifications have been satisfied.  Promotions are not guaranteed and are subject to availability of position openings.)

• Time in Position: Minimum 18 months.

PHYSICAL REQUIREMENTS/WORK ENVIRONMENT:

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

Frequently required to walk, sit, climb, bend, reach and squat/kneel.  Data Engineer works primarily indoors and will be sitting for prolonged periods of sitting at a desk and working on a computer.  Must be able to access and navigate each department at the organization’s facilities.  Data Engineer may be required to lift heavy objects; therefore, Data Engineer must be able to lift 25 lbs.

Work hours may include early morning, late afternoon/evening hours, and weekends in combination depending on job demands.

The Company is committed to the cause of equal employment opportunity for all employees and applicants, thus abiding by all applicable state and federal laws.  Our practices regarding employment, job promotion, compensation, training, and termination do not discriminate on the basis of race, color, religious creed, age, sex, national origin, veteran's status, disability, pregnancy, genetic information, or any other legally protected status.  It is expected that all employees, both management and staff, will fully support these nondiscriminatory policies.

The company has reviewed this job description to ensure essential functions and duties have been included. It is not intended to be an exhaustive list of all functions, responsibilities, skills, and abilities.

Revised: 05/12/2023