Data Warehouse Architect

Job Description

**Title**: Datawarehouse Architect

**Work location**: Remote

**Duration**: 3 years

**Term:** Fulltime

**Job Responsibilities**:

* Model in Kimball’s dimensional methodology using the Project requirements.
* Design/modify logical and physical dimensional models using Erwin to meet business’ reporting requirements.
* Prepare and document standards and procedures for dimensional data modelling and naming conventions.
* Create data models (both transacting and warehouse applications) using Kimball methodology, industry best practices and standard processes to ensure high quality data to reduce redundancy and support efficient reporting.
* Develop and maintain data standards, process documentation and templates that assist in a common understanding of data models and data marts and the processes that involve in developing them.
* Support data standardization efforts including best practice standards, naming conventions, and synchronization of shared data requirements across subject areas
* Utilize current SAP Business Intelligence tools, Oracle SQL and PL/SQL and databases, Toad, Erwin, and Kimball Methodology.
* Apply Kimball data modelling techniques (knowledge of conceptual, logical, and physical models).
* Work within the team to assist in the design of the overall ETL data warehouse architecture: Understanding of ETL strategy, staging databases and data quality.
* Support database development including the build and maintenance of stored procedures and advanced SQL/PLSQL techniques.
* Perform data analysis of extraction source systems and provide architecture guidance for data models.
* Establish and maintain security policies. Conducts risk and vulnerability assessments; identify vulnerabilities and risks.
* Ensure Data Architecture follows best practices and guidelines for Data Warehousing.
* Evaluate and provide awareness of security issues to management.
* Conducts system security evaluations, audits and reviews.

**Requirements**:

* Must be a US Citizen and possess (and be able to maintain) a Secret Clearance
* Certifications – Security+ and Certified Business Intelligence Professional.
* Experience using SAP Business Intelligence tools, Oracle SQL and PL/SQL, Toad, Erwin, and Kimball Methodology.

Job Type: Full-time

Pay: $90,000.00 – $120,000.00 per year

Benefits:

* 401(k)
* 401(k) matching
* Health insurance
* Paid time off

Schedule:

* Monday to Friday

Application Question(s):

* What is your work status: US Citizen, Permanent resident, H1B, OPT?
* What is the annual salary you are looking for?

Education:

* Bachelor’s (Required)

Experience:

* SAP BI Tools: 8 years (Required)
* PL/SQL Development: 8 years (Required)

Work Location: Remote