Senior Data Engineer

Senior Data Engineer

Join to apply for the Senior Data Engineer role at CAI
.

CAI is a global technology services firm with over 8,500 associates worldwide and a yearly revenue of $1 billion+. With more than 40 years of excellence, we unite 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.

• Req Number: R6111
• Employment Type: Full time
• Worksite Flexibility: Hybrid
• Location: Wilmington, DE (Hybrid)

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

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 deep experience with data warehousing, Oracle databases, and retrieval/manipulation of 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 will 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.

• Engineer and build Data Marts
• 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 platform
• Build and maintain Oracle Data Marts and associated ETL processes; 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

• 7 years of experience as a Data Engineer
• BS/MS degree in Computer Science, Engineering, or a related subject
• In‑depth working knowledge of Inmon data warehousing principles and business intelligence data architecture
• In‑depth familiarity with Data Modeling Normal Forms, Diagramming, Fact and Dimension modeling, Inmon concepts
• Basic level of Oracle knowledge required—database files, table spaces, and performance challenges specific to data warehousing
• Extensive experience in all aspects of Oracle SQL programming and query manipulation
• Experience working with MS SQL Server databases
• Extensive experience working with large sets of data and resolving data‑oriented issues
• Proficient in both MS Word and Excel; capable of producing presentation‑level documents and pivot‑table presentations
• Extensive experience with data profiling and data quality assurance, including audit trails for peer review
• Industry experience supporting accounting; proven track record of reconciliations and audit
• Extensive experience tuning queries for optimal performance
• Ability to work directly with business users to translate reporting requests into vetted work products
• Professional demeanor with strong written and oral communication skills
• Experience with MS SSIS
• Understanding of data conformity for reporting and ability to create solutions for conformity traps
• Good time‑management skills; sense of ownership and pride in performance impact on the team’s success

• Ability to safely and successfully perform essential job functions consistent with the ADA and other federal, state, and local standards
• Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings
• Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor

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 or call (888) 824‑8111.

$130,000 – $150,000

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 401(k) retirement account access. Employees in this role receive paid time off, paid sick leave, and/or other paid time off as provided by applicable law.