Pareto Intelligence
Healthcare data is complex. We make it simple.
Chicago, IL

Database Administrator at Pareto Intelligence

Sorry, this job was removed at 8:55 a.m. (CST) on Monday, July 6, 2020
Find out who's hiring in Chicago.
See all Data + Analytics jobs in Chicago
Please submit your resume with Built In/Database Administrator in the subject line to [email protected]
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

We are seeking a highly skilled SQL Developer with strong background and passion for T-SQL, Database Design and Data Modeling to engineer the backbone of several analytical tools and products.  This is a hands-on technical role with extensive focus on coding, designing, testing, improving and implementing and less focus on managerial or administrative tasks. This is an engineering-focused role as opposed to an analytics role but knowledge and understanding of analytics is beneficial. The role involves working with other Software and Data Engineers to develop and review SQL code and Database Designs, make recommendations, tune and apply best practices.

The Ideal candidate is a person that really enjoys working with SQL and SQL Server and has deep experience with both. This person’s time would be a good split between head down writing new code and tuning updating existing logic, researching and implementing new features in SQL Server and other DB technologies, and discussing projects with Data Scientists and other engineers to deploy the right database structure and ETL processes.


  • Extensive knowledge of Relational Database Concepts, database design, normalization and query optimization.
  • Strong ability to design, develop and interpret logical and physical data models
  • 5 to 7 years of programming experience designing, developing and supporting database applications, with emphasis on SQL and database design.
  • Highly comfortable in developing optimized, well-structured, moderate to complex SQL in large database/data warehouse environments, with extensive use of table joins, aggregate functions, analytic/OLAP and built-in functions and SQL programming constructs and techniques
  • Ability to explain concepts and share knowledge with team more junior team members.
  • Moderate analytic skills with the ability to analyze and trace data through complex statistical analysis.
  • Intermediate Knowledge of Healthcare domain, especially payer side business functions with regarding Medical/Pharmacy Claims and Membership data.
  • Experience with Business Intelligence and Data Visualization tools such as Cognos, Tableau etc.

Company Overview

Pareto Intelligence is a leading healthcare solutions company modernizing the way health plans and providers succeed in value-based care. These solutions are supported by proprietary algorithms, predictive models and advanced data science that have analyzed over $100 billion in claims/medical costs and touched over 14 million lives. Through this, Pareto demystifies complex healthcare data and delivers actionable strategies to achieve complete and accurate revenue, communicate critical patient information seamlessly, and inspire more informed business decisions. Pareto was launched in 2013 by HealthScape Advisors, a privately held management consulting firm based in Chicago. That means Pareto’s pedigree is deep expertise and a pragmatic approach to executing solutions.

Pareto Intelligence is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status, or any protected status as defined by law.

See More
Please submit your resume with Built In/Database Administrator in the subject line to [email protected]
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Where we are

Located right next to Merchandise Mart, everything you need is just steps away. From great food to shopping, our location can’t be beat!

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • GolangLanguages
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • RLanguages
    • ScalaLanguages
    • SqlLanguages
    • ReactLibraries
    • KafkaLibraries
    • AngularJSFrameworks
    • HadoopFrameworks
    • Node.jsFrameworks
    • PlayFrameworks
    • SparkFrameworks
    • AkkaFrameworks
    • CassandraDatabases
    • HBaseDatabases
    • HiveDatabases
    • MySQLDatabases
    • PostgreSQLDatabases
    • RedisDatabases
    • AWS S3Databases
    • Google AnalyticsAnalytics
    • InDesignDesign
    • ConfluenceManagement
    • JIRAManagement
    • DrupalCMS
    • WordpressCMS
    • MailChimpEmail

What are Pareto Intelligence Perks + Benefits

Pareto Intelligence Benefits Overview

Our benefits can be described in two words: options and flexibility. We understand that every person’s individual and family situation is different, so we aim to give you choices and combinations that you can customize to your needs. From four health insurance options to two types of FSAs, two dental insurance options, and more, our benefits packages are flexible to you—and subsidized at varying levels, too!

We also offer a generous bonus program as well as 401(k) matching. Our employees enjoy an “open PTO” policy, monthly "Life" subsidy, numerous social events throughout the year, and more. We know you work hard, so we do our best to reward you for that hard work!

