Role overview

Qualifications

8-12 years total experience in data design/architecture
5+ years big data experience and 3 years as solution architect
Proficiency in SQL and data analysis with experience writing ETL mapping specifications
Experience designing ODS and Data Marts; familiarity with data warehouse architecture (loading strategies, backup, recovery)

Responsibilities

Create logical and physical data models using best practices to ensure high data quality and reduced redundancy
Design Operational Data Stores (ODS) and Data Marts and architect the data warehouse including loading strategies, backup, recovery and scalability
Write SQL, perform data analysis, and provide ETL mapping specifications; collaborate with Business Analysts on enterprise information requirements
Leverage telecom/domain knowledge, data visualization tools (Power BI, Tableau), and big data platforms (Databricks, HDFS) and MPP databases (Azure Synapse, Teradata) to implement solutions

Key facts

Remote from: Anywhere
Full time
Data Architect
English

Other skills

Problem Solving

About the company

Pyramid Global Technologies

Pyramid Global Technologies is a highly regarded Managed IT Service Provider offers value-driven solutions and a range of IT support services. A Managed IT service provider can remotely manage your company’s IT infrastructure and/or end-user systems on a proactive basis. Pyramid Global Technologies is a leading independent, end-to-end IT services company, serving private and public-sector clients from a diverse array of industries across Australia. The company's technology independence, global talent and extensive partner network help clients harness the power of innovation to thrive on change and guide their digital transformation journeys. Our delivery team provides a global delivery platform that can be applied to the seamless planning, building and operations related to any technological solutions.

Company details

Company typeSME

Company size51 - 200

Links

Website LinkedIn See all jobs

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

Total experience: 8 - 12 years

Relevant experience: 5 ears of big data experience and 3 years’ solution architect

Salary: 170k P.A.

Remote work.

PFB the complete JD:

Should be able to create logical and physical data models using best practices to ensure high data quality and reduced redundancy

• Understanding of Telecom domain or good domain knowledge in any sector

• Expertise in writing SQL’s and perform data analysis

• Provide ETL mapping specification documents

• Experience in designing Operational Data Stores (ODS) and Data marts

• Designing a suitable technical architecture for the data warehouse implementation, these include loading strategies, backup, recovery and volumetric.

• Establishing the best practice approaches for solving business problems as well as providing inputs to the Business Analyst in terms of Enterprise informational Requirements

• Knowledge on any of the data visualization tools (Power BI, Tableau etc)

• Good exposure on any of the big data platform like (data bricks, HDFS etc)

• Adept knowledge on any of MPP databases like Azure Synapse, Teradata etc.