Bryan Welch

Senior Data Engineer at Shamrock Trading Corporation
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
West Des Moines, Iowa, United States, US

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

5.0

/5.0
/ Based on 2 ratings
  • (2)
  • (0)
  • (0)
  • (0)
  • (0)

Filter reviews by:

Jack Spivak

I've had the pleasure of working with Bryan directly on several complex data projects over the past year. And as SME on his team efforts, it has been my privilege to experience his leadership style, dedication, collaboration and success. If you are just looking for a recommendation, its simple: Hire him. Don't hesitate. He rocks! His skill, tenacity and teamwork improves everything he touches. He owns his work, cares deeply and goes "above and beyond" to deliver results. Bryan is an exemplary teammate and human being. He is always positive and ready to help. He asks the right questions to move a discovery or debug forward. He brings his ability to think outside the box and come up with innovative solutions. He solves problems - and stays laser focused on action steps needed to implement successfully. His curiousity is palpable. He's always ready to learn new technologies and keep up with industry trends and best practices. I've personally experienced his ability to onboard quickly and collaborate effectively within a complex cloud-based development environment. He is knowledgable and committed to Agile methodology. He brings full-stack skills and experience. Fluent in SQL and other languages. Effective and consistent in his use of Git, ETL, Dagster, DBT, S3 and JIRA-like requirement and change-management tooling. Cooperative and precise employing both standard procedures and developing/documenting new ones. We all know that great teams are not built by luck. It does play a part. If you are looking for a developer, team lead, data architect, DevOps engineer, business liaison... Your team would be lucky to have Bryan as a member.

Timothy Park