Volunteer in local community
Pareto supports local animal shelters, community parks, schools, and homeless shelters by dedicating company time to volunteer and contribute to these communities.
Partners with Nonprofits
Pareto partners with numerous organizations, such as the Anti-Cruelty Society, Cornerstone Community Outreach, Chicago Public Schools, Greater Chicago Food Depository, and Salvation Army.
Friends outside of work
Eat lunch together
Intracompany committees
Pareto has three cross-functional committees: Community Impact focuses on volunteer services; Culture fosters a healthy and engaged workforce; Inclusion & Diversity educates with unique initiatives.
Daily sync
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Pair programming
Open office floor plan
Dedicated Diversity/Inclusion Staff
Highly diverse management team
Pareto's management team represents the diversity of our employees. With continued efforts through our D&I initiatives and trainings, Pareto strives to foster an educated and supportive community.
Unconscious bias training
We believe in helping our employees understand and overcome unconscious bias. That's why we brought an unconscious bias expert to a recent all-company Pareto Way Day to educate our team.
Diversity manifesto
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
We offer two healthcare FSAs: A medical FSA for those on the PPO health insurance plan and a limited purpose FSA for dental and vision spending. Both allow you to contribute funds pre-tax.
Disability Insurance
Both short- and long-term disability is covered at 100% for our employees.
Dental Benefits
We offer two options for dental coverage (including dependents), with 50% of premium subsidized. We cover adult orthodontics and up to 100% of preventative care, depending on the plan choice.
Vision Benefits
Pareto subsidizes 25% of your vision premium and offers an allowance for frames and contacts. Annual eye exams are fully covered.
Health Insurance Benefits
We offer 4 health insurance options for individuals, as well as their spouses and families: A wide or narrow network PPO and wide or narrow network high deductible health plan (HDHP) with an HSA.
Life Insurance
We cover life insurance at your base pay and median of your bonus target, with the option to purchase additional coverage.
Wellness Programs
Our wellness programs include fitness classes, healthy snacks, a private “wellness room” for personal use and more!
Team workouts
Pareto's company fitness initiatives include in-office yoga and charity runs. We also have company sports team that participate in local clubs and leagues.
Retirement & Stock Options Benefits
We offer a robust 401(k) program with over 20 funds to select from and a one-on-one financial advisor to recommend funds and combinations.
401(K) Matching
We match 100% of the first 3% of the compensation, plus 50% of the next 2%. So, if you invest 6% the company matches at 4%.
Performance Bonus
Our employees enjoy a generous bonus program, distributed based on performance and as a percentage of your base salary.
Child Care & Parental Leave Benefits
Child Care Benefits
We have an additional FSA that is funded pre-tax and can be used for dependent care (daycare, nanny, etc.), where we contribute up to $5,000 annually.
Generous Parental Leave
We offer at least 12 weeks maternity leave and at least 2 weeks paternity leave. You do not have to work at the company for a certain amount of time before you can use it.
Flexible Work Schedule
On a case-by-case basis, we are open to offering flexible schedules and have several employees who have these arrangements in place.
Remote Work Program
Our remote work program includes work from home on occasion. Due to our open PTO policy and flexible working environment, we allow employees to work from home as needed.
Family Medical Leave
Employees are eligible for up to 12 weeks of family medical leave.
Company sponsored family events
Pareto sponsors family events throughout the year, including in-office events such as trick-or-treating on Halloween. In addition, spouses are invited to our annual holiday party.
Vacation & Time Off Benefits
Unlimited Vacation Policy
Pareto has an “open PTO” policy, meaning we do not limit time off. We believe in the importance of time away from work, so our employees are welcome to enjoy the appropriate amount of PTO.
Generous PTO
We have a generous “open PTO” policy.
Paid Volunteer Time
We host two enterprise-wide philanthropy days out of the office during business hours per year, as well as monthly volunteer opportunities!
Paid Holidays
In addition to our flexible PTO arrangement, we offer 10 paid holidays each calendar year.
Paid Sick Days
Sick days are included in our company’s “open PTO” policy... we prefer that the germs stay at home.
Perks & Discounts
Beer on Tap
Our Pareto-branded keg in the kitchen is always stocked with delicious craft beer!
Casual Dress
Our employees enjoy casual dress year-round—jeans allowed!
Commuter Benefits
Our employees can contribute pre-tax to a transit benefits account for monthly train or bus passes. We also have a discounted annual Divvy membership.
Company Outings
Cubs rooftop day. Brewery tours. Happy hours, project team celebrations, and more—we know how to work hard and play hard!
Free Daily Meals
Though not an "everyday thing," it's not uncommon to see donuts, coffee and breakfast in the Café or a full lunch spread for Town Halls, Lunch & Learns and lunch meetings.
Game Room
Think you can beat the reigning Super Smash Brothers champ? There’s a Nintendo Switch in the office!
Stocked Kitchen
Our kitchen is stocked with drinks (La Croix included!), coffee and tea, snacks, candy and more.
Some Meals Provided
As we've mentioned, company-sponsored meals are not uncommon at Pareto! Plus, our office manager has great taste, so it's always the most delicious local fares.
Happy Hours
It doesn’t take much for our team to find an occasion for a happy hour… from completed projects and promotions to engagements and baby announcements, we’re not ones to skip out on celebrating!
Our employees can contribute pre-tax to a parking benefits account for commuting. This is separate from (but structured the same as) our transit benefit.
Pet Friendly
Pareto has hosted the "Dog Days of Summer" in the past, where employees can bring their pets to the office on Fridays!
Recreational Clubs
Pareto sponsors two sports teams, volleyball and soccer, which are played in the summer and winter months. Many games are followed by a team happy hour!
Fitness Subsidies
We offer a $100 monthly "Life" subsidy, which includes reimbursement for gym memberships.
Professional Development Benefits
Job Training & Conferences
Pareto is always open to sponsoring job training and conferences that support your career development. Several of our employees have taken classes and attended industry events in this capacity.
Tuition Reimbursement
Our tuition reimbursement program is offered after 1 year of employment, must be germane to your role, and covers up to 70% of tuition.
Diversity Program
Lunch and learns
During our all-company Town Hall meetings, employees often present on various projects. Lunch is always included!
Cross functional training encouraged
Promote from within
Continuing Education stipend
While there is not a specific amount per person dedicated to continuing education, each individual builds a custom professional development program and works with their manager to expense costs.
Time allotted for learning
Pareto encourages all employees to take professional development courses and training opportunities. Employees are self-reliant in utilizing their work hours for learning.
Online course subscriptions available
Customized development tracks
Paid industry certifications
Many employees have CPAs, PHRs, PMPs, etc., and we pay to maintain relevant certifications.

