United Software Group Inc. - Canada
SQL Developer
What's your preference?
Job Description
- Req#: JPC - 10180057
- Bachelor's Degree in Computer Science or related field
- Minimum of 2 years’ experience within (SQL programming)
- Preferable - 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 dataflow
- Creating vibrant and usable visualizations for operations.
- Creating drill ins and cross filtration
SQL Developer
Work location : Halifax, NS (Permanent remote)
12 Months Contract
Description:
This resource is needed for an enterprise initiative associated to ServiceNow CMDB/ITAM/APM Reporting and Analytics. This includes creating, managing, and advancing enterprise-wide processes with coordination of IT operations. The candidate needed will need to have superior coding skills within SQL (T -SQL/Spark SQL) and 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. The other aspects of this role include partnering with IT operation groups to clarify business rules, processes, and policies.
Required Qualifications:
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
About the company
United Software Group, Inc. (USG) is a Global Information Technology Consulting Company established in the year 2002 with its Headquarters in Columbus-Ohio, USA. USG is operating a business in 6 countries USA, Mexico, Canada, UK, Ireland and India. USG is a Minority Owned Enterprise (MBE) offering IT consulting, Talent Management and Staff Augmentation Solutions to its Clients. USG is recognized by INC5000 as Americas Fastest-Growing Private Companies and is honored with A+ rating by BBB as a mark of a trustworthy customer-oriented organization. USG’s services are based on requirements specified by operational business users from different industries such as Banking & Financial, Consumer Good and Distribution, Telecommunication, Insurance, Engineering, Healthcare, Life Sciences, Retail, Manufacturing and Automotive.