Senior Fulfillment Analyst (Hybrid - Philadelphia) at PCS Retirement, LLC

Philadelphia, Pennsylvania, United States -

Full Time

Start Date

Immediate

Expiry Date

17 Apr, 26

Salary

75000.0

Posted On

17 Jan, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL, Data Analysis, Data Integrity, Documentation, Troubleshooting, Process Improvements, Automation, Microsoft Suite, Excel, Teams, Problem Solving, Communication, Salesforce, Data Retrieval, Query Optimization

Industry

Financial Services

Description

Description Company Overview PCS Retirement, LLC, a subsidiary of FSG Parent L.P., is one of the nation's largest independent and conflict-free retirement solution providers in the industry. PCS provides recordkeeping services to 19,000 plans and 850,000 eligible participants representing more than $26 billion in assets under administration. PCS' comprehensive retirement solutions platform includes business development tools for financial advisors, a data-driven recordkeeping technology that supports all types of retirement plans [401(k), 403(b), 457, Cash Balance, Defined Benefit, Non-Qualified], individual retirement accounts (including payroll deduction IRAs), and health savings accounts. At PCS Retirement, we cultivate an environment built on trust, where every team member is empowered to take ownership and contribute to our shared vision. Through collaborative teamwork we foster growth, both personally and professionally, ensuring that together we exceed expectations and achieve remarkable success. To learn more, visit https://www.pcsretirement.com/ Job Summary The Senior Analyst will play a critical role in leveraging Microsoft SQL expertise to extract, analyze, and interpret complex data sets, supporting strategic business decisions. This position requires extensive functional experience with SQL, strong analytical skills, and a deep understanding of syntax commands for query optimization and troubleshooting. Job Responsibilities • Develop, maintain, and optimize advanced SQL queries, stored procedures, and scripts. • Perform in-depth data analysis to identify trends, anomalies, and actionable insights. • Ensure data integrity and accuracy across multiple systems and reporting platforms. • Create and maintain documentation for SQL processes and data models. • Support ad-hoc reporting and provide timely, accurate analysis to internal teams. • Troubleshoot and resolve complex SQL-related issues, including performance tuning. • Contribute to process improvements and automation initiatives. • Perform other duties and special projects as assigned. Requirements • Bachelor's degree or equivalent work experience • Proficiency in SQL required • Demonstrated strong PC skills including Microsoft Suite, especially Excel and Teams • Retirement plan experience is a plus • Strong attention to detail • Ability to meet deadlines in a fast-paced environment • Self-motivated, takes initiative and ownership, and develops meaningful and effective working relationships • Ability to work independently with minimal supervision and build relationships across the organization • Strong problem solving and decision-making skills • Excellent written and verbal communication skills • Proven ability to comprehend technical systems and processes • Salesforce experience highly recommended • Knowledge and experience with data retrieval and manipulation with SQL queries Remote Work Information For all virtual remote positions, in order to ensure employees can effectively perform their job duties with no distractions, we require an uninterrupted virtual work space and there is also an expectation of family care being in place during business hours. Additionally, there is an internet work speed requirement of 50 MBps or better for individual use. If more than one person is utilizing the same internet connection in the same household or building, then a stronger connection is required. If you are unsure of your internet speed, please check with your service provider. Please ensure that you are able to meet these expectations before applying. Compensation Information The average salary for this position is expected to be between $65,000 and $75,000/year however, base pay offered may vary depending on multiple individualized factors, including market location, job-related knowledge, skills, and experience. We do not anticipate candidates to be paid at the top of the range however, from time to time, it may occur on a case-by-case basis. Other rewards and benefits may include: 401(k) match, medical, dental, vision, life insurance, short and long term disability, paid-time off, etc. For more information, please visit pcsretirement.com/careers Additional Information As an employer, PCS believes our success depends on diversity, inclusion, and mutual respect among our team members. We want to look like our customers, and we recruit, develop, and retain the most hardworking people from a diverse candidate pool. We are committed to making all employment decisions based on business need, merit, capability, and equality of opportunity. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, or national origin. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state, or local protected class.

Responsibilities

The Senior Analyst will leverage Microsoft SQL expertise to extract, analyze, and interpret complex data sets to support strategic business decisions. Responsibilities include developing SQL queries, ensuring data integrity, and troubleshooting SQL-related issues.