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 --- Apply    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 DCY - Product Specialist 5 / PS5 (778237) Create date: 07-Oct-2025 Start date : 10/20/2025 End Date : 06/30/2026 Submission deadline : 10/10/2025 Client Info : DCY Note: * Teams Interview * Fully Remote Description : Looking for candidate to function as a SME on enterprise systems, with advance skills in administering WebSphere.... (This job is for - RabbitMQ Jobs in OH Columbus Specialist - (in Columbus, OH)) GA DOL- Java Developer (774718) Create date: 13-Aug-2025 Start date : 09/01/2025 End Date : 03/31/2026 Submission deadline : 08/19/2025 Client Info : GDOL Note: * Agency Interview Type : Either Web Cam or In Person * **Local Metro Atlanta Candidate** * *Onsite Required from day 1* Description : The Georgi.... (This job is for - JavaScript JQuery Jobs in GA Atlanta Developer - (in Atlanta, GA)) Elect - GIS Developer 4 (774079) Create date: 01-Aug-2025 Start date : 08/15/2025 End Date : 12/31/2025 Submission deadline : 08/11/2025 Client Info : ELECT Note: * Agency Interview Type : Web Cam Interview Only * Remote Description : The Senior GIS Architect will lead the implementation of ArcGIS Enterprise at the Vi.... (This job is for - GISMICROSOFT Jobs in VA Richmond Developer - (in Richmond, VA)) Cyber Security Technical Assistance - 143398 Create date: 04-Jun-2025 Start date : 7/1/2025 End Date : 6/30/2026 Submission deadline : 6/12/2025 3:00:00 PM Client Info : DFA Note: * Onsite required. 20 hours/week * There is an incumbent for this position but feel free to submit candidates. Description : Staff augmentation fo.... (This job is for - Cybersecurity Jobs in MS Jackson Consultant - (in Jackson, MS)) Network Engineer III - 137015 Create date: 07-Nov-2024 Bid Limit Per Vendor : 2 Start date : 12/02/2024 End Date : 06/30/2025 Submission deadline : 11/14/2024 at 4:00PM CST Client Info : Supreme Court Note : * Interview Process: via Teams * Duration of the Contract: 6/30/2025, with potential for extension * Onsite or Remo.... (This job is for - job Jobs in WI Madison Engineer - (in Madison, WI))    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 PowerShell Service Architect (Jobs in Jackson, Mississippi) Java/J2EE Spring Developer (Jobs in Madison, Wisconsin) Communication Analyst (Jobs in Richmond, Virginia) Hibernate Bootstrap Spring Consultant (Jobs in Lansing, Michigan) MCP WINDOWS Consultant (Jobs in Des Moines, Iowa) RDBMS SQL T Administrator (Jobs in Columbia, South Carolina) DB2 JCL KOFAX Developer (Jobs in Atlanta, Georgia) Manager (Jobs in Dauphin County, Pennsylvania) GitLab CI/CD API Analyst (Jobs in Madison, Wisconsin) Sap Consultant (Jobs in Columbia, South Carolina)