Senior Data & BI Systems Analyst

JPS Tech Solutions Pvt Ltd

Boston (MA)

On-site

USD 110,000 - 160,000

Full time

46 hours ago

Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

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.

Responsibilities

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.