BI Developer

BI Developer
Chicago, IL – hybrid WFH (onsite 3 days/week in the loop)

Summary
The BI Developer works to support various professional services staff (primarily HR, Accounting and Legal) to develop reports, dashboards and analytics. This team will get requests from different departments, where data that needs to be accessed is in different systems. So this person will have the opportunity to work dynamically across a range of business systems and home grown applications to query databases, and develop insights to empower the business. You will be managing tickets through ServiceNow and Jira.

What you'll be doing

1. Perform complex data analysis, query and report development leveraging our main financial system(s) where applicable and other custom business systems as needed;
2. Work with the end users, developers and team management to understand business processes and requirements; identify gaps, communicate and define requirements for technical solutions including reporting, data warehousing and general application development;
3. Assist in the development of process changes or new technical solutions to satisfy the business need for projects and daily operations;
4. Develop reports using BI Tools, including IBM Cognos, Tableau, Business Objects and other tools for management reporting and financial analysis; connect and create SQL-statement-based queries or tools to facilitate data analysis;
5. Work with the BI Solutions team to develop data analysis models; create reports against source and data warehouse technologies; assist the business units in their information needs and end user reporting solutions;
6. Work with end users to address ad-hoc data analysis requests; determine the proper course of action to manage appropriate timelines via ticketing systems such as Service Now and JIRA;
7. Partner with cross-functional teams, including BI Strategy, various IT and accounting teams, and end-users, to facilitate effective communication and ensure a holistic understanding of business requirements and information delivery plan;
8. Troubleshoot data and application issues with end users; fully analyze the impact and determine the strategy for a resolution; fully test and reconcile reports and data analyses; assist in the implementation of the solution;
9. Assess the BI readiness of a business area, and, when appropriate, conduct thorough analysis of existing business processes to implement a BI solution from requirements gathering through post-implementation support.

Skills we're seeking

1. 2+ years of experience BI Development
2. Strong experience with SQL, including writing complex SQL queries
3. Experience developing reports and dashboards with Tableau and/or Cognos
4. Strong Excel experience, including Advanced Excel experience

Nice to haves

1. Bachelor's Degree, ideally in Computer Science or a related IT or Analytics field
2. Experience working in professional services environments
3. Experience with Cognos Analytics and/or TM1
4. Experience with Power BI
5. Experience with SSRS, SSAS, SSMS