Data Warehouse Operations Senior Engineer

Company Overview

At Motorola Solutions we believe that everything starts with our people. Were a global close-knit community united by the relentless pursuit to help keep people safer everywhere. Our critical communications video security and command center technologies support public safety agencies and enterprises alike enabling the coordination thats critical for safer communities safer schools safer hospitals and safer businesses. 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 peoples 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. Were 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

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

Basic Requirements

• Bachelors of Computer Science plus 3 years of experience or Masters degree

• Excellent SQL and strong hands-on scripting (Shell Script Python) ability

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 youd like to join our team but feel that you dont quite meet all of the preferred skills wed still love to hear why you think youd be a great addition to our team.