Senior Cloud Data Architect

Job Title: Senior Cloud Data Architect

Location: REMOTE (Preference to DMV area candidates)

Duration: 6 Months contract to fulltime hire

Our client is seeking a seeking a customer experience focused Data Architect to work with a team of subject matter experts and developers to design and implement data architectures supporting end to end data processing needs. As a data architect, you will interface with functional professionals and business managers to translate business concepts and needs into cloud-based data architectures that support high performance data and geospatial visualization and advanced analytics. You will be hands on in establishing and overseeing implementation of data standards, data ingest, integration, storage, and query architectures. You will design solutions for data migration from/to a range of data architectures that include Microsoft SQL Server, cloud-based data stores such as Azure data lake, Azure SQL, Azure Analytics Services, Azure Synapse.
Responsibilities:
• Work with client functional team members and business managers to analyze and translate business needs into long-term data architectures.
• Define conceptual, logical, and physical data models supporting high performance analytical queries in multiple subject areas.
• Design and implement data architectures for relational, data lake, delta lake, medallion architecture, NoSQL data stores.
• Design and deliver solutions using Microsoft Azure cloud services, including Azure data lake, Azure SQL, Azure Analysis Services, Azure Synapse.
• Design and implement data models for OLAP cubes, star schema, subject specific data marts.
• Design and implement processes, functions, and tools for data migration and conversion or refactoring of data models to support new architecture (e.g., SSAS cubes to AAS tabular models)
• Provide guidance on data pipeline design and implementation.
• Assist in the definition and maintenance of data modeling and data architecture design standards, tools, best practices.
• Assist with the implementation of data management and data governance best practices and tools, including capabilities such as enterprise data catalog, data quality.
• Suggest ideas to improve system performance and achieve cost efficiencies.
Requirements:
• BS degree in Computer Science or related field and 8+ years or Masters with 6+ years of experience
• 5+ years experience designing conceptual, logical, physical data models.
• 4+ years experience in cloud data architecture, including integration, data storage, query architectures.
• 4+ years developing and implementing data models for Microsoft SQL Server, star models, data marts, and SSAS OLAP cubes
• Experience developing and implementing models for data lake, Azure SQL and NoSQL databases
• Experience with design of data backup and retention, data migration, data quality
• Ability to work directly with client personnel at management and functional levels.
• Ability to clearly document, explain and obtain buy-in of designs and technical roadmap.
• Very strong SQL query language skills, with experience optimizing data query performance
• Knowledge and understanding of programming languages like Python, Spark, and .NET based development
• Knowledge and experience with data governance, including metadata management, enterprise data catalog, design standards, data quality governance, and data security.
• Experience with Agile process methodology, and CI/CD automation, and cloud based development (Azure, AWS).
• Ability to successfully obtain a government-issued Public Trust clearance.
Preferred Qualifications:
• Experience developing Master Data Management solutions
• Scaled Agile Framework (SAFe)
• Experience working with Azure DevOps
• Azure Enterprise Data Analyst certification