Location: Rolling Meadows, IL
Duration: Fulltime Permanent
Collaborate with internal customers, prospects and stakeholders, understand and translates business use cases and/or requirements into data analysis and data mapping and consequently data integration routines which involves moving, cleansing and transforming large amount of data between multiple systems.
Identifies data sources, provides data flow diagrams and documents source to target mapping and process.
Collaborate with the Data Architect to recommend optimal data models for data ingestion and BI developer for analytic reports
Facilitate the development of data integration efforts by leading small teams of 1-2 junior developers in addition to hands on design and development of large complex ETL jobs.
Design, implement and maintain database objects (tables, views, indexes, etc.) and database security.
Validate data integration routines by developing and executing test plans and scenarios including data design, tool design, data extract/transform, networks, and hardware.
Maintain the data warehouse performance by optimizing batch processing through parallelization, performance tuning etc.
Establish methods and procedures for tracking data quality, completeness, redundancy and improvement.
Work with the Data Architect to establish processes for governing the identification, collection and use of corporate metadata to assure metadata is accurate and valid in the business intelligence environments.
Ensure data quality through creation of audit controls, proactive monitoring and data cleansing techniques
7+ years of experience in Data Warehousing and Business Intelligence
5+ Years in BI development leveraging the Microsoft SQLServer.
5+ years in SSIS and use of Stored Procedures.
Strong understanding data modeling (i.e. conceptual, logical and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts).
Deep understanding of relational database design concepts and SQL programming
Experience guiding/mentoring developers with lesser experience.
Requires strong analytical, conceptual and problem-solving abilities.
Strong experience with business intelligence and data warehousing design principles and industry best practices.
Bachelor's degree preference in computer/information sciences or business/commerce.
Strong communications skills - oral and written
Self-starter with strong work ethic
Flexible and resilient, handle various demands planned and unplanned
Proven ability to handle multiple tasks and projects simultaneously.
Problem solver and desire to close issues, pragmatic and realistic with solutions
Professional demeanor, working with senior level managers and vendors
Ability to work independently under minimal supervision and meet deadlines.
Strong sense of accountability, adaptability, flexibility and a sense of urgency.
Demonstrated ability to establish priorities, organize and plan work to satisfy established timeframes.
Passionate about continuously improving organizational practices.
Ability to learn and apply new technologies quickly and self-directed.
Ability to prioritize and multi-task across numerous work streams