Lead Data Architect and Business Intelligence Specialist

5 days ago


Saint Leonards, Victoria, Australia BCS Technology Full time

Company Overview

BCS Technology is a leading provider of innovative solutions, dedicated to empowering businesses through cutting-edge technology.

Salary

The salary for this position is estimated to be between $120,000 and $180,000 per year, based on industry standards and location considerations.

Job Description

This hybrid role combines the responsibilities of a Senior SQL Developer and Business Intelligence Specialist. The successful candidate will be responsible for designing, developing, and maintaining complex SQL databases and queries, with a strong emphasis on T-SQL. Additionally, they will create and manage BI solutions to support data-driven decision-making processes across the organization, focusing on leveraging cloud technologies, particularly AWS.

Key Responsibilities:

  • Design, develop, and maintain complex SQL queries, stored procedures, triggers, and functions using T-SQL.
  • Optimize database performance and ensure the efficient operation of our SQL servers.
  • Collaborate with software developers to design and implement database structures that meet business requirements.
  • Conduct data analysis and develop reports to support various business functions.
  • Troubleshoot and resolve database-related issues in a timely manner.
  • Help perform data migrations and integrations between different systems.

Requirements

  • Bachelor's degree in Computer Science, Information Systems, or a related field.
  • Minimum of 5-7 years of experience in SQL development and database management.
  • Proven experience with BI tools such as Power BI, Tableau, or similar platforms.
  • Strong understanding of database design principles and best practices.
  • Proficiency in writing and optimizing complex T-SQL queries.
  • Experience with ETL processes and tools.
  • Excellent analytical and problem-solving skills.
  • Strong communication skills with the ability to work effectively with cross-functional teams.
  • Experience with AWS services such as RDS, Redshift, S3, and Lambda.
  • Knowledge of cloud-based databases and data warehousing solutions.


  • Saint Leonards, Victoria, Australia RSL Lifecare Full time

    About RSL LifeCare:We provide care and services to veterans and seniors in our communities or at home. Our vision is to create proud communities living their best lives, building upon our legacy of supporting veterans and their families for over 100 years.This is a unique opportunity to make a meaningful difference in people's lives at a large social purpose...


  • Saint Leonards, Victoria, Australia RSL Lifecare Full time

    About Us:RSL LifeCare is a leading social purpose organisation dedicated to providing care and services to veterans and seniors. Our vision is to create proud communities living their best lives, and we're committed to making a meaningful difference in people's lives.This role offers a unique opportunity to leverage your skills and expertise in business...


  • Saint Leonards, Victoria, Australia RSL Lifecare Full time

    About Us:RSL LifeCare is a leading social purpose organisation dedicated to providing care and services to veterans and seniors. Our vision is to create proud communities living their best lives, and we're committed to making a meaningful difference in people's lives.This role offers a unique opportunity to leverage your skills and expertise in business...

  • Data Architect

    2 weeks ago


    Saint Leonards, Victoria, Australia BCS Technology Full time

    About the JobWe are seeking a skilled Data Architect to join our team at BCS Technology. As a key member of our Data Science group, the ideal candidate will be responsible for designing, developing, and maintaining complex SQL databases and queries, with a strong emphasis on T-SQL.Key Responsibilities:Design, develop, and maintain complex SQL queries, stored...


  • Saint Leonards, Victoria, Australia BCS Technology Full time

    Job Title: Senior Business Intelligence DeveloperJob Summary:We are seeking a highly skilled Senior Business Intelligence Developer to join our team at BCS Technology. As a Senior Business Intelligence Developer, you will be responsible for designing, developing, and maintaining complex SQL databases and queries, with a strong emphasis on T-SQL. You will...


  • Saint Leonards, Victoria, Australia BCS Technology Full time

    Job Title: Senior Business Intelligence DeveloperJob Summary:We are seeking a highly skilled Senior Business Intelligence Developer to join our team at BCS Technology. As a key member of our data analytics team, you will be responsible for designing, developing, and maintaining complex SQL databases and queries, with a strong emphasis on T-SQL.Key...


  • Saint Leonards, Victoria, Australia BCS Technology Full time

    Job Title: Senior Business Intelligence DeveloperJob Summary:We are seeking a highly skilled Senior Business Intelligence Developer to join our team at BCS Technology. As a key member of our data analytics team, you will be responsible for designing, developing, and maintaining complex SQL databases and queries, with a strong emphasis on T-SQL. You will also...


  • Saint Leonards, Victoria, Australia RSL Lifecare Full time

    About Us:RSL LifeCare is a leading social purpose organisation dedicated to providing care and services to veterans and seniors. Our vision is to create proud communities living their best lives, and we're committed to making a meaningful difference in people's lives.We're seeking a skilled Business Intelligence Developer to join our team. As a key member of...


  • Saint Leonards, Victoria, Australia BCS Technology Full time

    Job Overview BCS Technology is a leading technology company seeking an experienced Senior Database Architect to join our team. The ideal candidate will have a strong background in database design, development, and management, with a focus on SQL and business intelligence. This is a challenging opportunity for someone looking to take their career to the...


  • Saint Leonards, Victoria, Australia Hammond Care Full time

    About UsHammondCare is a not-for-profit, values-based organisation that is passionate about improving the quality of care for people in need. As one of Australia's most innovative health and aged care providers, we aim to set the global standard of relationship-based care for people with complex needs.About the RoleThe Business Intelligence Analyst is a...


  • Saint Leonards, Victoria, Australia BCS Technology Full time

    About the RoleWe are seeking a highly skilled Senior BI Developer to join our team at BCS Technology. In this key position, you will play a crucial role in designing, developing, and maintaining complex SQL databases and queries, with a strong emphasis on T-SQL.As a Senior BI Developer, you will be responsible for creating and managing business intelligence...


  • Saint Leonards, Victoria, Australia BCS Technology Full time

    Job DescriptionAbout the RoleAs a Senior Business Intelligence Developer at BCS Technology, you will be responsible for designing, developing, and maintaining complex SQL databases and queries. A strong emphasis will be placed on T-SQL, and you will leverage cloud technologies, particularly AWS, to create and manage BI solutions that support data-driven...


  • Saint Leonards, Victoria, Australia BCS Technology Full time

    Job Title: Senior BI DeveloperJob DescriptionAs a Senior Business Intelligence Developer at BCS Technology, you will play a key role in designing, developing, and maintaining complex SQL databases and queries. With a strong emphasis on T-SQL, you will create and manage BI solutions to support data-driven decision-making processes across the organization,...


  • Saint Leonards, Victoria, Australia Hammond Care Full time

    About the RoleThe Integrations and BI Developer plays a crucial part in the IT function at HammondCare. This role focuses on all data collected in our business systems, methods of collection, data warehouse design and management, reporting, and providing business teams with the necessary information from our business systems to aid decision-making.This is a...


  • Saint Leonards, Victoria, Australia BCS Technology Full time

    Job Title: Technical Solutions ArchitectWe are seeking a skilled and experienced technical solutions architect to fill a key role in our company. This individual will be responsible for understanding customer business problems, providing innovative solutions, and driving the solution throughout the development lifecycle from pre-sales to delivery, including...


  • Saint Leonards, Victoria, Australia BCS Technology Full time

    Job SummaryWe are seeking a skilled and experienced Presales Solution Architect to drive the solution throughout the development lifecycle from pre-sales to delivery. The ideal candidate will have a strong technical background, excellent communication skills, and a proven track record in solution design, customer engagement, and project delivery.Key...


  • Saint Leonards, Victoria, Australia BCS Technology Full time

    About the RoleWe are seeking a skilled and experienced Pre-Sales Solution Architect to drive the solution throughout the development lifecycle from pre-sales to delivery, including coordination with offshore teams.ResponsibilitiesClient Engagement: Work closely with the sales team to engage with potential clients, understand their business needs, and...


  • Saint Leonards, Victoria, Australia BCS Technology Full time

    Company OverviewBSC Technology is a leading provider of cutting-edge technology solutions. We are committed to delivering innovative, customer-centric solutions that drive business growth and success.Salary$120,000 - $180,000 per year, depending on experience.Job DescriptionWe are seeking an Expert Digital Solutions Architect to join our team. As a key...


  • Saint Leonards, Victoria, Australia BCS Technology Full time

    Job OverviewWe are seeking a skilled and experienced presales solution architect to join our team at BCS Technology.About the RoleThe ideal candidate will have a strong technical background, excellent communication skills, and a proven track record in solution design, customer engagement, and project delivery.Key Responsibilities:Client Engagement: Work...

  • Senior Data Analyst

    2 weeks ago


    Saint Leonards, Victoria, Australia BCS Technology Full time

    Job OverviewBCS Technology is seeking a highly skilled Senior Data Analyst to join our team. As a key member of our data analytics department, you will be responsible for designing, developing, and maintaining complex SQL databases and queries, with a strong emphasis on T-SQL. In addition to your technical expertise, you will also be required to create and...