HUB International

Job description

About HUBHUB International Limited (“HUB”) is a top-10 global insurance and employee benefits broker, providing a broad array of property, casualty, risk management, life and health, employee benefits, investment and wealth management products and services. With over 11,000 employees and over 450 offices throughout North America, HUB is dedicated to helping individuals and businesses evaluate and manage their risks and insurance needs.About The PositionHub is seeking a Senior Business Intelligence Developer on our Data Analytics & Technology team. We seek individuals who have a passion for data and data visualization techniques to turn complex data sets into actionable insights. The Senior BI Developer plays a critical role in partnering with business folks across HUB to develop insightful and actionable reports. He/she will primarily be responsible for requirements gathering, design, development, testing, deployment, and support of complex reporting solutions.As part of the Data Analytics & Technology team, the successful candidate will have the opportunity to work with a collaborative team that is responsible for driving the adoption of data driven decision making by developing insightful and actionable reports.Responsibilities

  • Lead the design, development, analysis and delivery of SSRS reporting platform for operational reporting.
  • Build Visualization, dashboards, and AD-HOC reports in SSRS, PowerBI and Power Pivot DAX or MDX queries.
  • Have experience in report integration and creations with Microsoft`s SharePoint and MDS capabilities.
  • Works with complex queries; using specialized business technologies and applications.
  • Performs unit testing to validate accuracy and validity of reports and data integrity.
  • Provides user (business and client) training in BI reporting tools and reports as needed.
  • Troubleshoots and resolves data integrity and performance issues.
  • Create actionable business intelligence tools and reports.
  • Perform and maintain data extracts and imports.
  • Supervise small team of onshore/offshore development and quality assurance resources to insure timely delivery of all reporting solutions.
  • Performs tasks and duties related to ad hoc report analysis, design and processing.
  • Provide production support of existing reports and processes
  • Communicate issues, risks, and concerns proactively to management
  • Works with business, client and technical teams to gather and define requirements, author concise functional/technical documentation and provide status and project updates.


  • Bachelor’s degree – preference in computer/information sciences or business/commerce.
  • Experience supervising small teams of developers and quality assurance analysts.
  • Minimum of 7 + years’ experience in BI Reporting (SSRS, Power BI, Tableau). We prefer SSRS and PowerBI.
  • Requires strong analytical, conceptual and problem-solving abilities.
  • 5+ years of experience with T-SQL
  • Experience developing and delivering SSAS cubes a plus, including having DAX experience
  • Experience in Master Data Management with MDS being a plus
  • Experience with SharePoint report integration and mobile deployment a plus
  • Knowledge of best practices in enterprise wide SSRS report development, report security, reports delivery and implementation, and scaling the reports to have high availability.
  • Experience with various database administration tools (SQL 2005/2008, ORACLE), SQL clusters MSCS, reporting tools (SSRS, report writer) and ETL tools (DTS/SSIS) is a plus.
  • Strong in T-SQL and relational database technologies.
  • Comfortable reading and interpreting XML
  • Ability to function under close deadlines with minimal supervision and under potentially stressful situations.
  • Superior oral and written communication skills.
  • Nights, weekends, and non-regular hours may be required.

\Location: United States, Illinois, ChicagoRequired Education: Bachelor’s degree (4-year degree)Required Experience: 5-7 yearsRequired Travel: No travel requiredDate published: 30-Jan-2018Department: Information TechnologyRef#: P2173_20180117HUB International Limited is an equal opportunity and affirmative action employer that does not discriminate on the basis of race/ethnicity, national origin, religion, age, color, sex, sexual orientation, gender identity, disability or veteran’s status, or any other characteristic protected by local, state or federal laws, rules or regulations. The EEO is the Law poster and its supplement is available here at .We endeavor to make this website accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact the US Recruiting Team toll-free at (844) 300-9193 or . This contact information is for accommodation requests only; do not use this contact information to inquire about the status of applications.