HR Data Integration Consultant Job San Antonio area,Texas USA,IT/Tech

HR Data Integration Consultant

BRMi is seeking a HR Data Integration Consultant to support advanced data development and modernization efforts within our HR analytics environment. This role will focus on developing complex queries and database objects across SQL Server and Oracle platforms, with a strong emphasis on sourcing, transforming, and validating Oracle HCM data to support enterprise reporting, analytics, and historical data needs.

Benefits:

Comprehensive Medical, Dental, and Vision Insurance
Employer-Paid Life Insurance
Employer-Paid Short-Term and Long-Term Disability Insurance
401(k)
Paid Time Off (PTO) that includes Vacation Leave, Sick Leave, and 11 Paid Holidays
Educational Assistance

Salary: 100k-117k

Can be 100% remote in TX, VA, MD, DC, or FL

Responsibilities:

Develop and maintain complex SQL queries, stored procedures, views, and other database objects across SQL Server and Oracle environments.
Support HR data modernization initiatives by translating legacy SQL Server-based logic and reporting to Oracle HCM-sourced data.
Design, develop, and optimize data structures, transformations, and integration processes to support reporting, analytics, and downstream systems.
Utilize Oracle Analytics tools (BI Publisher, BICC) to extract, validate, and analyze Oracle HCM data.
Analyze Oracle HCM frontend functionality and backend data models to ensure accurate reporting and data usage.
Collaborate with business stakeholders, technical teams, and analytics partners to gather requirements and define data solutions.
Create and maintain technical documentation, including:

Data definitions
Business rules
Source-to-target mappings
Data lineage documentation
Governance artifacts

Perform data quality analysis, validation, reconciliation, and troubleshooting across multiple HR systems.
Investigate and resolve cross-system data issues and reporting discrepancies.
Support enterprise HR analytics, reporting, and historical data management initiatives.
Perform other duties as assigned

Qualifications:

Advanced SQL development experience, including:

Complex joins
Analytical/window functions
Query tuning and performance optimization

Hands-on experience with:

SQL Server
Oracle SQL

Strong experience working with Oracle HCM Cloud, including:

Core data structures
Functional configuration concepts
Reporting architecture

Experience with Oracle Analytics tools, including:

BI Publisher (BIP)
BICC

Experience supporting or modernizing data from legacy HR systems such as People Soft.
Understanding of enterprise data warehousing concepts, including:

Fact tables
Historical data management
Dimensional modeling concepts

Experience producing technical documentation supporting data governance and data management initiatives.
Ability to work independently in a contractor environment and manage deliverables with minimal oversight.

Desired:

Experience integrating Oracle HCM data into Azure-based data platforms.
Experience with Azure Data Factory, Synapse Analytics, or related Azure data services.
Familiarity with HR analytics and workforce reporting.
Experience supporting enterprise data governance programs.
Experience working in Agile delivery environments.
Prior experience supporting large-scale ERP or HRIS modernization initiatives.

BRMi will not sponsor applicants for work visas for this position. This is a W2 opportunity only. EOE/Minorities/Females/Vet/Disabled

We are an equal opportunity employer that values diversity and commitment at all levels. All individuals, regardless of personal characteristics, are encouraged to apply. Employment policies and decisions on employment and promotion are based on merit, qualifications, performance, and business needs. The decisions and criteria governing the employment relationship with all employees are made in a nondiscriminatory manner, without regard to race, religion, color, national origin, sex, age, marital status, physical or mental disability, medical condition, veteran status, or any other factor determined to be unlawful by federal, state, or local statutes.