Senior Cloud Data Architect (W2 only)

Senior Cloud Data Architect
Remote - Washington DC metro area candidates are preferred
$70-80/hr
US citizenship is required per government contract
Must be able to obtain Public Trust clearance
10% travel is estimated to be required

Responsibilities:
• Work with client and 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

System One, and its subsidiaries including Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.

System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.

#LI-VH1
#M1
Ref: #851-Rockville-S1

System One, and its subsidiaries including Joulé, ALTA IT Services, TeamPeople, and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.

System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.