- Company Name
- AIFA Solutions
- Job Title
- Technical Business Analyst -SQL, Power BI
- Job Description
-
**Job Title:** Technical Business Analyst – SQL, Power BI
**Role Summary:**
Technical Business Analyst responsible for gathering business and technical requirements, designing and delivering data visualizations, reports, and dashboards using SQL, Power BI, and Excel. Acts as a liaison between business stakeholders and technical teams to ensure accurate, actionable insights and efficient reporting processes.
**Expectations:**
- Translate stakeholder needs into clear technical specifications.
- Produce high‑quality, data‑driven visualizations and reports.
- Optimize SQL queries and automate reporting workflows.
- Maintain data governance, security, and compliance standards.
**Key Responsibilities:**
- Collect, analyze, and document reporting and analytics requirements.
- Design, develop, and maintain Power BI dashboards and interactive reports.
- Write and tune SQL queries for data extraction, transformation, and analysis.
- Build and support Excel‑based reports (pivot tables, advanced formulas, macros).
- Collaborate with business, data, and IT teams to ensure data accuracy and consistency.
- Provide insights and recommendations based on data analysis.
- Automate manual reporting tasks to improve efficiency.
- Ensure adherence to data governance and security policies.
**Required Skills:**
- Strong SQL proficiency (query writing, joins, performance optimization).
- Hands‑on Power BI expertise (data modeling, DAX, dashboard creation).
- Advanced Excel abilities (pivot tables, complex formulas, VBA/macros preferred).
- Experience in reporting, analytics, and data visualization.
- Excellent analytical, problem‑solving, and detail‑orientation skills.
- Strong verbal and written communication for stakeholder interaction.
**Required Education & Certifications:**
- Bachelor’s degree in Business Administration, Computer Science, Information Systems, Data Analytics, or related field (or equivalent experience).
- Relevant certifications (e.g., Microsoft Certified: Data Analyst Associate, SQL certifications) are a plus but not mandatory.