Remote SQL Lead - Data Solutions Architect

Flagshipacc; Chadds Ford Township (PA); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Flagshipacc is seeking an experienced SQL Developer to design, develop, and support enterprise data solutions that drive business performance. You will lead data tool development, collaborate with stakeholders, and mentor junior developers in a fast-paced, tech-forward environment.

The role emphasizes building scalable database solutions, maintaining ETL processes, and delivering secure, reliable data integrations across the organization, with flexibility for remote or hybrid work.

Qualifications

• Minimum of 4–7 years of Microsoft SQL Server development experience
• Advanced understanding of T-SQL programming, SQL Server administration best practices, database design, data modeling, and performance optimization.

Responsibilities

• Lead the development, enhancement, and maintenance of SQL Server databases, stored procedures, functions, SSIS packages, and data integrations.
• Serve as a technical lead on development projects, assisting project teams in defining and refining technical requirements.
• Develop project plans for new and modified database solutions, ensuring milestones are achieved and deliverables are completed on schedule.
• Work collaboratively with Business Systems Analysts, QA teams, application developers, and business stakeholders to design and implement effective data solutions.
• Support and maintain ETL processes, data integrations, and automated workflows to ensure data accuracy and availability.
• Create and maintain APIs and support application integrations with internal and external systems.
• Troubleshoot and resolve complex database and data-related issues while identifying opportunities for optimization and performance improvements.
• Participate in change management activities, production deployments, and after-hours support as needed.
• Train and mentor junior SQL Developers and provide technical guidance on development standards and best practices.
• Document database designs, technical specifications, and development procedures to support ongoing maintenance and knowledge sharing.
• Perform other duties as required or assigned.

Skills

SQL Server

ETL processes

T-SQL

Data modeling

APIs

C# integration

Education

Bachelor's degree in CS/IS/Engineering

Tools

SSIS

ActiveBatch

Power BI

PostgreSQL

Job description

Flagshipacc is seeking an experienced SQL Developer to design, develop, and support enterprise data solutions that drive business performance. You will lead data tool development, collaborate with stakeholders, and mentor junior developers in a fast-paced, tech-forward environment.

The role emphasizes building scalable database solutions, maintaining ETL processes, and delivering secure, reliable data integrations across the organization, with flexibility for remote or hybrid work.