Job Description :

Position Overview:
This position is responsible for writing and maintaining extract/transform/load routines to get data from institutional data sources for use by clinical researchers.
Position's 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.


Advanced DDL statements, including:
CREATE/ALTER/DROP tables, constraints, indexes, referential integrity, primary and foreign keys, data typing, defaults, defaults, check constraints, rules, triggers, logging, sort orders and character sets, transaction logs, global and local temporary objects, locking and lock contention/escalation, killing spids.
Advanced DML statements, including:

  • CASE statements, PATINDEX/CHARINDEX parsing, regular expressions, aggregate queries/scalar and vector aggregates, stored procedures, parameters, local and global variables, delimiters, CAST and CONVERT, datetime arithmetic, Boolean comparisons, while loops, cursors, RAISERROR, query optimization, SQL functions, system functions, querying system tables, query optimization.
  • SQL Server Management Studio experience, including compiling and scripting stored procedures, database mail, log analysis, optimizing/analyzing indexes.
  • SQL Server Integration Services experience include project and package creation/design; data flow tasks and data conversion; OLE, flat file and Excel data sources/destinations and connection managers; scheduled jobs; monitoring; data transformation; email notification.
  • Basic command of clinical research methods and epidemiologic principles, including missing-data handling, imputation (and its perils), parametric vs. non-parametric analysis, skewed distributions, implications of continuous vs. categorical data, assessing measurement error, form design, PID validation, CPT data

Required 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.
Basic Qualification : Position Overview: This position is responsible for writing and maintaining extract/transform/load routines to get data from institutional data sources for use by clinical researchers. Position s 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.
Additional Skills : Position Overview: This position is responsible for writing and maintaining extract/transform/load routines to get data from institutional data sources for use by clinical researchers. Position s 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. 100% REMOTE
Background Check :Yes
Drug Screen :Yes
Notes :
Selling points for candidate :100% REMOTE
Project Verification Info :
Candidate must be your W2 Employee :Yes
Exclusive to Apex :Yes
Face to face interview required :No
Candidate must be local :No
Candidate must be authorized to work without sponsorship :Yes
Interview times set :Yes
Type of project :Administration/Support
Master Job Title :Dev: SQL Server Database
Branch Code :Baltimore
             

Similar Jobs you may be interested in ..