Ready to join the team?
View our job opportunities below.

Data Architect

Location: Washington, DC
Data Architect
Clearance: Secret 

The primary responsibilities of the Data Architect include:
  • Develop and maintain data architecture guiding principles, policies, best practices, reference architecture and standards.
  • Establish standards for modeling, structuring, naming, describing, securing and formatting data.
  • Collaborate with the Knowledge Management (KM) and Enterprise Architecture (EA) team in the building and maintaining scalable enterprise data models.
  • Evaluate and make recommendations regarding data integrity.
  • Create and execute Microsoft SQL Server Integration Services (SSIS) Packages to Extract, Transform and Load data from N number of data sources.
  • Establish data normalization standards, processes and procedures to scale, manage and deploy data marts which support Power BI dashboards for the EA and KM program.
  • Diagnose, isolate, and resolve advanced problems pertaining to new and existing data infrastructures.
  • Architect and design all types of data stores such as application databases, ODS, EDW, and DataMart, etc.
  • Active DOD/DSS SECRET security clearance or higher.
  • Bachelor’s Degree or Masters in Computer Science or Information Systems.
  • At least ten (10) years’ related experience in data architecture including seven (7+) years of data modeling and database design and administration.
  • At least five (5) years’ experience writing technical documents.
  • Experience with EDM tools and developing data taxonomies, Entity Relationship Diagrams (ERD).
  • Strong understanding of Cloud Native development, Cloud Infrastructure, Open Source Frameworks, one or more Cloud Environments (AWS, Azure, or other).
  • Proven track record of establishing Artificial Intelligence, Machine Learning, Advanced Analytics, Data Governance, Data Management, Data Storage and Archival Strategies and executable roadmaps.
  • Conceptual, physical and logical modeling experience with Erwin or similar tools.
  • Exposure with ETL technologies such as SSIS, Informatica, etc.,
  • Proficient with BI tools like Power BI, SSRS.
  • Familiarity with State Department and the Managing State Projects for Information Technology (MSP-IT) project cycle.
  • Knowledge on advanced technology concepts like Big Data, Hadoop, Hive, Cloud, etc.
  • Familiarity with State Department and the Managing State Projects (MSP) project cycle
  • Familiarity with the Software Development Life Cycle (SDLC)
  • Previous experience working with Federal Government clients is highly desirable
this job portal is powered by CATS

Not seeing a career available and still want to be considered for a position at MSAG? No Problem, we've got you covered!