The Database Integration Engineer I will be a key member of the Infrastructure Engineering and Operations team at Exact Sciences, supporting data Integration, data modelling, data cleansing, and data migration. The successful candidate will have extensive experience in collecting business and user requirements, developing functional specifications, and integrating data to engineer automated production solutions for robustness, reliability, and operational simplicity.
Essential Duties and Responsibilities
Acts as a technical resource to our business partners in all phases of the development and implementation process; assist with incident and problem resolution as needed.
Works with Analysts and Business Users to translate functional specifications into technical designs for implementation and deployment.
Studies data sources by interviewing users; defining, analyzing, and validating data objects; identifying the relationship among data objects.
Plans data integration process by developing common definitions of sourced data; designing common keys in physical data structure; establishing data integration specifications; examining data applications; examining data models and data warehouse schema; determining best-fit data interchange methods; assessing middleware tools for data integration, transformation, and routing; developing project scope and specifications; identifying factors that negatively impact integration; forecasting resource requirements; establishing delivery timetables.
Improves data integration by designing and evaluating new data interchange formats; improving physical design; rewriting data policy, standards, and procedures.
Provide problem-solving expertise and complex analysis of data to develop business intelligence integration designs.
Build extensible data acquisition and integration solutions to meet the functional and non-functional requirements of the business.
Design, develop, and deploy data movements using SQL Server Integration Services, TSQL and Stored Procedures.
Collaborate with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements.
Conducts integration testing and maintains all integrations/DB systems.
Assures adherence to change management processes and security standards.
Follow data standards, resolve data issues, complete unit testing, and system documentation for data migration processes.
Provide development, QA, and production support to troubleshoot day-to-day data related issues.
Establish and maintain policies and procedures for Data Registration\Data Architecture.
Engages in vendor relationship management.
Setup and manage tools for database monitoring, diagnostics, and performance optimization for the data migration efforts.
Provide database infrastructure and architecture recommendations to admins supporting tactical and strategic business needs.
Engages in developing cloud strategies.
Work with IT operations teams to troubleshoot ETL and MDM issues and optimize the database server environments.
Partner with application and operations teams to establish and maintain standard operating procedures for data cleansing, data modelling, and data migration.
Engages in physical infrastructure maintenance; coordinates work activities with server and network operations team.
Works closely with SFDC and NetSuite admins to build automated workflows to ease admin activities.
Knowledge in installation and configuration of database clusters.
Ability to work effectively in a team-oriented environment with strong interpersonal and communication skills.
Results and deadline driven; must be willing to do whatever it takes to meet deadlines.
Solid analytical, problem solving, and trouble-shooting skills.
Excellent customer service skills and attention to detail.
Ability to communicate and negotiate with both technical and non-technical colleagues and stakeholders.
Uphold company mission and values through accountability, innovation, integrity, quality, and teamwork.
Support and comply with the company’s Quality Management System policies and procedures.
Regular and reliable attendance.
Ability to work designated schedule.
Ability to work nights and/or weekends.
Ability to lift up to 25 pounds for approximately 1% of a typical working day.
Ability to work on a mobile device, tablet, or in front of a computer screen and/or perform typing for approximately 100% of a typical working day.
Qualifications
Minimum Qualifications
Bachelor’s degree in Management Information Systems, Computer Sciences, or related fields.
5+ years of experience with SQL Server Integration Services (SSIS).
5+ years of experience in T-SQL and writing efficient and highly optimized SQL queries.
4+ years of complete data analysis/mapping and data profiling.
4+ years of experience setting up SQL Server 2012/2016/2017/2019 features for large database environments and geographically distributed production data centers.
2+ years of experience in database modelling and data design of OLTP and OLAP applications.
2+ years of experience with retrieving and loading data from/to Salesforce and NetSuite platforms.
2+ years of experience with Agile methodologies.
Demonstrated ability to perform the Essential Duties of the position with or without accommodation.
Authorization to work in the United States without sponsorship.
Preferred Qualifications
Microsoft SQL Server DBA Certification.
Experience with PostgreSQL.
#LI-AL1
We are an equal employment opportunity employer. All qualified applicants will receive consideration for employment without regard to age, color, creed, disability, gender identity, national origin, protected veteran status, race, religion, sex, sexual orientation, and any other status protected by applicable local, state or federal law. Applicable portions of the Company’s affirmative action program are available to any applicant or employee for inspection upon request.