Technical Business Systems Analyst – Data Warehouse (26-01870) -

Job Title: Technical Business Systems Analyst – Data Warehouse

Location

Warren, NJ

Work Arrangement

Hybrid – 3 days onsite

Job Overview

We are seeking a Technical Business Systems Analyst with strong SQL, data warehousing, and business analysis expertise. The ideal candidate will have experience gathering requirements, analyzing complex datasets, and preparing technical documentation for ETL and data warehouse applications. Healthcare and data warehousing experience are essential for success in this role.

Key Responsibilities

• Gather and analyze business and technical requirements and prepare BRDs, FRDs, and data mapping documents.
• Write complex SQL queries across multiple tables to perform data analysis, validation, and profiling.
• Collaborate with data engineers and data modelers to define data mappings, transformation rules, and database structures.
• Support ETL development, data quality validation, system testing, and production releases.
• Document business processes, functional specifications, and data requirements.
• Coordinate with cross-functional teams to resolve data issues and ensure accurate reporting.

Required Skills

• Strong experience as a Technical Business Analyst or Business Systems Analyst.
• Extensive SQL skills, including complex queries, joins, and data profiling.
• Hands-on experience with data warehousing, ETL processes, and data mapping.
• Experience preparing BRDs, FRDs, and functional specifications.
• Strong requirements-gathering, analytical, documentation, and stakeholder-management skills.
• Proficiency in Microsoft Office, Visio, and JIRA.
• Healthcare and data warehousing experience are mandatory.
• Must be local to the Warren, NJ area and available for an onsite interview.

Preferred Skills

SSIS, SSRS, Power BI, Tableau, Python, SharePoint, and experience supporting production releases.