Upwork home
Sign up
Secondary
Michael N.
Brampton, Canada
100% Job Success
Top Rated Plus

Business intelligence & Analytics Professional | Data Solutions Expert

Hello, I currently run an analytics consulting firm, and together we bring over 20 years of experience working on a wide variety of business intelligence and analytics projects. We bring experience as technical leads, overseeing portfolios of multiple analytics products and leading developers. Our mixture of strong technical and soft skills allows us to succeed in complex projects that involve a high level of interaction with business users and managers. We are currently working on the following projects: -- Data ingestion & analytics with a Canadian telecom company. Writing SQL scripts to load and transform data from Hadoop into MicroStrategy. Creating dashboards in MicroStrategy that allow business users to visualize data from their problem ticketing system and better determine how quickly they are responding to their corporate customers -- Data ingestion and analytics with an American IT security company. Ingesting data from Salesforce (Opps, Leads, Contacts, Campaigns etc.) into Snowflake using Fivetran. Creating a metadata layer in Looker using LookML code, and creating dashboards to track metrics such as ARR and MRR. Overseeing the rollout of dbt, which is a data transformation platform. dbt will be used as an intermediary data transformation step between Snowflake and Looker --Building a modernized analytics platform (Snowflake, FiveTran, dbt, Power BI) for a European marketing firm. The analytics infrastructure will allow them to build automated CEO level financial reports, reports on marketing campaigns as well as predictive analytics to determine how potential customers will benefit from their services --Build a modernized analytics platform (Snowflake, FiveTran, dbt, Holistics) for a Canadian education services company. They're looking to integrate data from multiple sources including their app, HubSpot, Stripe, Facebook Ads and Quickbooks -- Financial reporting for a restaurant and salon franchise company in Texas. We utilize dbt, Big Query and Google Sheets/Power BI to build models and reporting allowing the company to easily track performance and calculate bonus payments for managers We bring extensive experience with multiple platforms, technologies and databases (Looker, Lightdash, Holistics, Metabase, dbt, Snowflake, Google Big Query, Fivetran, Stitch). All of the projects we've worked on have involved data modeling, data ingestion and transformation, designing reports that allow dynamic aggregation of data, and designing dashboards that visualize data in meaningful ways. We are also more than capable of running meetings with relevant stakeholders to provide updates and receive feedback.
Michael N. has more jobs. Create an account to review them

Skills

  • Query Tuning
  • Oracle Database
  • Data Ingestion
  • Data Analytics & Visualization Software
  • Data Lake
  • Analytics
  • Snowflake
  • Data Engineering
  • dbt
  • SQL Programming

Browse similar freelancers