Senior Data Pipeline & Reporting Engineer

Triad Financial Services, Inc.; Jacksonville (FL); Hybrid; USD 85,000 - 110,000; Full time

Job summary

Triad Financial Services, Inc. is seeking a Reporting Analyst to expand and optimize data and reporting pipelines, supporting multiple teams and ensuring scalable reporting delivery architecture.

The role includes mentoring junior analysts, designing data structures, and improving data quality for key metrics. The position emphasizes hands-on SQL, SSRS/SSIS development, and building actionable insights for customer acquisition and operational efficiency.

Qualifications

• 5+ years’ experience with Microsoft SQL Server, T-SQL, SSRS and SSIS.
• Advanced SQL and relational database skills; experience with multiple databases.
• Ability to work independently or in a team.
• Strong mathematical and analytical abilities; attention to detail.
• Excellent verbal and written communication skills.

Responsibilities

• Review business requirements for completeness and accuracy.
• Assemble large, complex data sets meeting business requirements.
• Identify and implement internal process improvements for data delivery and reporting infrastructure.
• Collaborate with data and analytics teams to enhance reporting capabilities.
• Create advanced reports using T-SQL based on business requirements.
• Automate reports by scheduling SSRS deliveries.
• Design dashboards and visualizations in SSRS per business needs.
• Maintain SQL Stored Procedures and Views for consistency.
• Design new database tables to enable new data imports.
• Investigate and fix data issues and coding errors.
• Build analytics tools leveraging data pipelines for actionable insights.
• Develop and maintain databases and reorganize data for readability.
• Prioritize business information needs with management.
• Mentor junior analysts and perform quality control reviews.

Skills

MS SQL Server

T-SQL

SSRS

SSIS

ETL

Analytical skills

Communication skills

Independent work

Education

BS in Mathematics/CS/Information Management/Statistics

Tools

SSRS

SSIS

Job description

Triad Financial Services, Inc. is seeking a Reporting Analyst to expand and optimize data and reporting pipelines, supporting multiple teams and ensuring scalable reporting delivery architecture.

The role includes mentoring junior analysts, designing data structures, and improving data quality for key metrics. The position emphasizes hands-on SQL, SSRS/SSIS development, and building actionable insights for customer acquisition and operational efficiency.