SQL Developer

SQL Developer

Work location: Halifax, NS (Permanent remote)

Contract Duration: 12 Months

Description:

This resource is needed for an enterprise initiative associated with ServiceNow CMDB/ITAM/APM Reporting and Analytics. This includes creating, managing, and advancing enterprise-wide processes with coordination of IT operations. The candidate will need to have superior coding skills within SQL (T-SQL/Spark SQL) and the ability to create automated reporting solutions using the Power Platform (Power BI/Power Automate/etc.). The majority of workloads in this role are associated with data discovery, mapping, scripting, and automating solutions. Other aspects of this role include partnering with IT operation groups 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
• Variety of SQL syntax experience in order [T-SQL, Spark SQL]
• Writing complex SQL queries with data discovery, creation, and management using declarative variables (Declare/Sets) and soft coding parameters in queries/subqueries
• Creation and management of temporary tables
• Data scrubbing and pre-processing
• Query optimization (Partitioning, Indexing, and Scans)
• Designing and managing stored procedures
• CTE commands
• Common SQL functions/techniques (wildcards, case statements, mathematical operations, group by, having, where, etc.)
• Minimum of 2 years’ experience with Power BI, creating automated dashboards that depend on Server and/or serverless connections
• Experience using various ingestion methods (Direct Query, Import, Live); experience coding in DAX is a must
• Creating automated dataflows
• Creating vibrant and usable visualizations for operations
• Creating drill-ins and cross filtration

Nice to have:

• Experience with ServiceNow (CMDB, ITAM, APM) is a MAJOR plus
• Experience working within cloud technologies like Azure Synapse Analytics and/or Azure Databricks
• Experience working with or having knowledge of serverless (datalake) and server-driven (Warehouse) data systems
• Experience with APIs and semi-structured data