Data Integration Architect - Boise, United States - Idaho State Job Bank

Description

Up to 10% Clearance Required : Ability to Obtain Public Trust What You Will Do : + Create and maintain comprehensive diagrams and documentation that encompass all components of our IT systems, including network topology + Design and develop IT architecture solutions that meet the organization's strategic goals and objectives + Translate business needs into long-term data architecture solutions + Define, design, and build dimensional database schemas + Evaluate reusability of current data for separate analyses + Conduct data sheering to rid the system of old, unused or duplicate data + Review object and data models and the metadata repository to structure the data for better management and quicker access + Collaborate with cross-functional Agile teams to gather and analyze requirements and provide technical guidance + Evaluate and recommend the adoption of new technologies and best practices to improve IT architecture + Ensure data integrity, security, and compliance with industry standards and regulations + Orchestrate the data modelling activities across multiple products + Create conceptual, logical, and physical data models What You Will Need : + Bachelor's Degree.

You can substitute 4 years of additional exp for degree + US Citizenship or Green Card and the ability to obtain and maintain a federal Public Trust Years of IT experience + Experience as Solution or Data Architect + Proficiency in creating and maintaining detailed database diagrams and documentation + Strong analytical and problem-solving skills + Excellent communication and collaboration skills + Ability to work independently and as part of a team + Advanced experience with SQL + Experience with data modeling tools + Experience with a relational databases including MySQL, MS SQL Server, and/or Oracle + Deep understanding of data modelling and experience in preparation of optimal data structures + Familiar with data warehouse architecture, understanding of data warehouse concepts What Would Be Nice To Have : + Experience with JIRA and Confluence + Experience with Amazon Web Services (AWS) + Experience with modern data governance tools + Experience with Highly Available database configurations + Knowledge in Information Security concepts Federal government project experience The annual salary range for this position is $66,700.