Auckland, Auckland, New Zealand
● Work closely with stakeholders to gather and understand their requirements for reporting needs, ensuring deliverables meet business objectives. ● Build staging, fact, dimension, and reporting layer models in DBT, designed to be reusable across multiple reports and aligned with business logic. ● Migrate SSRS reporting queries into DBT models, making them reusable for other reports when needed. ● Use GitHub workflows to deploy DBT models efficiently and reliably. ● Support SSRS reporting by integrating DBT models into the Snowflake environment to enable insightful data analysis. ● Analyze data to help end users understand discrepancies or missing information, and create, modify, debug, and optimize SSRS reports using SQL to ensure accuracy and performance. ● Maintain version control and manage repositories for DBT models and SSRS reports using GitHub, supporting team collaboration and code integrity.
● Maintain our specialised fund administration system ensuring all services are functional for business operations. ● Collaborate with the operational teams to develop and maintain the system by analysing issues, obtaining requirements, providing solutions and product enhancement suggestions, making changes or fixes. ● Debugging code when it is believed the functionality of the system/business operation is not working as required. This includes the use of C# code, VBA Macros, PostMan for API related issues, and SQL Stored procedures. ● Develop and maintain Razor templates through CSS, HTML, C#. ● Investigate SQL Reporting (SSRS) issues ensuring the SQL queries are in line with client reporting requirements. ● Monitor API performance in Azure ensuring availability and performance is working without issues. ● Develop and maintain documentation/SQL scripts for business processes, data fixes. ● Ensuring all tickets received for support are prioritised accurately in Zendesk. ● Customizing ZenDesk to help understand business support needs. ● Acquire monthly support stats and developing a report. This is then analysed and used to look for business improvements and problem areas. ● Lead the support / system analysis team ensuring all queries are dealt with correctly. Managing any escalations when required. ● Peer reviewing scripts ensuring it will not cause business issues.
• Maintain BizTalk applications and server; proactive monitoring, and analysis of event logs, ensuring connections to end points are successful (SOAP, WCF, APIs, FTP services). • Maintain and investigate issues occurring within Azure Logic applications and understanding the process / requirements for workflow changes. • Develop and modify Azure Logic apps • Creation of alerting scripts for critical business applications using Powershell / Azure alerting. • Troubleshooting potential code issues in C#, XSLT, SQL stored procs and investigation in possible data issues using MS SQL queries, and analysing XML, and JSON data. • Ensure services on IIS are up and running without issues. • UAT and Production deployments for new applications and functions. • Editing of client website with HTML and CSS. • Review client requirements, reporting and feedback to developers for required functions. • Testing new applications and functions; providing feedback for any improvements. • Update and document any required processes, creation of training documents and guides in Confluence and Onenote and carry out the training. • Professional high level support and ensuring clients are communicated of any outages and current issues. • Queue management using CASD R12, Jira, and Service Now ticketing system. Including creation and management of change forms / process. Technology: MS BizTalk, CASD R12, Service Now, Agile, Jira, Confluence, MS Servers, Azure, VBScript, .Net C#, XML, XSLT, JSON, HTML, CSS, MS-SQL, TFS, IIS, PowerShell, APIs, SoapUI, Visual Studio.
• First point of contact for most customers. Providing escalation and initial troubleshooting. • Solve level 1 & 2 Technical issues relating to various technologies such as Active Directory (security groups, account issues etc), Microsoft Office suite, MS Exchange, Citrix, VPNs, General Desktop work such as permissions etc) • Strong level of communication • Provide and document knowledge for the knowledge base • Train new staff with multiple clients • Understand customer needs and translate to what needs to happen technically.
• Understanding and bringing an idea to working mobile products. • Develop mobile game applications for both Android and IOS using Visual studio for code editing, .Net C# as the language and Unity3D as the engine for cross-platform. • Create sprites and art for mobile game applications. • Include Google Play Game services API, adding leaderboards and achievements. • Include Google AdMob for monetization • Technology: .Net C#, Visual Studio, SourceTree / Git, Unity3D.
• Working in an agile feature driven design team. • Draw out the wire-frame for client. • Design and develop website as required by the client requirements. • Proactive communication with client. • Create User stories. • Set up the hosting and domain. • Documentation of functions, materials on how to edit pages using the CMS Joomla. • Technology: HTML, CSS, JavaScript, Joomla.