Job Description - SQL Developer Job in Rochester, NY: in Rochester
Return to jobs

SQL Developer Job in Rochester, NY:

Ref: US_EN_6_916327_1415686

Posted yesterday
Job Location
Rochester, New York
Contract Type
Contract/Temp to Hire
Category
Information Systems

SQL Developer Job in Rochester, NY:

Hybrid Onsite/ Remote

Please no 3rd parties or c2c Candidates

Primary responsibilities of the SQL Developer include development of enterprise data systems(Data Warehouse, Data Marts, both physical and virtual) using MS SQL Server and 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, ERP systems and reporting BI tools.

Responsibilities of the SQL Developer Job in Rochester, NY:

• Preform 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 ensure 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

Qualification of the SQL Developer Job in Rochester, NY:

SLQ 2008 and higher

TSQL – expert level skills

SSSI development skills

ETL Development Process

Data Modeling Concepts

Performance Tuning (queries etc)

SSRS report development – Nice to have

Crystal Reports –– Nice to have

Tableau Dashboard

For more information or to be considered for the SQL Developer Job in Rochester, NY please contact Thomas McCarthy Thomas.Mccarthy@modis.com

Equal Opportunity Employer/Veterans/Disabled

To read our Candidate Privacy Information Statement, which explains how we will use your information, please navigate to https://www.modis.com/en-us/candidate-privacy

The Company will consider qualified applicants with arrest and conviction records

Apply

Find your local office.

Modis has over 100 offices in the United States, Canada and Europe. With both industry and location-specific expertise, our people know their area and their labor market and can find the right position for you.

Locations