Application Systems Analyst / Programmer

JPS Tech Solutions Pvt Ltd; Boston (MA); Sur place; USD 110 000 - 160 000; Plein temps

Résumé du poste

JPS Tech Solutions Pvt Ltd seeks an experienced Application Systems Analyst / Programmer to support the MDM team for an enterprise Child Welfare Information System. The role focuses on database development, BI reporting, ETL, and data integration using PostgreSQL, MS SQL Server, T-SQL, PL/pgSQL, SSIS, and SSRS, with modernization efforts involving Salesforce and MuleSoft.

You will design and maintain database objects, optimize queries, and contribute to data migration and quality initiatives

Qualifications

• Extensive experience with PostgreSQL and MS SQL Server.
• Proficient in writing complex SQL (T-SQL, PL/pgSQL) and ETL development.
• Experience with SSIS/SSRS and BI reporting.
• Knowledge of data migration, data integration, and MDM.
• Strong problem-solving and database performance tuning skills.
• Familiarity with enterprise data governance and reporting standards.

Responsabilités

• Design, develop, and maintain interactive BI reports for business intelligence and operational needs.
• Integrate data from multiple sources into enterprise data systems.
• Assist in designing and implementing Master Data Management (MDM) solutions.
• Develop and maintain database objects, including tables, schemas, stored procedures, and queries.
• Write and optimize complex SQL queries using T-SQL and PL/pgSQL.
• Design, develop, and maintain SSIS packages.
• Develop and maintain SSRS reports and other reporting tools.
• Support ETL processes, data migration, data transformation, and data integration activities.
• Identify and resolve database performance bottlenecks and data quality issues.
• Work with PostgreSQL and MS SQL Server environments; support modernization with Salesforce and MuleSoft.

Connaissances

PostgreSQL

Microsoft SQL Server

T-SQL

PL/pgSQL

SSIS

SSRS

Data migration

Performance tuning

Formation

Bachelor's degree

Outils

SSIS

SSRS

Tableau

Salesforce data

MuleSoft Platform

Description du poste

Job Summary

We are seeking an experienced Application Systems Analyst / Programmer to support the Master Data Management (MDM) team for an enterprise Child Welfare Information System. The role involves developing and maintaining database solutions, creating business intelligence reports, integrating data from multiple sources, and supporting data management initiatives. The candidate will work with PostgreSQL, Microsoft SQL Server, T-SQL, PL/pgSQL, SSIS, and SSRS while contributing to the modernization of the existing application platform using Salesforce and MuleSoft. The ideal candidate will have strong database development, reporting, ETL, data migration, and performance optimization experience.

Key Responsibilities

• Design, develop, and maintain interactive and dynamic reports for business intelligence and operational reporting.
• Integrate data from multiple sources into unified enterprise data systems.
• Assist in designing and implementing Master Data Management (MDM) solutions.
• Develop and maintain database objects, including tables, schemas, stored procedures, functions, and queries.
• Write and optimize complex SQL queries using T-SQL and PL/pgSQL.
• Design, develop, and maintain SQL Server Integration Services (SSIS) packages.
• Develop and maintain reports using SQL Server Reporting Services (SSRS) and other reporting tools.
• Support ETL processes, data migration, data transformation, and data integration activities.
• Identify and resolve database performance bottlenecks, data quality issues, and connectivity problems.
• Apply SQL development best practices and database performance optimization techniques.
• Work with PostgreSQL and Microsoft SQL Server database environments.
• Support data modernization and migration activities associated with Salesforce and MuleSoft platform initiatives.
• Troubleshoot database-related issues and perform debugging of code and application performance problems.
• Manage multiple assignments, prioritize tasks, and meet project deadlines while working independently in a remote environment.
• Communicate project progress, requirements, challenges, and work plans to supervisors on a weekly basis or as requested.
• Perform other related duties as assigned.

Required Qualifications

• Minimum 6 years of overall Information Technology experience.
• Minimum 5 years of experience with PostgreSQL, Microsoft SQL Server, database reporting, and programming languages such as T-SQL and PL/pgSQL.
• Minimum 4 years of experience with advanced Microsoft SQL Server RDBMS and PostgreSQL database systems.
• Minimum 4 years of experience with ETL tools such as SSIS or equivalent technologies.
• Minimum 4 years of experience with SSRS or other reporting tools.
• Minimum 2 years of experience writing complex SQL queries, stored procedures, and database functions.
• Minimum 2 years of experience with database design, schema creation, maintenance, and SQL programming.
• Minimum 2 years of experience with SQL Server features, including indexing, partitioning, and security.
• Minimum 2 years of experience in database query performance tuning and optimization.
• Minimum 2 years of experience designing, developing, and maintaining SSIS packages.
• Minimum 2 years of experience with data migration, ETL processes, and data transformation using SSIS.
• Minimum 2 years of experience designing and developing reports using SSRS.
• Minimum 2 years of experience identifying and resolving database issues, debugging code, and troubleshooting performance problems.
• Minimum 2 years of experience managing multiple projects, prioritizing assignments, and meeting deadlines.
• Strong analytical, problem-solving, and database troubleshooting skills.

Preferred Qualifications

• Bachelor's degree in a relevant field.
• Knowledge of Tableau and business intelligence reporting.
• Experience working with Salesforce data and data management processes.
• Knowledge of Child Welfare Information Systems (CWIS).
• Experience supporting enterprise Master Data Management initiatives.
• Ability to work effectively within a collaborative team environment.
• Strong written and verbal communication skills.

Core Technical Skills

• PostgreSQL and Advanced PostgreSQL Database Management
• Microsoft SQL Server and RDBMS
• T-SQL and PL/pgSQL
• SQL Queries, Stored Procedures, and Functions
• Database Design, Schema Creation, and Maintenance
• SQL Server Indexing, Partitioning, and Security
• SQL Server Integration Services (SSIS)
• SQL Server Reporting Services (SSRS)ETL Development and Data Transformation
• Data Migration and Data Integration
• Master Data Management (MDM)
• Database Performance Tuning and Optimization
• Tableau and Business Intelligence Reporting
• Salesforce Data and MuleSoft Platform
• Child Welfare Information Systems
• Database Troubleshooting and Debugging