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