Data Management Analyst

Waterton; Chicago (IL); On-site; USD 70,000 - 100,000; Full time

Benefits offered by this job

Medical & Dental

Life & Disability

Pet Insurance

401k + Match

Paid Time Off

Volunteer Time Off

Tuition Reimbursement

Employee Discounts

Wellness Initiatives

Onsite Gym

Hybrid Work Environment

Job summary

Waterton is seeking a Data Management Analyst in Chicago to expand our data platform by acquiring, integrating, and modeling data from various sources. You will partner with stakeholders to deliver reliable datasets and robust reporting solutions while upholding data governance.

You will help rollout Microsoft Fabric architectures, onboard new data sources, and build self-service analytics with Power BI. Strong communication and teamwork are essential.

Qualifications

• At least 2 years in analytics, data, or a related field.
• Write complex queries and analyze data from relational databases.
• Understand data warehousing concepts: acquisition, ingestion, transformation, modeling.
• Power BI experience required.
• Microsoft Fabric experience preferred.

Responsibilities

• Design and build advanced Power BI semantic models for self-service analytics and enterprise reporting.
• Onboard new data sources into Waterton's centralized data platform.
• Develop and implement automated data pipeline testing for data accuracy.
• Maintain documentation of data sources, lineages, and transformation logic.
• Collaborate with stakeholders to identify reporting opportunities and align with business objectives.
• Define project scopes with relevant stakeholders and ensure feasibility of requirements.

Skills

Data analysis

SQL

Communication

Problem solving

Teamwork

Tools

Power BI

Microsoft Fabric

Azure Data Factory

Job description

Waterton Corporate Office
222 S Riverside Plz
Chicago, IL 60606, USA

Description

About Waterton

Waterton has grown from very humble beginnings with one phone and two desks to the successful, nationally recognized real estate investment and management firm it is today. As Waterton has evolved and grew, one thing has remained constant - the drive to achieve results by exceeding expectations. For 30 years Waterton remains passionate about delivering an incredible Resident Experience, which we believe is made possible by offering an extraordinary experience for our talented associates. We value performance that delivers experiences that exceed expectations, coupled with an unwavering commitment to Investor, Guest, and Resident service excellence. Overall, we are a collection of people who strive daily to "find the good and leave it better".

Job Summary

The Data Management Analyst is responsible for acquiring data from new and existing system integrations to grow Waterton's data platform, including data source analysis, data ingestion, transformations and modeling. Additionally, this role partners with business stakeholders to turn complex requirements into reliable data sets and reporting solutions while maintaining strong standards for data accuracy and governance.

How you will contribute to our team:

• Play a key role in the successful rollout of Microsoft Fabric's data architecture, including transitioning all data components from ADF to Fabric.
• Drive the end-to-end onboarding process for new data sources into Waterton's centralized data platform.
• Design, build, and optimize advanced Power BI semantic models to support self-service analytics and enterprise reporting.
• Develop and implement automated testing frameworks to continuously validate data pipelines and ensure data accuracy.
• Maintain comprehensive documentation of data sources, data lineages, business glossaries, and transformation logic.
• Collaborate with business leaders to identify reporting and data opportunities that support new or ongoing business objectives.
• Proactively seek to improve existing processes and drive innovative approaches.
• Define project scopes and objectives, involving all relevant stakeholders and ensuring technical feasibility with agreed-upon business requirements.

Knowledge, Skills, and Abilities

• Minimum of 2 years of professional experience in analytics, data, or a related field.
• Write complex queries, joins, and aggregations to analyze and extract data from relational databases.
• Fully understand data warehousing principles spanning data acquisition, ingestion, transformation and modeling.
• Prior experience in Power BI or another visualization software is required.
• Experience in Microsoft Fabric is preferred.
• Curious, analytical, and proactive mindset, demonstrating ownership, sound judgment, and a commitment to continuous learning and technical growth.
• Excellent verbal, written, and presentation skills, with a strong grasp of analytic and technical concepts and the ability to explain them to others.
• Team player with a collaborative spirit who can also work independently as needed.

How we will recognize and reward you:

At Waterton, we recognize that compensation and benefits are important not only to our associates but to their families as well. We offer a wide variety of rewards to meet everyone’s needs including:

• Competitive compensation and incentive program participation
• Full suite of benefits, including Medical, Dental, Life, Disability, and even pet insurance.
• 401k + match
• Generous paid time off, volunteer time off, and paid holidays
• A commitment to life-long learning through learning plans that include internal and external training, as well as consideration for tuition reimbursement.
• Employee discounts and wellness initiatives, like an onsite gym.
• Hybrid work environment (based on business or position needs)

The typical base salary hiring range for this role is $70,000.00-$100,000.00 per year, plus bonus program participation.

The pay range is base pay only and does not include any additional compensation or bonuses that this position may be eligible for. The pay range is approximate, and the actual pay may vary depending on related work experience, certifications, education, and other job related factors.

Waterton welcomes all.

Waterton is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender perception or identity, national origin, age, marital status, protected veteran status, or disability status.

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.