This job board retrieves part of its jobs from: Toronto Jobs | Emplois Montréal | IT Jobs Canada

  Jobs in Canada  

Bringing the best, highest paying job offers near you

Slide 1
Slide 2
Slide 3
previous arrow
next arrow

AedoAI Inc.: Database Engineer

AedoAI Inc.

This is a Full-time position in Ottawa, ON posted August 6, 2021.

AedoAI, Inc, is currently seeking someone who is passionate about transforming data into usable solutions that solve business problems for the Construction industry.

Your mission at Aedo will be to work with our partners to continuously improve the way the world is designed, constructed, and operated by empowering the workforce with technology, data, and insights that deliver value to workers first.From a data and technology perspective, the construction industry, and especially the Trade Contracting arm of construction, lags almost all other industries.

Data is not just siloed across multiple (often legacy) systems, but large quantities of it still exist only on paper or in spreadsheets that exist on a single manager’s desktop.

We bring together construction industry experts with top engineering, analytics, and data science talent to help rethink and redefine how construction plans, manages, and connects with data generated in the field.

Our partner’s platform enables project teams to simplify field data capture and easily share critical performance details across their organization, giving real-time insights into production and safety conditions on the jobsite.

Who you areYou’re very familiar with relational databases and have at least 3 years’ experience You have expert knowledge in ETL development with experience processing extremely large datasets within cloud-based data warehouses such as Snowflake, or Amazon RedshiftA comprehensive understanding of database structures, database administration, and query optimization.You have excellent SQL skills, with the ability to generate complex SQL queries from an entity-relationship diagram.Understanding of and experience with data archival strategies.You have 2+ years of experience with software development.You write clean, maintainable, and thoughtful code.You work well in a self-starter environment.You are comfortable working remotely, and have worked with remote teams before.You are excited by working on unfamiliar things and experimenting with new technologies.You play well with others, and know how to check your ego at the door.You want to work in an environment where learning, self-improvement, and personal and professional development are not only encouraged, but an important and necessary part of the job.Experience with Looker preferred.Experience with dbt preferred.

What you will doBuild systems, tools, and documentation to enable and empower data users to confidently build accurate dashboards, run data research projects, instrument features, and support outcome studies.Implement data model and ETL code improvements to improve pipeline efficiency and data quality.Own the data warehouse and enforce data consistency across downstream tools.Assist software engineers with the creation and maintenance of robust, scalable database code, and evaluates new and existing code for performance and scalability.Create and implement data archiving strategies and tools.Mentor software engineers and share your knowledge on how to write solid code..Work on a self-managed Agile team to build and maintain our applications.Maintain database performance by developing tuning methodologies and monitoring performance.Design and architect scalable software solutions for a growing software company.Take on challenges when you see them.

Nothing in the codebase is off limits, so if you see an opportunity to improve something, we aims to empower you to fix it.Regularly participate in peer code reviews.Bring new tools and ideas to the team to better improve our existing processes.Identify tech debt and work with other engineers to come up with solutions.Suggest and prioritize features, and express and defend your convictions.Research technology and write tech specs for complex new features.Participate in building our culture.

We have weekly team hangouts and a couple hackathons a year, and once we are able to gather, we will resume off-site team building activities.Continue to grow and learn new things.

We provide an annual stipend for professional improvement.

If there is an area of the product that you are interested in, we will do our best to give you opportunities that line up with those interests.Current tech stackCurrently converting our client codebases to TypeScriptReact/Redux for our web clientReact-Native/Redux for our mobile clientDjango 2.2/Python 3.7PostgreSQLHosted on AWS