Data Warehouse Architects/Engineers Job at Tanu Infotech Inc, Annapolis, MD

U0UzbG05c0VFd1RiTmRXM09lNmVHOXBxekE9PQ==
  • Tanu Infotech Inc
  • Annapolis, MD

Job Description

Title: Data Warehouse Architects/Engineers

Client: State of MD

Number of positions: 2

Duration: 2 years (optional)

Work Location: Hybrid work model. 3 days onsite at Annapolis, MD 21401 and 2 days remote

Candidates must submit resume, degree certificate(s), DL, visa and other professional certificates. Also they should provide 3 references.

Roles and Responsibilities:

1. Participation in all aspects of DW and ETL process design, creation, and specification for components.

2. Providing the following services in coordination with technical, functional and management representatives from JIS and the AOC.

a. Source Data Model to DW Logical Design ERD

(1) Understanding the general structure of the MDEC data and star schema models currently in use by JIS, and any related data sources identified as a result of initial planning and assessments.

(2) Creating a logical warehouse data design.

(3) Collaboration with platform administration team, design an ETL process to move data from the source system to the data warehouse, including, but not limited to, the following:

i Outlining the ETL process, setting the borders of data processing.

ii Providing system architecture for each element and the whole data pipeline.

iii Documenting the requirements of the system, manage its development and facilitate necessary knowledge transfer.

iv Assisting in the actual development/implementation of ETL tools.

v Conducting testing of the tools and data pipelines.

b. DW Schema

(1) Developing effective DW model(s) representing the data entities of the logical design based on functional analytic, reporting and bulk data requirements.

c. DW Physical Design

(1) Collaborating with platform administration to assist their efforts in creating a DW Physical design including technical considerations for data quality and operational efficiency.

3. Collaborating with business and technology stakeholders to ensure data warehouse architecture development and utilization.

4. All work completed by the proposed resource(s) shall be completed within regulatory compliance standards to protect sensitive data.

5. Reporting as follows:

a. Weekly progress report on programs and project,

b. Weekly report communicating project progress and status,

c. Weekly time reporting on JIS provided forms, and

d. Any additional reports as assigned by the supervising manager.

Job Tags

Remote job,

Similar Jobs

DIE RASSELBANDE PRESCHOOL INC

German speaking Preschool Teacher Job at DIE RASSELBANDE PRESCHOOL INC

Rasselbande Preschool has an opening for a German speaking preschool teacher. We are a German Immersion Preschool with a wonderful community of dedicated teachers and supportive families. Our common goal is guiding and enhancing children's development in our play based... 

Career Strategies

Nursing Home Administrator Job at Career Strategies

 ...DESCRIPTION Join the team as a Nursing Home Administrator and make a meaningful impact on the lives of the residents! They are seeking a dedicated and experienced professional to lead the compassionate team in providing exceptional care to the residents. About the... 

Links Global

Information Technology Specialist Job at Links Global

Job SummaryLinks Global seeks a skilled and customer-focused Information Technology Support Specialist to join our dynamic IT team. The ideal candidate will provide technical assistance and support related to computer systems, hardware, and software. The IT Support Specialist... 

NavitsPartners

Radiologic Technologist - Radiographer - RTR24-16594 Job at NavitsPartners

 ...Job Title: Radiologic Technologist - Radiographer Location: Bronx, NY 10461 Duration:3 Months Hours: 37.5 hours per week, 7.5 hours per day, 5 days per week Schedule: 8:00 AM 4:00 PM, Monday Friday, with alternating weekends and holidays. Possible temp... 

Vitaly Health

Locum Tenens Family Medicine Physician Job at Vitaly Health

 ...Job Title: Locum Tenens Family Medicine Physician Location: Wisconsin Position Overview: We are looking for a Family Medicine Physician to join our Health Center on a 5-month Locum Tenens basis, with the opportunity to extend. The role involves a Monday-Friday...