About the Role
We are seeking a Senior Data Architect / Data Modeller to design, develop, and implement enterprise-level data architecture solutions in a complex, distributed environment. The successful candidate will play a key role in shaping data warehouse and analytics solutions that support business intelligence, reporting, and insights generation across the organization.
This is a hands-on, onsite role requiring strong technical expertise, stakeholder collaboration, and documentation skills.
Key ResponsibilitiesDesign and implement enterprise data architecture for application development, BI, and analytics
Define data flow, database structures, storage strategies, and access methods
Design and maintain enterprise data models and data dictionaries
Translate complex business and technical requirements into executable development work packages
Collaborate with business stakeholders to understand reporting and analytics needs
Support ETL pipeline development, testing, defect resolution, and performance tuning
Optimize data models, schemas, and database performance
Coordinate with integration teams to identify future data and reporting requirements
Produce and maintain high-quality functional and detailed design documentation
Support Power BI reporting and analytics solutions
Lead knowledge transfer and training sessions for client and development teams
7+ years of experience in data modelling and data warehouse design
2+ years hands-on experience with Azure Data Lake and Azure Databricks SQL Warehouse
5+ years strong SQL experience (T-SQL preferred)
Expert knowledge of dimensional modeling and Delta Lake concepts
Proven experience building enterprise data warehouse solutions on the Microsoft Azure stack :
Azure Data Lake
Azure Databricks
Azure Data Factory (ADF)
Power BI
Experience with BI metadata modeling and report design (Power BI)
Strong experience with MS SQL Server technologies
Proficiency in writing and optimizing SQL stored procedures for reporting and datamarts
Experience with performance tuning and schema optimization
Hands-on experience with Azure DevOps
Experience with IBM Curam COTS solutions (Social Assistance Management Systems)
Knowledge of ETL design concepts
Experience with Oracle databases and PL/SQL
Familiarity with enterprise architecture frameworks and tools:
TOGAF
ArchiMate
Zachman
Experience using data modeling tools such as SAP PowerDesigner or Visio
...respect each individual's contribution at every level. Potential to make $80,000+ Gas Field Specialists, Inc. is seeking a Truck Drivers to perform a variety of routine and complex transportation work in driving and coordinating transportation plans in support of...
...Welcome to The Freelance Firm! We are a national network of experienced, high-level, freelance attorneys and paralegals who provide remote, on-demand support for both short-term and long-term legal projects for our client law firms. Due to increased demand, we...
...The Training Coordinator is responsible for coordinating and supporting the day-to-day delivery of learning and development programs within an automotive manufacturing environment. This role partners closely with operations, HR, and the Continuous Improvement (CI) team...
...Work from Home Data Entry & Office Administration Remote Online Role About the Job We are seeking motivated individuals in North... ...role allows you to work from home while gaining practical experience in digital office tasks, record keeping, and supporting client...
...make a meaningful impact on the lives of people with disabilities? At Hearth, we provide 1:1 support to NDIS participants across Melbourne. We match you based... ...working with them. Hearth is looking for support workers in the Outer Eastern suburbs of Melbourne,such as...