SQL Business Intelligence Developer

Information Technology Chicago, Illinois


Position at InnerWorkings

SQL Business Intelligence Developer

The Business Intelligence Developer will be responsible for developing reports and documenting procedures, for both internal and external use.



  • Build complex queries on disparate data sets and performance tune existing queries
  • Translate business needs into tabular reports
  • Maintain existing and build new SSIS packages to facilitate data movement for internal and external requirements
  • Collaborate on an Agile development team
  • Perform Code Reviews against established group Coding Standards
  • Document new reporting features or bugs from both internal and external users
  • Coordinate testing of reports with users
  • Generate standard or custom reports summarizing business, financial, or economic data for review by executives, managers, clients, and other stakeholders.
  • Maintain or update business intelligence tools, databases, dashboards, systems, or methods
  • Assist with project management activities by identifying project milestones, phases, and elements
  • Track activities, resolving problems, and publish progress reports
  • Manage timely flow of business intelligence information to users
  • Perform unit and regression testing for new features



  • 3+ Years work experience
  • Bachelor’s degree in a business or technology related discipline
  • 3+ years T-SQL experience
  • Experience with SSIS, SSRS, SSAS, and other report writing tools
  • Experience with Git and Agile methodologies
  • Strong Microsoft Excel skills related to data analysis and manipulation
  • Good troubleshooting and error isolation skills
  • Must be able to interact and communicate with individuals at all levels of the organization
  • Experience working in a public company and adhering to SOX compliant policies is a plus
  • Experience working in a multinational company a plus