BI Developer in Fairfield, OH at Interactive Business Systems

Date Posted: 11/1/2019

Job Snapshot

Job Description

Business Intelligence Developer
6 Months Right to Hire

3 Positions Open

Fairfield, OH

Requires SQL assessment test to be completed at the time of submission

Primary Skils:

ETL: DataStage, Cognos, and SAS

DB: SQL and DB2


  • develop reliable, reusable, automated and streamlined ETL code
  • design and develop BI data marts, reports and dashboards
  • teach teammates so that we all learn and grow together
  • create reconciliation procedures and data checks to ensure data quality
  • build in automated audit, balancing and controls 
  • provide production support, including on-call rotation and technical assistance to end-user and IT staff 


  • a bachelor's degree or have equivalent experience in computer science or related discipline.
  • proven experience distilling business requirements into data warehouse design artifacts such as a Facts Qualifier Matrix (FQM), Source to Target Maps and ultimately star schema data models
  • experience with Test Driven Development (TDD)
  • expert-level expertise with SQL, Data Modeling and Dimensional Modeling
  • experience in: designing and implementing ETL processes (preferred tools:  IBM's DataStage, SQL Server SSAS, SAS); developing BI dashboards (preferred tools:  IBM's Cognos, Microsoft's Power BI); creating data quality scorecards and data lineage; mentoring and teaching teammates; leading within the Kanban/ Agile space

Interested candidates should send a resume to the attention of Amrita Baliga  at Interactive Business Systems (

IBS offers a competitive salary and comprehensive benefits package to all employees. Referral and sign-on bonuses may also be available.

About IBS: IBS, Interactive Business Systems, Inc., is an IT solutions and staffing company known for achieving business objectives and bottom-line results through the smart architecting, implementation and management of technology. In three decades of developing the technology applications, tools, environments and teams that foster top business performance, we have become an industry-leading IT services provider.