Bryan Kerr Email & Phone Number

Lehi, Utah, Us

Lehi, Utah, Us

Purple is a digitally-native mattress manufacturing company with a mission to help improve lives through innovative comfort solutions.• My team of three amazing Analytics Engineers and I are masters of delivering accurate, reliable data to our business partners via efficient and scalable pipelines, transforming data from its raw form in Snowflake and making it available to consumers in their tool of choice (Excel, Looker, etc.). We are relentless in our desire for continuous improvement and strive to surprise and delight our customers daily.• I pioneered the implementation of data-ops development practices across both Analytics Engineering and Data Engineering teams, utilizing tools like dbt and GitHub to ensure our pipeline development happens in the proper environment, not in production.• As the primary product owner of our data warehouse, I work as a liaison between end users and engineers, gathering requirements and organizing all incoming requests in Jira to ensure our development queue is prioritized for high-value delivery.• Acting as the de facto data architect, I ensure all engineers across data teams are developing in a modular, scalable, consistent manner. I provide data modeling expertise and mentoring to the team.

Lehi, Utah, Us

Lehi, Utah, Us

• Using Python, created and maintained data pipelines into Snowflake from multiple types of source data, including APIs, emails, file shares, SAAS products (Fivetran), and Snowflake data shares. Utilized AWS infrastructure such as S3 and Lambda to accurately and efficiently stage data for idempotent data ingestion and transformation.

Eagle, Id, Us

Lamb Weston is a premier potato and fries company based in Idaho, the heart of US potato country. • Supported critical legacy ETL pipelines that provided visibility into sales data in a SQL Server data warehouse environment rather than having business users trying to pull it from the source mainframe.• Curated and governed report-ready, specialized datasets in Domo for users across the business to enable insights into various facets of the enterprise, such as consumer behaviors, marketing trends, and financial data. This became especially critical during the COVID era when restaurants across the world shut down and our users were reliant on fast, accurate data insights to help keep the business afloat.• Began migration of our Analytics environment to the Cloud using AWStechnologies, which enabled our data science teams to work on advanced machine learning models for things like crop stage detection. This enabled the company to continually provide high quality product to our consumers.

Boise, Idaho, Us

Micron is a world leader in innovative memory solutions that transform how the world uses information.Informatica Developer• Acted as Admin, SME, and Developer during initial setup of Informatica in the Enterprise Analytics and Data team at Micron.• Successfully guided team as Product Owner during an effort to automate the creation of our Informatica pipelines.• As an Informatica Developer, I strove to ensure timely, accurate data was loaded into our Teradata Enterprise Data Warehousing environment. This process utilized nearly 10,000 workflows pulling data from 9 fabrication facilities and cross-loading into two globally separate targets.Data-Ops Engineer• Built a first pass at a comprehensive ETL job catalog using Neo4J.• Constructed a simple Angular web app and connected Python Flask backend to allow ETL developers to programmatically send metadata and job status logs to the catalog.• Utilized OpenShift to quickly and easily deploy changes to the API as a part of a burgeoning CI/CD workflow. • Pivoted to using SQL Server and Splunk for the catalog and job logs, respectively, due to the performance limitations of Neo4J. Refactored the Python API as a part of this process.• Developed and deployed several Tableau and Splunk reports and data visualization dashboards to grant timely insights to management about pipeline status and issues.• Began construction of an automated monitoring and alerting system using Splunk.

River Heights, Ut, Us

Conservice provides outsourced utility management services for residential and commercial properties.• Managed a team of six using SQL Server Management Studio and SQL Server Reporting Services to engineer, design, and develop dynamic, data-driven reports.• Developed a system of conformance to help all team members hit their timeliness and accuracy goals.• Supervised creation and maintenance of over 700 data-driven reports for team members, management, company executives, and clients. • Began research and development of the first data warehouse prototypes at the company. • Self-taught SSIS to retrieve, clean, and load data into our first star schema.

River Heights, Ut, Us

• I created and designed reports for internal and external stakeholders, helping reduce time spent pulling manual reports and boosting productivity.• As the sole report developer, I taught myself SSRS and many advanced SQL principles with little guidance.

Bachelor Of Arts (B.A.), Management Information Systems

Education record