Senior Power BI Developer – Microsoft Fabric | Avacend, Inc. | Atlanta, GA (Onsite)

Avacend, Inc.; Atlanta (GA); On-site; USD 83,000 - 96,000; Full time

Job summary

Avacend, Inc. is seeking a Senior Power BI Developer with strong Microsoft Fabric expertise to join the Freestyle Data Science & Analytics team on an 18-month on-site contract in Atlanta, GA.

You will design and optimize Power BI reports, semantic models, and Fabric solutions while delivering high data integrity and fast performance. Required 8+ years in BI, advanced DAX, Power Query, RLS, and SQL tuning, with excellent English communication and willingness to work on-site five days a week.

Qualifications

• Minimum 8+ years in BI development and reporting.

Responsibilities

• Design, develop, and maintain scalable Power BI reports and dashboards.

Skills

Power BI development

DAX

Power Query (M)

Row-Level Security (RLS)

SQL performance tuning

Analytical problem solving

English communication

On-site availability

Education

Bachelor's degree in Computer Science / IT / Data Analytics

Tools

Microsoft Fabric development

Git

Azure Synapse Analytics

Azure Data Lake

Job description

Position Summary:

Avacend, Inc. is actively seeking an experienced, high-caliber, and technical Senior Power BI Developer with strong hands-on Microsoft Fabric expertise and 8+ years of progressive professional experience in business intelligence, data modeling, and enterprise reporting to join our client’s Freestyle Data Science & Analytics team on an up-to-18-month contract basis on-site in Atlanta, GA (5 days a week). In this critical BI development role, you will be responsible for designing, developing, optimizing, and maintaining complex Power BI reports, semantic models, and Microsoft Fabric analytical solutions. You will leverage your deep specialist expertise in advanced DAX, Power Query (M), data modeling, Row-Level Security (RLS), and SQL performance tuning to deliver uncompromised data integrity, reporting speed, and operational excellence. This opportunity offers competitive compensation ($60–$70/hr on W2), executive technical visibility, and exceptional career growth prospects within a premier global recruitment and workforce solutions enterprise.

Detailed Job Description:

As a Senior Power BI Developer – Microsoft Fabric supporting Avacend, Inc. on-site in Atlanta, GA, you will take full operational, tactical, and technical ownership of enterprise reporting architecture, semantic model optimization, and data visualization workflows. Your day-to-day responsibilities include building and deploying robust Power BI dashboards, implementing mandatory Microsoft Fabric data solutions, authoring advanced DAX measures and Power Query (M) transformations, configuring semantic models and Row-Level Security (RLS), writing and optimizing complex SQL queries, troubleshooting report performance bottlenecks across production environments, and collaborating closely with data engineers, analysts, and business stakeholders. You will utilize your proactive troubleshooting and analytical problem-solving skills to resolve complex data and rendering anomalies under strict project delivery timelines.

Key Responsibilities:

• Design, develop, test, and maintain highly scalable Power BI reports, executive dashboards, and analytical solutions.
• Implement and manage enterprise data architectures utilizing Microsoft Fabric platform components.
• Author advanced DAX measures, calculated tables, and optimize Power Query (M) data transformation scripts.
• Architect and maintain robust semantic models, star schema data models, and granular Row-Level Security (RLS) policies.
• Write, analyze, and optimize complex SQL queries, stored procedures, and database views for maximum reporting efficiency.
• Lead report performance tuning, query optimization, and memory footprint reduction across large datasets.
• Provide ongoing production support, troubleshooting, and issue resolution for enterprise reporting systems.
• Collaborate seamlessly with data engineering squads, business analysts, and analytics product managers.

Required Qualifications & Skills:

• Bachelor’s degree in Computer Science, Information Technology, Data Analytics, or a related technical discipline.
• Minimum of 8+ years of progressive professional experience in business intelligence development and data warehouse reporting.
• Strong, demonstrable hands-on Power BI development expertise in enterprise production environments (Mandatory).
• Mandatory hands-on professional experience with Microsoft Fabric development and integration (Must-have).
• Advanced practical mastery of DAX, Power Query (M), dimensional data modeling, and star schema architecture.
• Deep practical proficiency in semantic models, role-playing dimensions, and Row-Level Security (RLS) implementation.
• Advanced SQL programming skills and proven experience in report performance optimization and query tuning.
• Exceptional analytical, troubleshooting, debugging, and problem-solving capabilities under complex data conditions.
• Excellent written and verbal English communication skills with strong stakeholder collaboration abilities.
• Mandatory legal work eligibility and physical availability for 5-day-a-week on-site operations in Atlanta, GA.

Nice-to-Have Skills:

• Professional certifications such as Microsoft Certified: Power BI Data Analyst Associate or Azure Data Engineer Associate.
• Prior professional working experience in top-tier consulting firms, healthcare, financial services, or enterprise analytics teams.
• Hands-on familiarity with Azure Synapse Analytics, Azure Data Lake, and modern cloud data pipelines.
• Experience with Git version control for Power BI project files (PBIP) and CI/CD deployment pipelines.

Recruitment Pro Tip:

When applying for this Senior Power BI Developer position at Avacend, ensure your resume explicitly highlights your Microsoft Fabric and advanced DAX portfolio, details your enterprise semantic modeling experience, and confirms your availability for 5-day on-site work in Atlanta.