**Job ID Number** R4652 **Employment Type** Full time **Worksite Flexibility** Hybrid **Job Summary** As the Data Architect, you will be responsible for data warehousing, Oracle databases, retrieving and manipulating the housed data using ETL processing and complex SQL. **Job Description** We are looking for a **Data Architect** with a deep experience with Data Warehousing, Oracle databases, retrieving and manipulating the housed data using ETL processing and complex SQL **.** This position will be a **full-time, salaried opportunity** that is **hybrid** in **Wilmington, DE.** **What You’ll Do** + Architect 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 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 + Proven track record of XML queries and building XML to Relational data models and ETL **What You’ll Need** Required + 7 years of experience as a Data Architect + BS/MS degree in Computer Science, Engineering, or a related subject + In-depth working knowledge with Inman data warehousing principles and business intelligence data architecture + In-depth familiarity with Data Modeling Normal Forms, Diagramming, Fact and Dimension modeling, Inman concepts + Basic level of Oracle architecture 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 experience 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 + Strong communication skills, both written and oral. 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. **Physical Demands** + Ability to safely and successfully perform the 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, etc. + Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor **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. **Equal Employment Opportunity Policy Statement** It is the policy of CAI not to discriminate against any employee or applicant due to race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran. It is also the policy of CAI to take affirmative action to employ and to advance in employment, all persons regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran, and to base all employment decisions only on valid job requirements. This policy shall apply to all employment actions, including but not limited to recruitment, hiring, upgrading, promotion, transfer, demotion, layoff, recall, termination, rates of pay or other forms of compensation and selection for training, including apprenticeship, at all levels of employment. Employees and applicants of CAI will not be subject to harassment due to race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran. Additionally, retaliation, including intimidation, threats, or coercion, because an employee or applicant has objected to discrimination, engaged or may engage in filing a complaint, assisted in a review, investigation, or hearing or have otherwise sought to obtain their legal rights under any Federal, State, or local EEO law is prohibited.