This site uses cookies. To find out more, see our Cookies Policy

SQL Integrations Developer in Deerfield, IL at Envista Forensics

Date Posted: 2/6/2018

Job Snapshot

Job Description

Envista Forensics is looking for a new team member in IT who is looking for an engaging challenge in a collaborative environment.  Our development team is expanding to include a new back-end SQL integrations developer to create meaningful developments that automate processes, serve to integrate acquired companies, assure quality data quality across our enterprise systems, and solve other business challenges.  As a growing team all team members are able to contribute and provide feedback to effect how our team operates.  If you’re looking to join a constantly growing team solving new and interesting development problems every day, join Envista Forensics.

Envista Forensics and its subsidiary AREPA has over 400 employees located in 30 offices on 4 continents with IT staff located throughout the United States and in Denmark.


  • Develop, end-to-end, one-time and continuous data integrations (ETL) using SSIS based on requirements directly gathered or provided by business staff or analyst.
  • Utilize SQL DQS or other similar tools to maintain Data Quality in managed systems.
  • Create Stored Procedures, Views, Staging Tables, Triggers, Functions, Indexes and other similar SQL objects.
  • Maintain ownership of projects and tasks, working independently to meet deadlines.
  • Escalate issues in a timely manner encountered that cannot directly address.
  • Analyze and review existing integrations for optimization.  Refactor code as necessary.
  • Respond to break/fix issues with integrations.
  • Create design and test plans for all developments.
  • Work in broader Development team to assist with larger projects and improve overall development operations.
  • Provide coaching to less experienced team members.
  • Commit to and deliver continuous improvement of IT functions and broader business functions.
  • Participate in stakeholder discussions for system designs.
  • Work with ABA (Associate Business Analyst) to assure system documentation is accurate and update when changes are made or new developments created.
  • Continuously expand knowledge of industry trends and new technologies relevant to back-end development.
  • Participate in on-call escalation rotation
  • Performs other IT duties as assigned.


Job Requirements


  • Comprehensive Knowledge of and Strong Experience with MS SQL Server 2012+, SSIS (SQL Server Integration Services), and T-SQL (Transactional SQL).
  • Strong Skills in Data Mapping.
  • Strong Understanding of RDM (Relational Database Model) including the ability to work with basic non-MS SQL source systems such as MS Access, MS Excel, MySQL, or similar database engines.
  • Knowledge of and Experience with DQS (Data Quality Services) or similar tools appropriate for a SQL Server Environment.
  • Experience working in TFS (Team Foundation Server) for source code management strongly preferred.
  • Knowledge of working with integration between on-premise and cloud-based platforms strongly preferred.
  • Experience with Microsoft Dynamics CRM and Dynamics GP a major plus.
  • Knowledge and experience with SSRS (SQL Server Reporting Services) beneficial.
  • U-SQL knowledge or experience a plus.
  • Knowledge or experience with C# (C-Sharp) or JS (Javascript) not required, but a plus.


  • Strong analytical, creative and trouble shooting skills.
  • Good communication skills (written, verbal, and listening) with specific ability to translate detailed technical details to non-technical audience.
  • Proven track record of documenting work.
  • Functions independently while taking direction from superiors, co-workers, and internal customers.
  • Strong collaborative skills working in a diverse team environment.
  • Ability to accept responsibility and accountability for actions.
  • Ability to manage and coordinate multiple projects at a time and meet deadlines for those projects.
  • Ability to demonstrate conduct conforming to a set of values and ethical practices.
  • Ability to adapt to change quickly.


  1. Software Engineer Jobs
  2. Project Engineer Jobs