Data Scientist

We’ve got a position available for an experienced end-to-end SQL developer to join our dynamic team. We call these Data Scientist, but we are really looking for a solid dev.

Company: Porcupine Union

Purpose of position:

This role involves the full BI lifecycle, from gathering business requirements to designing and implementing ETL processes, developing reports and dashboards, and managing relationships with senior stakeholders. The ideal candidate will bridge technical expertise with business acumen, ensuring data-driven insights align with organizational goals. You will work in a collaborative environment, leveraging tools like SQL, SSIS/ADF for ETL, Power BI/SSRS for reporting, and data warehousing principles to deliver high-impact solutions.

• Collaborate with business users and senior stakeholders to elicit, document, and prioritise requirements.
• Conduct workshops, interviews, and analysis to translate business needs into technical specifications, including data models, KPIs, and reporting needs.
• Create detailed requirement documents, user stories, and functional specs to guide development.

• Design, build, and maintain robust ETL pipelines to extract data from various sources (e.g., databases, APIs, flat files), transform it using SQL scripts, stored procedures, or tools like SSIS/Azure Data Factory, and load it into data warehouses or data marts.
• Ensure data quality, integrity, and performance through validation, error handling, and optimisation techniques.

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

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

• Act as a primary point of contact for senior executives, presenting BI solutions, insights, and recommendations in clear, nontechnical language.
• Manage expectations, provide regular updates on project progress, and facilitate feedback loops to refine deliverables.
• Influence data strategy by advising on best practices and emerging trends.

• Perform unit testing, integration testing, and user acceptance testing (UAT) for BI solutions.
• Monitor system performance, troubleshoot issues, and implement enhancements. Ensure compliance with data governance, security standards (e.g., GDPR), and best practices.

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

• 5+ years in SQL development, with at least 3 years in end-to-end roles covering ETL, reporting, and stakeholder management.
• 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.
• 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 Power Shell) for automation is a plus.
• Demonstrated success in delivering BI projects from inception to production.
• Experience in industries like finance, retail, or healthcare is advantageous.

• Proven ability to manage senior stakeholders, with excellent communication and presentation skills.
• Experience in requirement gathering techniques (e.g., JAD sessions, use cases).
• 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.