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. 

• Design, develop, deploy, and maintain enterprise Power BI solutions, including: Semantic Models, Dashboards, Reports, Paginated Reports, KPI Scorecards, Self-Service Analytics Solutions
• Translate 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.

• Design 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.

• Evaluate and optimize report, dataset, and model performance.Utilize tools such as: DAX Studio, Tabular Editor, Power BI Performance Analyzer, VertiPaq Analyzer
• Troubleshoot refresh, query, gateway, and report performance issues.
• Implement incremental refresh, aggregations, DirectLake, Import, DirectQuery, and Hybrid architectures where appropriate.

• Collaborate 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 systems
• Support data validation, reconciliation, and quality assurance activities.
• Assist with migration and modernization initiatives involving cloud and enterprise data platforms.

• Implement and maintain: Row-Level Security (RLS), Object-Level Security (OLS), Workspace Governance, Dataset Certification, Access Management Standards
• Support 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.

• Partner 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.

• Provide 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.

Experience with one or more of the following:

Azure Data Lake Storage (ADLS)

• Fabric Lakehouse
• Fabric Warehouse
• Fabric Data Pipelines
• DirectLake Semantic Models
• Power Platform
• Python for analytics or automation
• Azure DevOps
• Git-based source control
• CI/CD pipelines and automated deployments
• Help advance the organization's modern analytics strategy through the effective use of Microsoft Fabric, Azure Data Factory, Azure Synapse, and Power BI.

• 8+ 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. 

• Expert-level experience with:
• Power BI Desktop
• Power BI Service
• Semantic Models
• Power Query (M)
• DAX
• Paginated Reports
• Deployment Pipelines
• Power BI Administration

• DAX Studio
• Tabular Editor
• Performance Analyzer
• VertiPaq Optimization
• Calculation Groups
• Incremental Refresh
• Composite Models
• DirectQuery and DirectLake Architectures

• Dimensional Modeling
• Star Schema Design
• Fact and Dimension Modeling
• Many-to-Many Relationships
• Data Warehousing Concepts
• Slowly Changing Dimensions (SCDs)

• Advanced SQL development skills:
• Complex joins
• Window functions
• Common Table Expressions (CTEs)
• Stored Procedures
• Query Optimization
• Data Validation

Strong experience with:

• Azure Data Factory (ADF)
• Azure Synapse Analytics
• Microsoft Fabric
• SQL Server