CAI ยท 2 hours ago
Senior Data Engineer
Wilmington, DE
Full-time
Hybrid
Senior Level
$130K/yr - $150K/yr
7+ years expCAI is a global technology services firm with over 8,500 associates worldwide. As the Senior Data Engineer, you will be responsible for developing and maintaining data solutions that support business needs, working with complex data models and SQL scripts to ensure data integrity and performance.
ConsultingSoftware
Responsibilities
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
Qualification
Required
7 years of experience as a Data Engineer
BS/MS degree in Computer Science, Engineering, or a related subject
In-depth working knowledge with 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. Ability to produce presentation level documents in MS Word, and pivot tables presentations in Excel
Extensive experience with data profiling and data quality assurance. This includes the understanding of creating an audit trail for peer review of work completed
Industry experiences supporting accounting a must. Proven track record of reconciliations and audit
Extensive experience in tuning queries for optimal performance
Ability to work directly with business users to quickly translate business reporting requests/requirements and produce a work product that has been vetted for quality and meets requirements as stated
Professional demeanor with strong communication skills, both written and oral
Ability to communicate easily with business partners and technical team members
Ability to defend data analysis work to both technical and business individuals
Experience in MS SSIS
Understanding of data conformity for reporting, ability to identify and create solutions for data conformity traps
Good time-management skills
Sense of ownership and pride in your performance and its impact on team's success
Benefits
Medical, dental, and vision insurance
401k retirement account access
Paid time off
Paid sick leave and/or other paid time off as provided by applicable law
Company
CAI
CAI is a global services firm with over 9,000 associates worldwide and a yearly revenue of $1.3 billion+.
5001-10000 employees
H1B Sponsorship
CAI has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (24)
2024 (28)
2023 (24)
2022 (30)
2021 (41)
2020 (48)
Funding
Current Stage
Late StageLeadership Team
Tom Salvaggio
President and CEO
Tony Salvaggio
Founder and CEO
Recent News
Computer Aid, Inc. (CAI)
2025-09-19
Company data provided by crunchbase