What You Do:

The Production Support Developer is an integral part of the software engineering team supporting the internal technology stack and direct client initiatives.  This position conducts full SDLC lifecycle activities, which include requirements analysis and design, developing analysis and reporting capabilities, and continuously monitoring systems and processes for performance and quality control to identify improvements.  More importantly, the Production Support Developer will coordinate activities with other members of the development and operations teams with customer support tickets within a production based environment.

How You’ll Do It:

• Handle and prioritize changes, configuration requests and other customer inquiries.
• Analyze and troubleshoot data and validate data flows.
• Design business reports via SSRS and Excel.
• Design and troubleshoot SSIS flows.
• Debugging of application code for observed functionality issues.
• Gathers requirements for software applications as the developer may serve as a subject matter expert on systems and processes.
• Designs, modifies and develops software applications.
• Responsible for maintenance and update of software applications.
• Designs and develops back end system processes.
• Designs and develops back end integration processes.
• Support development with unit testing and documenting test cases.
• Work closely with the broader software engineering team to prioritize business and information needs.
• Work closely with Multi-Channel Sample Management with business data analysis including, but not limited to data integrity testing/validation of inbound client data.
• Generate and QC outbound Client facing reports both scheduled and ad hoc.
• Monitor daily system status reports.  Validate data based on inbound data feeds.
• Assist Multi-Channel Sample Management team and Software Engineering with ad hoc request and support.
• Define, document, and train users on new systems.
• Gather requirements for software applications and review, evaluate and analyze applications.

What You’ll Need: 

1. BA/BS degree (or equivalent) required (Computer Science, Business or related field), or equivalent work experience
2. 3 or more years of .net software development experience
3. 2 or more years of MS BI tool development (SQL Server 2014+, SSRS, SSIS)
4. Knowledge of commonly used business systems concepts, practices and procedures
5. Strong verbal and written communication skills, including grammar, spelling, punctuation, etc.
6. Proven working experience as a data analyst
7. Technical expertise regarding data models, database design development, data mining and segmentation techniques
8. Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
9. Adept at queries, report writing and presenting findings
10. 2+ years experience in a business/office environment, pharmaceutical industry preferred, Sample Management/PDMA a plus
11. Experience with formulating data analyst reports and spreadsheets including pivot tables based on requirements

Knowledge, Skills, and Abilities:

1. Working knowledge of SQL Server 2014+ with ability to write complex T-SQL Queries, Stored Procedures, Functions
2. Working knowledge of Entity Framework, REST API’s
3. Working knowledge of MS BI Tools (SSRS, SSIS)
4. Experience in using the Git version control systems
5. Telerik and KendoUI control a plus
6. Salesforce.com and Pharmaceutical experience a plus
7. Analytical and systematic approach to software testing
8. Strong organization, communication (written and verbal) and team building skills
9. Must have the ability to handle multiple tasks simultaneously
10. Highly organized with strong interpersonal and prioritization skills
11. Ability to work under pressure and within tight deadlines
12. Strong follow-through on projects and duties
13. Ability to deal with frequent change, delays or unexpected events and capability to adapt to changes in the work environment and manage competing demands
14. Aptitude to prioritize and plan work activities and use time efficiently
15. Reliable attendance and punctuality a must
16. Ability to work in a team environment a must