Data Solutions Specialist

**About BEEM - From data to action**

At BEEM, we’re on a mission to democratize the access and use of data for any organization, regardless of their size. To do so, BEEM relies on passion and innovation to propose modern SaaS data solutions. We believe that it should be a simple process to use and monetize all accessible data. We empower our clients with intuitive software platforms like the BEEM platform and Fleet by BEEM app, built to remove the complexity of using, transforming and automating data-driven actions, at scale. Everything we do is aimed at creating a delightful and personalized experience, from our solutions to our on-boarding and support. And with our team, we pride ourselves in making sure every member is growing personally and professionally. We believe in a good company that respects people's individual skills and expertise, provide a creative and flexible work environment, and, if need be, Wine and Scotch on Thursday pm

**The opportunity...**

As a Data Solutions Specialist, you develop modern data pipelines and datasets to meet key business objectives and provide end-to-end data solutions. At BEEM, working in an Agile environment, you will be responsible to architect, implement and regularly manage data models and ELTs that will enable our clients' teams to access consistent metrics across their data ecosystem via the BEEM data platform. Your work will directly impact their ability to defining, developing and managing curated datasets, key business metrics and reporting across functional units. You are a self-starter and you are comfortable working cross-functionally with other teams internally, and as well as with the clients' internal teams, when acting as an extension to their teams. Your daily involvement will require you to be equally happy coding and tech-leading the team to implement the solution.

**The team will need you to...**
- Communicate, analyse and translate client requests into conceptual and detailed data solutions with estimates
- Design, build, develop, and maintain BEEM Data's transformation pipelines consolidating various data sources (streaming or batch) into our manage data lakes & warehouses
- Allow our client's or partner's analytics team to do more, faster, by building logical and understandable data models to house data pulled in their data lake
- Develop clean, tested, maintainable code in a continuous integration + continuous deployment environment
- Work as a collaborator in the product R&D team to influence and scope new features and functionality to better help you and our users
- Ensure the highest standard of data governance by crafting data contracts and service level agreements, automating data lineage tracking, data cataloging and runtime validations
- Define and improve our data methodologies to influence our product roadmap and guide junior teammates
- Assure effective collaboration between BEEM Data’ and the client’s teams, encouraging open communication and advocating for shared outcomes

**You'll bring to the team...**
- 1-3 years in data engineer or software engineer role with significant experience in data engineering
- Minimum 1 year of experience with SQL and understand how to write and tune complex queries
- DEC or BS/BA in Computer Science, or equivalent experience
- Excellent communication and client management skills
- You have professional experience designing, creating and maintaining scalable data pipelines
- Experience with BI tools architecture and governance, such as PowerBI
- You've wrangled enough data to understand how often the complex systems that produce data can go wrong
- You have a good understanding of data modelling (ie. Staging, Marts, Dimensional). Experience with DBT is a plus.
- Experience with databases, data lakes and warehouses (SQL, NoSQL, S3, Redshift, BigQuery, Snowflake, Azure)
- Experience with cloud environments (in particular AWS & Google Cloud) as well as cloud solutions like Kubernetes, Docker, etc.
- Knowledge of source control with Git, CI/CD pipelining, and experience writing automated unit and functional tests
- Have a security mindset - should be able to understand compliances (GDPR, SOX, CCPA, PIPEDA)
- Bilingualism French & English (mandatory)

**Bonus Points**
- Passion, drive and willingness to make a difference by building awesome software products
- Experience in working in a fast paced and quickly evolving tech environment
- Experience with batch data pipelining frameworks (Spark, Airflow)
- Experience with modern ETL tools (Fivetran, Stitch, etc.)

**You'll benefit from...**

At BEEM, we’re one team and we treat each other like family; we believe in equity and the workplace should be as enjoyable as much as home. ;-)
- Flexible remote work policy (within the current context of Covid-19, employees are mostly working remotely and can use our office space when needed, in accordance with the government sanitary recommendations)
- A 500$ budget allocation to make your work-at-home env