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
...Work from Home Data Entry & Office Administration Remote Online Role About the Job We are seeking motivated individuals in Kennewick... ...role allows you to work from home while gaining practical experience in digital office tasks, record keeping, and supporting...
...DESCRIPTION Amazon internships are full-time positions, and interns should expect to work Monday-Friday, up to 40 hours per week... ...also articles, podcasts/audio content, graphic novels, manga, video games, musicals/plays, board games, and other forms of IP. We work with...
...As a Remote Travel Consultant, youll play a mission-critical role in supporting our clients from their very first trip idea all the way to their safe return home. Youll be the steady, knowledgeable guide who keeps their travel experience seamless, stress-free, and genuinely...
...this Position Location: Any Location / Remote Full Part/Time: Full time Job Req:... ...JIRA, Leadership, Salesforce (Software), Scrum Certifications: None Experience:... ...our work depends on a Salesforce Scrum Master remotely joining our Federal Services...
...Own site taxonomy, navigation, filters, and product organization to maximize findabilityand elevate the path-to-purchase. Manage product lifecycle online, including SKU setup, enrichment, categorization, cross-sells/upsells, and asset management. Coordinate...