Enterprise Data/Integration Developer

Esri; Redlands, California, New York (CA, MO, NY); On-site; USD 83,000 - 142,000; Full time

Job summary

An established industry player is seeking a skilled data engineer to enhance their data management capabilities. In this role, you'll focus on developing efficient data pipelines and implementing ETL processes, ensuring high-quality data integration across various platforms. Collaborating with technical and business teams, you'll help define best practices and standards while securing sensitive information. This position offers a unique opportunity to contribute to innovative data solutions in a dynamic environment, supporting the company's mission of driving positive change through technology. If you're passionate about data and eager to make an impact, this role could be your next career move.

Benefits

Medical insurance

Dental insurance

Vision insurance

401(k) plan

Profit-sharing program

Paid vacation

Paid holidays

Professional growth opportunities

Qualifications

• 2+ years experience in Azure Data Lake and SQL Server with messaging solutions.
• Knowledge of data structures, warehousing, and analytic models.
• Experience with ETL solutions and secure credential management.

Responsibilities

• Develop data pipelines and deliver efficient ETL solutions.
• Implement enterprise integrations for scalable solutions.
• Control integration quality and manage data exchange anomalies.

Skills

Azure Data Lake

SQL Server

ETL/ELT processes

API management

Python

Data warehousing

Analytic models

Communication skills

Education

Bachelor's in Computer Science

Tools

Azure Data Factory

Oracle 19c

MuleSoft

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 Factor 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 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)

#LI-TM1

#LI-Onsite

Total Rewards

Esri's competitive total rewards strategy includes industry-leading health and welfare benefits: medical, dental, vision, basic and supplemental life insurance for employees (and their families), 401(k) and profit-sharing programs, minimum accrual of 80 hours of vacation leave, twelve paid holidays throughout the calendar year, and opportunities for personal and professional growth. Base salary is one component of our total rewards strategy. Compensation decisions and the base range for this role take into account many factors including but not limited to skill sets; experience and training; licensure and certifications; and other business and organizational needs.

A reasonable estimate of the base salary range is

$83,720—$141,440 USD

The Company

At Esri, diversity is more than just a word on a map. When employees of different experiences, perspectives, backgrounds, and cultures come together, we are more innovative and ultimately a better place to work. We believe in having a diverse workforce that is unified under our mission of creating positive global change. We understand that diversity, equity, and inclusion is not a destination but an ongoing process. We are committed to the continuation of learning, growing, and changing our workplace so every employee can contribute to their life's best work. Our commitment to these principles extends to the global communities we serve by creating positive change with GIS technology. For more information on Esri's Racial Equity and Social Justice initiatives, please visit our website here.

If you don't meet all of the preferred qualifications for this position, we encourage you to still apply!

Esri is an equal opportunity employer (EOE) and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law. If you need reasonable accommodation for any part of the employment process, please email [e-mail] and let us know the nature of your request and your contact information. Please note that only those inquiries concerning a request for reasonable accommodation will be responded to from this e-mail address.

Esri Privacy Esri takes our responsibility to protect your privacy seriously. We are committed to respecting your privacy by providing transparency in how we acquire and use your information, giving you control of your information and preferences, and holding ourselves to the highest national and international standards, including CCPA and GDPR compliance.