Business Intelligence Data Engineer


Kiefer Consulting is currently seeking a BI Data Engineer with Sharepoint knowledge to work on client-facing engagements in the Sacramento area.
The BI Data Engineer position requires strong business and technical skills. Responsibilities include data modeling, batch processing, data matching, data search, and duplicate record checking. It also includes integrating data quality tools in a Microsoft environment. Excellent communication skills and working as part of an integrated team are critical.



  • Assist with the design, development, implementation, and support of the customer’s Business Intelligence (Data Warehouse) and Business Analytic platform’s data architecture, including assessment of the client’s current model, and offer suggestions to improve performance, data handling, and development process efficiencies.
  • Lead developer to integrate new data quality components within the client’s Platform
  • Develop and support of detailed dimensional data models.
  • Develop detailed multi-dimensional (i.e. OLAP) databases in conjunction with team members.
  • Provide ETL design, development, implementation and support of the customer’s Business Intelligence & Business Analytic data for the warehouse.
  • Assist and guide customer technical staff in extracting data from the source system into the data warehouse staging area, ensuring data validation, data accuracy, data type conversion, and business rule application.
  • Prepare documentation, as part of the knowledge transfer process, which will enable the customer’s technical team to continue with the ongoing maintenance and operations of the BIBA system.
  • Design, develop, refactor, and support web service calls to stored procedures to consume data



  • A BS degree in information systems, computer science, or software engineering related field.
  • Experience with Microsoft SQL Server 08/12/14, SSIS, SSAS, SSRS, PPS; including experience with customer systems that have over 15 million record updates daily.
  • Experience developing and calling web service APIs
  • Experience with Microsoft Visual Studio 2010 and Team Foundation Server 2010.
  • Experience with data requirements gathering and analysis.
  • Experience with integrating data quality tools from companies such as Experian, Trillium, Informatica, etc.
  • Experience with data requirements gathering and analysis
  • Familiarity with multi-dimensional (OLAP) databases.
  • Experience translating dimensional data models into physical data structures.
  • Familiarity with data management and database administration concepts, principles, and processes.
  • Experience working as a BI Data Engineer on at least one project involving the design, development, implementation, and deployment of a BI software solution using the Microsoft BI Toolset. For this requirement, the amount of experience gained on each project must have been at least six full-time equivalent months.
  • Experience working as a BI ETL Developer on at least one IT project involving the design, development, implementation, and deployment of a BI software solution relatively large in size and complexity (over 15 million records).



Experience with Government technology projects.
Excellent verbal and written communication skills and the ability to interact professionally with a diverse group including executives, managers, and subject matter experts (technical and non-technical).


Location: Sacramento

Kiefer Consulting, Inc. is an equal opportunity employer.