Welcome to Lakergrow Dispensary
IT Database Developer
We are currently seeking candidates for the position of IT Database Developer.
Reporting to the Business Solutions Manager, the IT Database Developer is responsible for providing database and application solution strategy, technical design, architecture, and support for carrying out the implementation of enterprise database development.
This individual will apply proven communication, analytical and problem-solving skills to contribute to core organizational functions around Organigram’s architectural vision and direction around data, long-term data analytics, business intelligence and data warehousing to maximize the benefit of IT systems investments.
The database developer will work with various stakeholders, understand business wants and needs, and be proficient in software development lifecycle management processes.
Responsibilities:
Work with the leadership of the functional team in assessing requirements and providing technical assistance for architecting, executing, and developing the right database architecture;
Provide leadership and guidance regarding data modelling best practices, data governance and quality practices. Ensure data adheres to enterprise governance standards and maintain credibility and reputation of high-quality data;
Create the blueprint for cloud based BI architecture to support Organigram’s data analytics solutions that deliver’s information to the relevant users efficiently;
Develop integrations of commercial off the shelf (COTS) solutions with Organigram’s internally created software solutions and legacy IT systems;
Focus on database modeling, optimization, modernization, and performance improvement;
Deliver on overall data analytics strategy and build integrated solutions that are in line with the architecture framework and meets business requirements;
Establish and champion best data management practices to integrate, centralize and govern data sources;
Provide thought leadership in adopting and promoting Artificial Intelligence / Machine Learning tools and techniques in solving complex business problems;
Lead and mentor junior resources;
Create systems models, specifications, diagrams and charts to provide direction to system programmers;
Review and analyze, as well as encoding, testing, debugging and documenting of various data related systems;
Writing codes for database access, adjustments, and creations, as well as for stored procedures;
Identifying data sources, constructing data decomposition diagrams, providing data flow diagrams, and documenting the process;
Coordinate and perform in-depth tests, including end-user reviews, for modified and new systems;
Provides high-level database development assistance in creating specific applications for businesses;
Provides general support on information technology to design, develop, execute, and maintain the database application systems within Microsoft Intelligent Data Platform as well as on-premises database systems;
Works harmoniously in a cross-functional team comprising managers, supervisors, business analysts, systems personnel, network staff, and other developers in ensuring the delivery of software solutions as planned, within set budget, and timely;
Provides excellent customer service by responding to and assisting with resolving issues, including system outages;
Performs administrative duties as well as some project management tasks;
Other duties as required.
Qualifications:
College diploma or university degree in the field of computer science, information science or equivalent and 5+ years related work experience;
A proven track record in data management, governance, data design and database architecture;
Possess extensive experience with Transact-SQL and Microsoft SQL Server;
Knowledge of Microsoft Intelligent Data Platform and Azure;
Proficient in using enterprise ETL/ELT data integration tools, as well as in manipulating, processing and extracting value from large, disconnected datasets;
Knowledge of data lake storage and data warehousing solution components (e.g., Azure Data Lake, Synapse, Databricks, snowflakes);
Experience in troubleshooting and maintaining existing software applications;
Experience with Visual Studio and Microsoft 365 stack;
Must have a good knowledge of regularly used concepts, practices, procedures, software development lifecycles; application integration techniques; and relational database design;
Ability to communicate ideas in both technical and user-friendly language;
Proven analytical and creative problem-solving abilities;
Experience working in a team-oriented, collaborative environment;
Able to follow instructions and standard guidelines, which are needed to effectively perform the duties of the position.
While we thank all candidates for their interest, only those selected will be contacted.
Organigram is an equal opportunity employer.