Return to jobs

SQL Developer Job in Rochester, NY:

Ref: US_EN_6_916327_1415686

Posted today
Job Location
Rochester
Contract Type
Contract/Temp to Hire

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

If you’d like to have a talk about this role or other similar positions, then get in touch!

Cecile
Contact NameJob TitleSend message
Apply

Modis across the world

We’ve got more than 20 years’ experience as a leading expert in IT Engineering and Life Sciences solutions. Over that period, we’ve extended our presence across Europe, North America, Asia and Australia, creating local impact at a global scale. Find your local Modis to discover how we can partner with you or help you discover the next step in your career.

Find your local Modis