Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
Executive Order 11246, Section 503 & VEVRAA EOE, including disability/vets
Architecting RDBMS ETL Process Data Services SQL Queries Reporting Tools Analyst
 
Requirement id 88587
Job title Analyst
Job location in Jefferson City, MO
Skills required Architecting, Data Warehouse, RDBMS, ETL Process Data Services SQL Queries Re
Open Date 13-Feb-2019
Close Date
Job type Contract
Duration 6 Months
Compensation DOE
Status requirement ---
Job interview type ---
Apply
   Email Recruiter: coolsoft
Job Description Analyst: Architecting, Data Warehouse, RDBMS, ETL Process Data Services SQL Queries Re

Start Date:03/04/2019
End Date:6 Months from projected start date
Submission Deadline : 2/14/2019 @ 3pm CST

Description :

JOB DESCRIPTION The hired individual will be responsible for the following as a member of a large project team:
• Design an extensible data model that reflects the business and supports the analytical objectives we are trying to achieve
• Review project documentation which outlines the required data elements in the source for extraction to the Data Warehouse
• Define the processes from identified Data Sources/Elements into a manageable subset of data for extraction
• Perform complex analysis and design across multiple database platforms and technologies
• Develop and build EDW artifacts, such as SQL code and logical and physical data models
• Specify data points for extraction and recommend any required data sets and elements to improve delivered data products
• Build out the data warehouse and prepare the data for load into the reporting environment
• Design an automated, scalable, extensible ETL / ELT process to pull data from the source systems and transform it into the analytical model
• Design, build, and test on premises and cloud-based data warehouse and pipelines
• Develop data integrations between internal and external data environments
• Document data warehouse design plan, topography, and use cases
• Conduct JAD sessions to gather or confirm requirements
• Develop Use Cases, test cases and scripts
• Evaluate and assist ITSD team in ETL and database performance tuning
• Brief high-level summaries of JAD sessions to PM on at least a weekly basis, or more often if required
• Notify PM of concerns or questions regarding information shared in JAD sessions
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 88587 while calling.
 
Other jobs in MO: Clayton (1), Kansas City (6), Morrisville (1), Saint Louis (3), St Louis (15),
 
 Architecting job openings in other states
Jobs List

Architect Expert ISO Policy Change Development (774271)
Create date: 07-Aug-2025
Start date : 09/01/2025

End Date : 08/31/2026

Submission deadline : 08/08/2025

Client Info : NCDOT

Note:

* Agency Interview Type : Either Webcam Interview or In Person

* Remote

Description :

The candidate will be allowed to work remotely until all staff may be .... (This job is for - Architecting Jobs in NC Raleigh Architect - (in Raleigh, NC))

GTRI Sr. Data Architect (748151)
Create date: 01-Oct-2024
No of Submissions : 2

Start date : 11/04/2024

End Date : 06/30/2025

Submission deadline : 10/04/2024

Client Info : GTRI-Enterprise Systems Department

Note:

* Agency Interview Type : Either Web Cam or In Person

* Hybrid

* Plans and schedules team resources, sta.... (This job is for - ArchitectingAnalytics Jobs in GA Atlanta Architect - (in Atlanta, GA))

VDOT Statewide Video Solutions Architect ONSITE (729737)
Create date: 23-Feb-2024
Start date : 03/11/2024

End date : 06/30/2024

Submission deadline : 2/28/2024

Client info : VDOT

Note :

* Onsite

Description :

Genetec Security Center Video Management Administration Engineer that is responsible for a Statewid.... (This job is for - Architecting IP Jobs in VA Richmond Architect - (in Richmond, VA))

Programmer Analyst 4 - 120568 - SP
Create date: 24-Jul-2023
start date : 08/14/2023

End date : 1 Years from projected start date

submission deadline : 8/3 at 10am EST.

client info : DHHS

Note :

* Interview Process: Virtual Interview via MS Teams video. Please use laptop and be prepared so share screen if asked. Use of headphones is strongly discour.... (This job is for - Architecting Jobs in MI Lansing Analyst - (in Lansing, MI))

Programmer Analyst 4 - 118469 - SP
Create date: 24-May-2023
start date : 06/12/2023

End date : 1 Years from projected start date

submission deadline : 5/31 at 10am EST.

client info : DHHS

Note :

* Interview Process: Virtual Interview via MS Teams video. Please use laptop and be prepared so share screen if asked. Use of headphones is strongly discour.... (This job is for - Architecting Jobs in MI Lansing Analyst - (in Lansing, MI))
 
 
(Analyst: Architecting, Data Warehouse, RDBMS, ETL Process Data Services SQL Queries Re in Jefferson City, MO)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us