Jr-Mid SQL Developer in Cincinnati, OH at Vaco

Date Posted: 4/8/2021

Job Snapshot

Job Description

Job Specifics:
* Interpret business requirements and stay informed on methods of organizational data use
* Work with analysts, data architect, etc. in development of reports, visualizations, applications that use databases
* Develop, maintain, and troubleshoot custom solutions for integrating data from source systems into OLTP or data warehouse databases
* Develop and maintain data quality strategies
* Monitor SQL server databases to ensure optimum performance, analyzing and resolving performance issues ensuring maximum uptime.
* Perform problem assessment, resolution and documentation in existing ETL packages, mapping and workflows in production
* Demonstrate self-reliance in researching technical solutions and product functionality

Requirements:
* Basic understanding of Microsoft SQL Server platform preferred; 2012 or 2008R2
* 2+ years of SQL development experience - SSIS, SSRS, Power BI preferred
* Knowledge to read/write basic T-SQL commands; create objects (users, databases, tables, stored procedures, etc.)

* Experience using ETL software (SSIS preferred) and creating multifaceted workflows originating from diverse source systems
* Conceptual understanding of OLTP and data warehouse architecture