Data Warehouse/ Business Intelligence Developer

LGI · Ottawa, Ontario
Department LGI
Employment Type Full-Time
Minimum Experience Mid-level

About Lim Geomatics:

Lim Geomatics is an industry-leading GIS company that develops geospatial software and data for the forest industry to help forestry companies be more efficient with their office and field operations. By doing so, we empower data-driven sustainable forest management.


With our Forestry Geospatial Platform, forestry companies can uncover actionable insights within their timber harvesting supply chain and set targets and benchmarks to optimize forest operations. Unlike other competitive solutions, our products are the only ones that integrate fully with the ArcGIS platform letting organizations leverage their existing investments in enterprise GIS technology.


At Lim Geomatics, we work on solutions with our customers: There is no box. We don’t settle for the status quo. We celebrate diversity and leverage the creativity and technical expertise of the team. At Lim Geomatics, you will help us discover and realize innovative and game-changing products and solutions for our global customers.

About you:

As business intelligence developer, you understand that it’s an unpredictable world out there and it’s your job to manage it using clean patterns. You’re comfortable with designing good code, solving difficult problems in an understandable and re-usable way, and ensuring quality through appropriate testing. You enjoy working in a cross-functional team of Product, Design, and QA to create great applications and deliver value to customers. Customer satisfaction, team collaboration, and the importance of team reflection and constant improvement are your top priorities.


What you’ll do and how you’ll make an impact:

  • As a key team member, you will help to scope, plan, and execute reporting related developments integrated to web based applications.
  • Collaborate with stakeholders and team members to iterate on solutions and to continually deliver value to our clients
  • Improve the application delivery process using automation and writing testable software
  • Contribute to solutions for new and interesting problems, which often involve spatiotemporal components
  • Participate in the product testing and peer review process
  • Develop yourself personally and professionally by actively setting and achieving ambitious goals
  • Impact Lim Geomatics' growth by developing great applications and solutions


What is required:

  • Comfortable with Agile development practices
  • You have strong SQL scripting abilities and understanding of complex stored procedures, views, data aggregation/manipulation through table joins/queries, database design, normalization and de-normalization techniques
  • You have sound experience in enterprise reporting, BI toolsets, and data integration
  • You have working knowledge and familiarity with Bold Reports, Power BI
  • Good BI design and development skills, and data modelling and data analysis skills
  • Basic understanding of DevOps (Git Repositories, Branching, and Pull Requests)
  • Able to manage a workload that may touch on a few different applications any given week
  • You can independently research and implement solutions to complex problems

What would be an asset:

  • Experience with ESRI technology and mapping solutions
  • Experience using peripheral sensors (GPS, Camera, Bluetooth, Motion) and their data

Thank You

Your application was submitted successfully.

  • Location
    Ottawa, Ontario
  • Department
  • Employment Type
  • Minimum Experience