Data Modeler/analyst

Compensation

: $71,830.00 - $127,920.00 /year *

Employment Type

: Full-Time

Industry

: Advertising/Marketing/Public Relations



Loading some great jobs for you...





Skills:* Design and maintenance of conceptual and logical data model for OLTP and other analytical applications, using ERWIN* Analyzing functional and non-functional business requirements and translate into technical data requirements and create or update existing logical and physical data models* Facilitating data modeling sessions ranging from information gathering to model validation* Reverse and Forward Data Modeling* Providing support to analyze data requirements and data stored in a disparate set of systems and designing a robust relational structure for the future* Developing a solution to extract data out of the existing systems and store in the future system* Defining a data model and database design that is based on business needs* Conducting Business Requirements Analysis and educate the various project teams on the proper usage of data structures* Conducting data profiling and data analysis on source and target systems* Excellent Oracle SQL skills with the ability to validate data model functionality and performance using SQL* Must have good communication skills and ability to work in a fast-paced environmentResponsibilities:* Maintain data models in Erwin data modeling software* Participate in requirements gathering, project estimation and management* Utilize data modeling phase methodology leveraging conceptual, logical, and physical development to arrive at model solutions* Review and creation of architecture documents and diagrams: Data models, Data mapping, Data dictionaries, Metadata* Review and generate business rules for data* Research and document data flows* Research and document application integration solutions, ETL, SQL, etc.* Provide thought leadership regarding: Industry practices around collecting data, staging data, cleansing data, standardizing data, and publishing data into data marts.* Ensure data modeling deliverables conform to data modeling standards* Support integration of models and ensure definitions are consistent across the enterprise for shareability and reusability. * The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.

Launch your career - Create your profile now!

Create your Profile

Loading some great jobs for you...