Senior Data Integration Developer

Oxford Global Resources
Rochester, United States of America
4 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 127K

Job location

Rochester, United States of America

Tech stack

Data analysis
Databases
Data Architecture
Data Conversion
Data Integration
ETL
Data Mining
Data Structures
Data Warehousing
Electronic Data Interchange (EDI)
SQL Stored Procedures
Test Execution Engine
Data Objects
Physical Design
Custom Reports

Job description

Supports data warehouse performance by planning and delivering data integrations; mentoring team members.

Project Details:

  • Enhance data integration team accomplishments and competence by planning delivery of solution
  • Answer technical and procedural questions for less experienced team members; teach improved processes; mentoring team members
  • Study data sources by interviewing users; define, analyze, and validate data objects; identify the relationship among data objects
  • Plan data integration process by developing common definitions of sourced data; design common keys in physical data structure; establish data integration specifications; examine data applications; examine data models and data warehouse schema; determine best-fit data interchange methods; assessing middle ware tools for data integration, transformation, and routing; developing project scope and specifications
  • Identify factors that negatively impact integration
  • Forecast resource requirements
  • Establish delivery timetables
  • Deliver data integration by implementing shared databases; integrating data shared across legacy, new development, and purchased package environments
  • Develop system modification specifications
  • Map data
  • Establish interfaces
  • Develop and modify functions, programs, routines, and stored procedures to export, transform, and load data
  • Meet performance parameters; resolve and escalate integration issues; coordinate actions among users, operations staff, and outside vendors
  • Recommend adjustments as objectives change
  • Document operational procedures and data connections
  • Validate data integration by developing and executing test plans and scenarios including data design, tool design, data extract/transform, networks, and hardware
  • Maintain data warehouse performance by identifying and resolving data conflicts; upgrading data definitions
  • Improve data integration by designing and evaluating new data interchange formats; improving physical design; rewriting data policy, standards, and procedures
  • Maintain team accomplishments by communicating essential information; coordinating actions; obtaining expert input; reviewing open issues and action items; contributing information to team meetings and reports
  • Transfer knowledge of data integration process, techniques, and issues to application and support teams
  • Update job knowledge by tracking ETL strategies and technologies; participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations
  • Accomplish organization goals by accepting ownership for accomplishing new and different requests; exploring opportunities to add value to job accomplishments

Requirements

  • Ad Hoc Reporting
  • Requirements Analysis
  • Analyzing Information
  • Database Management
  • Operating Systems
  • Innovation
  • Verbal Communication
  • General Consulting Skills
  • Data Conversion
  • Data Modeling
  • Initiative

Benefits & conditions

Hourly Rate: 46-61

Oxford is an Equal Employment Opportunity Employer. All qualified applications will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Oxford will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. Oxford provides supplemental medical (we do not offer major medical), dental, vision, life, and disability benefit plans along with a 401(k) Retirement Savings Plan. Paid holidays based on eligibility and paid sick leave for applicable jurisdiction, as required. Oxford is committed to working with and providing reasonable accommodation to individuals with physical and mental disabilities. If you need special assistance or an accommodation while seeking employment, please email oxfordbenefitsgroup@oxfordcorp.com. We will make a determination on your request for reasonable accommodation on a case-by-case basis. Health Care about 5 hours ago Oncology Registered Nurse Supplemental Health Care Rochester, New York $2,102.00 - $2,319.00 per year Engineering about 5 hours ago Image Science Engineer American Cybersystems, Inc. Rochester, New York $70.00 - $76.00 per hour

Apply for this position