Skip to content
Combined ShapeCreated with Sketch.

Support and Database Management Analyst

Job opportunities

Montreal

Full-Time

Support and Database Management Analyst

Aïdi (www.aidi.io) is revolutionizing the management of construction projects. Our mission is to give a better life to public and private work owners by making it easier and more efficient to monitor and manage all their projects, programs and portfolios. At Aïdi, everything is fast, very fast. Aïdi must continually adapt to the needs of its growing customer-base, by offering an advanced SaaS platform allowing its users to apply the best industry practices while adjusting to the specific needs of each customer. Technology, expertise and human values bring us together. To offer a product that transforms the industry, Aïdi provides a work environment that encourages autonomy and accountability, creating conditions for employees to thrive and succeed the most.

Your role

The candidate will work closely with several internal teams, namely support, implementation, and development, on building ETL pipelines and processes to support data-related requests from our technical support and implementation teams. This role offers an excellent opportunity to be involved in several aspects of the product: investigate and resolve complex support tickets (level 2), develop and test scripts to rigorously import or transfer customer data and set up tools (reports, dashboards and software functions) allowing customers to better visualize the data generated by the use of Aïdi. Since our clients integrate Aïdi to have better visibility on all of their construction projects, this role is central to the company's mission: to make construction projects more predictable using clear, reliable and accurate reporting tools.

Key responsibilities

  • Develop, test and maintain ETL (Extract, Transform, Load) data management processes and tools
  • Import data into the software or develop SQL scripts to facilitate data imports and modifications to our customers' environments
  • Develop, test and maintain SQL scripts to extract raw data from our databases
  • Design and develop Excel or PDF reports allowing customers to visualize the extracted raw data according to their requirements
  • Assist the support team to answer any technical support request requiring further or advanced investigation (level 2)
  • Lead initiatives to better manage software data through the implementation of new tools or the improvement of certain Aïdi functionalities
  • Document tests, reports and scripts and maintain/update the directory of reports for our clients and internal teams

What we are looking for

  • 3-5 years of experience with ETL data management tools and pipelines, preferably applied to a SaaS product
  • Minimum of 1-2 years of experience with SQL queries and ability to manipulate large amounts of data in DBMS or data warehouse
  • Minimum of 2 years of experience in VBA and advanced proficiency in Microsoft Excel
  • Minimum of 1 year of experience using Python scripts to visualize data and able to draw some insights based on complex data sets
  • Minimum of 1 year experience using Jupyter Notebook, Python and data analytics packages, such as Pandas, Numpy, Matplotlib, etc.
  • Rigorous and analytical mindset with particular attention to detail
  • Be resourceful and self-taught to clarify requests that are sometimes vague or incomplete
  • Previous experience using cloud tools such as GCP/AWS (asset)
  • Previous experience in software version management tools (e.g. Github) and agile project management such as Jira (asset)

We got you covered

At Aïdi, we believe in work/health/personal life balance. That's why we offer, in addition to competitive compensation:

  • 3 weeks of vacation per year (and a fourth week after 3 years of service)
  • 10 paid personal days per year (cashable if not taken)
  • Group RRSP employee match contribution (up to 5% of salary)
  • Private health insurance plan including telemedicine
  • A unique “Dream Come True” program after two years of service which contributes up to $5,000 towards a personal project
  • Flexible working hours allowing a hybrid schedule of remote work
  • Several social activities, off-site, "Lunch and Learn" offering a pleasant and motivating work atmosphere

Please apply for this job here!

Struggling to find the apply link? Send us an email tojobs@aidi.io