Business Intelligence Developer

Chicago, Illinois


Full Time

$120k - $140k

Job Description Are you a talented Business Intelligence Developer with a passion for finance and wealth management? Do you thrive on using cutting-edge technology to analyze and transform data? If so, we have an exciting opportunity for you! We are a prestigious Chicago-based investment and wealth management firm, serving a select group of ultra-high-net-worth families across the country since 1997. With over $8 billion in assets under management, the company is renowned for its independent thinking, investment approach, and exceptional performance results. We are seeking a full-time Business Intelligence Developer to design and build reports and dashboards using the MS SQL Server BI Stack, including SSRS and TSQL, Power Query, and PowerBI. You will also play a crucial role in managing the firm's development pipeline using Azure DevOps. Working in a cross-functional team, you will develop and test solutions, create documentation, and collaborate with technical users, business users, and external vendors.

Join our dynamic team of experts and make a significant impact in the finance and wealth management industry. This is a fantastic opportunity to work in downtown Chicago, grow your skills, and contribute to a renowned investment firm with a strong commitment to excellence. If you have a background in finance or wealth management, along with expertise in data analysis and development, apply now to become a part of our forward-thinking and success-driven culture.

Required Skills & Experience
  • Bachelor’s degree or equivalent experience in Computer Science, Management Information Systems, Finance, or another related field
  • Experience designing and building reports and dashboards using MS SQL Server BI Stack, including TSQL and SSRS, Power Query, and PowerBI
  • Strong knowledge and experience with database fundamentals are essential. This includes expertise in designing both multidimensional and relational databases to ensure efficient data organization and retrieval.
  • 3-5 years of hands-on experience working with MS SQL and the Azure platform
  • Proficiency in SQL Server Integration Services (SSIS)
  • Microsoft suite skills, including SharePoint, Power Apps, and Power Automate
  • Experience developing data services APIs to share data infrastructure
Desired Skills & Experience
  • Experience with CRM software, especially Microsoft Dynamics 365
  • Experience in wealth management or financial services vertical
  • Familiarity with API management and integration techniques
What You Will Be Doing Tech Breakdown
  • 30% MS SQL Server BI Stack
  • 30% Azure DevOps
  • 40% SSIS (SQL Server Integration Services)
Daily Responsibilities
  • 60% Hands On
  • 20% Management Duties
  • 20% Team Collaboration
The Offer You will receive the following benefits:
  • Medical, Dental & Vision (HSA, FSA options)
  • Employer Paid Life Insurance
  • Employer Paid Short Term Disability
  • Employer Paid Parental Leave (12 weeks)
  • Optional Life Insurance, Long Term Disability, Spousal & Child Life Insurance
  • 401(k)
  • Flexible Schedules
  • 15 Vacation Days, 5 Sick Days, 1 Floating Holiday
  •  Education Reimbursement Programs
Applicants must be currently authorized to work in the US on a full-time basis now and in the future.


Posted by: Mia Quinn