Data modeler

AurionPro Solutions Leading Global IT Consulting Services. We’ve Urgent requirement with one of our client for Data modeler – Job opening Location Sun Prairie, WI Position title: Data modeler Work Location : Sun Prairie, WI Duration : Full Time Job Summary: The successful candidates for this position will be responsible for developing, integrating, managing, and promoting enterprise level data models and data modeling standards in the support of application database, data warehousing, and business intelligence initiatives within the Company. The ideal candidate will have substantial experience in analyzing requirements specified by the user community and design the required data structures to support those requirements as well as developing logical and physical data models to create and maintain both dimensional and relational database schemas. The candidate will act as both a data modeler for business applications as well as assist in the establishment of an enterprise inventory of data models and management of an enterprise metadata repository. Essential Job Responsibilities To successfully perform this job, the individual must be able to perform each essential job responsibility satisfactorily. Reasonable accommodations may be made to enable an individual with disabilities to perform the essential job responsibilities. Technical Performance : *Design and develop data solutions such as data models, or Extract, Transformation, Load (ETL) programs, or Business Intelligence (BI) components throughout the full data life cycle (DLC), making maximum use of data development tools/environments, coding standards, principles, and guidelines to meet business requirements o Design and execute unit and system test cases that assure the quality of the component and programs to be developed o React to and resolve production incidents in a manner that minimizes the outage or process impact and prevents reoccurrence o Provide accurate estimates for data development activities that maximize effectiveness of tools, methods, and development environments o Support the operational uses of the models/programs/BI solutions including the maintenance of these to meet changing business requirements Policy, Process, and Procedures : *Assist in the design, development, and implementation of data processes and deliver artifacts to support the data life cycle (DLC) o Coordinate the implementation of the models/programs/BI solutions developed in accordance with the change and release management policies to ensure delivery of Strategy & Technology (S&T) portfolio o Identify opportunities for improvements in the DLC assure best possible service is provided to business partners Environmental Awareness/Customer Focus: *Produce technical data specifications, designs, and documentation that facilitate delivery according to service level agreements (SLAs) and implementation criteria o Undertake timely resolution of defects and data process impact to maintain and improve service to business partners o Communicate effectively, both orally and in writing, with peers, management, and business partners to support and inform decision making and advise on progress o Take ownership for assigned problem resolution to minimize handoffs and see business partner problems through to full resolution o Openly and accurately communicate incident details o Develop data solutions with a focus on improved and /or efficient supportability to add value to the business *Maintain currency in best practice in area of expertise, whether data modeling, ETL, or BI, to keep up to date with current and future technologies Required Education &/or Exp Education Requirements: *Bachelor's degree in Computer Science, Engineering, or related field, or comparable experience, and continuing education related to the job. Experience Requirements: *5 to 7 years’ experience in logical data modeling with focus in data integration and extension of a generalized