Data Marts TFS T SQL Database Development Data Replication Methods Performance Tun   Requirement id 104159 Job title Consultant Job location in Kansas City, MO Skills required Computer Science, Information System, Data Warehouse, Data Marts TFS T SQL Database Developmen Open Date 28-Feb-2020 Close Date Job type Contract Duration 6 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Consultant: Computer Science, Information System, Data Warehouse, Data Marts TFS T SQL Database Developmen Note : * MODE OF INTERVIEW: Phone then in person (or video if no local) Description: • Our ideal Data Modeler has advanced knowledge of application, data, and infrastructure disciplines. Youll use your skills to implement data strategies, build data flows, and develop conceptual data models following CICD process. Youre capable of working independently and communicating effectively to provide feedback on policies, procedures, processes, and standards. Objectives of this role • Manage database design and data models for a specific application. • Analyze existing data and recommend changes that lead to a reduction of stored data without impacting business requirements. Daily and monthly responsibilities • Perform as a technical data steward understanding tables, data use, data replication, data connection, and data lineage and take accountability for data hygiene. • Analyze source system data and look for data redundancy and duplication. • Work with Enterprise Architects and Data Analysts to review exiting data models and suggest action to reduce input data for storage optimization. • Work with the development team to implement data strategies, build data flows, and develop conceptual data models. • Create data generation, editing, and refresh process to facilitate database and application testing • Work with the application development team to ensure that appropriate and efficient SQL is being coded and tested, and is built for performance during the development phase, instead of retrofitted later in production. • Review current database-coupled application logic – stored procedures, triggers, and user-defined functions (UDFs). Help to build, test, and maintain these objects, including source code management (TFS check-in/check-out), versioning, impact analysis, and code testing. • Create logical and physical data models using best practices. • Delivers and provides feedback for data modeling policies, procedure, processes and standards. • Assists with capturing and documenting system flow and other pertinent technical information about data, database design, or systems. Basic Qualifications • Bachelors degree in computer engineering, computer science, information systems, or related field. • 5+ years experiences with data analytics, data modeling or data architecture and database design. • Experience in data modeling or data architecture in transactional and operational reporting and analytical (EDW, Data Lake, NoSQL) solutions. • Experience with capacity planning, database scripting and package deployment • Good knowledge of data replication methodology. • Good knowledge of data warehouse, data mart and Data Lake • Strong understanding and experience in the use TFS Source Control and workflows, including process creation and automation of deployments. • Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools. • Strong understanding of good database development practices and T-SQL • Experience in implementing operational automation using scripts. Preferred Qualifications • Advanced knowledge of application, data and infrastructure disciplines. • Experience with Life Insurance or any insurance related products • Expertise in tuning and debugging SQL and resolving application specific bottlenecks. • Experience facilitating meetings and providing presentations to stakeholders and senior leaders. • Experience using (Erwin, TOAD, or any other data modeling tool) for data modeling. • Data modeling, data warehousing, dimensional modeling, data modeling for big data and metadata management. • Experience with DB2, Oracle, and/or SAP environments • Data Lake and Big Data modeling experience. • Excellent communication, problem solving, organizational   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 104159 while calling.   Other jobs in MO: Clayton (1), Kansas City (6), Morrisville (1), Saint Louis (3), St Louis (15),    Computer Science job openings in other states Jobs List NCDOT - Technical Specialist- Expert (723602) Create date: 02-Nov-2023 Remote Start date :11/27/2023 End date :11/29/2024 Submission deadline :11/08/2023 Client info :NCDOT Description : ***This is a remote position. If the candidate is outside of NC, they will be expected to come onsite for onboarding th.... (This job is for - job Jobs in NC Raleigh Specialist - (in Raleigh, NC)) GDOT IT Business Analyst 2 - Project Initiation (723464) Create date: 30-Oct-2023 Hybrid Start date :11/20/2023 End date :06/28/2024 Submission deadline :10/31/2023 Client info :GDOT - IT App Description : The Georgia Dept. of Transportation (GDOT) seeks a Business Analyst (BA) who will primarily assigned to compili.... (This job is for - job Jobs in GA Atlanta Analyst - (in Atlanta, GA)) GDOT IT Business Analyst 2 - Project Initiation (722571) Create date: 17-Oct-2023 Hybrid start date :11/13/2023 End date :06/30/2024 submission deadline :10/27/2023 client info :GDOT - IT App Description : The Georgia Dept. of Transportation (GDOT) seeks a Business Analyst (BA) who will primarily assigned to c.... (This job is for - job Jobs in GA Atlanta Analyst - (in Atlanta, GA)) GA DHS Sr. Java Developer - Tech Lead (721375) Create date: 26-Sep-2023 Remote start date :11/06/2023 End date :06/30/2024 submission deadline :09/29/2023 client info :DHS Description : As part of the applications development team, you will be driving the development of applications and providing leadershi.... (This job is for - MVVM Jobs in GA Atlanta Developer - (in Atlanta, GA)) GA DHS - Cybersecurity Analyst (716596) Create date: 02-Aug-2023 Start date : 08/21/2023 End Date : 06/30/2024 Submission deadline : 08/07/2023 Client Info : DHS Note : Hybrid *DO NOT submit candidates previously submitted to #710485* *MUST BE LOCAL TO METRO ATLANTA* *REQUIRED CERTIFICATIONS MUST BE UPLOADED* Description : job Jobs in GA Atlanta Analyst - (in Atlanta, GA))    Computer Science job openings in MO Jobs List SAP BA - 33294 Create date: 02-Apr-2018 Client Info : Monsanto Company Candidate must be our W2 Employee Job Description : SAP Vistex BA: The successful Business Analyst in the area of SAP Vistex will work within the high-performance Commercial IT Team. Exceptional teamwork is critical to the success of the individual and the achievement of bu.... (This job is for - Engineering Jobs in MO StLouis Analyst - (in St Louis, MO)) Java Developer - 33146 Create date: 27-Mar-2018 Client Info : Financial Industry Regulatory Authority, Inc. (FINRA) Job Description : Client: FINRA ROLE: Java Developer LOCATION: Rockville, MD 20850 DURATION: Long term rolling contract OVERVIEW: Apex Systems has an immediate need for several mid to senior level Java Develope.... (This job is for - Engineering Jobs in MO Rockville Developer - (in Rockville, MO)) .Net Dev - API, NodeJS, Mongo, Go - 31452 Create date: 29-Jan-2018 Client Info : Centene Corporation Job Description - Contingent-Application Software Engineer (Core Systems) (1086083) Job Description Contingent-Application Software Engineer (Core Systems)(Job Number: 1086083) Description Position Purpose: Design, build, test and maintain scalabl.... (This job is for - MIS Jobs in MO StLouis Developer - (in St Louis, MO)) Sr. .Net Developer - 31316 Create date: 25-Jan-2018 Client Info : Monsanto Company Note : Candidate must be our W2 Employee We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens Job Description : Looking for a senior developer with 8+ years of exp in programming, especially in .Net 4.0 and above. This person will be a full stack develop.... (This job is for - job Jobs in MO Chesterfield Developer - (in Chesterfield, MO)) Quality Assurance Automation (Data Engineering) - 25618 Create date: 11-Jul-2017 Candidate must be our W2 Employee Note : Candidates RTR form should be only on the name of APEX Systems Job Description : Job Requirements •Bachelors Degree or Masters Degree in Computer Science or related field; equivalent professional experience may be substituted for formal education •5+ y.... (This job is for - Quality Assurance SDLC Jobs in MO StLouis Developer - (in Stlouis, MO)) (Consultant: Computer Science, Information System, Data Warehouse, Data Marts TFS T SQL Database Developmen in Kansas City, MO)

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)