Ntech Inc Atlanta ,Georgia 60.00 - 60.00 $ Per Hour 06/Sep/2023
Requirements:
7+ years of Experience in Data Warehousing and Business Intelligence
5+ Years in BI development leveraging the Microsoft SQL Server. Needs to be an expert in T-SQL
5+ Years in SSIS and use of Stored Procedures.
1-2 Years in Azure Data Factory, SQL VMs, build and maintain ETL
Ingest and aggregate data from both internal and external data sources to build our data lake
Strong understanding of data modeling (i.e., conceptual, logical, and physical model design, Experience with Operation Data Stores, Enterprise Data warehouses, and Data Marts).
Deep understanding of relational database design concepts and SQL programming
Experience guiding/mentoring developers with lesser Experience.
Requires strong analytical, conceptual, and problem-solving abilities.
Strong Experience with business intelligence and data warehousing design principles and industry best practices.
Good to have:
1-2 Years in Azure Data Warehouse (Synapse)
1-2 Years of knowledge of utilizing Python, PySpark, and SparkSQL On Azure Cloud
|
|
Amount
|
of Experience
|
|
|
|
|||
|
Data Modeling
|
Required | 5 | Years |
|
Data Warehousing and Business Intelligence
|
Required | 5 | Years |
|
Microsoft SQL Server, T- SQL, PL/SQL
|
Required | 6 | Years |
|
SQL Server Integration Services
|
Required | 5 | Years |
|
Azure Data Factory, SQL VMs
|
Required | 3 | Years |
|
Azure Data Warehouse
|
Required | 2 | Years |
|
Python, PySpark, SparkSQL on Azure Cloud
|
Highly desired | 2 | Years |