Business Intelligence Developer

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.

#LI-MQ1