Apply for this position Please mention DailyRemote when applying
Posted 10 days ago United States Salary undisclosed
Before you apply - make sure the job is legit.

Attempting to apply for jobs might take you off this site to a different website not owned by us. Any consequence as a result for attempting to apply for jobs is strictly at your own risk and we assume no liability.

Job Description

job summary:

One of the nation's leading academic medical centers is looking for a full time SQL Developer in the Rochester NY area to join their team!

Primary responsibilities include development of enterprise data systems(Data Warehouse, Data Marts both physical and virtual) using MS SQL Server, Epic Cogito Applications, SSIS. This is done by working closely BI Developers, Data Scientist, Data Analysts and IT Server Administrators to build a foundation for integrated analytical applications/extracts in Crystal Reports; Virtual and Physical data warehousing, Epic Systems and reporting BI tools.

location: remote, remote

job type: Contract

salary: $44 - 49 per hour

work hours: 9am to 5pm

education: Bachelors


- SQL Server development by understanding the security model and schema objects including tables, indexes and applied constraints, functions, stored procedures, Views and advance T-SQL programming

- Designing ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse

- Perform proper testing and validation techniques to insure accuracy and integrity of reported or extracted data and document the unit test and validation processes used

- Develop new and support maintenance of existing reports and data sets contributing to maintaining the report inventory

- Understand and learn EMR workflows to translate between the transactional systems and the data repository

- Develop standard dimensional data model optimized for performance and ease of reporting

- Develop integrated administration tools for managing and monitoring the Data Warehouse

- Troubleshoot issues within the Warehouse

- Provide on call support as needed for business continuity and operations


  • Experience level: Experienced
  • Minimum 4 years of experience
  • Education: Bachelors

  • SQL Server developer
  • TSQL
  • SSSI Development Skills
  • ETL
  • database modeling concepts
  • Performance Tuning

For certain assignments, Covid-19 vaccination and/or testing may be required by Randstad's client or applicable federal mandate, subject to approved medical or religious accommodations. Carefully review the job posting for details on vaccine/testing requirements or ask your Randstad representative for more information.

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

- provided by Dice