Data Architect

Salient Federal Solutions, Inc.; Chantilly (VA); On-site; USD 120,000 - 160,000; Full time

Job summary

Salient Federal Solutions, Inc. is seeking a Data Architect in Chantilly, Virginia. In this role, you will develop enterprise Data Architectures strategies and provide solutions to support business strategies. Successful candidates will have at least ten years of experience in information technology and expertise in data warehouse modeling.

This position involves collaborating on various projects related to data management while ensuring data integrity and quality. The ideal applicant should possess strong communication skills and the ability to lead technical discussions.

Qualifications

• At least ten years of information technology experience in architecture/engineering, information security, or related experience.
• 3-5 years of data architecture experience, with expertise in transactional and data warehouse modeling.
• Ability to obtain and maintain a public trust clearance.

Responsibilities

• Develop enterprise Data Architectures strategies and solution recommendations.
• Work on data modeling, from conceptualization to visualization and optimization.
• Coordinate the design and development of new data sources and ensure integration.

Skills

Data modeling

Database design

SQL development

Data governance

Analytical skills

Communication skills

Education

Bachelor’s Degree in computer science, information science, or related field

Job description

Salient CRGT is a leading provider of health, data analytics, cloud, agile software development, mobility, cyber security, and infrastructure solutions. We support these core capabilities with full lifecycle IT services and training—to help our customers meet critical goals for pivotal missions. We are purpose-built for IT transformation supporting federal civilian, defense, homeland, and intelligence agencies, as well as Fortune 1000 companies.

Job Description

In this role you will:

• Develop enterprise Data Architectures strategies and provide solution recommendations in support of business strategies
• Work across all phases of data modeling, from conceptualization to visualization and database optimization. This extends to SQL development and database administration.
• Review business requests for data and data usage, research data sources and create requirements documentation
• Coordinate design and develop new data sources and usage ensuring consistency and integration with existing warehouse structure
• Design extract, transform and load logic of data, analyze data logs to enhance performance and increase functionality
• Design control and monitoring mechanisms to ensure accuracy and data integrity
• Coordinate development of and / or develop BI presentation layers
• Design, develop, test and deploy dashboards, scorecards, reports and alerts/notifications for the presentation of business metrics according to business user requirements consistent with integrated BI applications and warehouse structure
• Develop support documents for BI applications and provides user support and training
• Lead design of high-level conceptual and logical models that facilitate a cross-system/cross functional view of data requirements
• Oversee the mapping of data sources, data movement, interfaces, and analytics, with the goal of ensuring data quality
• Establish methods and procedures for tracking data quality, completeness, redundancy, and improvement
• Conduct data capacity planning, life cycle, duration, usage requirements, feasibility studies, and other tasks
• Collaborate with project managers and business unit leaders for all projects involving enterprise data
• Identify and develop opportunities for data reuse, migration, or retirement
• Provide consultation during business requirements gathering efforts
• May work with organization departments to design and develop data marts
• Design, develop, and implement the data architecture for a data warehouse, including high-performance ETL (Extract, Transform, and Load) tools, routines and infrastructure
• Lead Data Profiling and Data Quality analysis using SQL or other query based analysis
• Develop and implement solutions for cleansing data to remove errors and ensure consistency
• Recognize and leverage data sources both internally and externally to enhance the analysis capabilities
• Reverse engineer data specifications from source systems through data discovery, analysis, and other techniques

Qualifications

Mandatory Requirements:

• Bachelor’s Degree in computer science, information science, or related field required
• At least ten years of information technology experience -- architecture/engineering, information security, or related experience
• At least 3-5 years of data architecture experience, with expertise in both transactional and data warehouse modeling
• Master data management and data governance experience desired
• Ability to obtain and maintain a public trust clearance
• Salient CRGT will not sponsor work visas for this opening

Desired Qualifications:

• Strong initiative, innovative thinking skills, and the ability to analyze details and adopt a big-picture view
• Excellent oral and written communication skills with the ability to explain complex technical information to technical and non-technical contacts
• Ability to lead and assist a wide range of customers, from executive level to Line of Business, in meeting their business objectives
• Strong interpersonal skills to develop and maintain productive communications with external agencies and productive working relationships with other team members
• Strong data modeling and database design skills
• Intellectually curious, innovative and detail oriented
• Maintain professional demeanor in a fast-paced, changing environment

Salient CRGT is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, age, sex, sexual orientation, gender identity or expression, veteran status, disability, genetic information, or any other factor prohibited by applicable anti-discrimination laws.