US_West | Data Engineer_L2

Role Overview

We are recruiting for a Data Engineer (L2) to maintain, update, and optimize databases while supporting advanced data analysis and reporting. You will improve database performance using AI-driven techniques for error classification, predictive analytics, and intelligent data retrieval.

Key Responsibilities

• Manage data extractions from SAGE Datawarehouse cubes (troubleshooting, maintenance, modifications).
• Maintain server hardware/software (RARS), update drivers/plug-ins, run maintenance services, optimize indexes, and ensure network security.
• Preserve data integrity through organized storage and secure backup strategies.
• Modify server configurations as required for optimal performance.
• Generate comprehensive reports including error summaries and system shots.
• Maintain internal reporting databases and IB systems; update lookup tables for new errors weighted by functional category.
• Update cubes to support complex analytical queries and create custom report queries from existing data structures (internal testing/install base).
• Monitor daily automated jobs, troubleshooting issues with the SAGE DW interface as needed.
• Perform pre-emptive maintenance to identify data clogs and resolve reporting generation issues.
• Update stored procedures for Excel reports by adding new errors, removing obsolete entries, and incorporating system info.

Leverage AI/ML & Advanced Analytics

You will apply cutting-edge tools for:

• Database performance optimization (query tuning, indexing strategies, workload prediction).
• Intelligent anomaly detection in system performance and data flows.
• Predictive maintenance of database infrastructure.

Leverage AI techniques to enable automated error classification, predict recurring issues, generate intelligent reports, build smart dashboards with predictive insights/anomaly alerts, and optimize query efficiency using AI-assisted tools.