What are the responsibilities and job description for the Power BI Developer position at Focus America Inc.?
Must Have Skills:
⦁ Power BI
⦁ Dax
⦁ SQL
⦁ Paginated reports
Nice to Have Skills:
⦁ Understanding tables, relationships, keys
⦁ Star vs Snowflake schema concepts
⦁ Fact & Dimension tables
Detailed Job Description:
Key Responsibilities
⦁ Report Development
1. Develop interactive dashboards and reports using Power BI Desktop and Power BI Service
2. Create visually appealing and user-friendly data visualizations
3. Design reports based on business requirements
⦁ Data Modeling & Transformation
1. Build and maintain efficient data models (star/snowflake schema)
2. Use DAX for calculations, measures, and KPIs
3. Perform data transformation using Power Query (M language)
⦁ Data Integration
1. Connect and integrate data from multiple sources (SQL Server, Excel, APIs, cloud sources)
2. Design and maintain ETL processes
3. Ensure data accuracy, consistency, and validation
⦁ Performance Optimization
1. Optimize reports and dashboards for better performance
2. Monitor dataset refresh and troubleshoot issues
3. Improve query performance using best practices
⦁ Collaboration
1. Work with business stakeholders to gather requirements
2. Translate business needs into technical solutions
3. Collaborate with data engineers and analysts
Required Skills & Qualifications
⦁ Technical Skills
1. Strong experience with Power BI (Desktop & Service)
2. Solid knowledge of DAX and Power Query
3. Proficiency in SQL
4. Experience in data modeling techniques
5. Understanding of data warehousing concepts
⦁ Soft Skills
1. Good analytical and problem-solving skills
2. Strong communication skills
3. Attention to detail
Preferred Qualifications
⦁ Bachelor’s degree in Computer Science, IT, or related field
⦁ Experience with Azure (ADF, Data Lake, Synapse)
⦁ Knowledge of Python/R (optional)
⦁ Microsoft Certification (PL-300) is a plus
Experience Requirements
⦁ 6 years of experience in BI/Analytics
⦁ 4 years of hands-on Power BI experience
Key Competencies
⦁ Data visualization and storytelling
⦁ Bsiness understanding
⦁ Time management
⦁ Team collaboration
Minimum Years of Experience:
⦁ 5-8 years
Certifications Needed:
⦁ None
Salary : $40 - $50