SQL Engineer II: Data Pipelines & Analytics

Precision AQ; Philadelphia (Philadelphia County); On-site; USD 75,000 - 95,000; Full time

Benefits offered by this job

Discretionary annual bonus

Health insurance

Retirement savings plan

Life insurance and disability benefits

Parental leave

Paid time off

Job summary

Precision AQ's Access Genius Team seeks a SQL Engineer II to design, develop, and optimize data solutions powering client deliverables and internal products. This role operates with minimal oversight, owning complex data pipelines and SQL development while maintaining high standards for quality, accuracy, and timeliness.

The SE II will work primarily with Microsoft SQL Server, building scalable datasets and processes that support analytics, applications, and client-facing solutions.

Qualifications

• Bachelor degree or equivalent experience in CS/IS/Math or related field.
• 3–5 years of experience with Microsoft SQL Server in a production environment.
• Hands-on experience writing complex T-SQL queries, stored procedures, functions, views, and data transformations.
• Experience building and maintaining ETL processes and working with large data sets.
• Strong proficiency in query optimization, indexing, execution plan analysis, and performance troubleshooting.
• Experience with data modeling, data validation, data quality checks, and root cause analysis of data defects.
• Experience with Azure DevOps, Git, CI/CD concepts, or similar delivery management and source control tools.
• Strong accountability for delivering high-quality, accurate work on time.
• Excellent communication skills with both technical and non-technical stakeholders.
• Ability to independently manage multiple priorities and deadlines in a fast-paced delivery environment.
• Detail-oriented with a structured approach to problem-solving, documentation, and issue resolution.

Responsibilities

• Design, develop, and maintain SQL-based data solutions for client and product needs.
• Build and optimize complex queries, stored procedures, functions, views, and database objects for performance and scalability.
• Develop and maintain ETL pipelines to integrate, transform, and validate large data sets.
• Ensure data accuracy and integrity through rigorous validation, reconciliation, and quality checks.
• Translate business, delivery, and client requirements into technical SQL solutions.
• Partner with Product Delivery, Client Services, Engineering, and Product teams to deliver client value.
• Own assigned workstreams, meet deadlines, communicate risks early, and deliver high-quality work with minimal oversight.
• Create and maintain clear documentation for data processes, SQL logic, assumptions, and support procedures.
• Support production systems and resolve data-related issues in a timely, disciplined manner.
• Identify and implement process improvements to increase reliability, repeatability, scalability, and efficiency.
• Participate in code reviews, technical discussions, and delivery planning to improve quality and shared understanding.
• Apply established standards for change management, data handling, security, documentation, and production readiness.

Skills

SQL engineering

T-SQL

Data quality checks

Data modeling

Communication

Problem solving

Documentation

Change management

Education

Bachelor degree in Computer Science, Information Systems, Mathematics, or related field

Tools

Azure DevOps

Git

CI/CD concepts

SQL Server

Job description

Precision AQ's Access Genius Team seeks a SQL Engineer II to design, develop, and optimize data solutions powering client deliverables and internal products. This role operates with minimal oversight, owning complex data pipelines and SQL development while maintaining high standards for quality, accuracy, and timeliness.

The SE II will work primarily with Microsoft SQL Server, building scalable datasets and processes that support analytics, applications, and client-facing solutions.