SQL Developer

$93,600 - $106,080/Yr

NTT DATA - Louisville, KY

posted about 2 months ago

Full-time - Entry Level
Remote - Louisville, KY
1,001-5,000 employees
Professional, Scientific, and Technical Services

About the position

NTT DATA is seeking a Remote SQL Developer to support an enterprise initiative associated with ServiceNow CMDB/ITAM/APM Reporting and Analytics. This role involves creating, managing, and advancing enterprise-wide processes in coordination with IT operations. The ideal candidate will possess superior coding skills in SQL (T-SQL/Spark SQL) and will be responsible for developing automated reporting solutions using the Power Platform, including Power BI and Power Automate. The position primarily focuses on data discovery, mapping, scripting, and automating solutions, requiring collaboration with IT operations to clarify business rules, processes, and policies. This is a consumer-facing role that involves direct collaboration with Associate Directors, Managers, and front-line operations, necessitating excellent communication and responsiveness. The SQL Developer will be tasked with writing complex SQL queries, managing data creation and discovery, and utilizing declarative variables. Responsibilities will also include the creation and management of temporary tables, data scrubbing and preprocessing, query optimization, and designing stored procedures. The role requires familiarity with common SQL functions and techniques, as well as experience in creating automated dashboards using Power BI and coding in DAX. The candidate should also have experience with various ingestion methods and creating automated dataflows that provide vibrant visualizations for operations. This position is an excellent opportunity for individuals looking to grow within a forward-thinking organization that values innovation and inclusivity. NTT DATA is committed to helping clients innovate, optimize, and transform for long-term success, and this role plays a crucial part in that mission.

Responsibilities

  • Support enterprise initiatives related to ServiceNow CMDB/ITAM/APM Reporting and Analytics.
  • Create, manage, and advance enterprise-wide processes in coordination with IT operations.
  • Develop automated reporting solutions using Power Platform tools such as Power BI and Power Automate.
  • Conduct data discovery, mapping, scripting, and automation of solutions.
  • Collaborate with IT operations to clarify business rules, processes, and policies.
  • Write complex SQL queries for data discovery, creation, and management.
  • Create and manage temporary tables and perform data scrubbing and preprocessing.
  • Optimize queries through techniques such as partitioning, indexing, and scans.
  • Design and manage stored procedures and utilize common SQL functions and techniques.
  • Create automated dashboards in Power BI and code in DAX for data visualization.
  • Implement various ingestion methods for data processing.

Requirements

  • Bachelor's degree in computer science or related field.
  • 2+ years of experience in SQL programming, specifically T-SQL and Spark SQL.
  • Experience writing complex SQL queries with data discovery and management.
  • Proficiency in creating and managing temporary tables and performing data scrubbing.
  • Knowledge of query optimization techniques such as partitioning and indexing.
  • Experience designing and managing stored procedures and using common SQL functions.
  • 2+ years of experience with Power BI, including creating automated dashboards.
  • 2+ years of experience using various data ingestion methods (Direct Query, Import, live).
  • 1+ year of experience creating automated dataflows and visualizations.

Nice-to-haves

  • Experience with ServiceNow (CMDB, ITAM, APM).
  • Familiarity with cloud technologies like Azure Synapse Analytics and Azure Databricks.
  • Knowledge of serverless and server-driven data systems.
  • Experience with APIs and semi-structured data.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service