SQL Developer

5 days ago

North Melbourne, Australia WISE Employment Full time

Full Time Permanent Opportunity with flexible working arrangements
- Responsible for reporting information that will facilitate business planning
- Excellent salary and benefits including not for profit salary sacrifice

Celebrating 30 years in the employment services industry, WISE Employment is a not-for-profit organisation that has been inspiring, transforming and empowering people by connecting them with employers in numerous industries.

As a
**SQL Developer/Data Analyst** you will source and analyse Employment Services industry and WISE business data to provide meaningful and relevant data analysis and reporting to WISE. This data and reporting informs business planning, operational needs and strategic business decisions.

**The role**:

- Prepare tables, Stored Procedures, Views for WISE Insights (Yellowfin) with an emphasis on SQL Server including;
- Use SQL Server to develop and implement stored procedures, tables, views and functions.
- Review and interpret ongoing business report requirements.
- Source required data.
- Build appropriate and useful reporting deliverables.
- Analyze existing SQL queries for performance improvements.
- Suggest new queries.
- Develop procedures and scripts for data migration.
- Provide timely scheduled management reporting.
- Investigate exceptions and errors
- API management
- Ability to develop and work with APIs
- Understand and troubleshoot API issues
- Optimize API performance with ease
- Manage API keys and access
- Understand and work with API documentation
- Admin
- Git, creating branches, commits, merge requests etc
- Jira
- Confluence
- Syncing data for reporting
- Identify data required, quality of data and what might be proxied
- Write queries to extract from postgresql
- Design and create tables and stored procedures to facilitate reporting
- Prepare a job to run the sync
- Run data driven actions
- Identify data available, quality, currency/timing, and alternatives
- Design and create tables to support actions
- Write stored procedures and views to make data available
- Prepare jobs to hit endpoints
- Participate in discussions
- Advise on how data works in general
- Advise on what data is (or may be) available
- Run ad hoc reports
- Design, write and report on ad hoc queries as required by the project
- Create Yellowfin reports and dashboards

**About you**:

- SQL Server experience
- Experience with Data visualisations and reporting using BI tools eg (Tableau, Power BI Yellowfin or similar)
- TSQL and JSON, Postgres and Python experience (Desirable)
- You will thrive on our key attributes of Customer Centricity, Curiosity, Resilience, Adaptability, Creativity and a Growth Mindset
- Full Australian working rights, ability to satisfy national police check, and Working with Children Check requirements
- Hold a current driver’s license
- Double vaccinated against COVID 19

**Why WISE?**
- Join a growing organisation making a difference in the community
- You will work in a collaborative, professional team within an agile and positive work environment.
- Join a workplace which genuinely cares about its people, our customers and the community at large.
- Competitive salary including not-for-profit salary packaging
- Company mobile phone and laptop
- Reward and recognition initiatives and ongoing learning and development
- Access to exclusive benefits and discounts from leading retailers
- Access to a diverse range of employee benefits

**How can I apply?

  • sql developer

    3 days ago

    Melbourne, Victoria, Australia Milestone Information Technology Full time $70,000 - $120,000 per year

    We are seeking an experienced and highly skilled SQL Developer to join a leading retail organization based in Melbourne for an ongoing 6-month contract. This is an excellent opportunity to leverage your expertise in a dynamic environment, contributing to critical data initiatives within a large-scale enterprise.The Role:As a SQL Developer, you will be...

  • sql developer

    5 days ago

    Melbourne, Victoria, Australia Milestone Information Technology Full time $80,000 - $120,000 per year

    Key Responsibilities:Design, develop, and optimize complex ETL (Extract, Transform, Load) processes using SSIS (SQL Server Integration Services) for data migration from existing MS SQL Server environments.Develop and maintain T-SQL scripts, stored procedures, functions, and views for data extraction, transformation, and loading activities.Work extensively...

  • sql developer

    4 weeks ago

    City of Melbourne, Australia Milestone IT (Milestone Information Technology) Full time

    Overview We are seeking an experienced and highly skilled SQL Developer to join a leading retail organization based in Melbourne for an ongoing 6-month contract. This is an excellent opportunity to leverage your expertise in a dynamic environment, contributing to critical data initiatives within a large-scale enterprise. Role As a SQL Developer, you will...

  • Senior SQL Developer

    5 days ago

    Melbourne, Victoria, Australia INNOVATE IT AUSTRALIA Full time $80,000 - $180,000 per year

    Job Title: Senior SQL DeveloperJob Location : Melbourne, VICDuration : FTPJob Description: Year, extensive development experience in MS SQL Server 2008R2/2012/2014/2016/2019/2022 instance. Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, resource contentions, connectivity...

  • PL/SQL Developer

    1 week ago

    Melbourne, Victoria, Australia Salt Full time $80,000 - $120,000 per year

    PL/SQL EngineerContract, 6-months with possible extensions$920 / dayAbout the RoleSalt has partnered with an industry leader in the Australian tertiary education sector, now looking for an experienced PL/SQL Developer with extensive Cloud computing skills to join their large-scale team in Melbourne.We are seeking a highly skilled PL/SQL developer, with...

  • Senior MS SQL Developer

    3 days ago

    Melbourne, Victoria, Australia Hastha Solutions Full time $120,000 - $180,000 per year

    Urgent requirement of Senior MS SQL Developer - Contract - Melbourne Requirements10 -15 Year, extensive development experience in MS SQL Server 2008R2/2012/2014/2016/2019/2022 instance. Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, resource contentions, connectivity issues,...

  • Postgre SQL Developer

    7 days ago

    Melbourne, Victoria, Australia ALOIS Solutions Full time $40,000 - $120,000 per year

    Job Description:10+ years of DBA experienceManage and maintain PostgreSQL databases.Ensure database performance, integrity, and security.Design and implement database systems.Monitor and optimize database performance.Ensure data integrity and security.Develop and implement backup and recovery processes.Plan and execute disaster recovery strategies.Experience...

  • Senior MS SQL Developer

    5 days ago

    Melbourne, Victoria, Australia Tata Consultancy Services Full time $80,000 - $120,000 per year

    About TCS:Join Tata Consultancy Services, Asia Pacific and be part of an organization committed to sustainable development for our future. TCS follows the Tata group philosophy of building sustainable businesses that are rooted in the community and demonstrate care for the environment. Our unique values position us to combine a purpose-driven worldview with...

  • SQL Tester

    1 week ago

    Melbourne, Victoria, Australia RUBIX. Full time $90,000 - $120,000 per year

    We're hiring: SQL Tester / QA Engineer At RUBIX, we help our clients do great things with their data. We're looking for SQL Testers / QA Engineers to support one of our enterprise clients by ensuring data accuracy, validating business logic and strengthening reporting quality during a period of major project delivery.This is a hands on role focused on data...

  • PostGre SQL

    2 weeks ago

    Melbourne, Victoria, Australia ALOIS Solutions Full time

    Job role - PostGre SQL – DeveloperJob Location – MelbourneJob type – ContractJob Description10+ years of DBA experienceManage and maintain PostgreSQL databases.Ensure database performance, integrity, and security.Design and implement database systems.Monitor and optimize database performance.Ensure data integrity and security.Develop and implement...