Dan Gallo

Dan Gallo Email and Phone Number

Lead Data Engineer at Northwestern Mutual @ Northwestern Mutual
Dan Gallo's Location
Greater Milwaukee, United States, United States
Dan Gallo's Contact Details

Dan Gallo personal email

n/a
About Dan Gallo

• Skilled and dedicated Team Leader, Data Engineer, and Report Developer • Highly efficient end-to-end developer: conduct requirements gathering, develop ETL solution, then build and deliver report(s) to meet business needs• Maintain a high level of discretion with confidential/highly sensitive data• Extensive T-SQL and data modeling experience• Expert user of Power BI and Microsoft Excel• Strong proficiency in Python• Excellent written and verbal communication skills• Ability to comprehend, analyze, and interpret large, complex sets of data • Self-starter with strong ability to multitask, prioritize, and learn quickly

Dan Gallo's Current Company Details
Northwestern Mutual

Northwestern Mutual

View
Lead Data Engineer at Northwestern Mutual
Dan Gallo Work Experience Details
  • Northwestern Mutual
    Lead Data Engineer
    Northwestern Mutual Mar 2022 - Present
    Milwaukee, Wi, Us
    • Effectively lead a team of three - varying from Junior to Senior skill levels• Responsible for team deliverables in both quantity and quality of work• Lead and drive report/dashboard development for multiple key company initiatives• Collaborate closely with Senior Leadership (Sr Director, VP and above) to ensure deliverables remain on target and on time• Present actionable insights to senior leadership and provide recommendations• Develop and maintain complex business logic for reporting needs• Participate in hiring and interviewing process when expanding the team• Act as point of contact for cross-departmental work• Continually improve prior development work to reduce tech-debt• Lead team migration from on-prem SQL Server to AWS Postgres environment• Create standards and best practices for team• Transitioned team to Git to facilitate version-controlled code• Run monthly Power BI workshop (open to entire enterprise and began by me in 2018) to provide continual development for Northwestern Mutual's Power BI Community of Practice
  • Northwestern Mutual
    Senior Data Engineer
    Northwestern Mutual May 2020 - Mar 2022
    Milwaukee, Wi, Us
    • responsible for ownership and continued maintenance for multiple Power BI Workspaces and the reports/dashboards contained within• build enterprise ETL solution to grab, land, and analyze Jira (and Jira related) data and then developed several Power BI reports surface key initiative and deliver insights• founding member of Power BI consortium to discuss and develop Power BI standards and best practices for the enterprise Power BI tenant• act as a subject matter expert for all things Power BI related• provide technical mentorship to team intern and junior team members• requisitioned server for the Reporting & Analytics team while developing team database standards• leverage Python as an ETL tool as our company continues to pivot over to APIs• build and maintain SSIS packages for ETL processes for internal data movement
  • Northwestern Mutual
    Analytics Analyst
    Northwestern Mutual May 2018 - May 2020
    Milwaukee, Wi, Us
    • developed "Health of the Business" Power BI dashboard for C-Level executives• Power BI developer responsible for creation and maintenance of various Power BI reports and Dashboards• acted as sole data engineer to built out data lab from scratch to enable the Policy Benefits workstream to have workable, modeled data• lead effort to clean up database by removing deprecated tables, views, and stored procedures• key participant in multiple business practice events where we uncover gaps and process inefficiencies and develop more efficient workflows
  • Defy Media
    Senior Business Analyst
    Defy Media Aug 2016 - May 2018
    New York, New York, Us
    • Create, maintain, and regularly distribute reports/dashboards that track business KPIs • Key Finance contact for ongoing Data Warehouse project (began as proof of concept)• Constructed Lifetime Value Model, Subscription Forecast Model, Churn Model and Subscriber Analysis Tracker for subscription service• Construct SQL queries for ad-hoc requests to retrieve intricate metrics• Act as Data Steward and product owner of Reporting Portal• Collaborate with subject matter experts to understand business needs and requirements• Identify opportunities for improvement in reporting as well as operations and processes• Conduct on-going analysis of the business, operating practices, and data flows within and between various systems and applications
  • Defy Media
    Financial Analyst
    Defy Media Jun 2015 - Aug 2016
    New York, New York, Us
    • Aid in building multi-faceted models and forecasts• Support and develop management material for presentation to the Company’s Board of Directors • Key finance contact for operational departments, providing monthly updates of P&L activity and budgets vs. actuals • Closely analyze YouTube library of 80,000+ videos to ensure consistent and effective monetization
  • Defy Media
    Accounts Payable Manager
    Defy Media Jan 2014 - Jul 2015
    New York, New York, Us
    • Led the implementation of automated software solution for Company-wide invoicing process • Accurately processed 1,000 invoices and payments per month in five different checkbooks• Worked closely with Controller and Assistant Controller to effectively manage cash flow• Provided accurate, detailed accruals at month end as part of month-end close process• Aided in setting up a Company-wide Corporate AmEx credit card program
  • Defy Media
    Executive Assistant To Coo
    Defy Media May 2013 - Jan 2014
    New York, New York, Us
    • Additionally provided support to two Senior Vice Presidents and Vice President• Assisted in prioritizing daily tasks to keep executives on schedule• Coordinated all travel arrangements – air travel, car service, and hotel• Assisted in logistics and planning of companywide events
  • Hbo
    Executive Assistant To A Senior Vice President
    Hbo Sep 2009 - May 2013
    New York, Ny, Us
    • Provided full, daily support to two Vice Presidents and one Director• Managed multiple phones lines and calendars • Utilized creative problem solving and implemented new best practices

Dan Gallo Skills

Data Analysis Microsoft Excel Outlook Entertainment Management Microsoft Word Social Media Film Social Networking Video Production Mac Microsoft Office Digital Media Self Starter High Level Of Confidentiality Multitasking Skills Sql Transact Sql Microsoft Power Bi Business Analysis

Dan Gallo Education Details

  • Southern New Hampshire University
    Southern New Hampshire University
    Bachelor Of Business Administration - Bba

Frequently Asked Questions about Dan Gallo

What company does Dan Gallo work for?

Dan Gallo works for Northwestern Mutual

What is Dan Gallo's role at the current company?

Dan Gallo's current role is Lead Data Engineer at Northwestern Mutual.

What is Dan Gallo's email address?

Dan Gallo's email address is da****@****llo.com

What schools did Dan Gallo attend?

Dan Gallo attended Southern New Hampshire University.

What skills is Dan Gallo known for?

Dan Gallo has skills like Data Analysis, Microsoft Excel, Outlook, Entertainment, Management, Microsoft Word, Social Media, Film, Social Networking, Video Production, Mac, Microsoft Office.

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.