SS&C is a global provider of investment and financial services and software for the financial services and healthcare industries. Named to Fortune 1000 list as top U.S. company based on revenue, SS&C is headquartered in Windsor, Connecticut and has 20,000+ employees in over 90 offices in 35 countries. Some 18,000 financial services and healthcare organizations, from the world's largest institutions to local firms, manage and account for their investments using SS&C's products and services.
Job Description
SQL Server Developer & Report Writer
Locations: Palm Beach, FL - Hybrid 6x a month
Get To Know The Team:
SS&C, through its BPO partnership with Lighthouse, is currently seeking a candidate who will be part of a multi-dimensional middle to back office operations, IT/Risk development and accounting department responsible for all aspects of post trade matching, trade capture, and all aspects of daily operations, treasury services, accounting and tax compliance, planning and reporting. The ideal candidate is one who works or has worked within a multi-strategy hedge fund, financial institution or hedge fund administrator with solid exposure to fund accounting, OMS/PMS integration, middle office post trade reporting and operations.
Why You Will Love It Here!
- Flexibility: Hybrid Work Model & a Business Casual Dress Code, including jeans
- Your Future: 401k Matching Program, Professional Development Reimbursement
- Work/Life Balance: Flexible Personal/Vacation Time Off, Sick Leave, Paid Holidays
- Your Wellbeing: Medical, Dental, Vision, Employee Assistance Program, Parental Leave
- Diversity & Inclusion: Committed to Welcoming, Celebrating and Thriving on Diversity
- Training: Hands-On, Team-Customized, including SS&C University
- Extra Perks: Discounts on fitness clubs, travel and more!
What You Will Get To Do:
The position for SQL Server Developer & Report Writer primary reporting line is to the Director of Software Development and secondary reporting line to the Technology Co-Heads. The ideal candidate is proficient in T-SQL including creating tables, views, stored procedures, functions, CLR etc. that would be used in the reporting process. Competent in other disciplines like RDBMS concepts, query optimization, database normalization concepts, coding and naming standards, scheduling and delivery of reports. Candidate needs to be self-motivated, resourceful, excellent in time management, comfortable working with onshore and offshore resources in cross-functional teams.
- Write stored procedure, functions, views, in SQL Server to facilitate reporting.
- Create professional looking enterprise quality reports using SSRS.
- Schedule data driven subscriptions for delivery of reports via email or to pdf or excel files.
- Use of templates in SSRS for consistent look and feel of production quality reports.
- Conduct ad hoc analyses of operational issues and requirements
What You Will Bring:
- Bachelor's degree in Computer Science, Information Systems, or related discipline
- Strong knowledge of T-SQL including views, tables, stored procedures, triggers, scalar and table values functions.
- Strong knowledge of RDBMS database structures, normalization concepts, indexes and query optimization concepts, ability to work with large amounts of data.
- Strong knowledge of SSRS reporting design and structure
- Experience working with other reporting tools such as Crystal Reports, Power BI and Tableau is a strong plus.
- Knowledge of working with Visual Studio, TFS and GIT environment with multiple team members
- Knowledge of standards in software development and implementation
- Proficient knowledge of Excel and VBA
- Highly motivated self-starter with an appetite for knowledge
- Ability to understand reporting business requirements from business teams.
- Ability to manage multiple reports and tasks at once with attention to detail.
- Strong organizational skills with the ability to set, organize and meet priorities.
- Excellent interpersonal, verbal, and written communication skills
- Keep up to date with the latest development in technique, methodology and software availability.
- Experience in financial services industry is a plus.
- Experience with C# is a plus
- Experience with ETL tools like SSIS is a plus
Thank you for your interest in SS&C! To further explore this opportunity, please apply through our careers page on the corporate website at www.ssctech.com/careers.
#CA-BP
Unless explicitly requested or approached by SS&C Technologies, Inc. or any of its affiliated companies, the company will not accept unsolicited resumes from headhunters, recruitment agencies, or fee-based recruitment services. SS&C offers excellent benefits including health, dental, 401k plan, tuition and professional development reimbursement plan. SS&C Technologies is an Equal Employment Opportunity employer and does not discriminate against any applicant for employment or employee on the basis of race, color, religious creed, gender, age, marital status, sexual orientation, national origin, disability, veteran status or any other classification protected by applicable discrimination laws.
