SQL (NCS/Job/ 3870)
Job Skills
Job Description
Job description:
Primary Duties and Responsibilities:
5+ years of SQL Server ETL Development experience using SSIS, Azure Data Factory and Azure Databricks. Strong ETL, data warehouse, T-SQL skills.
Understanding of data warehouse and data mart architecture, and Kimball methodology.
5+ years of strong hands-on experience building large-scale databases
Design, build and launch efficient & reliable data pipelines to move and transform data
Broad understanding and experience of data modeling, data management, ETL and BI
Experience in building enterprise data warehousing with table partitioning, encryption and data compression
Experience with cloud migration
Perform ongoing monitoring, automation and refinement of reports and BI solutions.
Work with BI Management to identify and resolve data related issues.
Work with business departmental teams to help them define and document business requirements for new metrics and reports.
Participate in process reviews and enhancements.
Provide analysis and issue resolution on business reported concerns.
Participate in design and delivery of cubes, dashboards and various self-service business intelligence solutions.
