The Role : Job Responsibilities
Data Analysis & SQL Development
- Write complex SQL queries to extract, manipulate, and analyze data from multiple databases
- Develop and maintain stored procedures, views, and functions
- Perform data validation, cleansing, and quality assurance
- Optimize SQL queries for performance and efficiency
- Create automated data extraction processes and ETL workflows
- Collaborate with database administrators to ensure data integrity
Power BI Report Development
Design and develop interactive dashboards and reports using Power BI DesktopCreate and maintain Power BI datasets and data modelsImplement DAX calculations for advanced analyticsPublish reports to Power BI Service and manage workspace permissionsSchedule automated data refreshes and monitor report performanceCreate custom visualizations and implement best practices for dashboard designBusiness Analysis & Requirements Gathering
Work with stakeholders to understand business requirements and translate them into technical specificationsConduct data discovery sessions to identify key metrics and KPIsPerform gap analysis and recommend solutions for business challengesDocument functional requirements and create user storiesFacilitate workshops and requirements gathering sessionsCreate process flow diagrams and business process documentationStakeholder Management & Communication
Present findings and insights to business users and executive leadershipTrain end-users on Power BI reports and self-service analyticsProvide ongoing support and maintenance for deployed solutionsCreate user documentation and training materialsCollaborate with IT teams, data engineers, and other analystsIdeal Profile :
Required Qualifications
Experience
1-2 years of experience in business analysis or related roleProven experience writing SQL queries and working with relational databasesHands-on experience developing Power BI reports and dashboardsExperience with data analysis and reporting in a business environmentTechnical Skills
Advanced SQL proficiency including :o Complex joins, subqueries, and window functions
o Stored procedures and functions
o Data manipulation (INSERT, UPDATE, DELETE)
o Performance optimization techniques
Power BI expertise including :o Report and dashboard development
o DAX calculations and measures
o Data modeling and relationships
o Power Query for data transformation
o Power BI Service administration
Experience with database systems (SQL Server, MySQL, PostgreSQL, or similar)Knowledge of data warehousing concepts and ETL processesProficiency in Microsoft Excel (advanced formulas, pivot tables)Analytical Skills
Strong problem-solving and critical thinking abilitiesExperience with statistical analysis and data interpretationKnowledge of business intelligence concepts and methodologiesUnderstanding of data visualization best practicesAbility to identify trends, patterns, and anomalies in dataSoft Skills
Excellent written and verbal communication skillsStrong presentation skills with ability to explain technical concepts to nontechnical audiencesDetail-oriented with strong organizational skillsAbility to manage multiple projects and priorities simultaneouslyCollaborative mindset with strong interpersonal skillsPreferred Qualifications
Education & Certifications
Bachelor's degree in Business Administration, Computer Science, Information Systems, or related fieldMicrosoft Power BI certification (DA-100 or PL-300)SQL Server certifications (MCSA or equivalent)Six Sigma or Lean certification is a plusAdditional Experience
Experience with cloud platforms (Azure, AWS)Knowledge of programming languages (Python, R, VBA)Experience with other BI tools (Tableau, QlikView, Looker)Understanding of Agile / Scrum methodologiesWhat's on Offer?
Opportunity to make a positive impactExcellent career development opportunitiesPure Work From Home