BI Developer

Strategic Data Systems

DataStage, Cognos

  • Senior BI Developer
Business Intelligence Developer – Position Description
Our IT department is currently seeking an experienced BI developer contractor to build data pipelines that provide peace of mind for people by equipping them to make data-informed business decisions.
If you’re ready to build productive relationships, collaborate within a diverse team, embrace challenges and develop your skills, then Cincinnati may be the place for you.  
Be ready to:
  • strive to continuously learn and hone your craft
  • listen to business needs and design data models that support business outcomes
  • 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 
Be equipped with:
  • 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, SQLSvr 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