What are the responsibilities and job description for the SQL Developer position at PensionPro Software?
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.