Sql data analyst Jobs in Aurora, CO

N-PORT Data Analyst

As a leading financial services and healthcare technology company based on revenue, SS&C is headquartered in Windsor, Connecticut, and has 27,000+ employees in 35 countries. Some 20,000 financial services and healthcare organizations, from the world's largest companies to small and mid-market firms, rely on SS&C for expertise, scale, and technology.

Location: Denver, CO - Hybrid

About the Role

We are seeking a detail-oriented and analytical N-PORT Data Analyst to support regulatory reporting and data validation activities for registered mutual funds and investment companies. This role is responsible for the preparation, analysis, reconciliation, and quality review of SEC Form N-PORT filings while partnering with internal operations, compliance, fund accounting, and technology teams to ensure accurate and timely reporting.

The ideal candidate will possess strong knowledge of mutual fund operations, portfolio data, and regulatory reporting requirements within a fund administration environment.

Why Join SS&C

SS&C combines proprietary technology with deep industry expertise to support complex financial and health care operations. Our teams design, implement, and operate solutions that help clients manage data, automate processes, and scale their businesses with confidence.

You will work with industry experts, modern platforms, and evolving technologies, gaining exposure to real-world operational challenges and large-scale enterprise environments.

How You Will Make an Impact

• Prepare and review SEC Form N-PORT filings for registered investment companies, including monthly and quarterly reporting requirements.
• Analyze portfolio holdings, security classifications, derivatives, liquidity, and risk metrics to ensure regulatory accuracy and completeness.
• Perform data validation, reconciliation, and exception analysis across accounting, custody, pricing, and portfolio management systems.
• Research and resolve data discrepancies related to security master data, asset classifications, market values, and investment attributes.
• Coordinate with fund accounting, compliance, legal, and external clients to resolve reporting issues and meet filing deadlines.
• Monitor changes to SEC regulations and reporting requirements impacting N-PORT reporting obligations.
• Assist with testing, implementation, and enhancement of reporting systems, automation initiatives, and operational controls.
• Maintain detailed documentation of procedures, controls, and validation processes.
• Support internal and external audits, compliance reviews, and client inquiries related to regulatory filings.
• Participate in process improvement initiatives focused on operational efficiency, data governance, and reporting accuracy.

Required Experience

• Bachelor's degree in Accounting, Finance, Economics, Business, or related field.
• 25+ years of experience in mutual fund operations, fund accounting, regulatory reporting, or fund administration.
• Working knowledge of SEC Form N-PORT requirements and Investment Company Act reporting regulations preferred.
• Understanding of mutual fund securities, derivatives, liquidity classifications, and portfolio reporting concepts.
• Strong analytical, reconciliation, and problem-solving skills.
• Advanced proficiency in Microsoft Excel, including pivot tables, lookups, and data analysis functions.
• Experience with fund accounting platforms, data warehouses, or regulatory reporting tools preferred.
• Ability to manage multiple deadlines in a fast-paced environment with strong attention to detail.
• Excellent written and verbal communication skills.

What Sets You Apart (preferred qualifications)

• Experience within a fund administrator, asset management firm, or financial services organization.
• Knowledge of additional regulatory filings such as N-CEN, N-CSR, or Form PF is a plus.
• Familiarity with SQL, data visualization tools, or automation/reporting technologies preferred.

Skills & Competencies

• Regulatory Reporting
• Data Analysis & Reconciliation
• Mutual Fund Operations
• Attention to Detail
• Risk & Compliance Awareness
• Process Improvement
• Time Management
• Cross-Functional Collaboration

SS&C Technologies offers a comprehensive total rewards package designed to support your wellbeing, growth, and future. Our benefits include medical, dental, and vision coverage; a 401(k) plan with company match; paid time off, holidays, and parental leave; and professional development reimbursement opportunity. Actual base salary will vary based on several factors, including but not limited to relevant skills, prior experience, education, demonstrated performance, and geographic location. Colorado: The expected base salary for the position is between $55,000 USD to $120,000 USD. In addition, employees in this role may be eligible for consideration on an annual basis for a discretionary bonus and/or equity awards, such as restricted stock units or stock options, based upon individual and business performance at the company's discretion.

Applications will be accepted on an ongoing basis until the position is filled.

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.