Job Posting Title: SQL Developer
Work Location: Halifax, NS (Permanent remote)
Description:
We are seeking a skilled SQL Developer for an enterprise initiative related to ServiceNow CMDB/ITAM/APM Reporting and Analytics. This role involves creating, managing, and enhancing enterprise-wide processes in coordination with IT operations. The ideal candidate will have advanced SQL coding skills (T-SQL/Spark SQL) and experience with automated reporting solutions using the Power Platform (Power BI, Power Automate, etc.). Key responsibilities include data discovery, mapping, scripting, and automation. The role also involves collaborating with IT operation teams to clarify business rules, processes, and policies.
Required Qualifications:
- Bachelor’s Degree in Computer Science or related field
- Minimum of 2 years’ experience in SQL programming
- Proficiency in various SQL syntaxes including T-SQL and Spark SQL
- Expertise in writing complex SQL queries, data discovery, creation, and management
- Experience with temporary tables, data scrubbing, preprocessing, and query optimization
- Skilled in designing and managing stored procedures, CTE commands, and common SQL functions/techniques
- Minimum of 2 years’ experience with Power BI, including creating automated dashboards and using DAX
- Experience with various ingestion methods (Direct Query, Import, Live) and creating automated dataflows
- Ability to create vibrant visualizations and perform drill-ins and cross-filtration
Nice to Haves:
- Experience with ServiceNow (CMDB, ITAM, APM)
- Experience with cloud technologies like Azure Synapse Analytics and/or Azure Databricks
- Knowledge of serverless (datalake) and server-driven (warehouse) data systems
- Experience with APIs and semi-structured data