Senior Data Engineer

Senior Data Engineer

Req number : R6111

Employment type : Full time

Worksite flexibility :

Hybrid

Who we are

CAI is a global technology services firm with over 8,500 associates worldwide and a yearly revenue of $1 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right-whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise.

Job Summary

As the Senior Data Engineer, you will be responsible for developing and maintaining data solutions that support business needs. This role involves working with complex data models and SQL scripts to ensure data integrity and performance.

Job Description

We are looking for a Senior Data Engineer for a full-time, salaried opportunity that is hybrid in Wilmington, DE . The selected candidate will have a deep experience with data warehousing, Oracle databases, and retrieving / manipulating the housed data using ETL processing and complex SQL. The candidate should have a proven track record of building Data Marts following the Inmon data warehousing principles. The candidate should be able to quickly come up to speed on a complex database model, a database star schema architecture, and immediately contribute to building Data Marts, development and / or support of complex SQL needs, business-requested reporting, extracts, loads, stored procedures, interfaces, and ETL work

What You'll Do

• Engineer and build Data Mart
• Create, maintain, and tune complex SQL scripts
• Create and maintain existing SQL based custom reports
• Maintain complex data models
• Create and maintain data interfaces (scripted ETL) between our on-premise Oracle environment and MS SQL Server on the Azure based platform
• Build and maintain Oracle Data Marts and associated ETL processes. Ability to hard code ETL in native SQL
• Utilize advanced experience in Oracle SQL Loader to load data from files into Oracle databases
• Import / Export data from SQL Server / Oracle XML and CLOB Queries and convert data to standard Oracle tables
• Perform XML queries and build XML to Relational data models and ETL

What You'll Need

Required :

Physical Demands

The pay range for this position is $130,000 - $150,000 annually (USD). Exact compensation may vary based on several factors, including location, experience, and education. Benefit package includes medical, dental, and vision insurance, as well as 401k retirement account access. Employees in this role receive paid time off and may also be entitled to paid sick leave and / or other paid time off as provided by applicable law.

#LI-JM1

Reasonable accommodation statement

If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to application.accommodations@cai.io or (888) 824 - 8111.

The pay range for this position is listed above. Exact compensation may vary based on several factors, including location, experience, and education. Benefit packages include medical, dental, and vision insurance, as well as 401k retirement account access. Employees in this role receive paid time off and may also be entitled to paid sick leave and / or other paid time off as provided by applicable law.