ETL Data Extraction Tools MS Office Products MS SQL Server Technical Documentation   Requirement id 61092 Job title Architect Job location in Columbus, OH Skills required Sql Skills, ETL, Data Transformation, Data Extraction Tools MS Office Products Open Date 19-May-2017 Close Date Job type Contract Duration 1 Months Compensation DOE Status requirement Citizen Only Job interview type Face to Face interview    Email Recruiter: coolsoft Job Description Architect: Sql Skills, ETL, Data Transformation, Data Extraction Tools MS Office Products Start Date : 06/12/2017 End Date : 06/30/2017 Submission Deadline : 05/25/2017 Description : ** ODOT is looking for a Data Architect (DA1) for an assignment through the end of the fiscal year with a possible extension through FY18. This is a re-post of position ID 46622. Please do not submit candidates submitted to 46622. ** This posting will close to submissions: Thursday 5/25 @ 11AM ** LOCAL CANDIDATES ONLY and ONSITE INTERVIEWS are REQUIRED. Do not submit candidates unavailable to interview onsite. Please submit resumes in a word document and remove all candidate personal (phone email)and vendor information. Discuss with the candidates how their recent job experience relates to the job description. (Complete job description attached) This position will function as a highly skilled Data Architect with specific responsibilities that include: • Work with business owners, subject matter experts, and 3rd party vendors to determine project/application data requirements. • Develop data architecture models. • Develop data flow models. • Develop business process / workflow models. • Design, develop, and implement database tables/views. • Create SQL queries to support application interfaces, data transfers (ETLs), and data extracts. • Verify accuracy and completeness of application data validation procedures. • Troubleshoot data-related production problems. • Create project/user documentation for all the above. • Provide status of work and deliverable estimate to Team Lead. • Ability to work independently and as part of a team, the ability to manage time, work under pressure of tight deadlines, and meet assigned deadlines. Experience 1. Possess excellent communication skills; both oral and written skills including strong meeting and work session skills. 2. Have excellent organizational skills, proven analytical, planning, problem solving, and decision-making skills. 3. Demonstrate proven experience in troubleshooting issues. 4. Must enjoy working in a team environment. 5. Possess extensive knowledge of specific database systems,and is capable of hands-on work in all phases of database design and management. 6. Design,develop,and implement infrastructure to provide highly-complex, reliable,and scalable database to meet the organizations objectives and requirements. 7. Analyze organizations business requirements for database design,and implements changes to database as required. 8.Perform systems analysis on database,and resolves performance,capacity,and replication issues as necessary. 9.Provide detailed design and specification documentation, including flowcharts, for all aspects of the database. 10.Work with database analysts to develop methodologies,report views, queries, and table replications 11. Ensure that all the data is in the proper format. 12. Participate in the identification, prioritization, and development of technical initiatives and strategies. 13. Develop and maintain database standards and naming conventions. 14. Keep up-to-date one merging database architectures,technologies,and methodologies,and attends training classes as necessary. 15. Initiate discussion with Businesses to define and assemble business requirements. 16. Translate business requirements into technical requirements – strong technical documentation skills. 17. Define and evaluate logical and physical data models. 18. Architecture modeling: data analysis, business process, conceptual level technology. 19. Define user interface strategies. 20. Database design in coordination with DBAs. Mandatory Requirements 4yearcollegedegreeorequivalenttechnicalstudy. Advanced SQL Skills in MS SQL Server required. ETL or Data transformation experience.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 61092 while calling.   Other jobs in OH: Cincinnati (1), Cleveland (1), Columbus (233), Dublin (8), Solon (2), Sql Skills job openings in Columbus, OH Jobs List Data Analyst - 12446 Create date: 28-Mar-2019 Candidate must be our own w2 Employee Description: We are currently seeking a Data Analyst contractor in Columbus, Ohio to partner with Business/Requirement and Analyst Lead to work on measuring and managing the quality of requirements and work products. Should be able to discern, understand and communicate changes affecting scope, .... (This job is for - job Jobs in OH Columbus Analyst - (in Columbus, OH))    Sql Skills job openings in other states Jobs List NCDOT - Developer/Programmer- Senior (744121) Create date: 09-Aug-2024 No of Submissions : 2 Start date : 10/01/2024 End Date : 09/30/2025 Submission deadline : 08/15/2024 Client Info : NCDOT Note: * Agency Interview Type : Webcam Interview Only * Remote Description : The North Carolina Department of Transportation (NCDO.... (This job is for - Powerbuilder Jobs in NC Raleigh Developer - (in Raleigh, NC)) Quality Assurance Analyst IV -130668 Create date: 17-May-2024 Bid Limit Per Vendor : 2 Start date : 07/08/2024 End Date : 06/30/2025 Submission deadline : 5/24/24 at 4:00PM CST. Client Info : ETF Note : * Interview Process: MS Teams * Duration: 6/30/25 with potential for extension * Remote or Onsite: No WI residency.... (This job is for - job Jobs in WI Madison Analyst - (in Madison, WI)) NCDOT - AASHTOWare Project Support Preconstruction (728102) Create date: 06-Feb-2024 Remote Start date :02/09/2024 End Date : 02/14/2025 Submission deadline : 02/12/2024 Client Info : NCDOT Description : ------------------------------------------------------ The LCS team works 100% remotely, however our NCDOT customers are not. Team members are expected to be availab.... (This job is for - Database Admin Jobs in NC Raleigh Specialist - (in Raleigh, NC)) GA DHS - Sr. Data Analyst-DFCS- (725289) Create date: 27-Nov-2023 Job Title: GA DHS - Sr. Data Analyst-DFCS-Performance Planning And Reporting (725289) Hybrid Start date :01/02/2024 End date :06/30/2024 Submission deadline :11/30/2023 Client info :DHS Description : *CANDIDATE MUST BE LOCAL.... (This job is for - Microstrategy Jobs in GA Atlanta Analyst - (in Atlanta, GA)) QA Testing Analyst III Senior - 20230103084312 Create date: 03-Jan-2023 start date : 1/23/2023 End date : 4+months from the start date. submission deadline : 01-10-2023 Note : * Remote Description : Sr. Manual Sr Tester Strong SQL skills - does not need to be expert, need to be able to write que.... (This job is for - job Jobs in MN Plymouth Analyst - (in Plymouth, MN))    Sql Skills job openings in OH Jobs List Mulesoft Integration Developer - J-11-416-896 Create date: 19-Jun-2019 start date:06/24/2019 End date:06/30/2020 submission deadline:6/21/2019 Description: Must Have: Mule ESB AnyPoint Studio, Dataweave, RAML Data relationship / Data interfaces / SQL skills Agile Software Development Nice to Have: API Develo.... (This job is for - Mule Jobs in OH Colombus Developer - (in Colombus, OH)) Business Systems Analyst - 32849 Create date: 19-Mar-2018 Client Info : Great American Insurance Job Description : Our financial client is looking for a Technical Business Systems analyst proficient with insurance claims systems. Guidewire experience and experience in policy and causalities is required. Experience: 5 or more years of related experience that.... (This job is for - job Jobs in OH Cincinnati Analyst - (in Cincinnati, OH)) Data Modeler/Architect - J-10-882-844 Create date: 14-Apr-2014 Data Modeler / Data Architect Your Data Management skills are needed just about anywhere. But is it where you want to go? Imagine working for one of the nations most respected companies. Making a strategic contribution. Receiving the rewards and recognition you deserve. Whether you are pursuing a contract or permanent placement, Experis .... (This job is for - ERwinMS SQL Server Jobs in OH LINWORTH Modeler - (in LINWORTH, OH)) (Architect: Sql Skills, ETL, Data Transformation, Data Extraction Tools MS Office Products in Columbus, OH)

Featured Jobs Developer (Jobs in Atlanta, Georgia) Data Architect ETL Specialist (Jobs in Raleigh, North Carolina) SQL Architect (Jobs in Richmond, Virginia) Business Analyst Financial Analyst (Jobs in Fredericksburg, Virginia) Cyber Architect (Jobs in Columbia, South Carolina) VxRails Consultant (Jobs in Boise, Idaho) Project Manager Microsoft Manager (Jobs in Raleigh, North Carolina) Agile Jira UAT Manager (Jobs in Atlanta, Georgia) - - Analyst (Jobs in Portland, Oregon) HTMLCSSJavaScript Developer (Jobs in Lincoln, Nebraska)