Data Warehousing Specialist Job at Innovative Management Concept (Arlington)

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.

Job Responsibility

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

Requirements

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 data migration/integration of multiple data sources into a single repository, data analysis, and SQL programming language (e.g., ANSI SQL)
Familiarity with reporting/ad-hoc analysis tools such as Tableau, Power BI
Knowledge of Master Data Management principles, data integration and data migration, and Microsoft Power Apps
Expert knowledge of MS Office Suite (Word, SharePoint, Excel, and PowerPoint)
Excellent communication, consultation, conflict resolution, negotiation, and facilitation skills
Able to contribute to creating, refining, and documenting team business processes (e.g., .SOPs, design documents, process diagrams, etc.) in a highly flexible environment
Able to be flexible and able to thrive in a time-sensitive environment to meet strict deadlines with sudden and unpredictable needs
Able to 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
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

What we offer

401(k) with a 3% employer match
paid time off
paid holidays
FSA spending
dental
vision
health insurance
company-sponsored AD&D
life insurance

Innovative Management Concept - All Job Offers

Select Country

Data Warehousing Specialist

Job Description

Job Responsibility

Requirements

What we offer

Looking for more opportunities?

Data Warehousing Specialist

Data Warehousing Specialist

Acumatica Data Warehousing Specialist

Acumatica Data Warehousing Specialist

Specialist, Data & AI Governance

Bi and data specialist

Inventory Data Specialist

Specialist - Data Engineer

Data Modelling Specialist

Our AI answers in your language