Posted: Monday, October 2, 2017 9:01 PM
Job DescriptionData Modeler Consultant Job Description:OneAmerica IT Associates leverage their information technology skills participating in and leading peer groups to create solutions meeting complex product and process challenges. A Consultant leverages their technical knowledge to peer lead cross-functional teams in the delivery of improved business outcomes. May act as a mentor to analysts and senior analyst resources. Expected to identify and decide between alternative solutions with cross functional impact.The Data Modeler is responsible for design, administration, development and expansion of data assets that support business intelligence, advanced analytics, and reporting. The Modeler also will develop, maintain, and support the enterprise data warehouse system, corresponding data marts, and data interfaces between operational systems. This modeler will analyze and review complex object and data models and the metadata repository in order to structure the processes and data for better management and efficient access. Create and maintain the data documentation and be the liaison between migration team and IT. Key Responsibilities: Supports corporate data assets. Designs, reviews and maintains data models. Partners with Area Data Steward on data asset attributes and definitions. Follows established Data Architecture Framework and Guidelines for the design, development, management, storage, access, navigation, movement, transformation and quality of corporate data assets. Performs the data analysis activities to capture data requirements clearly, completely and correctly, and represent them in a formal and visual way through the data models. Creates semantically rich logical data models that define the Business data requirements and are independent of any technology solution (ie DBMS.) Manages the life cycle of the data model from requirements to design to implementation to maintenance. Looks for opportunities to provide data reuse, balancing the issues of centralization and replication. Encourages the Business to manage data as an asset. Ensures the preservation of strategic data assets as applications and technologies come and go. Requires an in-depth understanding of the Business data needs and the ability to align those Business needs with the overall Enterprise data vision. Evaluates the use of data to the goals and practices of the Business in a way that provides clear results. Acts as a liaison, deducing the data needs of a particular project or group and explaining the importance and use of the data most relevant to them. Helps ensure the accuracy and accessibility of all important data and is responsible for knowing what data is important and why. Compiles and maintains the schema definition for physical data models. Reviews all physical data models with data management committee before implementation. Assists the ETL developers to help ensure that the Business data rules are implemented correctly and clarifies issues as they arise. Knowledge and skills required for this role: A four-year College Degree in Business or Information Systems is required3+ years of experience data modeling data solutions including but not limited to : ODS, Data Warehouse, Data Integration Hub, OLTP/OLAP, or equivalent knowledge Core competency in: Relational DBMS (Oracle, SQL Server), Data modeling - ER Studio, CA Erwin or similar Entity Relationship tool. Competent level of understanding of SQL, PL/SQL, SSIS, Stored Procedures, and API's of assigned modules Excellent SQL skills and demonstrated ability to wite complex SQL for purposes of analyzing data and/or evaluating how information needs might be translated into backend strucutres. Strong oral and written communication skills are requiredCompany DescriptionAbout OneAmericaA national leader in the insurance and financial services marketplace for nearly 140 years, the companies of OneAmerica help customers build and protect their financial futures.OneAmerica offers a variety of products and services to serve the financial needs of their policyholders and customers. These products include retirement plan products and recordkeeping services, individual life insurance, annuities, asset based long-term care solutions and employee benefit plan products.Products are issued and underwritten by the companies of OneAmerica and distributed through a nationwide network of employees, agents, brokers and other sources that are committed to providing value to our customers. To learn more about our products, services and the companies of OneAmerica, visit /companies.
• Location: Indianapolis
• Post ID: 30714402 indianapolis