Sr. Data Warehouse Analyst

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

Description

The Senior Data Warehouse Analyst will support the company’s data warehouse and reporting environment by working with business users to understand data needs and help turn data into reliable, usable information. This role will assist with analyzing, organizing, validating, and improving data from various internal and external sources while supporting the technical processes used to move and manage data. The position will work with data warehouse tables, queries, data flows, ETL processes, stored procedures, and reporting datasets to help ensure information is accurate, complete, and available for business use. The ideal candidate can bridge business questions with technical data solutions and support reporting, data quality, and data warehouse initiatives.

• Work with business users to understand reporting, analytics, and data needs.
• Help define data fields, business rules, calculations, and report logic.
• Review data results with business users to confirm accuracy and usability.
• Identify data gaps, inconsistencies, or process issues that impact reporting.
• Support recurring reports, ad hoc data requests, dashboards, and business analysis needs.
• Communicate data issues, findings, and recommendations.
• Document report definitions, data logic, business rules, and process changes.
• Analyze raw data from internal systems, external files, partner data, and other sources.
• Write and troubleshoot SQL queries to research, validate, and extract data.
• Support data warehouse tables, views, stored procedures, and reporting datasets.
• Assist with ETL processes, SSIS packages, scheduled jobs, and data loads.
• Map source data to data warehouse tables and reporting structures.
• Clean, transform, and validate data before and after it is loaded into the data warehouse.
• Perform data quality checks, reconciliations, and issue resolution.
• Troubleshoot missing data, incorrect data, failed loads, and reporting discrepancies.
• Help maintain documentation for data flows, table logic, stored procedures, ETL processes, and refresh schedules.
• Support improvements to data warehouse processes, reporting efficiency, and data accuracy.

Requirements

• Bachelor’s degree in Information Systems, Computer Science, Data Analytics, Business Analytics, or a related field.
• 10+ years of experience in data warehousing
• Experience working with data warehouse concepts, data flows, data validation, and reporting datasets.
• Experience using reporting tools such as SSRS, Power BI, Excel, or similar platforms to create, maintain, and support reports and datasets.
• Strong expertise in working with ETL processes, stored procedures, scheduled jobs, SSIS, or similar data tools.
• Experience working with reporting tools such as SSRS, Power BI, Excel, or similar tools.
• Experience analyzing, validating, reconciling, and documenting data.
• Insurance industry experience preferred.
• Proven track record managing enterprise data initiatives, governance, and compliance.
• Excellent oral and written communication, organization, analytical, problem solving, and negotiation skills.
• High attention to detail and commitment to data quality.

Ability to thrive in a fast-paced, regulated environment.

Anchor Group Management Inc. Benefits

• Medical, Dental, Vision, FSA and HSA Plans. Employer annual contribution to HSA plan
• Employer sponsored basic life and basic life AD&D insurance, short term disability
• Voluntary life insurance
• Voluntary long term disability
• Voluntary Ancillary benefits: Accident-Hospital-Critical Illness
• 401K with Fidelity
• 401K employer match
• Transportation Stipend