BI Developer

We've got a position available for a BI developer

Company: Porcupine Union

Purpose of position:

The BI developer will enable data-driven decision making by overseeing the full BI lifecycle, translating business requirements into effective data solutions, designing and implementing ETL processes, developing reports and dashboards, and ensuring insights align with organisational goals.

Responsibilities:

• Collaborating with business users and senior stakeholders to elicit, document, and prioritise requirements
• Conducting workshops, interviews, and analyses to translate business needs into technical specifications, including data models, KPIs, and reporting needs
•  Creating detailed requirement documents, user stories, and functional specs to guide development

• Designing, building, and maintaining robust ETL pipelines to extract data from various sources (e.g., databases, APIs, flat files)
• Transforming data using SQL scripts, stored procedures, or other tools including SSIS/Azure Data Factory
• Loading data into data warehouses or data marts
• Ensuring data quality, integrity, and performance through validation, error handling, and optimisation techniques

 Data warehousing and modelling

• Developing and maintaining data warehouse architectures (e.g., star/snowflake schemas) using SQL Server or cloud platforms (Azure Synapse)
• Implementing slowly changing dimensions (SCD), fact tables, and indexing strategies to support efficient querying and analysis

 Reporting and visualisation

• Creating interactive reports, dashboards, and visualisations using Power BI, SSRS, or similar tools
• Developing DAX measures, calculated columns, and custom visuals to provide actionable insights
• Handling advanced features like row-level security (RLS), parameterised reports, and scheduled refreshes

 Senior business stakeholder management

• Act as a primary point of contact for senior executives, presenting BI solutions, insights, and recommendations in clear, non-technical language
• Managing expectations, providing regular updates on project progress, and facilitating feedback loops to refine deliverables
• influencing data strategy by advising on best practices and emerging trends

 Quality assurance and maintenance

• Performing unit testing, integration testing, and user acceptance testing (UAT) for BI solutions
• Monitoring system performance, troubleshooting issues, and implementing enhancements
• Ensuring compliance with data governance, security standards (e.g., GDPR), and best practices

 Collaboration and innovation

• Working cross-functionally with data engineers, analysts, and IT teams
• Staying updated on BI trends (e.g., AI-driven analytics, real-time reporting), and proposing improvements to processes and tools

Requirements:

• Bachelor's degree in Computer Science, Information Systems, Data Science, or a related field
• Relevant certifications (e.g., Microsoft Certified: Azure Data Engineer, Power BI Data Analyst) are highly desirable
• Minimum 5 years' experience in BI development, with at least 3 years in end-to-end roles covering ETL, reporting, and stakeholder management
• Demonstrated success in delivering BI projects from inception to production
• Relevant experience in industries like finance, retail, or healthcare (advantageous)
• Proficiency in SQL (T-SQL or similar) for querying, joins, aggregations, and performance tuning
• Experience with ETL tools such as SSIS, Azure Data Factory, or Talend.
• Strong knowledge of reporting tools like Power BI (DAX, data modeling, gateways) and SSRS (parameterized reports, deployments)
• Familiarity with data warehousing concepts, including dimensional modeling, OLAP, and big data technologies (e.g., Azure, AWS, or Snowflake).
• Basic scripting knowledge (e.g., Python or PowerShell) for automation is a plus
• Proven ability to manage senior stakeholders, with excellent communication and presentation skills
• Experience in requirement gathering techniques (e.g., JAD sessions, use cases)

Skills and Attributes:

• Proactive and results-oriented with a passion for data-driven decision-making
• Adaptable to fast-paced environments and willing to learn new technologies
• Strong ethical standards, especially regarding data privacy and accuracy
• Strong analytical and problem-solving abilities, with attention to detail
• Ability to work independently and in agile teams, managing multiple priorities

Should you not receive any feedback within ten (10) working days after the closing date, please accept your application as unsuccessful.