Skip to Main Content
← Back to Jobs

Senior Data Integration Developer

Enterprise Solutions Inc. Rolling Meadows, IL
  • Posted: over a month ago
  • Other
Title: Senior Data Integration Developer
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
Requirements:
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.
Work Traits:
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

Enterprise Solutions Inc.

Address

Rolling Meadows, IL
USA

What email should the hiring manager reach you at?

By clicking the button above, I agree to the ZipRecruiter Terms of Use and acknowledge I have read the Privacy Policy, and agree to receive email job alerts.

What email should we contact you at once we get salary info from the hiring manager?

By clicking the button above, I agree to the ZipRecruiter Terms of Use and acknowledge I have read the Privacy Policy, and agree to receive email job alerts.

Our qualification feature is only available to registered members - what email address would you like for us to keep on file?

By clicking the button above, I agree to the ZipRecruiter Terms of Use and acknowledge I have read the Privacy Policy, and agree to receive email job alerts.