What are the responsibilities and job description for the Data Architect position at CAI?
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.
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.
