Senior SQL Server / Data Warehouse Developer

Hybrid in Columbus, OH, US • Posted 39 minutes ago • Updated 39 minutes ago
Contract Independent
Contract W2
12 Months
No Travel Required
Hybrid
Depends on Experience
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • Data-flow Diagrams
  • IBM Cognos Analytics
  • Management
  • Microsoft Azure
  • Dimensional Modeling
  • Documentation
  • IBM
  • Data Processing
  • Data Validation
  • Data Warehouse
  • ELT
  • DFD
  • Data Extraction
  • Data Integration
  • Data Modeling
  • ADF
  • Analytics
  • Catalog Management
  • Conflict Resolution
  • Query Optimization
  • Reporting
  • Snow Flake Schema
  • Optimization
  • Performance Tuning
  • Problem Solving
  • Microsoft SQL Server
  • Microsoft SSIS
  • Microsoft SSRS
  • Technical Writing
  • Transact-SQL
  • Version Control
  • SQL
  • Star Schema
  • Stored Procedures
  • Tableau
  • Warehouse

Summary

Job description:

Technical Skills:

  • Extensive knowledge of Relational and Multidimensional Data Modeling, including dimensional modeling, star schema, and snowflake schema.
  • Strong expertise in T-SQL programming, including SQL queries, stored procedures, triggers, views, functions, and query optimization.
  • Expert-level experience with SQL Server Integration Services (SSIS), including:
  • SSIS error handling and troubleshooting.
  • SSIS Catalog management.
  • Package deployment and configuration.
  • Version control and documentation.
  • Performance tuning and optimization.
  • Strong experience in Data Warehousing and ELT processes, including data extraction, transformation, loading, and data validation.
  • Reporting and analytics experience using IBM Cognos, SSRS, and Tableau.
  • Experience creating and maintaining Data Dictionaries, Data Flow Diagrams (DFDs), and technical documentation.
  • Strong ad-hoc data warehouse troubleshooting and problem-solving skills.
  • Experience gathering data warehouse requirements, analyzing business needs, and translating them into technical solutions.
  • Hands-on experience with Microsoft Azure Synapse Analytics.
  • Experience developing and managing data integration pipelines using Azure Data Factory (ADF).
  • Strong experience with Snowflake Data Warehouse, including data integration, ELT, and data processing.

Mandatory Skills for Resume Screening

Skill

Priority

T-SQL / SQL Server

Mandatory

SSIS

Mandatory

Data Warehousing / ELT

Mandatory

Relational & Multidimensional Data Modeling

Mandatory

Azure Synapse

Mandatory

Azure Data Factory

Mandatory

Snowflake

Mandatory

Cognos / SSRS / Tableau

Required

Data Validation / DFD / Data Dictionary

Required

Work Location: Hybrid remote in Columbus, OH 43268

 
 
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91103975A
  • Position Id: 9147900
  • Posted 39 minutes ago
Contact the job poster
VP

Viswanath Pala

Recruiter @ Atash Enterprises, LLC

Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.