Advanced Data Visualization Analyst at Trail King… · Chicago

Advanced Data Visualization Analyst

Location: Chicago, IL, United States

About HCC/CCI

Henry Crown & Company/CC Industries is a Chicago-based, privately-held company that manages business, philanthropic, and family interests on behalf of a multi-generational family. The business ventures fall into broadly-defined categories: wholly-owned operating companies, public and private equity investments, and real estate. The enterprise also supports individual and collective giving through Crown Family Philanthropies and provides traditional family office services across generations. The enterprise employs approximately 350 professionals in the areas of investment management, corporate development, financial operations, tax, research and innovation, human resources, information technologies, and legal.

Why work for us?

We are a private enterprise with more than a 100-year legacy and track record of financial success, supporting our communities, and taking care of our employees. We plan strategically with a long-term time horizon and an integrated approach to access superior opportunities and optimize financial results. Integrity, collaboration, and dedication are cornerstones of our workplace culture that create rewarding professional experiences.

Position Description

The Advanced Data Visualization Analyst designs and develops Power BI dashboards and reports that transform complex data into clear, actionable insights for teams across Henry Crown & Company. As a member of the Business Intelligence team, this individual partners with technical and non-technical stakeholders to understand business needs and build reporting solutions that support informed decision-making. Responsibilities include developing and maintaining visualizations, supporting data modeling and reporting automation, and ensuring report accuracy and usability. This role offers opportunities to contribute to projects across the organization while building technical expertise through collaboration with experienced team members.

Responsibilities:

• Develop Data Visualizations: Build and maintain dashboards and reports in Power BI to visualize complex data for key business stakeholders.
• Develop Automation Flows: Build and maintain flows in Power Automate to orchestrate key reporting workflows.
• Optimize Data Models: Create and maintain data models in Azure Synapse and Power BI to support reliable reporting solutions, with some direction from senior team members on complex work.
• Enhance Reporting Capabilities: Continuously monitor and improve the performance and accuracy of Power BI reports and Azure Synapse queries to meet evolving business needs.
• Ensure Data Governance: Adhere to and enforce data governance best practices to ensure data quality, consistency, and security.
• Support Stakeholders: Provide training and ongoing support to business users for self-service analytics and BI tool usage.
• Document Processes: Create and maintain documentation for data models, ETL workflows, and visualizations.
• Leverage AI Visualization Tools: Utilize Microsoft Copilot for Power BI, AI visuals, and smart narrative features to accelerate report development and surface automated insights for business stakeholders.
• Stay Current with Trends: Keep up with the latest trends and updates in Azure, Power BI, and data visualization tools, and share knowledge with the team.
• Support Data-Driven Decisions: Provide ad hoc support for data queries and analysis to aid in decision-making for various departments.
• Backup and Cross-Training: Serve as a backup for other team members in the event of absence, covering essential data analysis and reporting functions.
• Explore AI Enhancements: Experiment with and evaluate emerging AI capabilities in Power BI and Microsoft Fabric, including Copilot-generated report summaries and AI-powered anomaly detection, and share findings with the BI team.

Qualifications:

• Bachelor's degree in Computer Science, Data Science, Information Technology, or related field, or equivalent work experience.
• Microsoft certifications such as Azure Data Engineer Associate or Power BI Data Analyst Associate preferred.
• Approximately 2–4 years of experience in data analytics, business intelligence, or a related field, with growing proficiency in Power BI. Demonstrated experience working with Azure Synapse Analytics or other Azure cloud-based tools required.
• Knowledge:
  • Working knowledge of Power BI, including DAX, Power Query, and report/dashboard creation, applied with growing independence and consistency.
  • General understanding of Power Automate, including how to create and maintain flows.
  • Working knowledge of Azure Synapse Analytics for data modeling, ETL processes, and building data pipelines.
  • General understanding of Microsoft Fabric and its role in advanced analytics.
• Skills:
  • Data Visualization: Ability to translate data sets into clear, actionable visualizations using Power BI, with growing originality and consistency in design and delivery.
  • SQL Proficiency: Working proficiency in SQL for data retrieval, filtering, and reporting queries, with ability to write and troubleshoot queries with growing independence.
  • Communication: Excellent communication skills, with the ability to present insights and technical information to both technical and non-technical audiences.
  • AI-Augmented Analytics: Working knowledge of AI features within Power BI (Copilot, Q&A, Smart Narratives, Key Influencers) and the ability to incorporate AI-driven visuals and natural-language summaries into dashboards and reports.
• Abilities:
  • Ability to apply data visualization concepts and tools with growing independence, requiring limited supervision on routine tasks.
  • Ability to collaborate with cross-functional teams and contribute to project work with some responsibility and specific direction.
  • Ability to analyze business requirements and translate them into technical specifications, applying some evaluation and originality in approach.
    

The Starting Salary Range: $93k - $105k. Exact compensation may vary based on skills, experience, and location. To see an overview of all our benefits please go to our career portal here.

Don’t meet every single requirement? Studies have shown that women, members of the LGBTQIA+ community, individuals experiencing disability and BIPOC are less likely to apply to jobs unless they meet every single qualification. At CC Industries we are dedicated to building a diverse, inclusive and authentic workplace, so if you’re excited about this role but your past experience doesn’t align perfectly with every qualification in the job description, we encourage you to apply anyway. You may be just the right candidate for this or other roles.