Advanced SQL Architect

4 days ago


Saint Leonards, Victoria, Australia BCS Technology Full time

About BCS Technology

We are a cutting-edge technology company seeking an experienced SQL architect to join our team. As an Advanced SQL Architect, you will play a key role in designing and developing complex SQL databases and queries using T-SQL.

Job Summary:

We are looking for a highly skilled SQL developer with expertise in database design principles, BI tools, and cloud technologies. The ideal candidate will have experience with Power BI, Tableau, or similar platforms, as well as proficiency in writing and optimizing complex T-SQL queries.

About the Role:

In this hybrid role, you will be responsible for designing, developing, and maintaining complex SQL databases and queries, with a strong emphasis on T-SQL. You will work closely with software developers to design and implement database structures that meet business requirements.

Responsibilities:

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

Requirements:

To succeed in this role, you must have:

A 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.

What We Offer:

We offer a competitive salary of $120,000 - $180,000 per year, depending on experience, as well as a comprehensive benefits package, including health insurance, retirement plan, and paid time off. If you are passionate about working with SQL and want to be part of a dynamic team, please submit your application.



  • Saint Leonards, Victoria, Australia BCS Technology Full time

    Job OverviewWe are seeking a highly skilled Senior BI Developer to join our team at BCS Technology. As a key member of our technical staff, you will play a crucial role in designing, developing, and maintaining complex SQL databases and queries, with a strong emphasis on T-SQL.About the RoleThis is a hybrid position that combines SQL development and Business...


  • Saint Leonards, Victoria, Australia BCS Technology Full time

    Job Overview">BCS Technology is seeking a highly skilled Senior BI Developer to join our team. This is an exceptional opportunity for an experienced professional to leverage their expertise in designing, developing, and maintaining complex SQL databases and queries, with a strong emphasis on T-SQL.About the RoleThe ideal candidate will have a minimum of 5-7...


  • 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...

  • Data Architect

    3 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 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 BCS Technology Full time

    About the RoleBrighten your career in data solutions with BCS Technology as a Senior SQL Developer and Business Intelligence Specialist. In this dynamic position, you'll design, develop, and maintain complex SQL databases and queries using T-SQL, focusing on cloud technologies like AWS.Key ResponsibilitiesCreate and optimize complex SQL queries, stored...


  • Saint Leonards, Victoria, Australia BCS Technology Full time

    Company OverviewBCS Technology is a leading provider of innovative solutions, dedicated to empowering businesses through cutting-edge technology.SalaryThe salary for this position is estimated to be between $120,000 and $180,000 per year, based on industry standards and location considerations.Job DescriptionThis hybrid role combines the responsibilities of...


  • Saint Leonards, Victoria, Australia BCS Technology Full time

    Overview We are seeking a skilled and experienced Presales Solution Architect to join BCS Technology. 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. Salary Range:$120,000 - $180,000 per annum Job...


  • Saint Leonards, Victoria, Australia BCS Technology Full time

    Job OverviewBecoming a Senior IT Infrastructure Analyst at BCS Technology is an exciting opportunity to join our team of experienced professionals in providing technical support and application services.About the RoleWe are seeking a skilled Technical Systems Support Specialist to provide exceptional technical expertise in supporting our airline reservation...

  • Senior Data Analyst

    1 month ago


    Saint Leonards, Victoria, Australia InDebted Full time

    About InDebted: InDebted is a pioneering organization that provides innovative solutions to support consumers in debt. Leveraging technology and human expertise, we utilize machine learning and AI to personalize the collections journey and foster positive customer experiences. Our mission is to revolutionize the world of consumer debt for the better.As a key...


  • Saint Leonards, Victoria, Australia TOMRA Full time

    Job OverviewAs a Business Analyst at TOMRA, you will play a key role in partnering with business units to provide strategic advice on investments, programs, and initiatives. You will be responsible for conducting financial modeling, data analysis, and presenting information to support decision-making. Your expertise will be essential in driving business...


  • Saint Leonards, Victoria, Australia BCS Technology Full time

    Company OverviewPizza Hut Australia is a leading food delivery and restaurant chain, seeking an experienced Senior .NET Developer to join its technology team. We are committed to delivering high-quality digital platforms that drive our business forward.Job DescriptionWe offer a market-leading salary with a range of benefits including health insurance,...


  • Saint Leonards, Victoria, Australia InDebted Full time

    About InDebtedInDebted is a forward-thinking organisation that provides innovative solutions to support consumers with debt. Our technology-driven approach, paired with a human touch, enables us to personalise the collections journey and deliver positive customer experiences.We're a team of over 300 people living and working around the world, with offices in...


  • Saint Leonards, Victoria, Australia Cisco Full time

    Job Description:We are seeking an experienced Network Engineering Specialist to join our team as a Customer Proof of Concepts Engineer.About the Role:The successful candidate will be responsible for designing, developing, and delivering customer-centric proof of concept labs, focusing on Enterprise Networking and Cisco Nexus technologies. This role requires...


  • St Leonards, Australia Mastercard Full time

    Our Purpose We work to connect and power an inclusive, digital economy that benefits everyone, everywhere by making transactions safe, simple, smart and accessible. Using secure data and networks, partnerships and passion, our innovations and solutions help individuals, financial institutions, governments and businesses realize their greatest potential. Our...

  • Revit Technician

    5 months ago


    St Leonards, Australia Kappa Executive Search Full time

    Our client, a prestigious architectural firm based in St Leonards, are actively seeking a seasoned Revit Technician with a strong background in health projects. This is an exceptional opportunity to join a leading team dedicated to delivering innovative architectural solutions in the healthcare sector. Key Responsibilities: - Utilise advanced Revit skills...


  • St Leonards, Australia Mastercard Full time

    Our Purpose We work to connect and power an inclusive, digital economy that benefits everyone, everywhere by making transactions safe, simple, smart and accessible. Using secure data and networks, partnerships and passion, our innovations and solutions help individuals, financial institutions, governments and businesses realize their greatest potential. Our...


  • St Leonards, Australia TOMRA Full time

    Job Description Reporting to the Head of Finance, the Business Analyst will work to partner with business units to provide advice on proposed investments, programs, initiatives and business cases. You will oversee and conduct modelling of the costs and benefits of future scenarios, and present information to help decision-makers manage the system...


  • St Leonards, Australia Cancer Institute Division Full time

    **_Manager, Data Science and Insights_** **Employment Type**: Fixed Term (24 months) with possibility to change to Permanent **Position Classification**: Health Manager Level 4 **Remuneration**: $137,173 - $163,431 per annum, excluding superannuation **Hours Per Week**: 38 **Location**: 1 Reserve Road, St Leonards, Sydney **Requisition ID**: REQ783844 **_...


  • St Leonards, Australia Mastercard Full time

    Our Purpose We work to connect and power an inclusive, digital economy that benefits everyone, everywhere by making transactions safe, simple, smart and accessible. Using secure data and networks, partnerships and passion, our innovations and solutions help individuals, financial institutions, governments and businesses realize their greatest potential. Our...


  • St Leonards, Australia Bureau of Health Information Full time

    **Data Visualisation Designer** **Bureau of Health Information** **Where you'll be working** The Bureau of Health Information (BHI) is a board-governed organisation that provides independent reports on the performance of the NSW public healthcare system. BHI’s primary purpose is to provide timely, accurate and comparable information on the performance of...


  • St Leonards, Australia Bureau of Health Information Full time

    **Data Visualisation Designer** **Bureau of Health Information** **Where you'll be working** The Bureau of Health Information (BHI) is a board-governed organisation that provides independent reports on the performance of the NSW public healthcare system. BHI’s primary purpose is to provide timely, accurate and comparable information on the performance of...


  • St Leonards, Australia Mastercard Full time

    Our Purpose We work to connect and power an inclusive, digital economy that benefits everyone, everywhere by making transactions safe, simple, smart and accessible. Using secure data and networks, partnerships and passion, our innovations and solutions help individuals, financial institutions, governments and businesses realize their greatest potential. Our...

  • Test Manager

    4 weeks ago


    St Leonards, Australia Health System Support Group Full time

    **Employment Type**:Permanent Full Time **Position Classification**:Health Manager Level 4 **Remuneration**:$137,173 - $ 163,431, plus Superannuation **Location**:1 Reserve Road, St Leonards NSW, in a hybrid working environment **Hours Per Week**: 38 **Requisition ID**:REQ526784 **Closing Date**:Wednesday, 13rd Nov 2024 (11:59PM) **Where you'll be...


  • St Leonards, Australia Mastercard Full time

    Our Purpose We work to connect and power an inclusive, digital economy that benefits everyone, everywhere by making transactions safe, simple, smart and accessible. Using secure data and networks, partnerships and passion, our innovations and solutions help individuals, financial institutions, governments and businesses realize their greatest potential. Our...