Data Analyst IV Job at Cloud Analytics Technologies LLC in San Jose

Work Authorization: US Citizen, Green Card, H-1B, GC-EAD, OPT-EAD, L2-EAD, TN Visa

Local Candidates Preferred. Non-local candidates must be willing to pay for your own interview travel expenses and relocation costs.

Job Description

Role: Data Analyst IV

Location: San Jose, CA

Duration: 10 months

Job Description:

The Configuration Management Data Analyst (Architect) will 'lead' and 'deliver' a large-scale design (beyond the immediate borders of ITSM and CMDB implementation) that addresses specific asset-related use cases, inter-system and data-to-process mapping – and evangelize the use of ITSM as a Single Source of Truth (SSOT), a hub for in/outbound data flows.

The Configuration Management Data Analyst will work with cross-functional stakeholders (business, application, process teams) to understand their needs, explore the availability of the data within the various data sources, perform analysis and appropriately map them to corresponding data attributes within the ITSM Atrium CMDB. As part of the data integration between the source systems and CMDB, facilitate the data transformation, data cleanup before the data gets into golden dataset in CMDB. Maintain precise documentation and accurate usage of the CMDB data. Assist in defining and registering of configuration items (CIs); the appropriate level of attributes, and relationships required to support IT Service Management (ITSM) processes and the governance of data in the CMDB. This role will also partner with Information Security to make sure that additional vulnerabilities aren't introduced due to the various integrations into the CMDB.

More specific responsibilities include, but are not limited to:

1. Enact system audit practices and conduct audits to ensure data integrity.
2. Reconcile the CMDB data when exceptions are noted between CMDB, discovery information, and other authoritative data repositories.
3. Partner with CMDB normalization and reconciliation rules implementation.
4. Support the integration of various data sources such as ADDM, SCCM, Casper, AD, bulk data, etc., into the Atrium CMDB from the data perspective.
5. Support design, development, and implementation of automated processes for gathering, populating, and maintaining CMDB data.
6. Ability to develop SQL queries and reports for management on KPIs to improve the process effectiveness, efficiency, and data accuracy.
7. Supports the Configuration Management processes using BMC Atrium CMDB and other tools like ADDM.

REQUIRED SKILLS:

• Experience in hardware and software asset and configuration management as well as knowledge of IT service management processes.
• Experience with Hardware/Software Asset and Configuration data and attributes.
• Five years of experience with BMC Atrium, BMC AR System, and BMC Remedy ITSM 7.x and 8.x.
• Familiarity with various BMC Atrium CMDB CI classes and relationships.
• Two years of experience with AI (Atrium Integrator) and other ETL tools.
• Experience mapping the data source attributes to various Atrium CMDB configuration item classes and establishing relationships.
• Experience with Normalization Reconciliation of multiple sources of data feeding into CMDB.
• Familiar with any of the following: discovery products including Microsoft SCCM, BMC ADDM; reconciliation in the BMC CMDB environment; integration of discovery solutions with a CMDB.
• Knowledge of Excel, SQL, query-writing, reporting tools.
• Candidates must have excellent organizational, communication, and problem-solving skills. Candidates should have proven understanding of IT business needs and knowledge of IT industry standard best practices.

Possibility of extension/conversion. Candidate must sit in San Jose but candidates willing to relocate at their own expense may be considered. Phone interview.

Equal Opportunity Employer

Cloud Big Data Technologies is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. Cloud Big Data Technologies will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will Cloud Big Data Technologies require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract.