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

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

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