Must have 3 years of Microsoft SQL Server 2016 (on premise or Azure cloud based)

Must have 2 years of NoSQL Databases (MongoDB, MS Azure Cosmos)

Must have 2 years of PostgreSQL, AWS Redshift

Must have 5 years of Sybase DB

Must have 5 years of Entity Relationship Diagrams (ERD)

Must have 5 years of Data Flow Diagrams

Must have 5 years of Star Schema

Must have 2 years of Data Vault 2.0

Must have 2 years of Scripting Language such as Python

Must have 2 years of Visio

Must have 2 years of Agile Scrum Methodology

Data Warehouse Architect is responsible for analyzing enterprise business needs and designing and developing complex logical databases, logical data models, relational data definitions, and data warehouses in support of Enterprise (NCCCS) information system needs.

Understands the methodologies and technologies that depict the flow of data within and between technology systems and business functions/operations.

Responsible for the identification and resolution of information flow, content issues and the transformation of business requirements into logical data models.

This position identifies opportunities to increase efficiency and effectiveness, trends in data uses, and single sources (sources of record) of data.

Responsible for designing, modeling, developing and supporting complex logical database designs, models, and definitions using market leading Database Management and Information Handling Systems. Analyzes data requirements, application and processing architectures, data dictionaries, and database schema(s), and then designs, develops, amends, optimizes, and certifies database schema design to meet system(s) requirements.

eSystems (the “Company”) is an equal opportunity employer and makes employment decisions on the basis of merit and business needs. The Company will consider all qualified applicants for employment without regard to race, color, religious creed, citizenship, national origin, ancestry, age, sex, sexual orientation, gender identity, genetic information, physical or mental disability, veteran or marital status, or any other class protected by law. To comply with applicable laws ensuring equal employment opportunities to qualified individuals with a disability, the Company will make reasonable accommodations for the known physical or mental limitations of an otherwise qualified individual with a disability who is an applicant or an employee unless undue hardship to the Company would result.

To apply for this job email your details to monica@esystems-inc.com