Data Warehouse Operations Senior Engineer

Motorola Solutions Systems Polska is seeking an experienced Data Warehouse Operations Support Senior Engineer to lead the monitoring, maintenance, and optimization of their enterprise data warehouse. The role supports and grows the Enterprise Data Hub and Reporting platform across all business functions.

• Bachelor's degree in Computer Science plus 3+ years of experience, or Master's degree.
• Excellent SQL skills.
• Strong hands-on scripting ability in Shell Script and Python.
• Experience working with AWS RedShift.
• Experience supporting ETL and reporting tools like Informatica and BRIO.
• Understanding of data modelling, databases, and data warehouses.
• Familiarity with CI/CD and related tools such as Jenkins.
• Understanding of SCRUM/Agile methodology.
• Understanding of REST API concepts.
• Familiarity with BI reporting tools such as Tableau.
• Strong communication skills.
• Hands-on experience in data warehousing design, tuning, and ETL/ELT process development.
• Database support experience and strong understanding of columnar database capabilities.

• Proactively monitor ETL for successful data loads and oversee reporting server performance for timely report delivery.
• Collaborate with stakeholders, Ops, and DBAs to quickly resolve job failures and service interruptions.
• Manage planned and unplanned downtime protocols to minimize business impact.
• Resolve complex data-level issues to ensure warehouse accuracy.
• Communicate data warehouse, job, and report status to stakeholders during month-end.
• Perform deep-dive Root Cause Analysis (RCA) and post-production reviews to prevent defect recurrence.
• Troubleshoot and fix data integrity defects and critical environmental issues in the data warehouse ecosystem based on priority.
• Act as the primary support for SOX Level 1 compliance requests and audits.
• Execute daily PSR data uploads.
• Manage monthly, quarterly, and annual scheduled loads and maintenance.