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

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

VIVA Creative

Creative Director Job at VIVA Creative

 ...About the Creative Director position: Are you a strategic thinker who excels at developing creative solutions for some of the world's most influential companies and organizations? If so, VIVA Creative is looking to meet you! VIVA is currently seeking an experienced... 

Request Technology

Expert Cyber Security Defense Engineer Job at Request Technology

 ...NO SPONSORSHIP EXPERTY CYBER DEFENSE ENGINEER - Python Automation Job Details...  ...application development Heavy automation. Security detection, investigations, log analysis...  ...industry. We fill positions at every level, from entry level to executive. Our specialties... 

The Salvation Army Thrift Store Phoenix

Retail - Assistant Store Manager - Tempe Job at The Salvation Army Thrift Store Phoenix

 ...we can continue to serve and impact our local community, through the commitment to Do The Most Good at our Main/Phoenix Thrift Store, which supports the Adult Rehabilitation Program. This is an opportunity to promote a positive shopping/donor experience, enhance customer... 

Aretsky's Patroon

Cocktail Server Job at Aretsky's Patroon

 ...recommendations: Suggest popular cocktails or other beverages based on guest preferences and availability. Handling payments: Accurately process payments, including cash, credit cards, and other methods. Maintaining cleanliness: Keep the bar and surrounding area clean and... 

Department of Veterans Affairs

MEDICAL TRANSCRIBER Job at Department of Veterans Affairs

 ...Please note: You willneed to take and pass an examination for Medical Transcriber to establish listeligibilityprior to job offer....  ...then the selected candidate will be required to provide college transcripts prior to appointment . Required Application Package...