Brian Johnson Email & Phone Number

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.

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.
• 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.
• 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.

Chicago, IL, US

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.

Chicago, IL, US

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.

• 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.

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.

• 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.
• 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.