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.
...PART-TIME afternoon and evening hours or weekends? YES to these questions WE WOULD LOVE TO TALK TO YOU! What does a Behavior Technician do? As a Behavior Technician, you'll provide 1:1 in-home support for children and teens with Autism or developmental disabilities...
...We have the perfect role for you! Were seeking enthusiastic Delivery Drivers to join our team at Dominos. As a Delivery Driver, youll be... ...Record check. Flexibility to work various shifts, including nights and weekends. Company Description: Twomays Inc....
Mortgage Loan OriginatorA well respected banking organization in Minnesota is looking to add to their mortgage team. This person should have... ...attitudeProfessional demeanor and attireProficient with MS Office applications (Word, Excel, Outlook, etc.)Salary commensurate...
...Job Description Job Description Sage Home Loans Corporation is seeking a licensed Mortgage Loan Officer (MLO). This position is responsible for communicating pricing terms and handling consumer escalations during the mortgage process. As a MLO, you will serve as a...
...Description The Digital Modernization sector within Leidos is seeking a Senior Network Administrator to manage the operational environment for the Compartmented Enterprise Services Office (CESO) NOC. With the CESO program, the Defense Information System Agency...