BI Developer

Responsibilities and Qualifications

Advantage Tech is seeking a BI Developer for a Client with a dynamic team in Overland Park, Kansas. The BI Developer’s primarily responsible involves designing and creating Tabular Cubes and SQL Server Reporting Services reports. The BI Developer understands complex business logic and builds code for multi-lingual, multinational applications. This role will interface with other developers and architects on a global basis and ensures that designs and quality are met. This role will also be responsible for taking projects from the requirements phase and see them through deployment. Creativity, drive, initiative and customer service are imperative to success. As a member of the IT team, you will be responsible for on-going process improvements, developing a collaborative environment and building relationships with the business.


Fundamental duties

  • Design, develop and maintain Tabular models based on Operational Data Store and/or Enterprise Data Warehouse
  • Troubleshoot performance issues with large tabular models.
  • Design and develop SSRS reports
  • Create and deliver data products that follow best practice standards and templates
  • ERD and meta data documentation of data services including Tabular models and SSRS Reports
  • Works with users and/or business analysts to define BI requirements
  • Develops proofs of concept to validate ideas or technologies
  • Works with corporate IT to help manage and maintain the BI tools environment
  • Respond and resolve data discrepancies and data issues related to Tabular models and SSRS Reports
  • Software Used: Visual Studios, SSRS, SSAS, SSMS

Minimum Qualifications

  • Bachelor's degree in IT related discipline or equivalent experience
  • 3+ years as a BI developer designing and building reports
  • 2+ years as a Tabular Model Developer
  • Proven experience with the Microsoft Business Intelligence stack
  • Experience with data architecture, including Enterprise Data Warehouse and Operational Data Store
  • Experience translating business requirements into SSRS reports, Tabular Models and SQL views and Stored Procedures
  • Experience tuning queries to optimize for large datasets
  • Proven experience working with complex SQL Queries and multi-domain Enterprise Operational Data Store
  • Experience translating business requirements into reports, dashboard/scorecards, self-service options, and BI query objects


Preferred Experience Requirements

  • Knowledge of ERP application data
  • Knowledge of Supply Chain data
  • Knowledge of Manufacturing and B2B business processes
  • Experience with agile methodologies
  • Strong problem-solving and a strong customer service orientation
  • Can manage multiple competing tasks at the same time


Submit Resume