Senior .Net, SQL, SSIS Developer - Broker/Dealer

$93,080 - $152,915/Yr

Guardian Life - New York, NY

Full-time - Mid Level

Remote - New York, NY

Insurance Carriers and Related Activities

About the position

The Senior Software Engineer - Broker/Dealer position involves collaborating with senior technical leads to transform business requirements into well-engineered, tested, and deployed business application code. The role encompasses the analysis, design, development, testing, installation, and maintenance of information systems, focusing on delivering efficient and cost-effective solutions. The incumbent will engage in various projects utilizing diverse hardware and software technologies, including new code construction and modifications to existing modules, while applying principled software development processes to automate solutions to business challenges.

Responsibilities

• Create detailed technical documentation based on formal business and functional requirements
• Develops/modifies programs and/or customizes applications to meet Guardian business needs including unit testing to ensure quality code is delivered to software testers
• Creates ad-hoc queries to support business requests
• Perform analysis of applications, feeds, API's, reports, etc in order to troubleshoot issues or make recommendations for enhancements
• Provides ongoing support and troubleshooting for installed applications

Requirements

• Understanding various project development methodologies including Agile and waterfall and overall SDLC Process
• Knowledge of Microsoft software development framework and related development environments
• Experienced with Microsoft SQL Server 2016 and higher, familiar with CTE and new features available in SQL Server 2016 and above
• Proficient in developing and implementing procedures and functions, with the ability to performance tune queries
• Experience in understanding complex data models and designing quality database solutions
• Experience in data analysis and research
• Experience in reviewing, interpreting, and implementing according to the business requirements
• Experience in Data Extraction, Transformation and Loading (ETL) between systems, file formats, using various SQL tools like SSIS
• Experience in SSIS package Deployment methodology
• Ability to analyze and troubleshoot SSIS packages
• Familiar with Object-Oriented concepts and Design Patterns
• Hands-on experience of OO Development methodology in n-tiered Client/Server and Web based environments
• Programming languages - C# (.net core and Entity Framework)
• Knowledge of XML, XSLT, ADO.NET, Tibco Topic/Queue
• Experience working with Third Party Vendor Systems

Nice-to-haves

• Solid understanding with REST API's
• Knowledge of AWS technologies, CI/CD pipeline, bitbucket, SNS/SQS Queue
• Knowledge of React, redux, other Javascript frameworks like Angular, ASP.NET MVC, JQuery
• Familiar with broker/dealer and securities processing
• Familiar with industry standard feeds such as DTCC/DAZL/DST
• Familiar with clearing firms and data aggregators such as Pershing/Albridge

Benefits

• Choice of medical plans with prescription drugs, including coverage for fertility and transgender inclusive benefits
• Dental plan
• Vision plan
• Health care accounts - flexible spending, health reimbursement, and health savings accounts
• Critical illness insurance
• Company-paid Life and Disability insurance plus voluntary supplemental coverage
• Accident insurance
• 401(k) retirement plan with a company match, plus an annual age/service-based Company contribution and an annual profit-sharing contribution, if applicable
• Complimentary 1:1 financial guidance with a licensed Fidelity representative
• Flexible work arrangements (part in-person/part remote)
• Unlimited paid time off for most roles plus time off for volunteering, jury duty, voting, and bereavement
• Personal holidays for colleagues to use in recognition of religious, cultural, or civic days
• Paid parental leave and paid family and medical leave policies
• Emotional well-being, mental health, and work/life resources powered by Spring Health
• Wellness programs, including fitness program and equipment reimbursement
• Child, adult, and elder back-up care support through Bright Horizons
• Adoption assistance
• College planning
• Tuition reimbursement
• Student loan assistance
• Commuter benefits in select metropolitan areas