Analyst Programmer - Auysd000522484

LVT People; Sydney; On-site; AUD 80,000 - 100,000; Full time

Job summary

AusbizConsulting in Sydney is seeking an experienced Analyst Programmer to join our dynamic team. You will be responsible for end-to-end data warehousing projects, implementing ETL processes and writing complex SQL while delivering interactive reports with Power BI, Tableau and Cognos.

We value SDLC expertise in both Waterfall and Agile environments, strong communication, and the ability to work autonomously or within a team.

Qualifications

• Degree in computer science or a related field.
• Experience with ETL, data warehouses, and SQL.
• Knowledge of the SDLC; Waterfall & Agile environments.

Responsibilities

• Perform ETL transformations and write complex SQLs for Redshift (AWS) and Netezza.
• Create interactive reports and dashboards using Power BI, Tableau, Cognos.
• End-to-end implementation, enhancement and migration & support of data warehousing projects.
• Analyze system requirements and develop technical designs.
• Design, code, test and install applications across platforms.
• Develop and maintain operating and system documentation.
• Mentor and guide junior team members.

Skills

SQL

Java

PL/SQL

XML

Data warehousing

Education

Bachelor's degree in Computer Science

Tools

Power BI

Tableau

Cognos

JIRA

Confluence

Job description

About us:

We are apassionate community of solvers coming together to provide services in DigitalTransformation and Data & Business Intelligence. We provide Cloud Strategy& Advisory, Tech Transformation & Transformation Office, Automation,Intelligent Data & AI Platforms, and BI Analytics to our clients.

Job Summary:

AusbizConsulting is seeking an experienced and talented Analyst Programmer to joinour dynamic team in Sydney. The successful candidate will be responsible forthe end-to-end implementation, enhancement, and support of data warehousingprojects and applications.

Responsibilities:

• Perform ETL transformationprocesses and write complex SQL’s using different databases such asRedshift(AWS), Netezza
• Create interactive reports anddashboards using platforms such as Power BI, Tableau, Cognos, scorecardsand cubes using Relational Models, DMR and OLAP
• End-to-end implementation,enhancement and migration & support of data warehousing projects
• Analyze system requirements anddevelop technical designs
• Design, code, test and installapplications programs either in one major language or in a range ofprograms across multiple platforms
• Develop and maintain operatingand system documentation
• Ensure systems are developedwithin agreed budgets and time frames and achieving necessary design andsystems security standards
• Develop and maintain applicationsoftware, cubes, data warehouses, databases, and cloud infrastructure
• Write, update and maintaintechnical program, end-user documentation, and operational procedures
• Provide technical mentoring andguidance to junior team members

Requirements

• Degree in computer science orrelevant field
• Relevant work experience isdesired
• Skills in one or more of themajor programming languages (either ‘legacy’ or ‘hot’) such as Java, XML,SQL, PL/SQL
• Knowledge of one of the majorrelational database packages such as Oracle, SQL Server
• Ability to work autonomously orin a team environment, directly dealing with customers and otherstakeholders
• Analytical thinker with apositive and helpful attitude
• Strong communication skills bothoral and written
• Advanced knowledge andunderstanding of the full SDLC. Experience in both Waterfall and Agile developmentproject environments is highly desirable
• Experience using JIRA andConfluence
• Strong understanding of SOA, webservices/REST, client server technology

Benefits

We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, colour, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.

Terms of employment

Full Time

Location

Level 28, ANZ Towers, 242 Pitt Street, Sydney, NSW 2000

Salary

$80,000 – $100,000