Data Warehouse Operations Engineer

Company Overview

At Motorola Solutions, we believe that everything starts with our people. We’re a global close-knit community, united by the relentless pursuit to help keep people safer everywhere. We build and connect technologies to help protect people, property and places. Our solutions foster the collaboration that’s critical for safer communities, safer schools, safer hospitals, safer businesses, and ultimately, safer nations. Connect with a career that matters, and help us build a safer future.

Department Overview

Company Overview
On any given day, every moment matters to someone, somewhere. And every moment, Motorola Solutions innovations, products, and services play essential roles in people’s lives. We help firefighters see around buildings and police officers see around street corners. We keep utility workers connected and visible to each other with real-time voice and data communication across the smart grid. And we provide the situational awareness first responders need when a moment brings catastrophe. We help people be their best in the moments that matter.

Department Description
Our IT organization has a critical role in driving extraordinary business results. Through a strong partnership with other areas of our business, we bring innovative thinking to every conversation and deliver with integrity. We’re looking for people who bring great ideas and who make our partners’ ideas better. Intellectually curious advisors (not order takers) who focus on outcomes to creatively solve business problems. People who not only embrace change, but who accelerate it.
We are seeking an experienced Data Warehouse Operations Support Senior Engineer to lead the monitoring, maintenance, and optimization of our enterprise data warehouse. This role involves ensuring the stability and performance of ETL, reporting, and cloud (AWS) infrastructure. You will be a key point of contact for month-end close support, crucial for SOX compliance and data integrity. You will join a fast-paced Data and Analytics team, supporting and growing our Enterprise Data Hub and Reporting platform by providing platform-level solutions for growing data and reporting needs across all business functions. We value creativity, enthusiasm, persistence, and a willingness to experiment.

Job Description

Designs, maintains, and optimizes databases. Ensures data integrity and accessibility by optimizing database architecture and design.

Basic Requirements

Scope of Responsibilities / Expectations

• For Application Monitoring, 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.

• For Application Maintenance, manage planned and unplanned downtime protocols to minimize business impact. Resolve complex data-level issues to ensure warehouse accuracy. Communicate DWH, Job, and report status to stakeholders during month-end.

• Break/Fix & Incident Management - Perform deep-dive Root Cause Analysis (RCA) and post-production reviews to prevent defect recurrence. 

• Promptly troubleshoot and fix data integrity defects and critical environmental issues in the DWH ecosystem based on priority.

• As part of Operational & Compliance Activities, 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/maintenance.

Desired Background/Knowledge/Skills

• Experience working with AWS RedShift

• Experience supporting ETL and reporting tools like Informatica, BRIO etc 

• Understanding of data modelling, database, data warehouse

• 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

Travel Requirements

None

Relocation Provided

None

Position Type

Experienced

Referral Payment Plan

Yes

EEO Statement

Motorola Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion or belief, sex, sexual orientation, gender identity, national origin, disability, veteran status or any other legally-protected characteristic. 

We are proud of our people-first and community-focused culture, empowering every Motorolan to be their most authentic self and to do their best work to deliver on the promise of a safer world. If you’d like to join our team but feel that you don’t quite meet all of the preferred skills, we’d still love to hear why you think you’d be a great addition to our team.