Additional Perks + Benefits

This organization is driven by the Pareto Way, which is about practicing and encouraging 5 key elements: Focus, Curiosity, Accountability, Inclusiveness, and Community Impact. Individuals who exemplify these values are most successful working at Pareto.

An Insider's view of Pareto Intelligence

What are some social events your company does?

One of the best parts of being on the Pareto team is spending time with coworkers outside of work. We go on a yearly brewery tour, monthly team dinners and happy hours. We also join the larger firm for other events such as a Cub’s Rooftop and annual golf outing, where we spend a day golfing and grilling out at one of the partners’ summer home.


Client Advisory Manager

How do you collaborate with other teams in the company?

As the Delivery team, we are the face of the company, but we rely on and deliver the work of our Product and Development teams. The three teams are like legs of a stool—we’d collapse without one another. We ensure collaboration by making sure all teams share a common goal and an understanding of the business impact on our customers.


Director, Client Operations

How has your career grown since starting at the company?

I started as an intern without much big data or minor tech experience. Now, I am a Senior Data Operations Engineer on a team the company relies on for expertise and analysis on all healthcare data we receive. Pareto has given me the resources and opportunities to not only grow my technical skills, but also my knowledge of the healthcare industry.


Senior Data Operations Engineer

How do you make yourself accessible to the rest of the team?

Spending time face-to-face with my team is important to me. I make a point to visit my team at their work spaces and catch up periodically. I’ll spend my lunch breaks in the café or going out to lunch with different people. Plus, my team knows that my door is always open for them, too.



What projects are you most excited about?

What I am most excited about at Pareto are the projects that bridge the gaps between emerging technologies and the delivery of health care services. It is fulfilling to play a role in bringing the two together to support our clients’ initiatives and ultimately improve the health and well-being of people.


Data Science Manager

Pareto Intelligence Jobs in Chicago

All Jobs
All Jobs
Data + Analytics
Dev + Engineer
Tap to close

Data Analyst

