Data Architect 1

  • Cedar Falls, IA
  • Contract

Company Description


This is our direct-client opening for an ArcSight Information Security Consultant located in Columbus, GA. This is a 3+ month contract-to-hire position and the salary upon conversion to a full-time employee will range depend on experience level, 

The candidate will provide technical\consultative support for the company’s Arcsight SIEM solution, to include management and maintenance of the current system, provide input on performance\stabilization improvements, created and maintain use cases supporting our SOC and other groups within the company, and guide management and team members with SIEM's best processes and practices. The job includes leading projects, managing relationships with other areas, processing security model updates, monitoring and reviewing access violation and security maintenance reports, and other duties as assigned. They will also analyze business and/or technical requirements to formulate a project plan. This includes risk assessments and scenarios to mitigate risk while still meeting required timelines. Lastly they will perform analyses and issues resolutions of business and project requirements. 


Deploying and maintaining ArcSight SIEM systems 
Coordinating and conducting security event collection, using log management tools, initiating event management, enhancing compliance automation, and leveraging identity monitoring activities using the SIEM platform. 
Advising leadership on monitoring and reporting best practices and develops use cases on how to use SIEM technologies to achieve end state requirements 
Interfacing with the business units, corporate functions, and security and risk personnel. 
Provides technical administration services for the ArcSight ESM, Logger and Connectors deployed in our environment. 
Providing requirements for custom development of Connectors (Agents) using the ArcSight FlexConnector 
Customizing security content including filter/rule/report creation, signature categorization, vulnerability mapping 
Responsible for configuration files, database tuning, configuration changes, sizing, and troubleshooting 
Collaborating with IT resources on troubleshooting and configuring networking devices, various platforms 
Developing integration capabilities with 3rd party systems including network management and trouble ticketing applications 
Responsible for upgrades and patches for all components of the ArcSight SIEM platforms 
Has overall responsibility for being the subject matter expert on SIEM software 
Developing standards and methodologies within the Information Security team 
Discovering, categorizing, and analyzing vulnerabilities, recommend/develop remediation/mitigation strategies, and escalate security events to the appropriate support team 
Security integration services including firewall, IPS, SIEM, multi-factor authentication, mobile security, routing, switching, servers, workstations, etc. 
Other duties include but are not limited to: participating in network, security hardware engineering and troubleshooting efforts, technical writing, as well as, mentoring peer engineers, and special projects as assigned by management.




Four year college degree and 4 or more years professional experience or 6 or more years professional experience is required.

We require a strong technical background in various information security and related products and concepts including some of the following areas: Arcsight, Systems design and integration, WAN Administration, Strong network administration skills, extensive customer relations experience, or customer Help Desk support experience.

Professional certification(s) preferred: AEIA, AESA, Security +, SANS, CISSP

Internal Notes:


The ideal candidate has to have installed Arcsight Enterprise platforms (multiple appliance connectors, loggers, that feed an ESM or more)  They cannot be just one that worked cases from a screen displaying ESM.  There are two main platform versions of ESM, ORACLE based and CORR.  We are Oracle now and are migrating to CORR.  A person with knowledge migrating to this would be helpful.   

There are four jobs or job levels for Arcsight: 

1) Administrates the Application running on the hardware, the care and feeding.   
2) Knows how to "Onboard" Systems and Applications via Smart Connectors and Flex Connectors. 
3) Able to view the data coming in via Logger and ESM and tune and right use cases accordingly. 
4) Analysis the data and react to the reports and alerts that are coming from the ESM system and work the cases respectively.   

I am looking for a person that has 1 through 3.  Number 4 is usually the analysis that you see at the SOC, staring at a screen, although having a person with experience with all four is a plus. 


Please complete the following skills-matrix and send back with your updated resume.


Full Name:


Total Experience as a Information Security Consultant/Engineer:

Total Experience with ArcSight SIEM systems:

Total Experience with WAN Administration:

Total Experience with Network Administration:

Do you have any relevant certifications, such as AEIA, AESA, Security+, SANS, or CISSP (not required, just a plus)?

Do you have any experience migrating ArcSight ESM from Oracle to CORR (not required, just a plus)?

Total Experience developing Connectors using the ArcSight FlexConnector:

Are you interested in a contract-to-hire position?

Current Salary:

Expected Hourly Rate:

Is this Rate W2 OR C2C?

If C2C, what is the name of your corporation?

Expected Full-Time Salary:

Do you have a Linkedin Profile?

If so, what is the URL of your Linkedin Page:

Day Phone #:

Evening Phone #:

Cell Phone #:


Current City/State:

Work Status (US Citizen / Green Card / H1B / etc.):


Job Description

This is our direct-client is looking for a Data Architect 1 - Cedar Falls, IA.  This is a permanent position and the Salary offered is DOE. 
The Cedar Falls Office has an immediate opening for a full time Data Architect in our Information Technology Division responsible for our logical and physical database design and administration.
Job Functions:
•         Lead the transformation of our data management.
•         Architect a simple and concise data model for our complex application, ETL, BI and storage environment.
•         Develop a data management vision and communicate for all levels of co-workers, clients and vendors.
•         Develop a data management tactical plan and communicate for all levels of co-workers, clients and vendors.
•         Resolve operational and reporting needs and benefit both.
•         Document database operations standards, data standards, and procedures.
Requirements for this position are:
•         BS/BA Degree in Computer Science, Management Information Services or related field.
•         A minimum of five years experience with various database management responsibilities in complex environments.
•         Experience handling different data sources and formats,while leveraging the data for business application.
•         Knowledge of big data concepts.
•         Experience with NoSQL (ex. MongoDB, Cassandra, CouchDB), Hadoop, HIVE, PIG or other big data toolsets.
•         Experience with multi-dimensional modeling.
•         Knowledge of SSIS, SSAS, SQL Server, SSRS, T-SQL a plus.
•         Knowledge of applicable data privacy and data security practices and laws.
Please complete the following skills-matrix and send back with your updated resume

Full Name:
Degree Major:
Total IT experience: 
Total Experience as a Data Architect:
Total hands on experience NoSQL, Hadoop:
Total Experience with SSIS, SSAS, SSRS:
Total Experience with TSQL:
Total Experience with ETL, BI and storage:
Total experience HIVE or PIG:
Total experience with Database management responsibilities in a complex environment:
Current Salary:
Expected Salary:
Day Phone #:
Evening Phone #:
Cell Phone #:
Current City/State:
Work Status (US Citizen / Green Card /H1B/ others):
Have you applied recently for this requirement earlier through anyone else? Y/N:
Are you ready to relocate on your own expenses (Yes/No)?
Why are you leaving your current employer?
Why are you interested in this job?

Additional Information