Data Architect/Data Modeler - Full-time

Description

Medline Industries, in north suburban Mundelein, IL, is seeking a Data Architect/Modeler to join the Information Services team.

The Data Architect/Modeler will translate business requirements into the appropriate data models that integrate with the overall logical data warehouse. This individual will work closely with senior members of the BI team as well as the manager to define, document, and apply business rules to enterprise data.

He/She will be responsible for defining business data requirements and creating logical and physical data models. Will also assist as needed in the design and development of ETL standards, policies, procedures, and metadata to ensure accuracy, quality, integrity, and optimization of this information. Responsibilities also include researching and documenting data requirements for designing database models that facilitate reporting, analytics and business intelligence.

Job responsibilities include:

• Create/maintain the Enterprise Business Intelligence data architecture to increase the robustness, performance, and scalability of systems.
• Ensure optimal end user performance by establishing and consistently executing overall system performance assessment processes and associated action plans.
• Provide oversight and direction for the design and development of the data layer(s).
• Responsible for the development of logical data models and physical data base designs applied across multiple computing environments.
• Assist development team in the design of new BI solutions. Work with product owner and business users to understand and translate user stories and/or requirements into data models, analytics reports and scenario models.
• Lead technology review meetings and ensure appropriate governance processes are followed.
• Develop standards, process flows and tools that promote and facilitate the mapping of data sources, documenting interfaces and data movement across the enterprise.
• Provide architectural solutions covering data structures, sourcing, integration, security, and retention.
• Define governance and best practices around meta-data to ensure an integrated definition of data for enterprise information, and to ensure the accuracy, validity, reusability, and consistent definitions for common reference data.
• This position is responsible for the data analyses/ design and solution architecture for DW applications.
• Creation of conceptual, logical and physical database models as well as process and data lineage diagrams.
• Create Application design, High level Design based on customer requirements
• Maintain quality of data in the warehouse, ensuring: integrity of data in the warehouse, correcting any data problems, data currency, establish design procedures to purge/archive old data
• Ensure design meets the requirements. Source data from legacy systems that are to be loaded into the warehouse; provide extracts of data from the warehouse back to operational systems
• Source data analysis / profiling where necessary to support ETL design.
• Work closely with ETL developers to assist them with development life cycle.
• Ensure necessary metadata repositories are developed for all initiatives and ensure these meet current needs and provide flexibility for future growth.
• Ensure that documentation is created, meets standards, and is properly maintained according to established standards and procedures, to facilitate ongoing support and maintenance.
• Provide technical leadership and guide team members.
• Elicit requirements and translate the requirements into models by building conceptual, logical and physical data models.
• Involved in data roadmap, current / target state for enterprise data.

Qualification

Success Criteria:

• Advanced Analytical Thinking and Problem Solving skills
• Solid experience in architecture, advanced reporting and dashboards.
• Experience working with data warehouses is required.
• Strong SQL skills and experience with performance tuning are required.
• Get it done” attitude
• Superior Communication and Business-Technical Interaction skills
• Good understanding of Data Modeling concepts, Data relationships
• Knowledgeable with ETL technologies SSIS, Informatica or DataStage

To qualify, you must possess the following skills:

• Bachelor’s degree in Computer Science or relates strongly preferred.
• Minimum 4 years experience in consulting or similar analyst position implementing DW’s and Data Marts
• Proven experience with ETL tool either SSIS, Informatica or DataStage
• Professional or educational experience in software development
• Excellent communication, and data analysis skills
• Excellent knowledge of SQL for performing data analysis
• Proficient in MS Office suite (Word, Excel, PowerPoint, Access, Visio) software

Medline is an equal opportunity/affirmative action employer including women, minorities, veterans and individuals with disabilities.