Skip navigation
Technical Consultant, Business Intelligence
Apply Now

Technical Consultant, Business Intelligence

Job Snapshot

Employment Type Full-Time
Job Type Information Technology
Education Not Specified
Experience Not Specified
Manages Others Not Specified
Industry Computer Software, Consulting
Required Travel Not Specified

Job Description

Position:                      Technical Consultant, Business Intelligence


FLSA Status:              Exempt


Service Area:              Technology


Location:                     Naperville Office



Job Description:

Sikich is looking for a Business Intelligence Developer to join our technology team to be based out of our corporate headquarters located in Naperville, IL. This is a great opportunity to join a growing organization with a recognized brand name within the professional services industry.     

This position creates and modifies SQL Server data warehouses, SQL Server Analysis Service models and cubes, custom stored procedures, SQL Server Integration Services and works with OData feeds. Responsibilities include coding, testing, debugging, documenting and maintaining those services.  Applicants should be competent to work on most phases of these applications, but may require instruction and guidance in some areas. This position may perform systems analysis functions. Work assignments are well defined; requires guidance in choosing techniques to meet objectives. Assists in research and fact-finding, in implementation and maintenance of databases, in development of software code and in programming applications.  


  • The application developer should be fundamentally sound in Programming and competent to work on general application programming activities
  • Responsible for employing best practices in creating a complete schema including tables, relationships, stored procedures, views, indexes and triggers
  • Design and deploy SSIS packages
  • Data mining using T-SQL for ad-hoc request from clients
  • Participate in the code review and acceptance process in order to enhance the delivery
  • Design logical data models and translating into physical database structure that integrate with the existing database structures
  • Responsible for monitoring databases to optimize database performance, resource use and physical implementations of databases
  • Design and handle the various aspects of the end to end life cycle related to complex data warehousing and business intelligence projects
  • Build and maintain SQL scripts including database objects such as stored procedures, views and functions for data extraction and analysis
  • Design and deploy complex OLAP cubes for efficient analysis of facts in multiple dimensions
  • You will work closely with the senior development staff as well as business analysts, user experience teams, quality assurance staff, and project managers gaining exposure to all phases of the software development life cycle
  • Comfortable in a fast-paced, dynamic environment with excellent interpersonal communication skills
  • Reprioritize and shift gears as necessary to deliver critical functionality in time to meet our customers’ needs while ensuring quality
  • Complete assigned tasks as directed in a timely manner using good object oriented coding practices and standards
  • Unit test code for proper functionality
  • Follow the established standards, patterns and process
  • Not afraid to seek guidance when needed to make good decisions
  • Participate in team planning activities
  • Enjoy software development

Job Requirements


  • Associates Degree in Computer Science or related discipline 
  • 2+ years of business intelligence experience 
  • 2+ years of database development experience, SQL Server, T-SQL, SSIS, SSAS, and SSRS
  • Extensive experience of writing SQL Queries, Views, Stored Procedures and Functions in SQL Server 2005/2008/2012
  • Excellent written and verbal communication skills
  • Experience with Internet/Intranet websites with (C#/VB.NET) Visual Studio, ASP.NET, and IIS (web-based, database-driven applications)
  • Experience with Excel PowerPivot and converting PowerPivot models to SSAS a plus
  • Experience with Accounting/ERP systems or knowledge of Accounting Processes a plus

Company Overview:

Sikich LLP is a nationally-ranked top 50 public accounting and consulting firm. Working at Sikich, you’ll become part of a highly motivated and competent team that values individual effort and growth while encouraging balance between your personal and work life. We recognize that our people are our most valuable asset—our employees drive our success.  

Sikich is honored to have been named a Top Workplace by the Chicago Tribune and recognized nationally as a Best and Brightest Company to Work For. If you're looking to take your career to the next level, learn more about Sikich — and the possibilities for you. Visit us as 

Working for Sikich: 

We recognize that our people are our most valuable asset—our employees drive our success. That’s why Sikich believes in empowering our people with real time career development, offering diverse and challenging work, and providing solid growth opportunities.  We're always looking for talented people to join our team. If you have a let’s get down to business, roll up your sleeves mindset, then Sikich is the place for you. 

To apply for this position, please submit your cover letter and resume to [Click Here to Email Your Resumé] 

View More Job Details


My client in the financial services industry is looking for a MS BI archite...
My client is hiring for a SQL Server Developer to help build a new team. Th...
SQL Server Developer A rapidly growing company is in need of a SQL Server D...
Senior Developer - Oracle PL/SQL ETL and OBIEE Reporting MDI Group - IT Workforce Solutions for What's Next
Senior Developer - Oracle PL/SQL ETL and OBIEE Reporting Rosemont, IL Contr...
ETL Development/Consulting Lead Forbes Technical Consulting, LLC
Our client is looking for an ETL Development/Consulting Lead . This is a fu...
CareerBuilder Tip:
For your privacy and protection, when applying to a job online, never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction. Learn more.

By applying to a job using you are agreeing to comply with and be subject to the Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.

Technical Consultant, Business Intelligence

Enter notes about this job: