SQL Developer

The SQL Developer will be responsible for designing, developing, and maintaining SQL-based solutions including the extensive data warehouse and ELT build in WhereScape Red.

• Support and maintain the Data Warehouse that collates and normalises data from more than 260 clinics across Australia and New Zealand.
• Manage the development and enhancement pipeline for ELT changes in Wherescape Red ETL automation tool, including build, test and deployment tasks to integrate data from various sources into the data warehouse ensuring data quality and accuracy.
• Provide data engineering expertise and consultation to the analyst teams that are using data from the data warehouse
• Assessment of emerging technologies
• Design, develop, and optimise SQL code for various applications and systems.
• Troubleshooting, Identify and resolve performance issues, data inconsistencies, and data quality problems in a timely manner.
• Create and maintain technical documentation, including data models, database schemas, ETL processes, and system configurations, to ensure clear and comprehensive understanding of the SQL environment.
• Analyse new systems to extract data.
• Perform integrity checks on data using both established and new procedures and tools
• Work closely with cross-functional teams, including developers, architects, and business users, to ensure effective collaboration and successful project outcomes.
• Provide technical guidance and support to junior team members, fostering knowledge sharing and skill development within the integration team.
• Participate in code reviews, adhere to coding standards, and ensure compliance with organizational policies and procedures
• Demonstrate self-management through professional behavior that is consistent with the company's values.
• Set the example for others, demonstrate loyalty to seeing the business succeed, conduct yourself respectfully and with a positive attitude.
• Earn credibility through comprehensive communication, establishing strong relationships and projecting an executive presence
• Express ideas clearly and concisely, use a clear communication style and tailor communication based on others’ needs.
• Communicate often and actively listen.
• Ensure collaborative and effective interactions and communication across the company: within and across departments and between functional areas.
• Works effectively with others regardless of level of authority; relate tactfully and consult stakeholders.
• Project confidence and poise when interacting with management, present thoroughly researched proposals, provide truth and earn trust.
• Demonstrate empathy for stakeholders and consider others’ pressures and motivators.
• Navigate through the organisation through managerial courage, leading change and knowing the business, including current and future strategies.
• Persevere in the face of setbacks, confront conflict productively, display good judgement in tough decisions.
• Deal effectively with ambiguity and adjust to changing business conditions
• Know how our business operates, understand commercial drivers, and proactively consider and present initiatives to improve the entire organisation.
• Champion the internal brand and values across the geographically dispersed and diverse workforce.

 

• Wherescape Red or similar ETL automation tooling experience
• Database design and development (Microsoft SQL, SQL Server, T-SQL and SSRS)
• Agile methodologies, object-oriented design and service-oriented design
• Relational databases, data modeling and ETL tools
• API development and Consumption
• Problem Solving Skills
• Ability to work in operational and project environments.
• Attention to detail.
• Tertiary qualifications in IT or Information Management related disciplines

We are HGS Offshore Staffing Solutions, a premier global partner in building offshore teams in the Philippines, with over 1,500 professionals across Metro Manila and Cebu.

Our goal is to ignite global potential by connecting exceptional talent with companies worldwide. We are committed to propelling your career forward by providing opportunities for growth, where your expertise can flourish in any field. Here, you'll have access to global industries, continuous training opportunities, and a culture where your voice always matters.

At HGS, we go beyond recruiting talented individuals, we cultivate a vibrant community. You'll be able to grow alongside your peers through professional development opportunities at your fingertips and connect with teammates during exciting company events. Our monthly huddles keep you connected with your team and colleagues. We also foster a dynamic community with our charity initiatives, reminding us that our careers can make a real difference. Whether you work remotely or side-by-side, you are always part of the team at HGS.