DATA ANALYST Job at Hire Our Heroes Veteran Job Board, Grapevine, TX

cThYRlBTVnE0SXN6akNDbDFuK3FpNVpVQUE9PQ==
  • Hire Our Heroes Veteran Job Board
  • Grapevine, TX

Job Description

Create and analyze business requirements to compose functional and implementable technical data solutions.

Identify integration impact, data flows and data stewardship.

Create new data constraints and or leverage existing constraints for reuse.

Create data dictionary, Data mapping for ETL and application support, DFD, ERD, mapping documents, metadata, DDL and DML as required.

Anticipate JAD sessions as primary modeler in expanding existing DB and developing new ones.

Evaluate and enhance current data models to reflect business requirements.

Generate, write and run SQL script to implement the DB changes including table update, addition or update of indexes, creation of views and store procedures.

Consolidate and update various data models through reverse and forward engineering.

Compare different WFHM DB environments and determined, resolve and document discrepancies.

Analyses DB discrepancies and synchronize the Staging, Development, UAT and Production DB environments with data models.

Review and revise data models for soundness of data structures and adherence to client standards.

Consult with application development business analysts to translate business requirements into data design requirements used for driving innovative data designs that meet business objectives.

Involve in information-gathering meetings and JAD sessions to gather business requirements, deliver business requirements document and preliminary logical data model.

Performs requirements gathering and design analysis for customer contact history for customer relationship management.

Work as business requirements analysts with subject matter experts to identify and understand requirements.

Supports data warehouse projects with logical and physical data modeling in Oracle environment and assure accurate delivery of DDL to the development teams.

Document the data requirements and system changes into detailed functional specifications.

Perform Extraction, Transformation and Loading (ETL) using Informatica power center.

Salary/Compensation: $122,500 per year

recblid epdjc1zroda02f9dqetnf8nhrc92jn

Job Tags

Similar Jobs

TEA & COFFEE EXCHANGE

Barista Job at TEA & COFFEE EXCHANGE

 ...offering a cozy and inviting space for our community to gather over expertly crafted beverages. Were all about creating memorable experiences for our customers, one cup at a time. If youre ready to bring your energy, creativity, and love for coffee and tea to the table,... 

ConocoPhillips

Oiler - Marine Job at ConocoPhillips

 ...production companies, based on proved reserves and production of liquids and natural gas. With operations and activities in 13 countries, we explore for, develop, and produce crude oil and natural gas globally. We are challenged with an important job to safely find and... 

Huntsville Health And Rehabilitation LLC

Activities Assistant Job at Huntsville Health And Rehabilitation LLC

 ...GENERAL PURPOSE Assist Activities Director in preparing and conducting activities for the resident. QUALIFICATIONS Experience working with the elderly and disabled Must demonstrate creative abilities in execution and development of activities Ability to... 

Cafe Knotted - Westfield Century City

Cashier/Barista Job at Cafe Knotted - Westfield Century City

 ...Caf Knotted is looking for a highly motivated and dedicated Cashier/ Barista to join our growing team. We are focused on providing a welcoming environment while continuing to cultivate a warm and knowledgeable team. This job is very hands-on and requires initiative,... 

Mom to Virtual Assistant

Virtual Assistant 15-20 Hours per Week (IC-AM) Job at Mom to Virtual Assistant

We are in the process of staffing a Virtual Assistant where a client needs someone to handle the following responsibilities. If you are interested, please complete the Virtual Assistant application. For other job information and updates on Virtual Assistant roles, make...