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

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

Maetz Consulting, LLC

CDL A Driver, .67-71 CPM Job at Maetz Consulting, LLC

 ...Full-time, Regional CDL A Driver, Home EVERY Weekend!~ Dry Van, 100% NO TOUCH ~$67 - .71 CPM (Average drivers make $85,000 - $105,000+)~ Our drivers make $1,800+ plus per week (gross) running 2,100 miles or less ~ Averages miles for regional is 1900-2200 miles... 

WS Development

Senior Associate or Director, Capital Markets Job at WS Development

 ...Overview WS is searching for a highly motivated Senior Associate or Director who will primarily be responsible for assisting in the sourcing,...  ...every WS employee to feel welcomed and valued irrespective of race, color, religion, gender, gender identity or expression, sexual... 

EAG Automotive

Sales Consultant - Spanish speaking Job at EAG Automotive

 ...Sales Consultant Automotive WE ARE SEEKING A FLUENT SPANISH SALES CONSULTANT If youre ready to kick your sales career into overdrive, now is the perfect time to join our team of automotive sales professionals. This is an opportunity for you to turn your sales... 

Northeast Healthcare Recruitment, Inc.

Hematology Oncology Nurse Practitioner Job at Northeast Healthcare Recruitment, Inc.

Ouresteemed team in Milford, CT is seeking a dedicated and skilledHematology Oncology Nurse Practitioner to join us in providing exceptional careto our patients. As part of our dynamic team comprising two physicians and twoNurse Practitioners, you will play a pivotal... 

VML

Associate Creative Director, Art Job at VML

 ...are a beacon of innovation and growth in an ever-evolving world. Our heritage is built upon a century of combined expertise, where creativity meets technology, and diverse perspectives ignite inspiration. With the merger of VMLY&R and Wunderman Thompson, we have forged a...