
Data Business Intelligence, Power BI Analyst
AIG
full-time
Posted on:
Location Type: Hybrid
Location: Dallas • New Jersey • North Carolina • United States
Visit company websiteExplore more
Salary
💰 $56,000 - $89,000 per year
About the role
- Design, develop, and maintain Power BI dashboards and reports to deliver clear and actionable insights.
- Collect, clean, and transform raw data into structured datasets optimized for reporting.
- Write and optimize SQL queries to extract and analyze data from relational databases.
- Collaborate with business users to gather requirements, define KPIs, and translate them into reporting solutions.
- Develop and maintain data models (Power Query, DAX, tabular models) to support reporting needs.
- Conduct data analysis to identify trends, anomalies, and opportunities for improvement.
- Ensure accuracy, integrity, and security of data across reporting systems.
- Provide training and support to business users on Power BI dashboards and self-service reporting.
- Work with IT, data engineering, and other cross-functional teams to improve data availability, governance, and reporting infrastructure.
- Document processes, data models, and reporting logic for future reference and knowledge sharing.
Requirements
- 3–5 years of experience in a BI Analyst, Data Analyst, or related role.
- Proficiency in Power BI (DAX, Power Query, data modeling, visualizations).
- Strong experience with SQL (queries, joins, stored procedures, performance tuning).
- Solid understanding of ETL processes and working with data from multiple sources.
- Strong analytical and problem-solving skills, with attention to detail.
- Ability to communicate findings clearly to both technical and non-technical stakeholders.
Benefits
- Competitive benefits
- Health, wellbeing, and financial security focus
- Professional development opportunities
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
Power BIDAXPower QuerySQLETL processesdata modelingdata analysisreporting solutionsdata transformationperformance tuning
Soft Skills
analytical skillsproblem-solving skillsattention to detailcommunication skills