Business Intelligence Engineer

We are looking for an experienced developer/analyst who is comfortable working as a Business Intelligence consultant, interacting directly with clients and other developers. The business world changes every day and our competences need to change with it. In order to stay on the cutting edge, our consultants need to be driven to learn and be creative in applying high quality solutions to complex problems. Most importantly, our client’s needs must always be at the center of our efforts! Business Impact is a solutions provider, and our products and service must always meet the end users expectations. Thus, part of your challenge is to translate complex problems into simple analytics that our users can act on. As a consultant, you will represent the full supply chain of data from source to front end reporting, and need to have (or acquire) knowledge of the full process.

The ideal Business Intelligence Engineer must be effective working both independently, and as part of a team environment. Our team at Business Impact works hard, smart and together. The position may be based anywhere in the U.S., with occasional overnight travel to project locations and to our headquarters (est. 15-30%).

Typical Tasks

  • Work both independently and as part of a project team to develop and maintain business intelligence databases, and create reports (Relational and OLAP)
  • Assist clients in solving Ad Hoc data related issues
  • Review user requests, create project specifications and estimate time and cost to fulfill client requirements
  • Meet with client decision-makers and analysts to define requirements and prepare deliverable estimates
  • Enable self-service reporting through development and training of standard reports and dashboards
  • Design, validate, QA, and deploy using ETL/data staging programs
  • Assist in the development of data models and elements, and document how they are used
  • Rapidly learn business and technology concepts while completing projects with concurrent deadlines

Desired Knowledge, Skills and Abilities

  • Experience in Business Intelligence Reporting, visualizing analytics in an actionable way
  • Knowledge of relational data, data warehousing and OLAP concepts (star/snowflake schema design, Kimball methodologies)
  • Familiarity and experience with Transact-SQL, triggers, indexes, views and stored procedures based on business logic
  • Experience with business processes and functions performed by ERP/accounting systems a plus
  • Ability to understand client business data and integrate multiple sources into optimal data structures
  • Ability to build team and customer confidence by being trustworthy and competent
  • Ability to communicate and participate in creating a good work environment

Desired Technical Skills (Not all required!)

  • MS SQL Server 2012/2008/2005
  • SQL Server Data Tools (BIDS) and SSAS, multidimensional and tabular
  • Reporting tools: TARGIT, Power BI, Tableau, SSRS, Yellowfin, other OLAP viewers
  • Database Tools: MS SS Management Studio and Tools, Query Analyzer, SQL Profiler
  • ETL Tools: SSIS, WhereScape, TimeXtender
  • Operating Systems: MS Windows Server 2014 and back
  • Programming Languages: T-SQL, .NET, C#
  • Web/Data Capabilities: IIS, Web Services, JSON
  • Office Productivity Suite: MS Office (Excel, Word, Outlook, etc.)

Preferred Education and Work Experience

  • Bachelor’s degree (or equivalent)
  • Several years of relevant professional experience
  • Working experience with Dynamics NAV, AX, GP, CRM, Ross, or JDE a plus