Data Management Sr Consultant, Workforce Analytics

About Northern Trust

As a global leader in innovative wealth management, asset servicing, asset management and banking services, Northern Trust (Nasdaq: NTRS) is proud to guide the world’s most successful individuals, families, corporations and institutions.

Since 1889, we have aligned our efforts with our three guiding Principles That Endure: Service, Expertise, and Integrity. Together, they reflect the three cornerstones of business conduct which we strive to instill in our employees, whom we call partners, and to provide to our clients and the communities we serve worldwide.

With more than 135 years of financial experience and over 24,000 partners, we serve the world’s most sophisticated clients using leading technology and exceptional service.

At Northern Trust, data drives all of our decision-making and HR is no exception. The HR Workforce Analytics team pioneers Northern Trust’s approach to talent strategy and organizational growth. As a member of the team, this position will play an important role in helping leverage vast troves of data to generate insights and inform decisioning-making for internal clients across the globe.

Working as a Consultant for Data Management, you will be responsible for ensuring day-to-day reliability and consistency of the HR’s data environment. This role enforces data governance routines and controls, ensures the quality and consistency of formulas/definitions across reports, supports BAU operations for data products (dashboards, reports, data marts, semantic models), and serves as a second line of support for user inquiries and incident resolution for data products and HR programs owned by Workforce Analytics. The ideal candidate blends strong data management fundamentals with pragmatic operations discipline and great stakeholder communication.

Key Responsibilities:

Data Governance & Controls

• Execute and continuously improve data governance routines (e.g., data quality checks, data lineage updates, access reviews, metadata stewardship, retention/archiving).
• Maintain and enforce business definitions and calculation standards across dashboards, KPIs, and reports; steward the business glossary and data catalog entries.
• Run periodic data quality monitoring (completeness, accuracy, timeliness, conformity, uniqueness) and coordinate issue remediation with owners.
• Support policy compliance (data privacy, security classification, separation of duties) and contribute to audit readiness with evidence/artifacts.
• Participate in change control for data products (including versioning, release notes, and regression validation).

User Support & Enablement

• Serve as the second point of contact for user inquiries about data products, fields, measures, and report usage.
• Manage the support queue (tickets/requests), ensure SLA adherence, and provide clear, non-technical explanations.
• Create and maintain user-facing documentation: how-to guides, data dictionaries, FAQs, and release notes.
• Deliver office hours, training sessions, or quick-start videos to promote self-service analytics and data literacy.
• Monitor ETL/ELT pipelines, data refreshes, and scheduled report jobs; triage and resolve incidents or escalate per runbook.
• Investigate data anomalies, reconcile discrepancies, and document root cause and prevention action items.
• Perform minor fixes/enhancements (e.g., measure updates, parameter/config changes, small model optimizations) following SDLC and change procedures.
• Collaborate with Data Engineering/BI teams on performance tuning, reliability improvements, and capacity planning.

Consistency of Formulas & Definitions

• Own standard KPI/metric definitions, measures, and business rules; drive alignment with business stakeholders.
• Implement automated and/or procedural checks that prevent drift or duplication of metrics across reporting artifacts.
• Review new report requests for alignment with canonical models and glossary terms before approval.

Required Qualifications

• Bachelor’s degree in Information Systems, Computer Science, Statistics, Engineering, Business Analytics, or related field—or equivalent experience.
• 5+ years of experience in data operations, BI/analytics, or data governance.
• Hands-on with at least one BI platform (e.g., Power BI, Tableau, Looker) and SQL (intermediate)
• Working knowledge of ETL/ELT concepts and tools (e.g., Azure Data Factory, dbt, Informatica, SSIS, Databricks).
• Familiarity with data governance practices (data cataloging, glossary management, metadata, lineage) and at least one tool (e.g., Microsoft Purview, Collibra, Alation).
• Understanding of data quality dimensions and controls; experience designing/operating DQ checks.
• Strong documentation, communication, and stakeholder management skills.

Preferred Qualifications (Nice-to-Haves)

• Experience with Microsoft stack (Power BI, Azure Synapse, Fabric, ADF, Purview) or your org’s core stack.
• Knowledge of semantic models (e.g., tabular models, DAX) and measure design principles.
• Exposure to ITSM tools (ServiceNow, JIRA) and support workflows (SLA, priority, escalation).
• Familiarity with privacy/security frameworks (e.g., role-based access control, data classification, GDPR-like controls).
• Scripting for automation (PowerShell, Python) and experience with CI/CD for BI artifacts.

Working with Us

As a Northern Trust partner, you will be part of a flexible and collaborative work culture, which has a strong history of financial strength and stability. Movement within the organization is encouraged, senior leaders are accessible, and you can take pride in working for a company committed to an inclusive workplace and assisting the communities we serve.

Philanthropy is deeply rooted in Northern Trust’s history and is an essential element of our culture. Employees around the world give their time and talent to work for the greater good of their communities.

Reasonable Accommodation

Northern Trust is committed to working with and providing adjustments to individuals with health conditions and disabilities. If you need a reasonable accommodation for any part of the employment process, please email our HR Service Center at MyHRHelp@ntrs.com, or alternatively you can discuss your individual requirements with the recruiter you are working with.

About Our Manila Office

The Northern Trust Manila office celebrated a decade of excellence in 2024. Through agility, resiliency, innovation, and excellence, they have evolved into a dynamic hub with diverse capabilities and a thriving workforce of over 1,200 - driving meaningful impact and sustainable growth. Learn more.