Business Intelligence Developer

Job Purpose

Be responsible for migrating LINK’s Connect system data warehouse to Google’s BigQuery and Google DataFlow / Apache Beam. To manage ongoing business intelligence needs and analyze and develop new requirements. Troubleshoot issues and ensure efficient and timely resolution to these, communicating with key stakeholders as needed.

Key Performance Indicators

The Primary Indicator Will Be

• Job duties performed accurately and within strict timelines
  
  

Secondary Indicators Will Include

• Clear, concise communication internally and externally
• Demonstrates a high degree of integrity and professionalism
  
  

Business Requirements & Analysis Experience

• Migrate existing data warehouse and batch ETL process to BigQuery / DataFlow
• Works with internal and external customers and IT partners to develop and analyze business intelligence needs.
• Interprets business requirements and determines optimum BI solutions to meet needs
• Scope and estimate work involved in producing new reports and dashboards
• Troubleshoots problems with existing reports / ETL process, develop solutions
  
  

Information And Quality Assurance

• Creates data quality tickets, as needed
• Verifies the data collected is within required quality standards
• Recommend quality metrics and ensures quality metrics are documented and tracked
  
  

Research/Evaluation

• Identifies and provides input to new technology opportunities that will have an impact on the enterprise wide BI systems
• Provides input into business requirements for the design of solutions
• Provides input to the development of information quality metrics
  
  

Skills And Experience

• Strong experience of Google’s BigQuery
• Strong experience with Google DataFlow / Apache Beam
• Experience migrating star schema data warehouses to BigQuery
• Experience migrating older ETL systems to Apache Beam
• Database extraction, analysis and testing as part of data assurance
• Experience with Microsoft Power BI or similar reporting applications
• Experience creating reports and analytical dashboards
• Data anonymization
• Continuous integration & deployment experience (GIT, JIRA, Atlassian, other)
• Excellent organization and administration skills
• Fluent in English (read, write and speak).
• Able to build and maintain strong relationships with LINK staff and external customers where required.
  
  

Personal Attributes

• Good communicator and able to provide clear feedback to the clients and team
• Provides guidance and problem-solving assistance to other team members
• Well dressed, professional appearance, with a confident, positive and respectful manner
• Be highly motivated and keen to succeed
• Be service and ‘team’ orientated
• Be able to manage relationships
• Have good written and verbal communication skills
• Able to ‘multi-task’ and manage multiple issues and projects
• Presents as a professional and knowledgeable individual with good listening skills and high levels of empathy with others
• Have high levels of enthusiasm and energy
• Shows flexibility in approach and able to change and adapt to circumstances
  
  

Qualifications

• Typically requires 5-7 years of Business Intelligence or related technical experience
• Knowledge of one or more business functional areas
• College degree preferred
  
  

Our organization is dedicated to fostering a workplace environment that values diversity and inclusion. We actively seek to attract, recruit, and nurture talent from a broad spectrum of backgrounds, each contributing unique perspectives, ideas, and experiences. Our goal is to cultivate a productive and inclusive atmosphere that represents various cultures and groups, where everyone is given an equal opportunity to thrive.

Your needs and preferences are important to us, and we are committed to ensuring an equitable and accessible recruitment process. If you feel you need any reasonable adjustments to be made in order to apply for a vacancy at Link, please contact us at [email protected]

Job Purpose

Be responsible for migrating LINK’s Connect system data warehouse to Google’s BigQuery and Google DataFlow / Apache Beam. To manage ongoing business intelligence needs and analyze and develop new requirements. Troubleshoot issues and ensure efficient and timely resolution to these, communicating with key stakeholders as needed.

Key Performance Indicators

The Primary Indicator Will Be

• Job duties performed accurately and within strict timelines
  
  

Secondary Indicators Will Include

• Clear, concise communication internally and externally
• Demonstrates a high degree of integrity and professionalism
  
  

Business Requirements & Analysis Experience

• Migrate existing data warehouse and batch ETL process to BigQuery / DataFlow
• Works with internal and external customers and IT partners to develop and analyze business intelligence needs.
• Interprets business requirements and determines optimum BI solutions to meet needs
• Scope and estimate work involved in producing new reports and dashboards
• Troubleshoots problems with existing reports / ETL process, develop solutions
  
  

Information And Quality Assurance

• Creates data quality tickets, as needed
• Verifies the data collected is within required quality standards
• Recommend quality metrics and ensures quality metrics are documented and tracked
  
  

Research/Evaluation

• Identifies and provides input to new technology opportunities that will have an impact on the enterprise wide BI systems
• Provides input into business requirements for the design of solutions
• Provides input to the development of information quality metrics
  
  

Skills And Experience

• Strong experience of Google’s BigQuery
• Strong experience with Google DataFlow / Apache Beam
• Experience migrating star schema data warehouses to BigQuery
• Experience migrating older ETL systems to Apache Beam
• Database extraction, analysis and testing as part of data assurance
• Experience with Microsoft Power BI or similar reporting applications
• Experience creating reports and analytical dashboards
• Data anonymization
• Continuous integration & deployment experience (GIT, JIRA, Atlassian, other)
• Excellent organization and administration skills
• Fluent in English (read, write and speak).
• Able to build and maintain strong relationships with LINK staff and external customers where required.
  
  

Personal Attributes

• Good communicator and able to provide clear feedback to the clients and team
• Provides guidance and problem-solving assistance to other team members
• Well dressed, professional appearance, with a confident, positive and respectful manner
• Be highly motivated and keen to succeed
• Be service and ‘team’ orientated
• Be able to manage relationships
• Have good written and verbal communication skills
• Able to ‘multi-task’ and manage multiple issues and projects
• Presents as a professional and knowledgeable individual with good listening skills and high levels of empathy with others
• Have high levels of enthusiasm and energy
• Shows flexibility in approach and able to change and adapt to circumstances
  
  

Qualifications

• Typically requires 5-7 years of Business Intelligence or related technical experience
• Knowledge of one or more business functional areas
• College degree preferred
  
  

Our organization is dedicated to fostering a workplace environment that values diversity and inclusion. We actively seek to attract, recruit, and nurture talent from a broad spectrum of backgrounds, each contributing unique perspectives, ideas, and experiences. Our goal is to cultivate a productive and inclusive atmosphere that represents various cultures and groups, where everyone is given an equal opportunity to thrive.

Your needs and preferences are important to us, and we are committed to ensuring an equitable and accessible recruitment process. If you feel you need any reasonable adjustments to be made in order to apply for a vacancy at Link, please contact us at [email protected]