Brian Johnson

Brian Johnson Email and Phone Number

Director, Data and Analytics at RaiseRight @ RaiseRight (formerly ShopWithScrip)
Brian Johnson's Location
Greater Chicago Area, United States, United States
Brian Johnson's Contact Details

Brian Johnson personal email

About Brian Johnson

Experienced Director of Business Intelligence with a track record of success in building world-class data and analytics functions across multiple industries. Expertise in Business Intelligence, Analytics, Data Warehousing, and LeadershipKey Accomplishments:• Hands-on leader driving data solutions and services - specializing in building out analytics and data warehouse platforms with modern data architecture design principles.• Extensive experience delivering business intelligence and analytics solutions.• Deep experience designing scalable data-intensive solutions on Snowflake and Redshift cloud data warehouse platforms.• Specialize in deploying various enterprise self-service data tools having deployed multiple ground-up implementations with Tableau and Looker.• Principled leader and team builder of high-performing individuals – partnering across all organizations to synthesize quantitative and qualitative data into actionable insights.Skills:Analytics - Big Data - Data Science - Business Intelligence - Data Lake - Data Warehousing - Reporting Solutions - Cloud Architecture - Data Visualization - Scripting - Microservices - Machine LearningTechnical Skills: Snowflake - Redshift - SQL - SQL Server - DBT (Data Build Tool) - AWS - Prefect - Python, Tableau - Looker - GitHub - CI/CD - SSIS - SSAS - SSRS - Microservices

Brian Johnson's Current Company Details
RaiseRight (formerly ShopWithScrip)

Raiseright (Formerly Shopwithscrip)

