Bı/Data Warehouse Developer İş İlanı
İşveren Hakkında
- İstanbul(Asya)(Ataşehir)
- Bilişim, İnternet, Yazılım, Bilişim Danışmanlığı
GENEL NİTELİKLER
We are looking for a BI/Data Warehouse Developer who will be in key role to support backend ETL process of business intelligence reporting activities and maintenance of the existing integrations. You will be a part of the Business Solutions & Insights team whose ambition is to help business unlocking the value of internal and external data sources, translating data into actionable, automated dashboards, and promoting data-driven decision making within the company. You will be accountable for developing and maintaining an analytics cube by integrating the data from multiple sources such as API, flat files, SQL DB, sFTP, SharePoint, web services etc.
Key Responsibilities
· Migrate backend data into the data-warehouse, create automated ETL pipelines to process the data required for reporting and refresh schedules to populate the reporting views periodically
· Create/Maintain a star schema structure with facts and dimensions for self-service reporting
· Create/Maintain denormalized schema to improve data modelling efficiency, enable cross functional reporting, reduce latency
· Create/Maintain automations using logic apps in Azure
· Integrate new datasets from multiple sources into the central database
· Cost and usage reporting and performance management
· Test and maintain existing processes and activities
Requirements
- M.S. or bachelor’s degree in Computer Science, MIS, Engineering
- 8+ Years of experience in developing BI and data engineering solutions using Azure data environment and tools (specificallyAzure Data Factory, Azure Synapse, Databricks, Blob Storage, SSMS – SQL Server Management Studio, Logic Apps etc.)
- Our working language is in English and proficiency in both spoken and written is a must
- Expert in creation of data warehousing and BI solutions from the scratch
- End-to-end ETL pipeline development experience
- Capabilities in core and advanced concepts of MS SQL, Python / PySpark / Spark SQL for data engineering such as stored procedures, dynamic programming, creating views, query optimization concepts etc.
- Experience with integration of data from multiple data sources and APIs
- Knowledge of BI tools (Tableau, Power BI, Qlik Sense etc.) is a plus
