Synergy Staffing Inc logo

Senior SQL Developer

Synergy Staffing Inc
  • Pittsburgh, PA
  • Instant Apply
2 days ago

Job Description

Position Summary: The Sr SQL Developer is responsible for designing, developing, administering, and optimizing SQL Server databases, ETL processes, and reporting solutions that support organizational operations and strategic decision making. This role requires strong analytical thinking, technical expertise, and the ability to work both independently and collaboratively with cross functional teams.

Essential Functions & Responsibilities:
Database Development & Administration

  • Develop complex SQL queries, stored procedures, functions, triggers, and views to support applications and reporting needs.
  • Administer SQL Server databases, including performance tuning, backup/recovery, security configuration, and troubleshooting.
  • Monitor database performance, identify bottlenecks, and implement optimization strategies.
  • Ensure data integrity, security, and compliance with organizational and regulatory standards.
  • Develop and maintain database schemas, tables, indexes, and data dictionaries.

ETL, Data Integration & Analytics

  • Design and maintain ETL processes for data integration, transformation, and automation using SSIS or related tools.
  • Assist in writing applications and interfaces that interact with SQL databases.
  • Utilize Microsoft Fabric for data management, analytics, and integration tasks as appropriate.
  • Develop and maintain Power BI reports and dashboards, ensuring accuracy, usability, and visualization best practices.

Reporting, Analysis & Collaboration

  • Conduct data analysis and develop standardized management reporting tools.
  • Produce reports and analyze large datasets for management and special projects.
  • Collaborate with business users, analysts, and departmental teams to understand data requirements and deliver effective solutions.
  • Resolve data or reporting issues in partnership with functional teams.
  • Develop and implement technical standards and best practices for database design, development, and reporting.

Documentation & Continuous Improvement

  • Document database structures, ETL processes, reporting logic, and operational procedures.
  • Stay current with emerging technologies and best practices in SQL development, Power BI, and Microsoft Fabric.
  • Develop and deploy process improvements that enhance data quality, reporting accuracy, and operational efficiency.
  • Perform all other duties assigned by the Supervisor.

Education & Experience Requirements:

  • Bachelor's degree in Computer Science, Management Information Science, or related field
  • 3–5 years of experience with SQL Server
  • 1–2 years working with SSRS and SSIS
  • Familiarity with Power BI technologies is strongly preferred

Skills & Competencies

  • Strong analytical skills and a business mindset
  • Excellent organizational skills with the ability to prioritize and multi task
  • Strong written and verbal communication skills
  • Self motivated with the ability to work quickly and independently with minimal supervision

Numbers & Facts

LocationPittsburgh, PA
IndustryFinancial Services
Company Size1 to 9 employees
Websitehttp://www.synergystaffing.net

About Company

We are a staffing company dedicated in placing quality candidates within our network of companies. We are unique and far different from most staffing companies. All Jobs posted on our sites are for immediate direct hire and we also hire on behalf of our clients. This eliminates steps in the hiring process and gets you to work faster!

Skills

  • Analysis Skillsunmatched
  • Automationunmatched
  • Best Practicesunmatched
  • Business Intelligence Softwareunmatched
  • Business Skillsunmatched
  • Business Strategyunmatched
  • Communication Skillsunmatched
  • Computer Scienceunmatched
  • Cross-Functionalunmatched
  • Data Analysisunmatched
  • Data Managementunmatched
  • Data Processingunmatched
  • Data Qualityunmatched
  • Data Recoveryunmatched
  • Data Setsunmatched
  • Database Administrationunmatched
  • Database Designunmatched
  • Database Extract Transform and Load (ETL)unmatched
  • Database Optimizationunmatched
  • Database Programmingunmatched
  • Database Technologyunmatched
  • Database Triggersunmatched
  • Emerging Technologyunmatched
  • Establish Prioritiesunmatched
  • Fabric Managementunmatched
  • Information Scienceunmatched
  • Information/Data Security (InfoSec)unmatched
  • Management Reportingunmatched
  • Microsoft Product Familyunmatched
  • Microsoft SQL Serverunmatched
  • Microsoft SQL Server DBA (Database Administration)unmatched
  • Multitaskingunmatched
  • Operational Strategyunmatched
  • Operational Supportunmatched
  • Organizational Skillsunmatched
  • Performance Analysisunmatched
  • Performance Tuning/Optimizationunmatched
  • Power BIunmatched
  • Presentation/Verbal Skillsunmatched
  • Process Improvementunmatched
  • Regulatory Complianceunmatched
  • Reporting Dashboardsunmatched
  • Reporting Skillsunmatched
  • SQL (Structured Query Language)unmatched
  • SQL Databasesunmatched
  • SQL Server Integration Services (SSIS)unmatched
  • SQL Server Reporting Services (SSRS)unmatched
  • Software Administrationunmatched
  • Software Developmentunmatched
  • Standards Developmentunmatched
  • Stored Proceduresunmatched
  • Testingunmatched
  • Usability Engineeringunmatched
  • Writing Skillsunmatched

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Resume Builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Resume Builder