Senior Software Engineer - Business Intelligence

| Chicago
At Relativity, we make software to help users organize data, discover the truth, and act on it. Our e-discovery platform is used by more than 13,000 organizations around the world to manage large volumes of data and quickly identify key issues during litigation, internal investigations, and compliance projects.
Here you can own your career in a community of values-driven people who help our customers around the world solve complex data challenges. If this sounds like the place for you, check out the details of this position below.
The Senior Software Engineer is responsible for design and development of the advanced reporting data warehouse & advanced reporting solutions for the engineering department. This automation is used to drive consistency across the department and provides a means to measure the effectiveness of our product development processes. This position requires the ability to wear multiple hats and be creative in solving the dynamic needs of the department. The Software Engineer is responsible for the development of data extraction and transformation routines (ETL) from systems used by engineering using direct SQL / TSQL queries, stored procedures / views or other custom programs (C#, Python, Informatica, REST API). The data warehouse technologies reside in both on-premise and Azure SQL Server environments and is sourced from systems used across the lifecycle of software development and testing (JIRA, SalesForce, BitBucket, Jenkins, Elastic Search, etc). This position requires detailed knowledge of advanced reporting technologies including Tableau, PowerBI, or SSRS.

Responsibilities

  • Drive creative solutions for departmental reporting/analysis challenges
  • Gather, document and analyze requirements from internal customers and assess impact of required changes
  • Build out prototypes of the software automation to prove out the technology and understanding of requirements
  • Design and build data warehouse logical and physical data models
  • Develop and maintain complex data migration ETL processes using MS SQL Server 2012/2016, TSQL, C# REST API’s, and other scripting technologies.
  • Create operational and product-related metric reports and custom dashboards using Tableau
  • Analyze data sources to identify gaps in data content. Collaborate with Agile Tools and IT teams to implement required customizations to JIRA workflows, validation scripts and notification schemes
  • Partner with IT and internal customers to streamline and scale data-related processes and workflows

Qualifications

  • Bachelor's degree in Computer Science, Engineering or other related subject
  • At least seven years of experience in data analysis, modeling, transformation, and advanced reporting for commercial-grade systems and applications
  • At least seven years of experience designing and writing SQL for commercial-grade business intelligence systems
  • At least three years of experience experience using Tableau, PowerBI or SSRS 
  • Experience writing complex SQL using Microsoft SQL Server to load, transform and report on data
  • Experience creating custom reports using Microsoft SSRS, Tableau, or PowerBI
  • Experience with System Integration and Workflow automation across enterprise and software engineering systems including Salesforce or other CRM systems
  • Experience with Application Customization of JIRA Server or Cloud
  • Experience using tools for data extraction and data warehouse modeling such as Azure Data Factory, Snowflake, or Informatica is a plus
  • Knowledge and experience developing custom add-ons to Atlassian Products (JIRA, BitBucket, Confluence) using SIL Powerscript / Scriptrunner / Groovy Script, REST APIs is a plus
  • Experience working in a commercial software product organization is a plus
  • Strong problem solving and analysis skills
  • Effective communication and teamwork skills
  • #LI-SN1

Relativity has over 160,000 users in 40+ countries from organizations including the U.S. Department of Justice, more than 70 Fortune 100 companies, and all of the Am Law 200. Relativity's cloud solution, RelativityOne, offers all the functionality of Relativity in a secure and comprehensive SaaS product. Our company has also been named one of Chicago's Top Workplaces by the Chicago Tribune for seven consecutive years.
If you’re ready to grow with us, we’d love to hear from you.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, or national origin, disability or protected veteran status, or any other legally protected basis, in accordance with applicable law.

Read Full Job Description

Technology we use

  • Engineering
    • .NETLanguages
    • C#Languages
    • JavaLanguages
    • ScalaLanguages
    • AzureLanguages
    • ChefLanguages
    • PowershellLanguages
    • JenkinsLanguages
    • Node.jsFrameworks
    • MySQLDatabases

Location

We’re a community of passionate, life-long learners tackling challenging problems. We care about each other and about our community.

An Insider's view of Relativity

How does your team reward individual success?

Rewarding success is one of my favorite parts of my role. Formally through annual bonus plans, thank you notes in our HR system and of course through promotions. I also like to submit nominations to be recognized at company meetings and spotlights in department newsletters. We move fast at Relativity it’s nice to slow down and just say thanks!

Jessica

Operations Manager, Customer Success and Support

How do you collaborate with other teams in the company?

On the Certification team, I develop exams and study content for our end users. To ensure that our exams are valid, I work with almost every team embracing their expertise and industry knowledge into the development process. It takes continuous interdepartmental collaboration to keep exam content accurate as the Relativity platform evolves.

Sean

Certification Specialist

How has your career grown since starting at the company?

As an Application Support Specialist, I have increased my technical knowledge in SQL database management, Network Administration, and Server Infrastructure. Prior to coming to Relativity, I had zero knowledge of e-Discovery, and now provide On-site training to our clients teaching them about the various e-Discovery tools Relativity has to offer.

Kamal

Application Specialist II

What are some social events your company does?

Our annual user conference, Relativity Fest, is such a tremendous opportunity to get one on one face time with our partners. Fest draws 2,000 platform users and practitioners from all different facets of the industry and being able to connect with them and hear their stories is extremely powerful.

Michael

Platform Account Manager

What are Relativity Perks + Benefits

Relativity Benefits Overview

We have a great selection of benefits from very competitive insurance plans to fun office perks!

Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Onsite Gym
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Performance Bonus
Bonuses are based on a combination of how the company performs as well as how the individual performs.
Child Care & Parental Leave Benefits
Generous Parental Leave
Vacation & Time Off Benefits
Generous PTO
Everyone starts with 18 days of PTO, plus 11 paid holidays every year. Our office is also closed between Christmas and New Years, which does not take away from your PTO balance.
Paid Holidays
Perks & Discounts
Casual Dress
Commuter Benefits
Tax-free transportation opportunities.
Company Outings
We have our annual Summer Jam (picnic that includes friends and family), our User Conference - RelativityFest, and a holiday party each year.
Game Room
Our Cafe houses ping-pong, foosball, and a variety of arcade games - including Killer Queen (a multi-player game that is one of few in the country).
Stocked Kitchen
We have tea, coffee (including fancy espresso machines), a variety of LaCroix, soda, and many other things. We also have fresh fruit delivered twice a week in our pantry areas.
Some Meals Provided
Meals are often provided during morning or afternoon training sessions. There is also always plenty of leftover food from such meetings that employees can dive into after the attendees are finished.
Happy Hours
Different for each team, but always a great time!
Recreational Clubs
RelWOW (Relativity Women of the Workplace), Several Intramural Sports Teams (kickball, softball, volleyball, etc.), Vertikal (climbing group), Working Moms Group, Queeries, and several more.
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
All full-time employees (non-contract) receive $3,000/year to pursue professional development opportunities.
Diversity Program

Additional Perks + Benefits

We also offer a Divvy bike share discount, have Fooda discounts in the office, and offer DRYV Laundry Service for those who have workout clothes that need washing!

More Jobs at Relativity63 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR
Legal
Marketing
Operations
Product
Project Mgmt
Sales
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Marketing
new
Chicago
Operations
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Data + Analytics
new
Chicago
Finance
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
HR
new
Chicago
Operations
new
Chicago
Product
new
Chicago
Project Mgmt
new
Chicago
Developer
new
Chicago
Sales
new
Chicago
Project Mgmt
new
Chicago
Operations
new
Chicago
Marketing
new
Chicago
Operations
new
Chicago
Developer
new
Chicago
Sales
new
Chicago
Product
new
Chicago
Developer
new
Chicago
Design + UX
new
Chicago
Project Mgmt
new
Chicago
Project Mgmt
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago