Senior Data Warehouse Analyst — Data Quality & ETL

Socket.dev; Schaumburg (IL); On-site; USD 110,000 - 150,000; Full time

Benefits offered by this job

Medical benefits

Life insurance

Voluntary benefits

401K plan

Transportation stipend

Job summary

Anchor Group Management Inc. seeks a Senior Data Warehouse Analyst to support data warehousing and reporting, translating business needs into reliable data solutions. You will work with ETL processes, stored procedures, and reporting datasets to ensure accuracy and accessibility for decision making.

The role emphasizes collaboration with business users, data quality assurance, and documenting data flows and rules to enable governance and compliant reporting.

Qualifications

• Bachelor's degree in information systems, CS, or analytics.
• 10+ years in data warehousing environments.
• Experience with ETL, SSIS, and data integration.
• Proficient in SSRS, Power BI, and Excel reporting.
• Strong data validation and governance experience.

Responsibilities

• Collaborate with business users to define data needs and reporting logic.
• Develop and maintain ETL processes, stored procedures, and data loads.
• Validate data quality and reconcile data sources for reports.
• Support dashboards and datasets with SSRS/Power BI.
• Document data flows, rules, and process changes.

Skills

SQL

Data analysis

Data quality

Attention to detail

Communication

Problem solving

Education

Bachelor's degree in IS/CS/Analytics

Tools

SSRS

Power BI

SSIS

Excel

Job description

Anchor Group Management Inc. seeks a Senior Data Warehouse Analyst to support data warehousing and reporting, translating business needs into reliable data solutions. You will work with ETL processes, stored procedures, and reporting datasets to ensure accuracy and accessibility for decision making.

The role emphasizes collaboration with business users, data quality assurance, and documenting data flows and rules to enable governance and compliant reporting.