Responsibilities
•Understand business requirements of BI context and design a data model to transform raw data into meaningful insights
•Use Power BI to create dashboards and interactive visual reports. Connect Power BI to multiple data sources like OOTD, Databases, Excel, etc.
•Design, Development, Testing, providing Power BI scripts, performing detailed analysis
•Perform DAX queries and functions in Power BI
•Analyzing the current ETL process, defining and designing new systems
•Design, build and deploy BI solutions
•Data warehouse development and working with SSAS, SSIS, SSRS
•Maintain and support data analytics
•Conduct unit testing and troubleshooting
•Design, develop and deploy business intelligence solutions with SQL queries for best results, filters, and graphs to better understand your data at all levels for performance improvements and suggestions
•Collaborate with users and team members at various levels for suggestions and improvement.
•Publish dashboard workspace online
•Develop and update technical documentation
Requirements
•BSc/BA in Computer Science, Engineering or relevant field
•2-3 years of experience in data-related roles
•Experience in BI tools and systems such as Power BI, Tableau, SAP, etc.
•Background in data warehouse design (e.g. dimensional modeling) and data mining
•In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
•Familiarity with BI technologies (e.g. Microsoft Power BI, Oracle BI)
•Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
•Proven abilities to take initiative and be innovative
•Analytical mind with a problem-solving aptitude