Job Summary:

PensionPro is seeking an SQL Developer with the drive and potential to grow into a Data Architect/Engineer in the long term. The SQL Developer is responsible for improving and ensuring stability, reliability, and performance to meet the needs of our organization. You will collaborate with a cross functional team, analyze business requirements and design scalable efficient solutions to optimize SQL performance issue and improve overall efficiency.

Location: Candidates MUST be local to Harrisburg, PA area to work in hybrid capacity – 3 days in office per week (Tuesday, Wednesday and Thursday) for in person collaboration with the team.

 

Responsibilities:

  • Develop and optimize T-SQL scripts, collaborate with development teams, troubleshoot database issues and learn advanced database design principles.
  • Work with the Data Engineering Team to design, develop and maintain ETL processes from various sources into data warehouses and other storage solutions.
  • Perform regular testing, debugging and fixing the issue to ensure high-quality, stability and reliability of software delivery.
  • Collaborate with senior developers, requirement analysts, stakeholders and subject matter experts to design software applications.

 

Requirements:

  • A bachelor’s degree in computer science or related technical discipline or 2 years of relevant technical experience required.
  • Experience with MS SQL or any relational database required.
  • Knowledge and demonstrated hands-on experience with creating stored procedures and packages, functions, triggers, DDL (Data Definition Language), DML (Data Manipulation Language), and views.
  • Strong understanding of database design principles, including normalization, relationships, and indexing.
  • Query performance and tuning.
  • Knowledge of SQL Reporting tools like SSRS and Power BI required.
  • Ability to work effectively both independently and as part of an integrated team.
  • Ability to communicate clearly and efficiently with technical peers and management.
  • Must be quick learner to embrace new technologies in Big Data (Data Warehouse, Data Lake, OLAP, NoSQL)
  • Knowledge of Coding Fundamentals including Python, C# or Java required
  • Knowledge of ETL Development is a plus.