The day-to-day responsibilities include but not limited to:
- Recognize business requirements in the context of BI and create data models to transform raw data into relevant insights
- Using Power BI, create dashboards and interactive visual reports
- Define key performance indicators (KPIs) with specific objectives and track them regularly
- Analyze data and display it in reports to aid decision-making
- Convert business needs into technical specifications and establish a timeframe for job completion
- Create, test, and deploy Power BI scripts, as well as execute efficient deep analysis
- Use Power BI to run DAX queries and functions
- Create charts and data documentation with explanations of algorithms, parameters, models, and relationships
- Construct a data warehouse
- Use SQL queries to get the best results
- Make technological adjustments to current BI systems to improve their performance
- For a better understanding of the data, use filters and visualizations
- Transform existing Non-Power BI Reports into dashboards
- Experience with custom/ third party visuals
Essential traits:
- Minimum level of education required is BA/BS degree in computer science or other relevant educational or work experience; advanced degree is a plus
- Background with BI tools and systems especially Power BI
- Excellent Knowledge hands on experience VBA (Visual Basic for Applications), SQL Advance excel are required
- Graduate with 2-5 years experience in Power BI, Advance Excel, VBA SQL
- Prior experience in data-related tasks
- Understanding of the Microsoft BI Stack
- Be familiar with MS SQL Server BI Stack tools and technologies, such as SSRS and TSQL, Power Query, MDX, Power BI, and DAX
- Exposure in implementing row-level security and bookmarks.
- Analytical thinking for converting data into relevant reports and graphics
- Knowledge of Power BI application security layer models
- Ability to run DAX queries on Power BI desktop
- Proficient in doing advanced-level computations on the data set
- Ensure data and insights generated are maintained at high quality standards to meet stakeholder expectations
- Active learning and complex problem solving
- Excellent communication skills are required to communicate needs with client and internal teams
- Proven abilities to take initiative and be innovative
- Analytical mind with a problem-solving aptitude
- Translate business needs to technical specifications
- Open for feedback and learning opportunities
- Can work in metric driven system work independently with onshoreas per requirement
Preferred:
- Microsoft/ Any other BI Certified Data Analyst
