Job Description - Jr Developer - SQL in Rochester
Return to jobs

Jr Developer - SQL

Ref: US_EN_6_916327_1473673

Posted on 15 November 2022

We are recruiting for a Junior SQL Developer.


Under general direction and with considerable latitude for the exercise of independent judgment and initiative, the Jr Developer is responsible for supporting informatics-related infrastructure programs, and contributing to the specification, development, and deployment of tools and projects. This includes support for data warehouses and the Secure Environment for Data & Analytics computing platform. This position works collaboratively with the Informatics team members, senior leadership and other research informaticians.

Works collaboratively with other Informatics staff, including other Informaticians and programmers, and other partners, including the Enterprise Data and Analytics team.  



Evaluate, adopt, and improve open-source packages and tools to analyze and report data quality and completeness in research data warehouses


Develop SQL queries, procedures, and other scripting codes (Python or R) to assist in the maintenance and validation of the research Common Data Models, including i2b2 and OMOP


Support development and operation of the computer programs to facilitate the process of informatics activities and research tools, including data cohort discovery tools, ATLAS and TriNetx


Design, develop, and maintain online dashboards in support of reporting of informatics services, and operation of data warehouses and the SERDA program


Work closely with other informaticians and programmer analysts on process improvement



  • Bachelor’s degree with major course work Computer Science, Computer Engineering, Software Engineering, or equivalent, minimum of 2 years of related work experience, or an equivalent combination of education and experience/training. 
  • A minimum of 2 years of programming experience with SQL in Microsoft SQL Server is required. Experience and knowledge with programming language (Python or R) and BI tools (e.g. Tableau, Microsoft Power BI) are required.
  • Familiarity with common data model such as i2b2 or OMOP and medical vocabularies (ICD, CPT4, SNOMED, etc.) are highly valuable.
  • Must have the ability to juggle several projects at once.
  • Requires excellent communication and organization skills
  • If you are interested in this position, please contact Mike Keegan with Modis at 585-465-1236 and/or send Mike your resume at:


    Equal Opportunity Employer/Veterans/Disabled

    To read our Candidate Privacy Information Statement, which explains how we will use your information, please navigate to

    The Company will consider qualified applicants with arrest and conviction records


    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.