Data Modeler / Analyst with Power Designer

Job Title: Data Modeler / Analyst with Power Designer - Direct Hire / Full Time / Perm Job Location: Johnston, IA Job Type: Full Time / Perm / Direct Hire + Benefits Job Description: Works closely with the business and other Information Technology (IT) teams focusing on the processes of gathering, analyzing and documenting information requirements using standard data management tools and techniques for the creating, support and administration of database objects.  Work is of medium to high complexity and moderate to high in risk. Has expanded contact with responsibility to varied and multiple departments and functional operations, and actively participates in strategic business relationships. Serves as an effective and key team member in various roles including serving as a team lead.  Participates in the review and formation of work processes. May plan work and schedules for others on project-related work.  Impact of decision-making is medium to high risk and impact.  Serves as a consultant or expert and actively shares knowledge across workgroups. Applies information analyses to optimize the integration of major strategic business processes. Designs and implements complex changes impacting several processes with minimal direction.  Primarily performs as an individual contributor, but may supervise a small work team (6 or fewer members). Duties: Leads the review and formation of processes to create and manage physical data models for applications, data warehouse, and data marts. Creates and manages logical data models for an enterprise and/or project level where projects are of medium to high complexity and moderate to high in risk. Documents and maps interaction between business processes, information, and data to ensure that business has data integration for projects which are of medium to high complexity and moderate to high in risk. Performs gap analysis (including problem resolution and change management) and evaluation between information requirements and the quality of design of database and database administration environment of vendor purchased and/or outsource solutions, actively working to share knowledge. Manages physical design and integration of databases to support information requirements where projects are of medium to high complexity and moderate to high in risk. Develops, implements, and supports methodologies, standards, and tools for data management such as metadata management, data mining, data modeling, data cleansing, transformation and matching, data stewardship, data quality, data integration, data security, and data marts. Provides input to design of application systems and interfaces to ensure data access, integration, integrity, and security for projects which are of medium to high complexity and moderate to high in risk. Leads the effort of performing database/application performance tuning, data transformation and mapping, backup, and recovery of application databases including design and development of disaster recovery procedures which ensure enterprise data consistency. Responsibilities:  Experience creating and changing data models using power designer tool Experience mapping data interactions, business rules, and data transformations Performing gap analysis on data issues (quality, cleansing, security) Strong SQL skills Experience with DB2 mainframe, SQL server, and Oracle
Salary Range: NA
Minimum Qualification
Not Specified years

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.

More Jobs

Senior Data Analytics Analyst
West Des Moines, IA Farm Bureau Financial Services
Senior Data Analyst - Corporate Audit Services
Cedar Rapids, IA U.S. Bank
Data Analyst
Des Moines, IA Infinite Resource Solutions
Data Analyst I.T.
Des Moines, IA Fidelity
Analyst, Data
West Des Moines, IA General Dynamics Information Technology
Business Intelligence Designer - Data Reporting
Cedar Rapids, IA UFG Insurance