Data Analytics Engineer

ASSA ABLOY
Phoenix, AZ, United States
27 days ago
Apply on www.indeed.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
8 years minimum
Working hours
Regular working hours
Languages
English
Job source

Tech stack

Microsoft Access Artificial Intelligence Data Analysis Spreadsheets Continuous Integration Relational Databases IBM Cognos Business Intelligence Microsoft Office Microsoft SQL Server Performance Tuning Scrum Methodology Microsoft SharePoint
+9 more
Software Engineering SQL Stored Procedures SQL Databases SQL Server Integration Services Sap Business Objects Data Analytics Qlikview Tools for Reporting Software Version Control

Job description

We’re building a modern analytics practice that goes beyond dashboards. This role will create revenue-focused sales analytics using ERP + non-ERP sources (customer POS, CRM, industry data, spreadsheets, and other structured/unstructured sources), and will establish reusable analytics foundations (certified datasets, standardized metrics, semantic layer) that reduce ad-hoc reporting and democratize insight generation.

This is an in-office position in Phoenix, Arizona.

ESSENTIAL FUNCTIONS & RESPONSIBILITIES

To perform this job successfully, an individual must be able to perform each essential function satisfactorily:

A) Sales revenue analytics & decision enablement (first 6 months priority)

  • Partner with Sales and Finance to build a differentiated sales analytics product that improves decision-making on revenue drivers (e.g., pricing/discounting, mix, customer/segment performance, channel).
  • Create executive-ready insight narratives and repeatable analytic “decision frameworks” (driver trees, leading indicators, KPI hierarchies).
  • Integrate and reconcile new sources beyond ERP (e.g., customer POS feeds, CRM, external/industry signals, customer master enrichment, spreadsheets) into governed analytical datasets.

B) Analytics engineering: data products, semantic layer, and standardized metrics

  • Design and own curated analytics datasets and reusable dimensional models that become a “single source of truth” for Sales and Finance analytics.
  • Establish and enforce consistent KPI definitions via a metrics/semantic layer approach (define metrics once, reuse everywhere).
  • Implement testing, documentation, and data-quality practices so stakeholders trust and adopt the analytics outputs.

C) Self-service enablement & analytics democratization

  • Reduce ad-hoc reporting by delivering certified datasets, reusable templates, and clear consumption patterns that allow business users to self-serve safely.
  • Establish training/enablement (office hours, best-practice templates, “how to use” documentation) and analytics community rituals.

D) Lead the Analytics COE / Community of Practice (roadmap ownership)

  • Build an Analytics COE operating model that is not a report factory and not a help desk-focused on standards, adoption, and scalable enablement.
  • Produce and manage a 12 to 18-month roadmap for analytics capabilities (platform patterns, data products, priority domains, adoption metrics).

E) Modern tooling & innovation (governed)

  • Implement analytics CI/CD patterns (e.g., version control, release discipline, peer review) to scale reliably.
  • Introduce modern techniques/tools where they improve time-to-insight and adoption, including governed AI-assisted analytics experiences supported by trusted semantic metrics.

Requirements

The requirements listed below are representative of the knowledge, skills, and/or abilities required for this position., * 8-10+ years in analytics/BI/data roles with evidence of business impact and cross-functional partnership.

  • Expert SQL + strong data modeling (facts/dimensions; performance-aware).
  • Proven ability to create reusable analytics assets (certified datasets, metric definitions, semantic consistency).
  • Strong business acumen and ability to proactively propose analyses (not just take requirements).
  • Ability to mentor and lead technically (player/coach) and guide a data engineer.

What success looks like (6 months)

  • A Sales revenue analytics capability that integrates non-ERP signals and is actively used by Sales leadership for pricing/revenue decisions.

  • Measurable reduction in ad-hoc reporting through certified datasets, templates, and defined intake/triage patterns.

  • A functioning Analytics COE/Community of Practice with an agreed 12-18-month roadmap and adoption goals.

Computer Skills

  • Proficiency in MS Office

  • A background experience on SAP Business Objects, QlikView or Cognos, as well as knowledge of SharePoint, Access and JDE Enterprise One 9.0 is highly desirable.

  • Proficiency in word processing, spreadsheets, email and order processing software;

  • Strong relational database knowledge is a must. MS SQL Server 2008/2012/2014 development.

  • Understanding of reporting tools: SAP Business Objects XI, Cognos, QlikView, etc.

  • MS Analysis Services development

  • Knowledge of SSIS, store procedures, triggers, and performance tuning.

  • Strong knowledge and experience in the Software Development Life Cycle. SCRUM experience and certification is a plus.

Language Ability

  • For business and safety reasons, ability to write reports and business correspondence in English and effectively present information and respond to questions from groups of managers, clients, customers, technicians, and assemblers in English.

PHYSICAL DEMANDS

Physical demands described are representative of those that must be met by an employee to successfully perform the essential functions of the job.

While performing the functions of this position, the employee is frequently required to sit, stand, walk, stoop and kneel; use hands, reach with hands and arms; communicate clearly and effectively. The employee may also be frequently required to lift up to 10 pounds.

About the company

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this position.

The noise level in the work and shop environment is moderate to loud.

While performing the duties of this position the employee may occasionally be required to work near fumes or airborne particles and toxic or caustic chemicals. The employee may also be required to work near moving mechanical parts.

We are the ASSA ABLOY Group Our people have made us the global leader in access solutions. In return, we open doors for them wherever they go. With nearly 63,000 colleagues in more than 70 different countries, we help billions of people experience a more open world. Our innovations make all sorts of spaces - physical and virtual - safer, more secure, and easier to access. As an employer, we value results - not titles, or backgrounds. We empower our people to build their career around their aspirations and our ambitions - supporting them with regular feedback, training, and development opportunities. Our colleagues think broadly about where they can make the most impact, and we encourage them to grow their role locally, regionally, or even internationally. As we welcome new people on board, it’s important to us to have diverse, inclusive teams, and we value different perspectives and experiences.

You must create an Indeed account before continuing to the company website to apply

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.indeed.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

1:48 min

Automating exploratory data analysis within training pipelines

Dora Petrella · World Congress 2023

1:32 min

Recognizing the persistence and utility of spreadsheet applications

John Bettiol · World Congress 2022

1:42 min

Combining technical skills with strong business communication

Lukas Kölbl · LIVE

1:36 min

Performing exploratory data analysis to uncover underlying patterns

Julian Joseph · LIVE

6:10 min

Transitioning agile recruiting teams away from manual spreadsheet management

Rudi Bauer Rudi Bauer +1 · Cappuccino with HR

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt · LIVE

Videos

See all

Related articles

See all