View
Director, Data and Analytics at RaiseRight
Brian Johnson Work Experience Details
  • Raiseright (Formerly Shopwithscrip)
    Director, Data And Analytics
    Raiseright (Formerly Shopwithscrip) May 2021 - Present
    Grand Rapids, Michigan, Us
    RaiseRight is the largest gift card fundraising platform in the United States, helping 50,000 organizations raise over $800 million for initiatives that matter to them.
  • Clearcover
    Director Of Business Intelligence
    Clearcover Jul 2019 - Mar 2021
    Chicago, Il, Us
    Lead Business Intelligence and Analytics at one of the fastest-growing insurtech start-ups in the auto insurance industry.• Architected and launched the foundational analytic platform leveraging a modernized tech stack of Snowflake, DBT (Data Build Tool), and Tableau with AWS, Prefect, Python, GitHub and CI/CD processes for automated data workflow pipelines.• Lead cross-functional projects using advanced data modeling and applied analysis techniques with interactive reporting related to Marketing Analytics, Product Analytics, and Growth Analytics.• Recruited and hired a high-performance Business Intelligence and Analytics department from 2 to 13 people comprised of analytic engineers, analysts, and managers that scaled with the explosive growth the business experienced and the associated data complexity introduced with that expansion.• Manage and own the Business Intelligence and Analytics department budget to ensure investments were being allocated effectively. • Supported Executive team with data and analytics to be utilized in fundraising efforts to secure multiple rounds of funding for the business.
  • Clearcover
    Head Of Business Intelligence
    Clearcover Oct 2018 - Jun 2019
    Chicago, Il, Us
  • Rising Medical Solutions
    Director Of Business Intelligence
    Rising Medical Solutions Jan 2016 - Oct 2018
    Chicago, Il, Us
    Led a team of data engineers, data architects, and data analysts developing strategic data solutions that drive claims related medical cost containment and care management services for health insurance markets.• Led data transformation initiative from on-premise solutions to AWS Cloud to improve data warehousing capabilities. • Developed and implemented technical roadmap and data strategy to support the business - working with stakeholders to align organizational objectives with data solutions.• Architected and executed a data lake strategy in AWS S3 that ingested thousands of data objects utilizing AWS Redshift as the data warehouse platform. • Streamlined self-managed data services model throughout the organization utilizing Tableau Enterprise Software along with ad-hoc tools to enable business users to manage and analyze their own data.• Managed and directed the migration and redesign of the entire Data Warehousing/Business Intelligence environment to the Amazon Web Services (AWS) cloud computing platform.• Developed ETL data pipelines leveraging various tools and services to provide customized solutions to meet the demands of a given data workload: utilized Microsoft SSIS, Elastic Map Reduce, and Python.• Winner of Business Insurance magazine’s 2013 Innovation Award for Rx Intelligence analytics platform.
  • Rising Medical Solutions
    Business Intelligence Manager
    Rising Medical Solutions Jul 2011 - Dec 2015
    Chicago, Il, Us
  • Potbelly Sandwich Works
    Business Intelligence Developer
    Potbelly Sandwich Works Oct 2007 - Jul 2011
    Chicago, Il, Us
    • Designed and developed a new data warehouse on a Microsoft SQL Server platform.• Applied data mining algorithms to analyze customer purchasing pattern behavior to optimize marketing strategies and increase sales. • Built role-specific dashboards for management to gain visibility into store, district, and zone performance metrics.• Deployed training and tools enabling end-users to self-manage ad-hoc analysis and reporting.• Recipient of company National Golden Pillar Award for individual contribution to corporate profit.
  • Firstlook Systems
    Senior Reporting And Analytics Engineer
    Firstlook Systems Mar 2007 - Sep 2007
    • Redesigned data warehouse environment to Microsoft Analysis Services platform, enhancing and optimizing its main product line of management reporting tools.• Organized data marts that supported OLAP cubes and reporting systems with SQL Server. • Partnered with business analysts to design key product metrics and analytic components.
  • Heidrick & Struggles, Inc.
    Systems Analyst
    Heidrick & Struggles, Inc. Dec 2002 - Mar 2007
    Chicago, Il, Us
    • OLAP database architect on a globally dispersed team designing, developing and maintaining all business intelligence systems and global management reporting.• Designed and developed Microsoft Analysis Services cubes for enterprise business intelligence applications, improving the timely delivery of operational, HR, and financial data for analysis and reporting.• Performed physical data warehouse design and ETL system implementation on SQL Server platform.
  • Various Clients
    Information Technology Consultant
    Various Clients Jun 1995 - Nov 2002
    • Led multiple Microsoft SQL Server database projects. Database responsibilities included design and modeling, data migration, coding stored procedures, coding triggers, database backups, performance, and capacity tuning, examining query execution plans, and database monitoring.• Developed and programmed data-driven e-commerce web sites for order processing and sales reporting.• Achieved Microsoft Certified Trainer certification, taught Microsoft Curriculum courses for implementing a database design on Microsoft SQL Server.

Brian Johnson Skills

Data Warehousing Microsoft Sql Server Analytics Databases Olap Business Intelligence Tableau Ssis Analysis Services Analysis Data Science Database Design Business Analysis Data Visualization Amazon Web Services Enterprise Software Consulting Mdx Etl Management Ssrs Team Management Healthcare Analytics Claims Management Amazon Rds Amazon Ec2 Amazon S3 Big Data Analytics Big Data

Brian Johnson Education Details

  • Southern Illinois University Edwardsville
    Southern Illinois University Edwardsville
    Computer Science

Frequently Asked Questions about Brian Johnson

What company does Brian Johnson work for?

Brian Johnson works for Raiseright (Formerly Shopwithscrip)

What is Brian Johnson's role at the current company?

Brian Johnson's current role is Director, Data and Analytics at RaiseRight.

What is Brian Johnson's email address?

Brian Johnson's email address is bj****@****ail.com

What is Brian Johnson's direct phone number?

Brian Johnson's direct phone number is +131259*****

What schools did Brian Johnson attend?

Brian Johnson attended Southern Illinois University Edwardsville.

What skills is Brian Johnson known for?

Brian Johnson has skills like Data Warehousing, Microsoft Sql Server, Analytics, Databases, Olap, Business Intelligence, Tableau, Ssis, Analysis Services, Analysis, Data Science, Database Design.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.