Data Engineer

JOB SUMMARY:

As a Data Engineer, you will manage platforms, applications, and data associated with the job function, performing data migrations, automating data enrichment tasks, and developing system integrations across marketing, finance, sales, and relationship management systems. You will be expected to have expertise in relational databases, data mining and transformation, integration patterns, systems administration, reporting, risk management, and application security. Your role involves collaborating with and coaching team members to create effective, scalable solutions, making strategic decisions, implementing best practices, and ensuring projects are completed on schedule.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

• Maintain Windows and Linux servers running integration platforms and assist with compliance procedures.
• Collaborate with solutions architects, project managers, business analysts, and developers to ensure proper strategy, design, and solutions are created.
• Create supporting documentation for system integration, administration, and compliance tasks.
• Assist with incident management and resolution for database and platform settings.
• Stay up to date with novel integration capabilities and patterns.
• Create maintainable, elegant code and high-quality data products that are well-documented and user-friendly.
• Build, maintain, and improve the infrastructure for extracting, transforming, and loading data from various sources using SQL and Oracle technologies.
• Design analytics tools to utilize the data pipeline to produce actionable insights.
• Analyze business needs to create scalable solutions.
• Identify methods to streamline processes and automate repetitive tasks.
• Work with partners from different functional departments and lead projects.
• Maintain security data across multiple data centers and regions.

POSITION REQUIREMENTS AND CONDITIONS:

Education/Experience/Skills

Education:

• Bachelor’s degree in computer science, engineering, information technology, or a related field, or comparable experience.

Required Skills and Experience:

• 5 years of experience in creating distributed data pipelines for batch and real-time applications.
• 4 years of programming experience in R or Python.
• 4 years of experience with SQL; NoSQL experience is a plus.
• 4 years of experience in dimensional data modeling and schema design.
• Expertise in integration development using ETL tools (e.g., Talend, MuleSoft, Informatica, SSIS).
• Well-versed in a variety of transport and API protocols, including REST, GraphQL, and gRPC.
• Knowledge of JSON, XML, SQL, and SOAP/REST-based online services.
• Strong communication skills and ability to work in highly agile environments.
• Proficiency with API Authentication and Authorization (OAuth, OpenID, Bearer).
• Strong analytical and problem-solving skills.
• Ability to work autonomously with little oversight.
• Knowledge of integration development for sales and CRM technologies.
• Experience in developing, managing, and designing data processing systems, including MapReduce or MPP systems.
• Familiarity with constructing microservices using frameworks like Spring Boot.

Preferred Skills:

• Experience with Oracle Database and Oracle Fusion Cloud.

Physical Demands and Conditions

The physical demands described below are representative of those that must be met by an employee to successfully perform the essential functions of this job. Some requirements may be modified to accommodate individuals with disabilities:

• While performing the duties of this job, the employee is regularly required to sit; stand; and use the hands to handle, finger, or feel objects, tools or controls;
• The employee must frequently walk, talk or hear, and reach with the hands and arms; occasionally, the employee must crouch or kneel;
• The employee must occasionally exert or lift up to 15 pounds carrying boxes of records and forms and frequently exert or lift moderate amounts of weight;
• Successful performance requires specific vision abilities that include close vision and the ability to adjust focus.
• The job requires the ability to travel.
• The work environment is that typical of an office and retail store. The noise level in the work environment is usually quiet.

IMPORTANT DISCLAIMER NOTICE

The job duties, elements, responsibilities, skills, functions, experience, educational factors, and the requirements and conditions listed in this job description are representative only and not exhaustive of the tasks that an employee may be required to perform. The Employer reserves the right to revise this job description at any time and to require employees to perform other tasks as circumstances or conditions of its business or the work environment change.