SQL/ETL Dev
Description:
Senior Programmer Analyst
This position is responsible for writing and maintaining extract/transform/load routines to get data from institutional data sources for use by clinical researchers. Positions roles & interactions: This position will require a significant level of collaboration with other members of the Core for Clinical Research Data Acquisition (CCDA) team and with the Precision Medicine team. It will also require working closely with our Medical Director/Honest Broker on specific projects and techniques. This position will also require working closely with our research customers to discern their needs and to understand and address changes that arise from end user acceptance testing. A weekly scrum is held with the entire team to review all work. The senior programmer analyst will use Jira to document and track assignments. Data must be delivered in a secure manner, following all applicable institutional policies and State and Federal regulations for privacy, security, and the conduct of human subject research.
Needs:
SSIS must be very strong
SQL Must be strong Complex Query Development
DBA-level understanding of SQL Server database and table design and performance, including logs, fillfactor settings, optimization, SQL Server Agent, user permissions and schema, transaction management, iSQL, bcp, batch files.
Skills:
SSIS must be very strong
SQL Must be strong Complex Query Development
DBA-level understanding of SQL Server database and table design and performance, including logs, fillfactor settings, optimization, SQL Server Agent, user permissions and schema, transaction management, iSQL, bcp, batch files.
Job Type: Full-Time, Permanent