Data Operations & ETL Specialist — BI Insights

Trusaic; California; On-site; USD 70,000 - 110,000; Full time

Benefits offered by this job

Equity

Healthcare

401(k)

Paid Time Off

Job summary

Trusaic, a regulatory compliance software company, seeks a Data Operations Coordinator in California to manage, transform, and secure enterprise workforce data across HRMS, Payroll, and Benefits feeds. You will produce BI and KRI insights to guide client decisions.

Ideal candidates will have a mathematically or technically oriented background, strong Excel and SQL skills, and experience with large relational databases and governance across multi-system data pipelines.

Qualifications

• Education: Bachelor's degree in Mathematics, Computer Science, Statistics, Economics, or a related quantitative field.
• Technical Proficiency: Advanced skills in Microsoft Excel and hands-on experience manipulating large-scale relational databases and complex database feeds.
• Analytical Mindset: Exceptional problem-solving capabilities with high detail orientation.
• Domain Knowledge: Working familiarity with client HR technology ecosystems (HRMS/HCM, Payroll, Time & Attendance, Benefits, L&D, Leave of Absence).

Responsibilities

• Database Feed Management & Maintenance: Manage client feeds with data integrity.
• Data Extraction & Governance: Secure receipt, extraction, storage, and protection of sensitive workforce data.
• ETL & Data Hygiene: Transform, consolidate, validate, and cleanse data streams.
• Business Intelligence (BI) Reporting: Design BI reports with KPIs and KRIs.
• Quality Assurance: Run QA on analytics outputs and feeds.

Skills

Data governance

ETL concepts

Analytical mindset

Relational databases

Education

Bachelor's degree in Mathematics, Computer Science, Statistics, Economics, or related quantitative field

Tools

SQL

BI tools

Job description

Trusaic, a regulatory compliance software company, seeks a Data Operations Coordinator in California to manage, transform, and secure enterprise workforce data across HRMS, Payroll, and Benefits feeds. You will produce BI and KRI insights to guide client decisions.

Ideal candidates will have a mathematically or technically oriented background, strong Excel and SQL skills, and experience with large relational databases and governance across multi-system data pipelines.