BI Developer

AFL manufactures industry-leading fiber optic cable, connectivity and accessories and provides engineering and installation services for some of the largest telecom customers in the world. Our company was founded in 1984 with a single fiber optic cable and today, we manufacture thousands of products, generate an excess of $3B in revenue, and employ approximately 12,000 associates worldwide. At AFL, we recognize that our employees are our greatest asset. We hire and train each individual, investing in them to ensure success in their careers. With a commitment to professional development and growth, let us connect you to your next career opportunity.What We Offer:Flexible time off policy 401K Company match (up to 4% - dollar for dollar)Professional development, training, and tuition reimbursement programsExcellent medical, dental, vision, and life insurance policy optionsOpportunities for career advancement with an industry leading company!We are seeking an experienced Senior Power BI Developer to join our Enterprise Information Management (EIM) team. This role is responsible for designing, developing, optimizing, and supporting enterprise reporting and analytics solutions across the Microsoft data platform. The ideal candidate is a highly skilled Power BI professional with deep expertise in semantic modeling, DAX, SQL, data warehousing, and cloud-based analytics platforms including Microsoft Fabric, Azure Data Factory, Azure Synapse Analytics, and SQL Server. This position will be able to work remotely from anywhere in the United States while supporting primarily East Coast hours.This individual will partner closely with business stakeholders, business analysts, data engineers, and architects to deliver scalable, secure, and high-performing reporting solutions that enable data-driven decision making. The role requires strong technical expertise, hands-on development experience, performance tuning capabilities, and a passion for building enterprise-scale business intelligence solutions.Key ResponsibilitiesPower BI Development & ArchitectureDesign, develop, deploy, and maintain enterprise Power BI solutions, including: Semantic Models, Dashboards, Reports, Paginated Reports, KPI Scorecards, Self-Service Analytics SolutionsTranslate business requirements into scalable reporting and analytics solutions.Design and implement dimensional data models using star schema and best-practice modeling techniques.Develop advanced DAX calculations, measures, calculation groups, KPIs, and time intelligence solutions.Create efficient Power Query (M) transformations to cleanse, standardize, and prepare data for reporting.Build executive, operational, and analytical dashboards that provide actionable insights.Data Modeling & AnalyticsDesign and maintain enterprise semantic models and reusable business metrics.Implement fact and dimension models, hierarchies, aggregations, and composite models.Develop analytical solutions supporting operational reporting, performance management, and business intelligence initiatives.Ensure consistency of KPI definitions and data calculations across the reporting ecosystem.Support self-service reporting while maintaining governance and data quality standards.Performance OptimizationEvaluate and optimize report, dataset, and model performance.Utilize tools such as: DAX Studio, Tabular Editor, Power BI Performance Analyzer, VertiPaq AnalyzerTroubleshoot refresh, query, gateway, and report performance issues.Implement incremental refresh, aggregations, DirectLake, Import, DirectQuery, and Hybrid architectures where appropriate.Data Integration & Engineering CollaborationCollaborate with data engineers to design and support data pipelines and analytics solutions.Work with data sourced from: Azure Data Factory, Azure Synapse Analytics, Microsoft Fabric, SQL Server, Excel and other enterprise systemsSupport data validation, reconciliation, and quality assurance activities.Assist with migration and modernization initiatives involving cloud and enterprise data platforms.Governance & SecurityImplement and maintain: Row-Level Security (RLS), Object-Level Security (OLS), Workspace Governance, Dataset Certification, Access Management StandardsSupport deployment pipelines and release management processes across Development, Test, and Production environments.Ensure compliance with enterprise BI governance standards, naming conventions, and development best practices.Maintain technical documentation, data dictionaries, and reporting standards.Stakeholder EngagementPartner with business stakeholders to gather requirements and define reporting solutions.Facilitate workshops and requirements discovery sessions.Provide guidance on KPI development, reporting strategy, and visualization best practices.Present findings and recommendations to technical and non-technical audiences.Serve as a subject matter expert for Power BI and enterprise reporting.Mentoring & LeadershipProvide technical leadership and mentorship to junior and mid-level developers.Conduct design reviews and code reviews.Promote Power BI development standards and best practices across the organization.Contribute to strategic planning and continuous improvement of the analytics platform.Required QualificationsExperience8+ years of experience in Business Intelligence, Data Analytics, or Data Warehousing.5+ years of hands-on Power BI development experience.Experience delivering enterprise-scale reporting and analytics solutions.Experience working directly with business stakeholders and technical teams.Technical SkillsPower BIExpert-level experience with:Power BI DesktopPower BI ServiceSemantic ModelsPower Query (M)DAXPaginated ReportsDeployment PipelinesPower BI AdministrationAdvanced Power BI Performance TuningDAX StudioTabular EditorPerformance AnalyzerVertiPaq OptimizationCalculation GroupsIncremental RefreshComposite ModelsDirectQuery and DirectLake ArchitecturesData ModelingDimensional ModelingStar Schema DesignFact and Dimension ModelingMany-to-Many RelationshipsData Warehousing ConceptsSlowly Changing Dimensions (SCDs)Database & Query DevelopmentAdvanced SQL development skills:Complex joinsWindow functionsCommon Table Expressions (CTEs)Stored ProceduresQuery OptimizationData ValidationAzure & Microsoft Data PlatformStrong experience with:Azure Data Factory (ADF)Azure Synapse AnalyticsMicrosoft FabricSQL ServerPreferred QualificationsExperience with one or more of the following:Azure Data Lake Storage (ADLS)Fabric LakehouseFabric WarehouseFabric Data PipelinesDirectLake Semantic ModelsPower PlatformPython for analytics or automationAzure DevOpsGit-based source controlCI/CD pipelines and automated deploymentsHelp advance the organization's modern analytics strategy through the effective use of Microsoft Fabric, Azure Data Factory, Azure Synapse, and Power BI.Job SummaryRequisition Number: BIDEV009040Job Category: IT - Business AnalystsSchedule: Full-Time