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

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

Troutman Pepper

Strategic Legal Research Analyst Job at Troutman Pepper

 ...A leading law firm is seeking a Research Analyst to provide expert-level legal research support to attorneys, utilizing advanced research technologies. The ideal candidate will have a Master of Library Science and at least five years of law firm experience. Responsibilities... 

HireFox

Associate Dentist Job at HireFox

 ...caring atmosphere. Are you ready to help us achieve our next million smiles? We have an exciting opportunity for you! Position: Associate Dentist We are currently looking for an Associate Dentist to join our expanding team. Support our goal of providing outstanding... 

Stellar Senior Living

RN Job at Stellar Senior Living

Are you a nurturing soul with a passion for making a positive impact on the lives of our cherished senior residents? If so, we want YOU to be a part of our warm and welcoming team. Why Us? We are committed to providing a Stellar life for our residents. Our dedicated team...

US0767 Prysmian Cables and Systems Usa LLC

Electrician Job at US0767 Prysmian Cables and Systems Usa LLC

 ...distribution , as well as medium low voltage cables for the construction and infrastructure sectors. We also produce a comprehensive...  ...Principal duties and responsibilities: ~ The Maintenance Electrician reports to the Maintenance Manager. \n ~ Responsible for... 

Ecolab

Senior Lab Technician Job at Ecolab

 ...Want to build a brighter, bolder future and cultivate your career? Join Ecolabs team and help create a world in which we all thrive. Ecolab is seeking a Senior Lab Technician to join our team in Naperville, IL. As a Senior Lab Technician, youll su Lab Technician,...