Job Description
Is this role right for you?
In this role, you will:
• Developing SQL queries / ETL packages using T-SQL and SSIS to ingest data from source systems to integrate with SQL Server data warehouse.
• Design and develop physical data model structures in SQL Server
• Design and development of high-quality dashboards / reports using tools like Power BI, SSRS, Crystal Report, Excel/PowerPivot, and Tableau. Develop custom reports, analytics and KPI’s for the Business
• Builds and maintain proper documentation, data lineage and extract-transform-load (ETL) processes.
• Collecting business requirements / user stories while working in a lab with a product owner, Business Analyst, Scrum Master, and application developers.
• Developing SQL views to enable data consumers to read data from data warehouse also optimizing and enhancing current jobs performances metrics.
• Documenting databases, data process flows and maintain data dictionaries, support and onboarding...