Skip to main content
Tallo logoTallo logo

Find Jobs

Find Jobs Near You – Available Work in Your Location

Skip to job details

Back to Results

Apply for this opportunity

To apply for this job, you'll continue to an external website or email application.

Cyber Guardian Threat Solutions LLC

USMS - (OSI) Data Warehouse Specialist, SME

Review key factors to help you decide if the role fits your goals.
Pay Growth
?
out of 5
Not enough data
Not enough info to score pay or growth
Job Security
?
out of 5
Not enough data
Calculating job security score...
Total Score
42
out of 100
Average of individual scores

Were these scores useful?

Job Description

This position will support a project providing business case and business process analysis for a large government agency and will be responsible for developing and creating organization-wide data policies, standards, and processes and for oversight and strategy execution of the data governance and data quality framework.
Work Location:
On-site in Arlington, VA, with normal hours M-F, 7am - 4pm.
Essential Duties and Responsibilities:
This position will include, but is not limited to, the following tasks:
  • Perform data cleansing and standardization (e.g., removing duplicates, sanitization), assessing data quality, and eliminating irrelevant data to identify and interpret data patterns and trends.
  • Plan and execute data migration strategies from legacy systems to modern databases.
  • Assess data repositories for compliance with data governance policies and standards.
  • Create database queries using ANSI SQL or other programming languages.
  • Create reports/dashboards leveraging Power BI.
  • Analyze data from various systems and formats and audit databases regularly to maintain data quality.
  • Ensure data integrity and data standards within databases.
  • Provide enterprise data solutions and enhance reporting capabilities.
  • Maintain current databases and database objects.
  • Coordinate with other team members to reach project milestones and deadlines.
  • Identify areas for improvement in the current process.
  • Collaborate and work with business users and IT partners to remediate identified gaps, using both manual and automated solutions.
  • Recommend processes and create reports to continuously monitor data quality.
Basic Required Qualifications and Skills:
  • Bachelor's degree in a relevant discipline from an accredited institution of higher learning. 5+ years of experience with data architecture, data management, data analysis, IT process reengineering, systems analysis, design, and implementation, and data modeling
  • Hands-on experience with: o data migration/integration of multiple data sources into a single repository. o Data Analysis o SQL programming language (e.g., ANSI SQL)
  • Familiarity with: o Reporting/ad-hoc analysis tools such as Tableau, Power BI
Knowledge of:
o Master Data Management principles o Data Integration and Data Migration o Microsoft Power Apps
  • Expert knowledge of: o MS Office Suite (Word, SharePoint, Excel, and PowerPoint)
  • Excellent communication, consultation, conflict resolution, negotiation, and facilitation skills.
  • Able to: o Contribute to creating, refining, and documenting team business processes (e.
g., in SOPs, design documents, process diagrams, etc.) in a highly flexible environment. o Be flexible and able to thrive in a time-sensitive environment to meet strict deadlines with sudden and unpredictable needs. o Independently synthesize unstructured feedback from stakeholders and consider relevant data to present quality business solutions.
  • Proven problem-solving skills with demonstrated ability to think out of the box and generate creative solutions; ability to break a complex problem down into its component parts and arrive at the appropriate solution in a timely fashion.
  • Positive attitude, averse to the status quo, always looking to improve current processes and procedures; ability to see opportunities for change, capitalize on them, and implement them when appropriate for the benefit of the organization.
  • A self-starter with a strong work ethic who sets high standards for self and others and demonstrates enthusiasm for the mission of the team.
  • Please note that pursuant to a government contract, this specific position requires U.S. Citizenship.
  • Must have an active DoD Secret clearance or higher to establish reciprocity for Moderate Risk Background Investigation (MBI) Public Trust T3 case type.
Investigation closure date MUST be less than five years old. Must be able to obtain Moderate Risk Background Investigation (MBI) regardless.
Job Type:
Full-time Pay:
$120,000.00 - $130,000.00 per year
Benefits:
401(k) matching Dental insurance Health insurance Paid time off Vision insurance
Education:
Bachelor's (Preferred)
Experience:
Data analysis skills: 5 years (Required) Ability to
Commute:
Arlington, VA 22202 (Required)
Work Location:
In person

Benefits

  • Paid Time Off (PTO)
  • 401(k) Plans
  • Health Insurance
  • Dental Insurance