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

M25qTW9SKzR2c2Y5S1BMcCswMnNGVmdjWmc9PQ==
  • 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

Allied Universal

Armed Security Field Supervisor - Transit Job at Allied Universal

Allied Universal, North America's leading security and facility services company, offers rewarding careers that provide you a sense of purpose. While working in a dynamic, welcoming, and collaborative workplace, you will be part of a team that contributes to a culture... 

Prevalent Group

Field Service Technician - Nashville Job at Prevalent Group

 ...Field Service Technician full-time/permanent position Remote position Military encouraged...  ...expectations through installations, repairs, and maintenance of coding and marking...  ...overtime ~ Company provided cell phone, laptop and tools ~ All travel expenses... 

Universal Hierarchy Node

Manager, Global Program Management, Disease Area X Job at Universal Hierarchy Node

 ...functional leadership experience ~ Strong project / program management skills ~ Intermediate knowledge in drug development Why Novartis : Our purpose is to reimagine medicine to improve and extend peoples lives and our vision is to become the most valued and... 

Kaniksu Community Health

Certified Medical Assistant (CMA) Job at Kaniksu Community Health

 ...needs. From prevention and wellness to medical, dental, and behavioral health. From pediatric...  ..., and Life insurance ~ Education Assistance and Guided Career Pathways ~4% 401K employer...  ...Club A Kaniksu Community Health Certified Medical Assistant (CMA) is not just... 

APAC - Kansas - Shears

Heavy Highway Tack/Distributor Driver Job at APAC - Kansas - Shears

 ...our team. Traveling Tack Driver or Distributor Driver: Do you want to work for a...  ...safety above all else? Are you looking for opportunities and benefits for a large corporation...  ...conditions with skill and exercise of independent judgment. Ability to read, write...