challenge
Sparq needed a better, more analytical way to efficiently target the most promising American cities to establish a local presence. When comparing potential cities for a new development center, there are thousands of inputs to consider, including demographics, technical skills availability, wages, costs of living, quality of life and the prevalence of higher education institutions, just to name a few. Sparq needed to quickly analyze large amounts of data from both public sources and proprietary data not available for public purchase. Sparq’s growing success in providing onshore digital engineering talent required them to speed up the process of identifying and opening new locations to meet fast-growing client demand. Time was of the essence.
solution
Our team took on the challenge of using a unique combination of results from both data mining and machine learning approaches applied against purchased third-party data to evaluate tens of thousands of data points across 59 mid-sized cities. Sparq designed a similarity mining algorithm to check for similarity percentages between city statistics and implemented a clustering algorithm to examine similarities between cities based on their statistics. Using Power BI to visualize the algorithm results helped the executive team to query the data with different weighting scenarios and quickly assess the best possible cities in which to make investments based on head-to-head comparisons. The application was built in AWS using Terraform for environment setup, React for front-end, DynamoDB for data and .NET for back-end.
results
By overlaying the data mining and machine learning approaches, we were able to drill down on the most appropriate cities with more accuracy, allowing Sparq to increase the likelihood of success and achieve an outsized return on investment. These approaches helped Sparq leadership select two new development center locations in Buffalo, NY and Baton Rouge, LA. The entire development process took less than two months compared to six months in previous site selection processes.
Modernizing Mobile App Measurement for Multi-Million Dollar Marketing Campaigns
A global consumer tech leader was investing millions in paid media but lacked visibility into 90% of campaign performance—limiting their ability to drive key business outcomes. See how we turned data blind spots into marketing intelligence.
New Trading Desk Enables Continued Growth for Top 10 US Bank
Following the merger of two major financial institutions, our client—a top 10 US bank—needed to expand their suite of offerings to attract new Fortune 500 clients and increase their competitive advantage. Learn how our expertise in complex capital market solutions helped us establish a state-of-the-art trading desk to fuel future growth.
Centralized Reconciliation System Transforms Payments Company’s Treasury Operations
A rapidly growing unicorn payments company, faced challenges managing payments across a complex and expanding ecosystem. Learn how we created a centralized solution to streamline data management, ensure compliance, and maintain trust with stakeholders.
Future-Proofing a Payments System for Scalable Growth
Our client, a rapidly-expanding payments company, needed to lay the groundwork for their next-generation payments platform. Their existing payments system was outdated and lacked the scalability and flexibility required for future growth. Learn how we built a façade around their legacy system to modernize their payment management processes without disrupting ongoing operations.