Peersight
Employers
Jobs
Companies
Top Cities
Log In
Jobs
Truck Driver Position Occupational Therapist 0 0 PR Digital Marketing Intern Delivery Driver Paid Healthy Trial Participant Paid Clinical Trial Participant Paid Research Participant BairesWash Incorpora Personal Para Software Developer Bread Baker Dental Receptionist-Full Time Driller Delivery Driver Carpenter Bud Tender Hiring Mortgage Agents and Brokers Marketing Assistant Amazon Picker Amazon Warehouse Associate - Immediate Amazon Warehouse Associate - Immediate Amazon Order Packer Seasonal Full-Time Warehouse Team Member Amazon Picker Amazon Warehouse Associate Full-Time Warehouse Team Member Amazon Warehouse Worker Amazon Picker Amazon Picker Amazon Warehouse Associate - Immediate Amazon Picker Full-Time Warehouse Team Member Amazon Picker Amazon Picker Amazon Warehouse Worker Amazon Warehouse Associate - Immediate Amazon Warehouse Associate - Free Amazon Warehouse Worker Amazon Warehouse Worker Amazon Warehouse Associate Amazon Order Packer Amazon Warehouse Associate - Free Seasonal Full-Time Warehouse Team Member Amazon Warehouse Worker Amazon Picker Amazon Warehouse Worker Full-Time Warehouse Team Member Amazon Warehouse Worker Newest Jobs
Companies
Yelp ContactMonkey CareGuide Clearbanc Sterling-Turner Exact Media Aerotek Two Sigma Aecom Peel Regional Police AsteroidX Akira Jane Street Borrowell Insight Global WeWork Shopify First Convenience Bank American Income Life Doordash Amazon Flex Square Microsoft AT&T Instacart Clickworker Vector Marketing Scotiabank Creative Circle Hatchways Walgreens UnitedHealth Group Recovhub LowCostWebDesignFirm.com Desjardins CI&T mappedin 51talk Top Hat Checkout 51 Paylocity Mobeewave TD Bank The Youth Connection Hootsuite SnapTravel ScribbleLive autoTRADER.ca GoParkr Xiaomi All Companies
Top Cities
Chicago, Illinois Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs New York, New York Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Toronto, Ontario Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Vancouver, British Columbia Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Calgary, Alberta Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs San Francisco, California Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Montréal, Quebec Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Los Angeles, California Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs
Navigation
My Profile Log Out

Sr. HANA BI Modeler At Medline Industries Inc

Location: Northfield, Illinois

Job Description

Job Description
Translate business requirements into the appropriate data models that integrate with the overall logical data warehouse. Define business data requirements and create logical and physical data models. 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.

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. Create conceptual, logical and physical database models as well as process and data lineage diagrams. Create Application design, High level Design based on customer requirements.
Provide oversight and direction for the design and development of the data layer(s). Develop logical data models and physical data base designs applied across multiple computing environments. 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
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. Work closely with ETL developers to assist them with development life cycle.
Lead technology review meetings and ensure appropriate governance processes are followed. 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.
Develop standards, process flows and tools that promote and facilitate the mapping of data sources, documenting interfaces and data movement across the enterprise. 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.
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. Medline offers a business casual, entrepreneurial work environment with strong growth potential, a competitive compensation package, and a complete benefits package including medical/dental/vision/life insurance; 401(k) with company match. And much more!
Job Qualifications
Education

Bachelor's degree Relevant Work Experience

Minimum 4 years of experience in consulting or similar analyst position implementing DW's and Data Marts.
Proven experience with ETL tool either SSIS, Informatica or DataStage.
Experience working with data warehouses.
Professional or educational experience in software development. Additional

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 Preferred Qualifications

Additional

Advanced Analytical Thinking and Problem Solving skills
Solid experience in architecture, advanced reporting and dashboards.
Strong SQL skills and experience with performance tuning are required.
Superior Communication and Business-Technical Interaction skills.
Good understanding of Data Modeling concepts, Data relationships.
Knowledgeable with ETL technologies SSIS, Informatica or DataStage.