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- Mid Level (743592) Create date: 29-Jul-2024 No of Submissions : 2 start date :08/12/2024 End date :08/08/2025 submission deadline :08/02/2024 client info :NCDOT Note: * Agency Interview Type:Either Webcam Interview or In Person * Hybrid Description : *.... (This job is for - JEE Jobs in NC Raleigh Specialist - (in Raleigh, NC)) GCRTA - System Administrator 4 (742952) Create date: 19-Jul-2024 No of Submissions : 2 Start date : 08/05/2024 End Date : 06/30/2025 Submission deadline : 07/24/2024 Client Info : GCRTA Note: * Remote Description : General ? Strong understanding of Oracle Cloud services, including compute, storage, networking, and data.... (This job is for - job Jobs in OH Columbus Administrator - (in Columbus, OH)) GA - GSFC - Data Science / Analytics Developer (742117) Create date: 17-Jul-2024 No of Submissions :2 Start date :8/12/2024 End Date :12/31/2024 Submission deadline :07/22/2024 Client Info :GSFC - IT Note: * Onsite * Agency Interview Type:Either Web Cam or In Person Description : MUST be Local Metro Area Candidates ·US Citizenship.... (This job is for - job Jobs in GA Tucker Analyst - (in TUCKER, GA)) GA DHS IT Business Analyst 4 (741668) Create date: 02-Jul-2024 * Remote No of Submissions : 1 Start date : 07/29/2024 End Date : 06/30/2025 Submission deadline : 07/09/2024 Client Info : DHS Note: * Web Cam Interview Only Description : Duties and responsibilities Identifies and defines business req.... (This job is for - SDLC SME Jobs in GA Atlanta Analyst - (in Atlanta, GA)) VDOT Technical Writer 4 (740267) Create date: 25-Jun-2024 * Hybrid No of Submissions : 2 Start date :07/01/2024 End Date :06/30/2025 Submission deadline :6/28/2024 Client Info :VDOT Note: * In Person Only * In office at VDOT - 1401 East Broad Street, Richmond, VA - at least 3 days per week. * Long term posit.... (This job is for - Documentation Jobs in VA Richmond Consultant - (in Richmond, VA))    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 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)