I had the privilege of working with Bryan on my team for about a year. I was initially impressed with Bryan's extensive experience and his positive attitude. When he joined Lifespark, he quickly became a high impact teammate, often working to enable others' work while still executing well on his own responsibilities. Collaborating and pairing with Bryan is a joy and it's awesome to work with someone who leans into problems with curiosity first, instead of frustration. At Lifespark, he worked extensively in Snowflake and with dbt and Dagster to enable the flow of data from our partners to clinicians who relied on up to date information to deliver excellent patient care. I am highly confident that he will be a highly valued teammate wherever he goes!

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • United States
    • Truck Transportation
    • 500 - 600 Employee
    • Senior Data Engineer
      • Apr 2023 - Present

      Tech: SQL, Python, Airflow, dbt, Databricks, Kafka, Salesforce, AWS, Redshift, Lambda, EC2, S3, Docker, Github, Agile Tech: SQL, Python, Airflow, dbt, Databricks, Kafka, Salesforce, AWS, Redshift, Lambda, EC2, S3, Docker, Github, Agile

    • United States
    • Hospitals and Health Care
    • 200 - 300 Employee
    • Staff Data Engineer
      • Feb 2022 - Mar 2023

      ► Partner closely with key stakeholders from devops, data science, product, clinical employees, and end-users to develop a road map and architecture to derive meaningful data and actionable insights ► Build pipelines, data orchestration and foundation architecture for scalability and reliability ► Manage healthcare data including EMRs, ADT, members, and claims ► Own projects from ingest of 3rd party data to data discovery, cleaning, mapping to data warehouse, marts, dashboards and Salesforce ► Tech: SQL, Python, AWS, EC2, S3, Snowflake, Snowpipe, dbt, Dagster, Salesforce, Looker, Docker, Github, Agile Show less

    • United States
    • Retail
    • 100 - 200 Employee
    • Senior Data Engineer
      • Jul 2018 - Mar 2022

      ► Sole data engineer supporting three data scientists with data ingestion, ETL, and data architecture ► Build python RESTful services and SQL tools to clean, analyze, and migrate ERP system from Cobol and SQL Server to Infor cloud ► Work with business stakeholders to map business processes, model data, and design dashboards and KPIs ► Lead the identification and implementation of data integration projects ► Analyze and translate business requirements into a form that can easily be understood by all audiences ► Tech: Python, Spark, Kafka, ETL, SQL, SSIS, Azure, Databricks, Tableau, Infor M3, Incorta, Microservices, SQL Server, COBOL Show less

    • United States
    • Software Development
    • 500 - 600 Employee
    • DBA Team Lead
      • Apr 2013 - May 2018

      DBA team lead for a global, enterprise SaaS company serving 3,000 clients ranging from SMB to Fortune 10► Designed updated SQL Server architecture that cut CPU, disk, and licensing costs by 30%, saving $5 million► Manage team of junior and senior DBAs based in the US and India; work cross-functionally with other teams to support 24/7/365 SaaS operations, priorities, customer escalations, maintenance plans and process improvement► Support SaaS applications on 4000+ AWS Cloud and on-premise servers with over 2PB of storage on MySQL, MSSQL, Oracle, MongoDB, IIS, Windows Server, and CentOS across 8 data centers► Reduced time to resolve customer issues by automating tier one support tasks and optimizing ticket workflows to match SLA, root cause analysis, and 24/7/365 on call support requirements► Build automation frameworks and pipelines to generate internal and external reports of customer and database activity trends for use by sales, account management, engineering, and cloud operation teams► Automate CI/CD using Git, Jenkins, and Docker for faster and safer deployment► Define, lead, and delegate multiple simultaneous projects to improve performance, cut resource costs, solve client issues, and provide ongoing value► Design and tune database server architecture to optimize performance of network, SANs, VMs, database engines, and application servers► Implement proactive monitoring to prevent issues, tune servers, and adjust application code to allow growth and scaling of production environments► Tech: AWS, MySQL, SQL Server, Oracle, MongoDB, Bash, Python, CI/CD, Git, Docker, Jenkins, Windows Server, Centos linux Show less

    • Senior Database Administrator
      • Mar 2007 - Apr 2013

      Manage more than 700 Oracle, SQL Server, and MySQL servers across twelve data centers world wide on a team with three other DBAs. Responsible for server hardware requirements, performance tuning, high availability, clustering, replication, data migration, system upgrades, backups, schema architecture, and maintenance automation.► Support application advancement in an Agile work environment by pairing effectively with developers and system administrators► Automated database maintenance and disaster recovery processes► Designed continuous integration methodology for database release patching► Created custom framework for multi-tenant reporting and analytics► Tune database servers through production level load tests and database performance tests Show less

    • City Council
      • Jan 2012 - Dec 2015

      Represented the interests of residents and business owners while providing leadership, business acumen, analysis and innovative thinking to drive our community to continued success. Represented the interests of residents and business owners while providing leadership, business acumen, analysis and innovative thinking to drive our community to continued success.

    • Lead Software Engineer
      • Jun 2006 - Feb 2007

      Lead developer on 15 projects at MVNO start-up to migrate and update legacy systems for better efficiency, reliability, and reporting. Lead developer on 15 projects at MVNO start-up to migrate and update legacy systems for better efficiency, reliability, and reporting.

    • United States
    • Manufacturing
    • 700 & Above Employee
    • Bioinformatics Software Engineer
      • Jan 2003 - Jun 2006

      Designed, developed, and implemented applications using C#, .NET, Java, Perl, and Oracle databases including web services, automated data analysis, loan management, financial analysis, and information retrieval systems Designed, developed, and implemented applications using C#, .NET, Java, Perl, and Oracle databases including web services, automated data analysis, loan management, financial analysis, and information retrieval systems

    • Senior Software Engineer
      • Sep 2001 - Nov 2002

      Lead architect and developer at defense industry start-up developing data mining, knowledge management, and database systems Lead architect and developer at defense industry start-up developing data mining, knowledge management, and database systems

    • IT Services and IT Consulting
    • 1 - 100 Employee
    • Senior Consultant
      • Nov 1999 - Sep 2001

    • Telecommunications
    • 700 & Above Employee
    • System Analyst
      • Dec 1995 - Nov 1999

    • Systems Engineer
      • Jan 1993 - Dec 1995

Education

  • University of Colorado at Boulder
    Master of Science (MS)
  • Iowa State University
    Bachelor of Science (BS)

Community

You need to have a working account to view this content. Click here to join now