Duties & Responsibilities

  • Support the analysis, design, implementation and testing of Business Intelligence software, systems and reports.
  • Development of data warehousing components and packages
  • Design, build, and manage SQL Server databases in the Azure cloud
  • Analyze flat files to design and build star schemas and snowflake schemas to hold the data in SQL Server
  • Design, build, and deploy tables that support slowly changing dimensions (Type 2 & Type 4)
  • Design, build, and deploy SSIS packages to perform ETL into SQL Server
  • Create stored procedures to aid in aggregation of data, data loads, and data exports
  • Monitor and debug daily scheduled jobs that load and export data
  • Review and implement best practices for data manipulation
  • Create and support Azure Data Factory pipelines
  • Optimize databases using indexes and SQL optimization
  • Review and document databases, tables, views, and ETLs
  • Model data into Data Marts to be used by Azure Analysis Services
  • Build tabular models for Azure Analysis Services and create DAX measures
  • Coaching, mentoring and development
  • Data analytics
  • Operational Maintenance and Support
  • Research and Development actively engage in future state discussions and designs.
  • Provide accurate and detailed report/presentations for technology and architecture decision making

 Desired Experience & Qualification

  • Com Informatica or BCom Business Informatic or BSc. Computer Science or relevant qualification
  • Microsoft BI certification
  • Azure Data Analyst Associate or Azure Data Engineer Associate certificate an advantage
  • BI STACK (SSAS, SSRS, SSIS) including SQL. AZURE DATA LAKES, DATA FACTORY, DATA BRICKS
  • Full BI Stack development (SSAS, SSRS, SSIS) including SQL including BI STACK (SSAS, SSRS, SSIS) including SQL. AZURE DATA LAKES, DATA FACTORY, DATA BRICKS

 What I need:

  • Azure
  • SQL Server
  • DWH
  • Azure data lakes
  • Azure Data bricks
  • Azure Data Factory
  • BI/Azure Developer – BI Stack, Azure, Corporate Finance (advantageous)

 Characteristics

  • Self-disciplined, development professionalism
  • Excellent attention to detail
  • Demonstrates a driven, creative, self-motivated personality with a strong desire to succeed
  • Open to learning and self-development

 Experience 

  • 5+ years’ experience in business intelligence
  • 5+ years’ experience in relational database design and build
  • 5+ years’ advanced T-SQL and SQL scripting experience
  • 5+ years’ advance data analysis experience
  • Data presentation design and build (reports and dashboard) experience
  • 5+ years’ ETL process design, build and troubleshoot experience
  • 5+ years’ data warehouse design, build and maintenance experience
  • 5+ years’ advance Microsoft Excel experience
  • Experience and sufficient knowledge of Microsoft SQL Server Integration Services (SSIS 2017), Microsoft SQL Server Reporting Services (SSRS 2017), Microsoft SQL Server Analysis Services (SSAS 2017) and Microsoft Power BI
  • DevOps – code repository and version control

Learn more/Apply for this position