Sr. Analyst, Marketing Business Intelligence - Centennial, CO

Job Description

Summary
Responsible for transforming large, complex data into consumable business databases and applications for self-service analytics and reporting. Create system architecture, design, and specification using in-depth engineering skills and knowledge to solve difficult development problems and achieve engineering goals. Determine and source appropriate data for a given analysis. Work with data modelers/analysts to understand the business problems they are trying to solve then create or augment data assets to feed their analysis. Has in-depth experience, knowledge and skills in own discipline. Usually determines own work priorities. Acts as resource for colleagues with less experience.

Employees at all levels are expected to
- Understand our Operating Principles; make them the guidelines for how you do your job
- Own the customer experience - think and act in ways that put our customers first, give them seamless digital options at every touchpoint, and make them promoters of our products and services
- Know your stuff - be enthusiastic learners, users and advocates of our game-changing technology, products and services, especially our digital tools and experiences
- Win as a team - make big things happen by working together and being open to new ideas
- Be an active part of the Net Promoter System - a way of working that brings more employee and customer feedback into the company - by joining huddles, making call backs and helping us elevate opportunities to do better for our customers
- Drive results and growth
- Respect and promote inclusion and diversity
- Do what's right for each other, our customers, investors and our communities

Primary Responsibilities
- Supports the data sourcing, design, staging and ETL processing that supports all Sales & Marketing Reporting and Analysis in the West Division
- Provides daily support across the Sales & Marketing organization providing technical expertise on databases and platforms, creating solutions to optimize and streamline processes and support ad-hoc reporting needs.
- Partners with Sales & Marketing Analytics team (Division and Regions) on data needs including sourcing, architecture, and query performance
- Partners with CHQ and West Division EBI to understand and communicate new data sources being ingested into the NDW platform. Provide UAT function on updated data processes.
- Acts as a liaison between Division and CHQ for data validation efforts, improving the quality and consistency of data sources being used, and socializing data gaps that need to be addressed.
- Develop and maintain our source of truth databases for Sales & Marketing while ensuring data quality and accuracy
- Requires strong communication and collaboration skills
- Preferred knowledge and experience with National Data Warehouse and Teradata framework

Core Responsibilities
- Creates technical documentation (internal) using understanding of internal business areas and processes as well as working knowledge of database design, data manipulation, ETL, implementation, information storage & retrieval, and data flow & analysis.
- Preemptively recognize and resolve technical issues utilizing knowledge of policies and processes.
- Optimize data sources and processing rules to ensure appropriate data quality of all products utilizing trouble-shooting, design, and development skills along with cross systems technical knowledge.
- Solves critical issues and shares knowledge such as trends, aggregate, quantity volume regarding specific data sources.
- Acts as a subject matter expert in one or more technical areas; such as data architecture, data engineering or data manipulation within big data systems like Hadoop and SQL.
- Serves as a team leader within a work group or on cross-functional teams; accepts team lead stretch assignments, acts as a resource for colleagues with less experience. Presents to broader senior leadership team. Understands other business units and how
- Acts as a liaison between business owners and technical associates to ensure the data collected and processed is both actionable and relevant to the end goals.
- Determines appropriateness of data for storage and optimum storage organization. Determines how tables relate to each other and how fields interact within the tables to develop relational models.
- Collaborates with technology and platform management partners to optimize data sourcing and processing rules to ensure appropriate data quality.
- Consistent exercise of independent judgment and discretion in matters of significance.
- Regular, consistent and punctual attendance. Must be able to work nights and weekends, variable schedule(s) as necessary.
- Other duties and responsibilities as assigned.

Education Level
- Bachelors Degree

Field of Study
- Computer Science or related field

Years of Experience
- Generally requires 5-8 years related experience.

Additional Requirements
- Expert SQL skills required
- End user data prep and data presentations skills required
- Preferred background in Teradata and MS SQL stack
- Query performance tuning and explain plan knowledge preferred
- Tableau background preferred
- SSRS background preferred