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

Senior Software Engineer – Broker/Dealer

Overview

This position works closely with our senior technical leads to translate business requirements into well-engineered, tested, and deployed business application code. This includes the analysis, design, development, testing, installation, and maintenance of information systems and to resolve most efficient and cost-effective approach to meet business requirements. Projects utilize a variety of hardware and software technologies and may include new code construction, modifications to existing modules, and/or package implementation. Incumbents apply principled software development processes and apply various technologies to engineer and implement their automated solutions to business problems A few sentences about the position here…

You Will:

• 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

You Have:

• 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. Ability to performance tune the 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).
• Other - Knowledge of XML, XSLT, ADO.NET, Tibco Topic/Queue
• Experience working with Third Party Vendor Systems!

Nice to have Technical Expertise

• 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

Domain Knowledge (Preferred, a big plus.)

• 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.

Location & Travel:

• Two days a week at a Guardian Location in Holmdel, NJ OR New York, NY

Salary Range

The salary range reflected above is a good faith estimate of base pay for the primary location of the position. The salary for this position ultimately will be determined based on the education, experience, knowledge, and abilities of the successful candidate. In addition to salary, this role may also be eligible for annual, sales, or other incentive compensation.

Our Promise

At Guardian, you’ll have the support and flexibility to achieve your professional and personal goals.  Through skill-building, leadership development and philanthropic opportunities, we provide opportunities to build communities and grow your career, surrounded by diverse colleagues with high ethical standards.

Inspire Well-Being

As part of Guardian’s Purpose – to inspire well-being – we are committed to offering contemporary, supportive, flexible, and inclusive benefits and resources to our colleagues.

Health Care

• Choice of [high deductible/copay] 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

Life and Disability Insurance

• Company-paid Life and Disability insurance plus voluntary supplemental coverage

• Accident insurance

Retirement and Financial

• 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

Time Off and Remote Work

• 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 and Work-Life

• 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

Equity & Inclusion

Opportunities to build inclusive and meaningful connections through involvement in colleague-led affinity groups:

• Employee Resource Groups:

• Colleague Connection Committees

• Community Involvement Committees

A culture that encourages colleagues to bring their authentic selves to work

• Voluntary self-ID

• Pronunciation and phonetic spelling of names

Benefits apply to full-time eligible employees. Interns are not eligible for most Company benefits.

Equal Employment Opportunity

Guardian is an equal opportunity employer. All qualified applicants will be considered for employment without regard to age, race, color, creed, religion, sex, affectional or sexual orientation, national origin, ancestry, marital status, disability, military or veteran status, or any other classification protected by applicable law.

Accommodations

Guardian is committed to providing access, equal opportunity and reasonable accommodation for individuals with disabilities in employment, its services, programs, and activities. Guardian also provides reasonable accommodations to qualified job applicants (and employees) to accommodate the individual's known limitations related to pregnancy, childbirth, or related medical conditions, unless doing so would create an undue hardship. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact applicant_accommodation@glic.com.

Current Guardian Colleagues: Please apply through the internal Jobs Hub in Workday.