Power BI Developer (Contract Role) Armstrong Fluid Technology

About Armstrong Fluid Technology

Job Description

Job Summary: We are seeking a highly skilled Power BI Developer / Data Analyst to design, build, and maintain scalable business intelligence solutions. The ideal candidate will possess strong analytical acumen and hands-on expertise with the Microsoft BI stack to deliver actionable insights that drive data-informed decision-making across departments. Key Responsibilities: Data Modelling & Architecture: Design robust semantic data models, define relationships, hierarchies, and KPIs that align with business rules and analytics goals. Data Transformation: Utilize Power Query (M) and SQL to cleanse, transform, and aggregate data from diverse sources including enterprise systems, data warehouses, and APIs. Visualization & Storytelling: Build insightful and interactive dashboards, reports, and visualizations in Power BI that translate complex data into clear, business-relevant narratives. Advanced Analytics: Develop and optimize complex DAX measures and time-intelligent calculations to support trend analysis, forecasting, and comparative insights (e.g., YoY, MTD, YTD). Collaboration: Partner with cross-functional stakeholders (business, IT, operations, and management) to gather requirements, understand pain points, and deliver tailored BI solutions. Performance Optimization: Monitor, troubleshoot, and enhance report performance and refresh schedules for high-volume datasets using Direct Query or Import modes. Governance & Documentation: Ensure compliance with data governance policies and maintain thorough documentation for data lineage, metrics definitions, and BI processes. Required Skills and Qualifications: Bachelor's or Masters degree in Computer Science, Information Systems, Data Analytics, or a related field. 5+ years of hands-on experience in Power BI development, including data modelling, Power Query, and advanced DAX. Solid understanding of data warehousing concepts, ETL pipelines, and relational database management systems (e.g., SQL Server, Oracle). Proficiency in SQL for querying and transforming data across large datasets. Familiarity with Python for data processing or integration is a plus. Strong analytical and problem-solving skills with a keen attention to detail. Excellent communication skills to convey technical concepts and business insights effectively. Experience working in Agile environments and with tools like Jira, or Confluence is advantageous. Tools and Technologies: Power BI Desktop and Power BI Service (publishing, scheduling, and workspace management) Microsoft SQL Server (SSMS, SSIS, T-SQL) Power Query (M) and DAX Excel (Power Pivot, Power Query,