Power BI Developer (only W2)

Job Title: Power BI Developer

Location: Louisiana, MO 63353 (Onsite)

Implementation: Infosys

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

⦁ Business understanding

⦁ Time management

⦁ Team collaboration

Regards

Andrew

ampstekandrew@gmail.com