Job Information
Guardian Life Senior .Net, SQL, SSIS Developer - Broker/Dealer in New York, New York
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
$93,080.00 - $152,915.00
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.
Every day, Guardian helps our 29 million customers realize their dreams through a range of insurance and financial products and services. Our Purpose, to inspire well-being, guides our dedication to the colleagues, consumers, and communities we serve. We know that people count, and we go above and beyond to prepare them for the life they want to live, focusing on their overall well-being — mind, body, and wallet. As one of the largest mutual insurance companies, we put our customers first. Behind every bright future is a GuardianTM. Learn more about Guardian at guardianlife.com .
Guardian Life
- Guardian Life Jobs