Pareto Intelligence
2 days ago
Duties & Responsibilities Design and build publication-ready data visualizations using diverse sets of structured and unstructured data Build interactive dashboards and reports that provide insights that can be easily interpreted and applied by business leaders to help improve client performance Provides data analysis and model development support for the deployment of Pareto’s software solutions Reasons independently to synthesize raw data

Senior Network Engineer

Pareto Intelligence
1 week ago
Position Description  Defines, provisions and manages on premise and Amazon Web Services (AWS) cloud infrastructure services.  Design, develop, and operationalize the automation of delivery, operations, and security for our applications and infrastructure.  Support information security audit (i.e., HIPAA/HITECH assessment, SOC 2 Type 2)  Ensure the security, confidentiality, availability, and integrity of client information for yourself and

Data Scientist

Pareto Intelligence
1 week ago
Position Description Create and refine predictive algorithms that support the numerous product offerings as well as the overall client satisfaction initiatives for Pareto IntelligenceTM Participate in all project phases from concept, requirements, development, test, and production support Explore and understand new big data and analytic technologies that enable faster and more efficient system operations, ultimately delivering timely insights

Data Operations Engineer

Pareto Intelligence
1 week ago
Position Summary: Data Operations is at the core of Pareto Intelligence's promise to deliver exceptional and actionable data insights to our clients. Your team is responsible for the scalable comprehension, ingestion, cleaning, and deploying of client data on schedule - think of the team as the heart muscle that pumps data throughout Pareto Intelligence. And, because quality and consistency are our hallmarks, we're more than a little obsessed

Marketing Manager

Pareto Intelligence
1 week ago
Position Description  Do you thrive in an environment where you get to wear multiple hats? Are you motivated by the ability to own a marketing campaign from start to finish? If so, Pareto Intelligence is looking for a Manager, Marketing & Content Strategy to be the champion and owner of our brand. You will own the entire marketing funnel — a feat that is both challenging and exciting. No two days will be the same, and you will be the biggest

 Client Advisory Analyst

Pareto Intelligence
2 weeks ago
Support client relationships and maximize the adoption and value generated for Pareto’s Clients from our solutions. Be a business expert in the areas for which Pareto provides solutions to health plans and providers. Strategically identify ways to further support our Clients and bring them more value. Proactively listen to Clients, their feedback and gather market intelligence to drive solution enhancements and new solution ideas. Collaborate on a daily basis with other team members to solve complex problems for our Clients. Maintain industry exposure through industry group meetings and other forums. Ensure the security, confidentiality, and integrity of client information for yourself and the team you supervise.

 Client Advisory Associate

Pareto Intelligence
2 weeks ago
Manage Client relationships and maximize the adoption and value generated for Pareto’s Clients from our solutions. Be a business expert in the areas for which Pareto provides solutions to health plans and providers. Strategically identify ways to further support our Clients and bring them more value. Proactively listen to Clients, their feedback and gather market intelligence to drive solution enhancements and new solution ideas. Collaborate on a daily basis with other team members to solve complex problems for our Clients. Maintain industry exposure through industry group meetings and other forums. Ensure the security, confidentiality, and integrity of client information for yourself and the team you supervise.

Product Manager

Pareto Intelligence
3 weeks ago
Position Description You are passionate about products, usability, and innovation.  You are comfortable with road mapping conversations and execution level strategies. You are excited about new product innovations and leading the way in healthcare data analytics.  You know your way around data structures, healthcare analytics, and risk adjustment models.  You are eager to partner with Design, Engineering, and Analytics to create high quality and

Senior Data Engineer

Pareto Intelligence
3 weeks ago
Responsibilities include: Act as the senior member of a cross-functional, agile data development team. Jump in and solve the most complex technical problems and design issues. Initiate and lead refactoring effort. Be a top-notch coder on the team, capable of deep diving into implementation details of components and features across the technology stacks. Stay on top of and drive adoption of advanced cloud-based features and capabilities where

Data Architect

Pareto Intelligence
3 weeks ago
Responsibilities include: Create the large-scale plans that define the life cycle of our corporate data Engage in creating advanced big-data models Work closely with the entire data engineering team to ensure that data flows effectively and efficiently through our systems Help to maintain the integrity and security of the company’s data lakes Recommend data structures based on the data storage and retrieval needs of each department Monitor