KansasCityRecruiter Since 2001
the smart solution for Kansas City jobs

Sr. Data Architect

Company: SSI
Location: Kansas City
Posted on: February 16, 2020

Job Description:

Please send resume to Prakash at pmohantyssipeople.com or reach me on 412-203-0250 Note: We are not sponsoring, Only W2 Client: Direct Client Title: Sr. Data Architect Location: Kansas City, MO Duration: 12 months with possible extension Job Description: 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 and analytical skills Understanding of enterprise and reporting modeling concepts, including dimensional modeling, snowflakes, slowly changing dimensions, schema on read, irregular dimensions, and surrogate, compound and intelligent keys. Advanced degree in computer engineering, computer science, information systems, or related field. - provided by Dice

Keywords: SSI, Kansas City , Sr. Data Architect, Other , Kansas City, Kansas

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other Other Jobs


Auto Body Technician
Description: Overview BUSY SHOPS GREAT EARNINGS AND BENEFITS STATE OF THE ART TECHNOLOGY Questions Want to apply Call/Text Jenny 708 642-0336 Email: Jennifer.Twomey gerbercollision.com Gerber Collision (more...)
Company: Gerber Collision & Glass
Location: Kansas City
Posted on: 02/28/2020

Travel Nurse RN - Clinical - $1,489 per week
Description: ARMStaffing is seeking a travel nurse RN Clinical for a travel nursing job in Kansas City, Missouri:- Specialty: Clinical- Discipline: RN- Start Date: 03/04/2020- Duration: 13 weeks- 36 hours per week- (more...)
Company: NurseFly Travel Nursing
Location: Kansas City
Posted on: 02/28/2020

Licensed Life Insurance Agent - Work any time, from anywhere
Description: Join the revolutionary ASSURANCE platform, and enjoy the freedom of working when you want, from wherever you want, helping inbound, qualified, in-market
Company: ASSURANCE Independent Agents
Location: Kansas City
Posted on: 02/28/2020


CDL-A Independent Contractors - Lease Purchase Optn - 200k/yr Avg
Description: SOAR TRANSPORTATION GROUP - INDEPENDENT CONTRACTORS Lease-Purchase Options When you re ready to get your trucking business on track for a top income, come talk to us at SOAR. We work closely with
Company: The Driver Board
Location: Kansas City
Posted on: 02/28/2020

Realtor + License
Description: IMPORTANT: You must be a state licensed real estate agent Sentry Residential is currently seeking real estate agents to join our rapidly growing brokerage. Sentry is building a national brand focused (more...)
Company: Sentry Residential
Location: Kansas City
Posted on: 02/28/2020

Registered Nurse (RN)
Description: Determined to Increase your work/life balance and home time, your ability to learn and advance, and your impact on other's lives We leave work at work. So should you As a critical part of every (more...)
Company: Octapharma Plasma, Inc.
Location: Kansas City
Posted on: 02/28/2020

Class A CDL Dedicated Company Drivers - $2,500 Sign-On Bonus (Kansas City)
Description: Truck Drivers Earn up to 45 Cents per Mile for Dedicated Freight Lanes Hiring drivers to run dedicated freight as follows:Tennessee
Company: Pemberton Truck Lines
Location: Kansas City
Posted on: 02/28/2020

Licensed Associate Broker
Description: IMPORTANT: You must be a state licensed Real Estate Broker Sentry Residential is currently seeking real estate broker's to join our rapidly growing brokerage. Sentry is building a national brand focused (more...)
Company: Sentry Residential
Location: Kansas City
Posted on: 02/28/2020

Class A CDL Dedicated Company Drivers - $2,500 Sign-On Bonus (Kansas City)
Description: Truck Drivers Earn up to 45 Cents per Mile for Dedicated Freight Lanes Hiring drivers to run dedicated freight as follows:Tennessee
Company: Pemberton Truck Lines
Location: Kansas City
Posted on: 02/28/2020

CNA - Certified Nursing Assistant
Description: We Are Hiring Carondelet Place, an Ascension Living community, is seeking qualified and passionate CNAs to join our nursing staff Seeking CNA for Full Time opportunities. Evening Shift: 3:00pm - 11:00pm (more...)
Company: Ascension, C14
Location: Kansas City
Posted on: 02/28/2020

Log In or Create An Account

Get the latest Kansas jobs by following @recnetKS on Twitter!

Kansas City RSS job feeds