Data Warehousing Specialist, SME (IMC00789)

The data warehousing specialist will provide data governance and analytics support to our government customer by implementing and maintaining effective data governance frameworks and compliance, while also delivering insightful business intelligence reports designed to empower informed decision makers.

Work Location: Hybrid role with onsite requirements Tuesday and Thursday (weekly) in Arlington, VA, with the balance of work performed remotely, based upon the needs and direction of the customer.   

Basic Required Qualifications and Skills:  Note: These are mandatory items that all candidates must have when submitting an application to IMC for this position. Please ensure that your submission addresses each of these requirement items. Candidates without these required elements will not be considered.

• Bachelor’s degree in a relevant discipline from an accredited institution of higher learning.
• 5+ years of experience with establishing and managing data analytics, data warehousing, and/or quality and data governance programs.
• Thorough understanding of Master and Reference Data Management and data governance best practices and services.
• Intermediate experience in Power BI and Tableau, to include proficient understanding of data transformation, queries, and database connections, with the ability to create and analyze visual reports and dashboards to support decision-making processes agency-wide.
• Expert knowledge and use of the MS Office suite (Word, SharePoint, Excel, PowerPoint, and Visio) to prepare documents, clean and manipulate data, and create and deliver presentations.
• Basic knowledge of common database management platforms (e.g., Oracle, Microsoft SQL Server).
• Strong communication skills (both verbally and in written form) and work collaboratively with cross-functional teams, including IT professionals, law enforcement personnel, and other stakeholders, to foster a cohesive and integrated approach to data governance and business initiatives.
• Excellent 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.
• Expert time management and organizational skills to meet tight deadlines and address evolving priorities in a dynamic work environment. Poses a strong aptitude for prioritizing tasks based on criticality, impact, and urgency to ensure alignment with office initiatives and the agency’s strategic goals and objectives.
• A self-starter with a strong work ethic and positive attitude 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 Moderate Risk Background Investigation (MBI) Public Trust T3 case type or higher (Secret, TS, etc.) and investigation closure date MUST be less than five years old.

Desired Qualifications and Skills:  It is desirable that the candidate has the following qualifications:

• Knowledge of:
  • External data standardization and exchange organizations such as NIEM, FBI CJIS, and ISO.
  • SQL Server 2016 Master Data Services (MDS).
  • Database and programming tools such as SQL Server and Visual Studio.
  • Amazon S3 and AWS Athena query tool.
  • SQL Server Integration Services (SSIS).
• Understanding of:
  • Master Data Repository concept.
  • Data Warehouse concept.

Essential Duties and Responsibilities: This position will include, but is not limited to, the following tasks:

• Develop, refine, and implement organization-wide data governance policies, procedures, and standards to ensure data accuracy, integrity, and security.
• Collaborate with cross-functional teams to establish and enforce data quality standards and best practices.
• Conduct regular data audits and assessments to identify and rectify data issues and discrepancies.
• Provide consultation and direct support to product owners, developers, business analysts, end users, and other customers to further data governance program initiatives.
• Create, refine, and document team business processes (e.g., in Standard Operating Procedures and/or process diagrams) in a highly flexible environment.
• Identify data quality metrics that pinpoint gaps and ensure compliance with standards.
• Collect data from internal and external data sources using a variety of methods and tools.
• Perform data cleansing and standardization (e.g., removing duplicates, sanitization), and assess data quality and eliminate irrelevant data to identify and interpret data patterns and trends.
• Perform comprehensive data analysis to evaluate data quality, discern trends, patterns, and insights crucial for informed decision-making. Collaborate closely with Data Governance leadership to grasp reporting needs and data requisites, interpreting them effectively.
• Develop and maintain interactive, visually engaging reports and dashboards utilizing Microsoft Power BI and Tableau. Analyze, curate, and interpret extensive data sets from diverse sources and formats to generate actional metrics, reports, and visualizations.
• Work with SME’s data stewards, product owners and managers, and other stakeholders, to establish data quality rules and definitions consistent with department and organization strategies.
• Assist with the developer of data quality metrics that identify gaps and ensure compliance with standards across the organization.
• Manage master and reference data in a master data repository.
• Independently synthesize unstructured feedback from stakeholders and consider relevant data to present quality business solutions.
• Implement and document data visualization best practices to ensure effective communication of datasets and product operability.
• Other duties as assigned. 

Salary and Benefits Information: Please see the salary information listed at the beginning of this document, which is not a guarantee of compensation or salary. All salaries will be based on relevant experience, geographic location, and position and/or contractual requirements, which could fall outside of the listed range. For more information about IMC’s benefits, please visit our website at https://www.imcva.com/about-imc/careers.