Data Architect SSAS Data Migration Data Modeling Architect (Jobs in Richmond, VA)   Requirement id 95177 Job title Architect Job location in Richmond, VA Skills required T/SQL Queries, Data Architect, SSAS, Data Migration Data Modeling Open Date 18-Jul-2019 Close Date Job type Contract Duration 6 Months Compensation DOE Status requirement not found Job interview type Face to Face interview    Email Recruiter: coolsoft Job Description Architect: T/SQL Queries, Data Architect, SSAS, Data Migration Data Modeling Candidate must be our W2 Employee We should submit only GC, GC EAD, L2 EAD, H4 EAD and Citizens. Notes : Onsite interviews are required - will not take candidates who will not physically come onsite for the interview. Candidates must have SENIOR level experience. At least 10+ years of working hands on and with business users. High level consultant. Long-term project - typically extend in 6-12 month increments. Last person in this role was there for 5 years as a contractor. Description: Summary The Virginia Retirement System (VRS) is seeking an SQL Server Data Architect with a passion for database development and support. As a SQL Server Data Architect, the ideal candidate brings proven Database development and support experience and the ability to thrive in a highly collaborative and fast-paced work environment. This is a hands-on, analytical and technical role, requiring strong Database development and support experience and comprehensive SQL Server expertise, preferably with Public Pension Management or Financial Services systems background. Responsibilities: The SQL Server Data Architect provides strong technical, analytical and presentation skills to lead and actively participate in Database projects. They are responsible for designing and building database architectures and solutions for VRS. They will consult with project teams, management and business partners on the different aspects of database processes; develop, optimize and maintains conceptual and logical data models; and implement and maintain the physical data model. The position may involve working on multiple, concurrent deadline-driven projects and support. The SQL Server Data Architect will work closely with Project Managers, Business partners and other resources during all phases of the Software Development Life Cycle, and will ensure deadlines are met and output is of the highest quality. • Design and implement effective database solutions and optimal data models • Manage the migration of data from existing systems to new systems • Assess and recommend solutions to improve new and existing database systems • Translate complex business requirements to optimal technical solutions • Provide technical expertise in SQL development and database optimization • Ensure the development projects follow the SDLC process • Work independently and in collaboration with the DBA and application support teams, lead database development projects • Create and maintain technical design and support documents Required Skills: • SQL Server 2014, 2016 or later • Proficient in relational and multi-dimensional data modelling and data modelling tools • Proficient in writing complex T-SQL statements and stored procedures • Advanced knowledge in Query Tuning and Optimization • Strong knowledge of database structure and data mining • Proven experience in data conversion and data transformation • Strong analytical and problem solving skills • Ability to organize and plan work independently • Ability to multi-task and context-switch effectively between different activities and teams • Ability to deliver effectively in a fast pace environment • Windows server 2012 and 2016, and Active Directory Preferred Technical skills: • SQL Server Master Data Service • SSRS, SSAS and Power BI • Tableau reporting tool • Data Wareho   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 95177 while calling.   Other jobs in VA: Alexandria (1), Ashburn (3), Cardinal (1), Charllottesville (1), Charlottesville (6), Chesapeake (2), Chester (2), Dulles (3), Fredericksburg (1), Fremont (1), Glen Allen (2), Reston (4), Richmond (45), Roanoke (14), Virginia Beach (14),    T/SQL Queries job openings in other states Jobs List RHAPSODY DEVELOPER-Consultant -11205-1 Create date: 02-May-2024 Start date :5/20/2024 Submission deadline : 5/9/2024 Client Info : Health & Environmental Control Department (DHEC) Note : Q) INTERVIEW PROCESS(who will conduct i/v, phone or in-person, how many rounds of i/vs)? A) An interview panel will conduct one initial round of in person, video, or phone .... (This job is for - JavaScript XML Jobs in SC COLUMBIA Consultant - (in Columbia, SC)) SQL Developer - 47693 Create date: 24-May-2019 We should submit only GC, GC EAD, L2 EAD, H4 EAD and Citizens. Description: Requirements/Description: Data analyst for databases supporting multiple systems and varying business departments. Business analyst for projects and reports, working across the company with business sponsors to produce user requiremen.... (This job is for - SSIS Jobs in NC Charlotte Developer - (in Charlotte, NC)) ServiceNow Developer - 47436 Create date: 16-May-2019 Description: serviceNow Developer and Data Analysis needed In need of a developer who can help in the migrating of two in house system named MIA and MyTek to a new platform called ServiceNow. MIA is an inventory tracking system to track client devices, request are opened in servicenow, requests MIA Applicat.... (This job is for - JavaScript Jobs in AR Bentonville Developer - (in Bentonville, AR)) MS SQL Server Database Consultant - J-11-321-972 Create date: 16-May-2018 Description: MS SQL Server Database Developer person that is very experienced in writing complex stored procedures using Transact SQL and SSIS packages to extract, transform, and load data from MS SQL Server databases. The following skills are required in an moderate to advance level of experience. MS SQL Server Studio .... (This job is for - SSIS Jobs in CA Sacramento Consultant - (in Sacramento, CA)) Systems Software Programmer - Advanced - 7425-1 Create date: 01-Jun-2017 Start date : 07/03/2017 Deadline : 06/08/2017 Client : Department of Revenue Description : DOR has implemented SAP Business Objects (BO) as its tool set for Business Intelligence. DOR wishes to engage a systems software programmer experienced in Business Objects to support the continuing development of the DOR .... (This job is for - job Jobs in SC Columbia Developer - (in Columbia, SC))     (Architect: T/SQL Queries, Data Architect, SSAS, Data Migration Data Modeling in Richmond, VA)

Featured Jobs QoS Analyst (Jobs in Dauphin County, Pennsylvania) Team Work Written Consultant (Jobs in Nashville, Tennessee) ASP.Net&C# Typescript MS SQL Server Specialist (Jobs in Raleigh, North Caro Project Manager Interpersonal Expert (Jobs in Raleigh, North Carolina) ASP.Net Typescript Web Specialist (Jobs in Raleigh, North Carolina) Tableau Consultant (Jobs in Dauphin County, Pennsylvania) Middleware C++ Expert (Jobs in Raleigh, North Carolina) BRD RTM SCRUM Analyst (Jobs in Richmond, Virginia) Documentation TechLead (Jobs in Madison, Wisconsin) ITSM Interpersonal Consultant (Jobs in Madison, Wisconsin)