Data Engineer

$150,000 - $150,000/Yr

Roth Staffing Companies - Anaheim, CA

Full-time - Mid Level

Anaheim, CA

Administrative and Support Services

About the position

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.

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.

Requirements

• Bachelor's degree in computer science, engineering, information technology, or a related field, or comparable 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.
• Experience with Oracle Database and Oracle Fusion Cloud.
• 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.

Benefits

• Competitive salary up to $150k with possible flexibility for the right candidate.