SQL Developer

SUMMARY:We are seeking a full-time SQL Developer to join our dynamic team on-site in Pittsburgh, PA or Harrisburg, PA. Hybrid and remote positions are also available. This role supports the customization of our proprietary software based on customer specifications and provides ongoing support of software functionality. The SQL Developer will design, develop, and maintain databases; perform Extract, Transform, Load (ETL) processes; and create data models that support organizational reporting and decision-making. Additional responsibilities include developing and optimizing database solutions, analyzing datasets, and ensuring data accuracy, integrity, and performance.Key ResponsibilitiesDatabase Design, Development, and OptimizationDesign, develop, and maintain relational databases to support proprietary software applications and customer-specific configurations.Create and optimize SQL queries, stored procedures, views, and functions to ensure efficient system performance.Analyze existing database structures and recommend improvements to enhance scalability, reliability, and maintainability.Implement indexing, performance tuning, and query optimization best practices.ETL and Data IntegrationDesign, develop, and maintain ETL processes to extract data from internal and external sources.Transform and validate data to ensure consistency, quality, and accuracy across systems.Load data into target databases and data stores following established standards and controls.Troubleshoot ETL failures and implement corrective actions to prevent data disruptionData Modeling and AnalysisDevelop logical and physical data models to support application functionality and business intelligence needs.Collaborate with internal stakeholders to understand reporting, analytics, and data requirements.Analyze datasets to identify trends, anomalies, and opportunities to improve decision-making.Ensure data integrity, accuracy, and compliance with internal policies and regulatory requirements.Software Support and CustomizationSupport customization of proprietary software solutions based on customer specifications.Provide ongoing database and data-related support for deployed software applications.Investigate, diagnose, and resolve data and database-related issues reported by users or clients.Collaborate with developers, analysts, and project managers to support solution delivery.MINIMUM REQUIREMENTS:Bachelor’s degree in Computer Science, Information Systems, Data Science, or a related field.Minimum of 3–5 years of experience as an SQL Developer or in a similar database-focused role.Strong proficiency with SQL and relational database management systems (e.g., SQL Server, PostgreSQL, Oracle, or MySQL).Experience designing and maintaining ETL workflows and data integration processes.Strong understanding of data modeling concepts and database normalization principles.Proficiency in Microsoft Office, particularly Excel for data analysis and validation.Ability to analyze complex datasets and ensure data accuracy and integrity.PREFERRED QUALIFICATIONS:Experience supporting proprietary or commercial software applications.Familiarity with reporting and business intelligence tools.Experience working in hybrid or distributed team environments.Knowledge of data governance, security, and compliance best practices.