Database Engineer

| Chicago | Hybrid
Sorry, this job was removed at 11:12 a.m. (CST) on Wednesday, July 17, 2019
Find out who's hiring remotely in Chicago.
See all Remote Data + Analytics jobs in Chicago
Apply
By clicking Apply Now you agree to share your profile information with the hiring company.

Join us to make a difference and deliver results across the organization and for our clients. There is plenty of room for growth and experience for the right, highly motivated person.

About PerkSpot

At PerkSpot, we work with America’s top employers to offer the best perks and discounts to millions of employees. These exclusive savings are a great recruitment and retention tool that allows their employees to take advantage of unique opportunities and feel great about their company. We help employees from over 800 companies like Spotify, Walgreens, McDonald's, and Lyft to save on everything from gym memberships and movie tickets to electronics, new cars, and travel.

Profitable and growing. Our company was founded in 2006 by good people with great vision, and we’re carrying on the work they started. As we continue, we’re proud of our leadership position in the industry, but we’re committed to doing more – developing better products, reaching more employers, and getting more employees engaged with our platform. In 2018, our company announced an additional investment of $50 million dollars from Susquehanna Growth Equity. This next stage of growth will focus on expanding our use of technology -- specifically machine learning and AI -- to consistently put the right perks in front of the right people, at the right time.

About the Role

PerkSpot is looking for a full-time take-charge Database Engineer who is ready to take the next step in their career to help manage our data infrastructure, including architecture of new data-heavy features, optimization of data storage and performance, and access control.

While data is not a new concept here at PerkSpot, we have a lot of room for improvement. With your expertise and focused attention, you will make data more accessible and digestible, helping us to make better informed decisions and understand the stories behind the data.

This role will initially report to the VP of Technology, but that may change as the PerkSpot organization continues to grow.

A successful candidate will have:

  • 3+ years of experience
  • Hands on experience in data modeling and database design
  • An aptitude for optimizing the performance of new and existing queries.
  • Ability to implement SQL data transfer methods via SSIS packaging
  • Working knowledge of column indexes and their use in optimizing query performances
  • Comprehensive knowledge of underlying architecture of Microsoft SQL Server
  • Knowledge and significant experience designing, developing, debugging and deploying SQL Server stored procedures, triggers, T-SQL & SSIS packages
  • Experience maintaining MS SQL Server 2016+ instances as well as AzureSQL.
  • Ability to debug and solve complex problems
  • Superior written and oral communication skills
  • A passion for quality work with a teamwork mindset

A successful candidate will:

  • Be self-directed, with a strong sense of ownership
  • A results-oriented and dynamic individual with a hands-on mentality
  • Hands on practical experience with Microsoft Analysis Services and data warehousing

Your First Month

  • Meet the team. Culture is huge at PerkSpot. Take this time to meet the team and learn the ins and outs of the business, and gain a better understanding of all the stakeholders
  • Familiarize yourself with the applications, systems, and tools.
  • Transition all database management and access tasks.
  • Develop an initial 90 day plan for immediate improvements in data performance, development of data-heavy applications, and processes for production data access.
  • Learn how we get things done at PerkSpot -- raise the bar!

The Perks of Working at PerkSpot

We’re a big platform, but still a small team. That means we’re going to trust you with more responsibility than elsewhere, and invest in you more. You’re going to grow – a lot.

We’re a team of forty people working out of our office in Chicago’s River North neighborhood. We dress how we like, boast an open time-off policy, stock a good beer selection, and we’re pretty obsessive about our coffee. Most of all, we welcome good people with lots of energy and enthusiasm.

PerkSpot offers the full suite of benefits you’d expect from a profitable, established company, including health and dental insurance, 401(k), pre-tax transit benefits, and fully-funded disability coverage. We have in-office bike storage and a shower on-site.

We hold weekly all-company get-togethers on Fridays where we learn from what went wrong and celebrate what went right. Every week at PerkSpot, we aim a little higher and get a little bit better than the previous week.

Apply

All applications will be kept strictly confidential. Please submit a resume AND cover letter (a cover letter is very important to us) telling us how you stack up to the qualifications, plus any other information you feel would be relevant to PerkSpot. Don’t be afraid to show your spark and personality!

All positions require a full background screening.

Read Full Job Description
Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.

Technology we use

  • Engineering
    • C#Languages
    • JavascriptLanguages
    • PythonLanguages
    • SqlLanguages
    • .NET CoreLanguages
    • jQueryLibraries
    • ModemizrLibraries
    • ASP.NETFrameworks
    • Elastic SearchDatabases

Location

320 W Ohio St, Chicago, IL 60654

An Insider's view of PerkSpot

What projects are you most excited about?

The projects that excite me the most are ones where I'm able to collaborate cross-functionally to creatively market the company. With a product that is always evolving, it's exciting learning and expanding my knowledge as a marketing professional while telling the brand's story to a variety of different industries and audiences.

Courtney

Senior Content Marketing Associate

What makes someone successful on your team?

Having a strong sense of curiosity goes far on the PerkSpot Finance team. We are always pushing to dig deeper on analysis and provide the “why” behind the numbers. We want our partners across the business to have the information they need to be successful. If they succeed, then we’ve done our jobs.

Mel

Director of Finance

How do your team's ideas influence the company's direction?

The tech team has a lot of influence over how solutions are implemented, leading to scalable, reliable solutions which provide great value to our users. Ultimately these design decisions help grow the business by providing a great user experience!

Chris

Manager of DevOps

How does your team reward individual success?

Each week a member of our team is recognized as the PerkSpot "Star" of the week. They recieve a big trophy to position on their desk for the week and receive credits to spend in our gift card platform. This person has gone above and beyond to help the company and/or support multiple teams on a special project or initiative.

Anthony

Senior Account Executive

What are PerkSpot Perks + Benefits

PerkSpot Benefits Overview

PerkSpot offers the full suite of benefits you’d expect from a profitable, established company, including health and dental insurance, 401(k) with company match, pre-tax transit benefits, and fully-funded disability coverage. We have in-office bike storage and showers on-site.

Culture
Volunteer in local community
Partners with nonprofits
Open door policy
OKR operational model
Team based strategic planning
Pair programming
Open office floor plan
Flexible work schedule
Remote work program
Diversity
Documented equal pay policy
Dedicated diversity and inclusion staff
Mandated unconscious bias training
Mean gender pay gap below 10%
Diversity employee resource groups
Hiring practices that promote diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability insurance
Dental insurance
Vision insurance
Health insurance
Life insurance
Pet insurance
Mental health benefits
Financial & Retirement
401(K) matching
Company equity
Performance bonus
Child Care & Parental Leave Benefits
Childcare benefits
Generous parental leave
Family medical leave
Company sponsored family events
Vacation & Time Off Benefits
Generous PTO
Paid holidays
Paid sick days
Office Perks
Commuter benefits
Company-sponsored outings
Free daily meals
Some meals provided
Company-sponsored happy hours
Pet friendly
Fitness stipend
Home-office stipend for remote employees
Onsite gym
Professional Development Benefits
Job training & conferences
Lunch and learns
Promote from within
Mentorship program
Continuing education available during work hours
Paid industry certifications

Additional Perks + Benefits

PerkSpot offers free Financial Advisory services to all our employees from an outside Financial Advisory firm.

More Jobs at PerkSpot

Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about PerkSpotFind similar jobs like this