Sign in

Aptitive
Original technology and enterprise content presented by Aptitive, a Chicago-based IT consulting firm with data, analytics, and custom application solutions

P&C insurance is an incredibly data-driven industry. Your company’s core assets are data, your business revolves around collecting data, and your staff is focused on using data in their day-to-day workstreams. Although data is collected and used in normal operations, oftentimes the downstream analytics process is painful (think of those month-end reports). This is for any number of reasons:

  • Large, slow data flows
  • Unmodeled data that takes manual intervention to integrate
  • Legacy software that has a confusing backend and user interface
  • And more

Aptitive recently reached Snowflake Premier Services Partner status, which got us reminiscing about the history of our partnership. Our strategic relationship with Snowflake began back in 2016, though our partnership became official in 2018. Below, see how our Snowflake solutions have developed from then until now.

Certifications and Accreditations

Despite the value provided by our years of Snowflake experience, we also encourage our consultants to become certified SnowPros. In fact, 80% of our consultants are Snowflake trained or certified. Aptitive boasts a total of 31 Snowflake accreditations and certifications.


Aptitive’s data consultants embrace their careers on their own terms. Because we focus on finding projects in the Chicagoland area, our consultants can create the work/life balance that suits their lifestyle. They have access to the many rewards of a technology consulting career — challenging projects, rapid career growth, and a competitive salary — without the drawbacks typically synonymous with consulting. To read more about the perks of an Aptitive career, head to our Careers page.

Each month, we’re shining a spotlight on three of Aptitive’s data consultants to learn how they got started in data consulting, how they have…


Aptitive recently became a Premier Services Partner in Snowflake Partner Network, so we asked our CTO, Fred Bliss, to look back on the start of our partnership and share his thoughts on how Aptitive and Snowflake have evolved. Using his expert knowledge of Snowflake and his intimate perspective on Aptitive’s growth, Fred also takes a look forward at where he sees our partnership going from here. Watch the video below.

Looking to learn more about Aptitive’s history with Snowflake? Take a look at our infographic.

How has Aptitive’s partnership with Snowflake grown since we started working together in 2016?

We officially started our partnership in 2018. But as early as 2016, we…


Hospital patient satisfaction (HCAHPS scores) and nurse turnover are two big issues hospitals are currently facing. Both issues have major implications with regard to patient outcomes and hospital efficiency and profitability. For example:

On top of an already-high nurse turnover rate of 19.1%, the US healthcare system is facing an alarming rate of nurse retirements by the end of 2022. The cost of turnover is also incredibly high — it is estimated that each percentage point of nurse turnover costs an average hospital almost $350,000 in terms of recruiting, onboarding, and training. …


Aptitive is excited to share our latest accomplishment: reaching Snowflake Premier Services Partner status! This achievement recognizes Aptitive and Snowflake’s strong partnership, and it serves as further confirmation of Aptitive’s expert knowledge of the Snowflake platform.

Snowflake’s groundbreaking Data Cloud helps companies drive valuable insights from data across their organizations. It not only powers the ability to delve deeper into essential data but also provides seamless access to the relevant information an organization needs to make critical business decisions.

Aptitive is proud to be a strategic Snowflake consulting partner. Our trained and certified SnowPros have experience accelerating time to value…


At Aptitive, we’re always keeping an eye on up-and-coming technologies. We investigate, test, and test some more to make sure we fully understand the benefits and potential drawbacks of any technology we may recommend to our clients. One unique tool we’ve recently spent quality time with is data build tool (dbt).

Looking for more data and analytics insights? Download our eBook, “Advanced Data Insights in 2021: An End-to-End Guide for Digital Analytics Transformation.”

What is dbt?

Before loading data into a centralized data warehouse, it must be cleaned up, made consistent, and combined as necessary. In other words, data must be transformed —…


Aptitive’s data consultants embrace their careers on their own terms. Because we focus on finding projects in the Chicagoland area, our consultants can create the work/life balance that suits their lifestyle. They have access to the many rewards of a technology consulting career — challenging projects, rapid career growth, and a competitive salary — without the drawbacks typically synonymous with consulting. To read more about the perks of an Aptitive career, head to our Careers page.

Each month, we’re shining a spotlight on three of Aptitive’s data consultants to learn how they got started in data consulting, how they have…


Maybe you’re venturing into data visualization for the first time, or maybe you’re interested in how a different tool could better serve your business. Either way, you’re likely wondering, “What is Looker?” and, “Could it be right for us?”

In this blog post, we’ll go over the benefits of Looker, how it compares to Power BI and Tableau, when you may want to use Looker, and how to get started if you decide it’s the right tool for your organization.

Ready to jump into data visualization? Check out our data visualization starter pack.

What is Looker?

Looker is a powerful business intelligence (BI)…


Now that we’re moving into Q2 2021, you’re likely evaluating the progress your company has made toward this year’s goals. Where does your data and analytics strategy stand? Are you ahead of expectations? Lagging behind? Lacking a strategy entirely?

By this point, the idea that data can transform your business isn’t an earth-shattering revelation. Tailored analytics solutions and strategies can help you grow your revenue, unlock new markets or customers, enhance productivity, and advance your operations in unexpected ways. The good news is there’s still time to take advantage of these many benefits in 2021. …

Aptitive

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store