Data Platform & BI Analyst

Waterton; Chicago (IL); Hybrid; 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 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.