Enterprise Data/Integration Developer

Esri; Redlands (CA); On-site; USD 80,000 - 110,000; Full time

Job summary

Join a forward-thinking company as a Data Engineer, where you'll play a pivotal role in transforming enterprise data through innovative ETL and messaging solutions. This position offers the chance to collaborate with cross-functional teams, ensuring data quality and compliance while developing scalable data pipelines. You'll leverage cutting-edge technologies in the Azure data platform and work in an agile environment. If you're passionate about data management and eager to make a significant impact, this role is perfect for you!

Qualifications

• 2+ years of experience in Azure Data Lake and Data Factory.
• Strong knowledge of ETL/ELT processes and secure credential management.

Responsibilities

• Develop data pipelines and deliver efficient ETL solutions.
• Implement enterprise integrations for scalable and high-performance solutions.

Skills

Azure Data Lake

Data Factory

SQL Server

API management

Python

R

C#

Java

JavaScript

ETL/ELT processes

Education

Bachelor’s in computer science or related STEM field

Tools

Oracle 19c

MuleSoft

SAP

Salesforce

Adobe

ServiceNow

Microsoft

Job description

Overview

In this technical role, you will focus on the acquisition, transformation, and disposition of enterprise data. It focuses on ETL/ELT processes from business systems into the lake house and support for the pub-sub data node. The role will give you the opportunity to work closely with other enterprise teams to define shared standards and practices and leverage common infrastructure and security. You will also be responsible for monitoring the environment, maintaining system health, and securing the content. This role will interact with both technical partners (Developers, Stewards, DBAs, Architects) and business partners.

Responsibilities

• Work collaboratively with the team to develop data pipelines, data enrichment, and performance metrics.
• Deliver high quality and highly efficient ETL and/or messaging solutions based on a standard framework.
• Implement enterprise integrations that result in scalable, flexible, and highly available solutions that perform well under high traffic.
• Partner with internal teams to develop and support effective data solutions.
• Apply standards to support enterprise privacy and compliance needs.
• Understand and implement secure credential management options and proper encryption practices.
• Control integration quality and develop ways to detect and correct anomalies with data exchange.

Requirements

• 2+ years of experience developing in Azure Data Lake, Data Factory, and/or SQL Server with 1 year of experience with commercial solutions used for messaging and microservices including API management with SOA, ODATA, queue management, and an enterprise service bus.
• Knowledge of Azure data platform, data structures, data warehousing, statistics, and analytic models.
• Experience with integration and/or ETL solutions including hands-on experience with at least one of Oracle 19c or greater, Microsoft SQL Server 2022 or greater, MuleSoft, or Azure Data Factory.
• Strong interpersonal, verbal, and written communication skills.
• Ability to work both independently and in a team environment.
• Knowledge of the development and management required for ETL, ELT, REST, and SOAP implementations.
• Experience in SQL and at least one other language such as Python, R, MDX, C#, Java, or JavaScript.
• Development experience with RDBMS (Microsoft SQL Server) in both transactional and analytic/EDW models.
• Ability to analyze and document complex business processes and project details.
• Working knowledge of core business platforms (SAP, Salesforce, Adobe, ServiceNow, Microsoft).
• Bachelor’s in computer science or related STEM field.

Recommended Qualifications

• Experience working in agile environments and practicing SAFe/scrum/DevOps.
• Knowledge of data management best practices, processes, tools, standards, and methodologies.
• Experience/Exposure to cloud data tools (DocumentDB, Data Lake, Synapse, NoSQL, Hadoop/Spark, Data Bricks, Glue, Data Factory).
• Development experience in the cloud (AWS, Azure).