Business Intelligence Architect in Hoffman Estates, IL at Transformco

Date Posted: 4/8/2021

Job Snapshot

  • Employee Type:
  • Location:
    3333 Beverly Road
    Hoffman Estates, IL
  • Date Posted:
  • Job ID:

Job Description

Req/Job ID: 1003655BR
Employing Entity: Transform SR Holding Management LLC
Employment Category: Regular, Full-time
Job Function: Analytics
Store ID: 58491: Sears Holdings Management Corp

Job Summary:

The Business Intelligence (BI) Architect delivers end-to-end BI solutions for internal business groups. The position works closely with business leaders to define requirements and provides subject matter expertise for other developers and analysts.

Scope of Responsibility:

Provides support for Business Intelligence (BI) initiatives across the enterprise, supporting multiple Business Units.

Job Duties/Responsibilities:
  • Leads development and delivery of complex BI solutions that drive better understanding of business performance, improvement areas, and support strategic and tactical decisions to improve business growth across the enterprise.
  • Develops data sources - tables, views, and data flows - to clean, transform, and organize data into intelligence that can be more effectively utilized in reports and dashboards.
  • Performs hands-on, deep dive, data-driven analysis using technologies such as Snowflake, Python, SQL (Structured Query Language,) and Tableau to indentify and help solve.
  • Works with business leadership and cross-functional stakeholders to define requirements and understand the intent of reporting requests to better deliver on expectations.
  • Proactively identifies areas for improvement in report design, user experience flow, and underlying data structures.
  • Administers the Tableau Online environment
  • Acts as a subject matter expert for Tableau report development and data source design for other Business Intelligence developers and analysts

Education Experience: Bachelor's Level Degree
Years of Related Experience: 5-10 Years
  • Travel Requirements: None
Age Requirement: 18+

Job Requirements

Job Requirements:
  • 5+ years advanced SQL Programming experience, including but not limited to complex join operations, common table expressions (CTEs), recursive CTEs, query performance tuning.
  • Expertise in identifying and implementing Tableau report design best practices.
  • Excellent communication and interpersonal skills (both verbal and written).
  • Understanding of normalized and denormalized data structures and their optimal usage.
  • Basic understanding of statistical concepts and functions.
  • Basic Python programming skills.
  • Familiarity with cloud database technologies such as Snowflake, BigQuery, and Redshift.
  • Experience in predictive analytic methodologies and technologies.
Preferred Skills:
  • Master's Degree in Data Science.
  • Intermediate Python programming skills, including analytical functions, and data transformation/manipulation.

Potential Future Positions:
  • Mgr, Data Engineering


Not Ready to Apply?

Joining our Talent Network will enhance your job search and application process. Whether you choose to apply or just leave your information, we look forward to staying connected with you.