Data Architect

Washington, DC
Jan 27, 2022
Jan 29, 2022
IT, IT Architect
Full Time
Data Architect & ModelerThe Data Architect & Modeler will have a critical role for the Organization to develop, implement and document data architecture and data modeling solutions in line with data strategy, and champion business team goals. You will communicate complex technical ideas with all levels of business teams, demonstrating the significance of well-informed changes to promote growth, and will design and document data architecture and data modeling solutions, which include the use of relational, dimensional, and NoSQL databases. These solutions support enterprise information management, business intelligence, machine learning, data science, and other business interests. You will manage and govern the expansion of existing Cloud platform architecture and the optimization of data query performance via best practices, creating highly scalable and flexible data models optimized across different data domains and for various purposes, working with other BTS team members such as BI Developers, Data Insights, Analysts and Data Scientists to design and implement solutions.Essential DutiesLead the design, development, and implementation of complex data systems. Direct the discovery work for understanding business goals to document business and data requirements, creating data strategies to build data models across all data platforms (relational, dimensional, and NoSQL) and data tools (reporting, visualization, analytics, and machine learning) to support data analysis and business intelligence.Work with business partners and team members in BTS to define business definitions for data models, implement data strategies, build data flows, and develop and fine tune the performance of the conceptual/logical/physical data models. Create and maintain current and target state data architectures.Define, establish, and govern design standards including guidelines, tools, best practices, and related development for enterprise data architecture, data modeling process framework to ensure data quality. Evaluate and recommend emerging technologies for data management, storage. and analytics.Lead the Agile strategy and approach for the release of data models to support data strategy. Working with BI Leadership and BI staff proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks. Oversee end to end data life cycle management activities.Required QualificationsMinimum of a Bachelor's Degree or equivalent experience, plus at least ten (10) years of relevant experienceProven hands-on relational, dimensional, and/or analytic experience (using RDBMS, dimensional, NoSQL data platform technologies, Databricks, Data Factory and ETL and data ingestion protocols).SQL Development Experience in Azure SQL DB and Azure SQL DW.Experience with Data Lake, Data Warehouse, and enterprise big data platforms in multi-data-center contexts.Proven knowledge of metadata management, data modeling, and related tools (Erwin or ER Studio or others) required.Demonstrated understanding of OLAP and OLTP frameworks, business analytics services such as Power BI and Tableau, and source databases (Like Azure SQL Server, Azure Synapse, etc.)Experience in team management, communication, and presentation.Ability to regularly learn and adopt new technologyAbility to relate architectural decisions and recommendations to business needsDemonstrated ability to communicate and collaborate successfully with individuals and teams at all levelsProfessional proficiency in MS Office suiteProfessional proficiency in spoken and written EnglishDemonstrated commitment to fostering and maintaining an environment of diversity, inclusion, and belonging.