Scott is available for hire
Hire ScottScott Carmody
Verified Expert in Engineering
Data Warehouse Architect and Developer
Naperville, IL, United States
Toptal member since September 5, 2019
Bio
Scott is a data warehouse architect and BI developer with 30 years of industry experience. He specializes in the Microsoft BI stack. He utilizes all aspects, including building data marts and data warehouses in SQL Server, ETL with SSIS, SSAS cubes, and creating reports and advanced analytics with SSRS and Power BI. Scott also has considerable cloud experience with Azure and has worked with Azure SQL Database and Azure Data Factory.
Portfolio
A Leading Home Improvement Services Company
Data Warehousing, Data Warehouse Design, ETL...
Three Five Two, Inc.
Microsoft Power BI, SQL, Azure, Data Modeling, Fabric, Excel 365...
Carhartt
Business Intelligence (BI), Microsoft Power BI, SSAS Tabular, Documentation...
Experience
- Data Warehousing - 20 years
- Dimensional Modeling - 20 years
- SQL - 20 years
- SQL Server Analysis Services (SSAS) - 19 years
- SQL Server Reporting Services (SSRS) - 19 years
- SQL Server Integration Services (SSIS) - 14 years
- Microsoft Power BI - 4 years
- SQL Server 2016 - 3 years
Work Experience
Senior Data Warehouse Architect and Business Intelligence Developer
2024 - PRESENT
A Leading Home Improvement Services Company
- Handled dimensional modelling of a new data warehouse that will be used as the source for Power BI reports and ad-hoc analysis. Involves SQL Server.
- Built a robust ETL solution to load the data warehouse from disparate source systems. Involved a thorough knowledge of SSIS.
- Developed Power BI reports. Created visually rich reports, making extensive use of DAX and data modelling concepts. Created a semantic model using Tabular Editor 3 as the authoring tool.
- Used Anthropic's Claude AI and MCP to assist with model development.
Technologies: Data Warehousing, Data Warehouse Design, ETL, SQL Server Integration Services (SSIS), SSIS Custom Components, SSAS Tabular, Microsoft Power BI, Claude, Model Context Protocol (MCP)
Microsoft Fabric Engineer | Power BI Expert
2023 - 2024
Three Five Two, Inc.
- Developed a conceptual and physical dimensional data model to be used in historical reporting.
- Created and implemented the dimensional model in Microsoft Fabric. Source data was pulled into the lakehouse using OneLake via Gen2 data flows and pipelines. Fact table pulls were designed for incremental refresh. Data was populated in the warehouse.
- Created Fabric capacity for the client; Researched cost analysis versus other approaches like Azure Synapse Analytics.
- Performed training and knowledge transfer of Fabric capabilities and led a walkthrough of the pieces developed with key stakeholders from the client.
Technologies: Microsoft Power BI, SQL, Azure, Data Modeling, Fabric, Excel 365, Microsoft Data Transformation Services (now SSIS)
Business Intelligence Principal Engineer
2023 - 2024
Carhartt
- Enhanced and created data models crucial to the business, including the point of sale.
- Handled Power BI report development, which required extensive use of DAX and data modeling concepts.
- Conducted Power BI training for internal Carhartt personnel.
- Developed new data model training for internal Carhartt personnel.
Technologies: Business Intelligence (BI), Microsoft Power BI, SSAS Tabular, Documentation, Data Analysis, Excel 365
Power BI Developer | Data Analyst
2023 - 2023
Trillium Beverages Pvt. Ltd.
- Developed a dataset from Neilsen survey data and other sources. Involved knowledge of Power Query to reverse-engineer some metrics that were not supplied.
- Merged queries in the Power Query editor to pass back to Microsoft Power BI.
- Developed Power BI reports from the dataset involving complex DAX to solve compound annual growth.
Technologies: Data Analysis, Microsoft Power BI, Data Analytics, Business Intelligence (BI), Microsoft Excel, Excel 365
Senior Data Warehouse Architect | BI Developer
2023 - 2023
Callon Petroleum
- Built a SSAS Tabular cube from an existing dimensional model.
- Created multiple Power BI reports based on the SSAS cube.
- Developed data-profiling Power BI reports from a metadata mart holding Gartner-based profile table statistics (internal project). This involved showcasing data statistics and services to external clients.
Technologies: Business Intelligence (BI), Microsoft Power BI, Documentation, Data Analysis, Excel 365, SQL Stored Procedures
Data Engineer
2022 - 2023
A-dec, Inc.
- Reworked existing SQL logic and routines for performance improvement.
- Captured EDW requirements related to an AX 2012 archiving project. Acted as the BI/data team liaison for this high-level project. Reworked ETL processes to capture the appropriate data row from prod and archive systems.
- Assisted HR with a UKG to Workday data migration project.
Technologies: Microsoft Power BI, Data Engineering, SQL, Azure, Data Architecture, Data Warehousing, Documentation, Data Analysis, Excel 365, Git, SQL Stored Procedures, Google Cloud SQL
Senior Data Warehouse Architect | Power BI Developer
2021 - 2023
Georgia-Pacific
- Helped create Proof of Concept Power BI models for inventory projections, allowing the business to make better-informed decisions. This involved detailed knowledge of SQL, SSIS, and Power BI.
- Assisted in the development of Power BI reports, working directly with the business sponsor.
- Oversaw mentoring and training of GP personnel and mgmt.
Technologies: Business Intelligence (BI), Dashboards, Data Analytics, Data Architecture, Documentation, Data Analysis, Excel 365, SQL Stored Procedures, Microsoft Data Transformation Services (now SSIS)
Senior Data Warehouse Architect | BI Developer
2022 - 2022
Health Care Service Corporation
- Created a dimensional model for an enterprise data warehouse in SQL Server.
- Designed and developed a robust ETL solution using SSIS.
- Developed and maintained an Analysis Services Tabular cube.
Technologies: Business Intelligence (BI), Microsoft Power BI, SQL Server Analysis Services (SSAS), Data Analysis, SQL Stored Procedures, Microsoft Data Transformation Services (now SSIS)
Senior Data Warehouse Architect | Power BI Developer
2022 - 2022
Gifted Healthcare
- Designed and architected tables and stored procedures in SQL Server to serve as the source for Power BI reports.
- Created Power BI reports to assist in travel nurse billing, payroll reconciliation, client scorecard, etc. This involved in-depth knowledge of DAX, data modeling, and proper visualizations.
- Provided knowledge transfer and training for internal personnel.
Technologies: Business Intelligence (BI), Microsoft Power BI, Data Analysis, SQL Stored Procedures
Senior Data Warehouse Architect | BI Developer
2020 - 2021
Atlantic Broadband
- Created SSIS packages to connect to 3rd-party SOAP APIs to send and receive data.
- Handled the architecture of the new IVR data mart (Kimball dimensional modeling).
- Took charge of various reporting off of the ABB data warehouse.
Technologies: Business Intelligence (BI), Data Warehouse Design, APIs, Data Analysis, Microsoft Data Transformation Services (now SSIS)
SQL Server Analysis Services Developer
2020 - 2021
PepsiCo
- Incorporated dimension and fact changes to existing SSAS cubes.
- Integrated a corporate security model into the existing cube.
- Created a version of the existing cube on Azure Analysis Services.
- Built data build tool models to populate tables in Snowflake. These tables are being used to populate an Azure SSAS cube.
Technologies: Data Engineering, Microsoft SQL Server, Data Analysis, Git
Power BI Developer
2020 - 2020
Toptal Client
- Served as a Power BI consultant for a large analytics and data science consulting company in South America.
- Created a Power BI report for their client. This was an iterative approach where the client was rapid prototyping design and functionality.
- Contributed to this project, which involved complex modeling, visualizations, and complex DAX coding.
Technologies: Microsoft Power BI, SQL Architecture, Data Analytics, ETL, Business Intelligence (BI), Data Architecture, Dashboards, Reports, Interactive Dashboards
Power BI Developer
2019 - 2020
Toptal Client
- Created multiple sales reports and dashboards in Power BI to help the company with sales and volume metrics, including market share. Multiple visualizations, slicers, bookmarks, and complex DAX coding were involved.
- Built the data model and necessary relationships for effective reporting.
- Managed the architectural design of the underlying SQL database for various initiatives within the company.
Technologies: Microsoft Power BI, SQL, Data Pipelines, Data Visualization, Reporting, Data Engineering, Data Analytics, SharePoint, Microsoft Excel, ETL, Business Intelligence (BI), Data Architecture, Dashboards, Reports, Interactive Dashboards
Senior Data Warehouse Architect | BI Specialist
2015 - 2020
BluBØX Security
- Solely created a data warehouse in Azure SQL Database reading from a transactional system. Developed SSIS ETL processes and successfully ported them to Azure Data Factory to service reports.
- Implemented Power BI as an analytics platform sourced from the company's data warehouse as well as all reporting needs. This involved porting the model, managing relationships, and creating visualizations for reports.
- Conducted knowledge transfer sessions among personnel.
Technologies: Microsoft Power BI, SQL Server Reporting Services (SSRS), SSAS, SQL Server Integration Services (SSIS), Azure, SQL, Data Pipelines, Data Visualization, Reporting, Data Analytics, SharePoint, Microsoft Excel, ETL, Business Intelligence (BI), Data Architecture, Dashboards, Reports, Interactive Dashboards, Microsoft Data Transformation Services (now SSIS)
Senior ETL Architect/Developer for Kirkland & Ellis (legal firm)
2019 - 2019
Request Technology
- Converted SSIS packages under SQL 2008 R2 to SQL 2016. Added new functionality when needed.
Technologies: SQL Server Integration Services (SSIS), SQL, Data Pipelines, Data Engineering, Data Analytics, ETL, Business Intelligence (BI), Data Architecture, Reports, Interactive Dashboards
Senior BI Specialist for Plante Moran, Southfield, MI
2019 - 2019
Strive Consulting (contract)
- Assessed and triaged issues related to data movement and ETL among business processes within the firm. Required extensive use of SQL scripting and SSIS.
- Planned for data warehouse build-out.
Technologies: SQL Server Integration Services (SSIS), SQL, Data Engineering, Data Analytics, ETL, Business Intelligence (BI), Data Architecture, Reports, Microsoft Data Transformation Services (now SSIS)
Senior BI Specialist for Komatsu, Rolling Meadows, IL
2019 - 2019
Randstad Technologies (contract)
- Helped create over 180 Power BI reports and dashboards against SSAS tabular models as part of Komatsu’s New Parts System initiative program.
Technologies: Microsoft Power BI, SQL Server Integration Services (SSIS), SQL, Data Pipelines, Reporting, Data Engineering, Data Analytics, SharePoint, Microsoft Excel, ETL, Business Intelligence (BI), Data Architecture, Dashboards, Reports, Interactive Dashboards
Senior ETL Developer for Reyes Holdings (Great Lakes Coca Cola Bottling)
2019 - 2019
Addison Group (contract)
- Supported new and existing SSIS development for the Coca Cola business unit of the beverage distribution company.
- Assisted with SSAS cube development.
Technologies: SSAS, SQL Server Integration Services (SSIS), Microsoft SQL Server, Data Pipelines, Data Engineering, Data Analytics, Microsoft Excel, ETL, Business Intelligence (BI), Data Architecture
Senior BI Specialist for CDW, Vernon Hills IL
2018 - 2019
Insight Global (contract)
- Oversaw all MDS (Master Data Services) and ETL development (SSIS) from the AS400 source system to the corporate DW in order to create a new categorization for products. Required extensive use of MDS and the MS BI stack of tools including SSIS.
Technologies: SSAS, SQL Server Integration Services (SSIS), Cisco MDS, SQL, Data Analytics, ETL, Business Intelligence (BI), Data Architecture, Microsoft Data Transformation Services (now SSIS)
Senior BI Specialist for Ventas, Chicago, IL; Merchant's Fleet Management, Rosemont, IL
2017 - 2018
Addison Group (contract)
- Managed all ETL development (SSIS) from the source financial system (Yardi) to the corporate DW. Also responsible for optimizing and developing MDX queries from several cubes used in reporting. Required extensive use of the MS BI stack of tools including SSIS, SSAS, and the MDX query language.
- Headed DW architecture and ETL development (SSIS). Created Data Dictionary for DW. Optimized several source queries. Responsible for production deployment procedures.
Technologies: SSAS, SQL Server Integration Services (SSIS), SQL, Data Engineering, Data Analytics, ETL, Business Intelligence (BI), Data Architecture
Senior BI Specialist
2012 - 2017
Aon
- Created, developed, and modified an entire BI solution to handle ad hoc requests and MDX report queries regarding comparative analysis among clients (brokerage firms) for McLagan Retail.
- Assisted in redesigning an optimal solution for the existing survey data warehouse. Helped evaluate in-memory solutions. Developed a robust ETL solution for large data loads using SSIS. Assisted with DBA tasks to host an acquired company in MS Azure.
- Architected a data warehouse according to Kimball best practices. Created robust ETL using SSIS, including email notification, auditing, and logging. Designed and developed a cube in SSAS. Created complex calculated member logic.
Technologies: SQL Server Reporting Services (SSRS), SSAS, SQL Server Integration Services (SSIS), SQL, Data Engineering, Data Analytics, ETL, Business Intelligence (BI), Data Architecture
Senior BI Architect/Developer
2012 - 2012
SIMS Recycling (contract)
- Created a complete data warehouse and BI solution for inventory analysis. Required extensive use of the entire MS BI stack of tools including SSIS, SSAS, SSRS, and the MDX query language.
Technologies: SQL Server Reporting Services (SSRS), SSAS, SQL Server Integration Services (SSIS), SQL, Data Engineering, Data Analytics, ETL, Business Intelligence (BI), Data Architecture
Senior BI Architect/Developer
2010 - 2011
Redbox (contract)
- Provided real-time strategic data and information to the loss prevention and games teams using a combination of T-SQL and OLAP cube queries. Created real-time alerts and reports which contributed to a reduction of fraud in game rentals from 17% to 2% and allowed for a nationwide rollout of games with an estimated $40 million increase in revenue.
- Assisted the marketing department with numerous initiatives including providing RFM (recency, frequency, and monetary) data to assist in strategic decision-making initiatives.
Technologies: SQL Server Reporting Services (SSRS), SSAS, SQL Server Integration Services (SSIS), SQL, Data Engineering, Data Analytics, ETL, Business Intelligence (BI), Data Architecture
Senior ETL Architect/Developer for W. K. Kellogg Foundation, Battle Creek, MI
2010 - 2010
Information Technology Partners (contract)
- Managed ETL architecture using a combination of T-SQL stored procedures and SSIS, SSAS, and SSRS Reports with Dundas to create a corporate dashboard displaying trends of corporate contract, request, and grant information for a non-profit charitable foundation. Dramatically reduced the existing ETL time from a run time of around one hour to between 5-10 minutes.
Technologies: SQL Server Reporting Services (SSRS), SSAS, SQL Server Integration Services (SSIS), Reporting, Data Engineering, Data Architecture
Project History
Dashboard Creation
Created over 100 Power BI dashboards in three months for a new parts system project. This included multiple visualizations, DAX coding, etc.
Redbox Game Rentals
Redbox was considering not rolling out games to their kiosks because of a high rate of fraud in test markets. I created real-time alerts and reports which contributed to a reduction of fraud in game rentals from 17% to 2% and allowed for a nationwide roll-out of games with an estimated $40 million increase in revenue.
Education
1984 - 1988
Bachelor's Degree in Computer Science
Siena College - Loudonville, NY
Skills
Libraries/APIs
Fabric
Tools
Microsoft Power BI, Microsoft Excel, Git, Visual Studio, SSAS, Power BI Desktop, Claude
Languages
SQL, C#.NET, VBScript, Excel VBA, MDX
Paradigms
Dimensional Modeling, ETL, Business Intelligence (BI), Model Context Protocol (MCP)
Storage
SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server 2016, Microsoft SQL Server, Data Pipelines, SQL Stored Procedures, SQL Server Management Studio (SSMS), SQL Architecture, SSAS Tabular, Google Cloud SQL
Platforms
SharePoint, Azure
Other
Data Visualization, Multidimensional Expressions (MDX), Data Warehousing, Data Warehouse Design, Data Reporting, Reporting, Data Engineering, Data Analytics, Data Architecture, Dashboards, Reports, Interactive Dashboards, Documentation, Data Analysis, CSV, Business Analysis, Excel 365, Microsoft Data Transformation Services (now SSIS), DAX, APIs, Windows 10, Cisco MDS, Data Modeling, SSIS Custom Components
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring