"Job#: 2028956 Job Description: IT Security Specialist -Hybrid role-3 days on site in Chicago, IL or Denver, CO LocationsYou will be working as part of a team developing methods to quickly reference systems of record (SORs), systems of origin (SOOs) and other available data stores for a comprehensive reliable and timely view of the attack surface and vulnerability exploitability potential, with the goal of enabling answers to the following three questions as quickly as possible.- Do we have it?- Are we vulnerable?- Is it exploitable?The Attack Surface Visibility and Analysis team is responsible for data mining efforts to identify and understand the firms Attack Surface. You will leverage tools like Hue (Hive and Impala), Power BI, SQL Server, Cloudera, .NET and Python to design, create and prepare queries and visualizations for other Security groups, under the supervision of the Attack Surface Visibility and Analysis Manager. A successful candidate will be team oriented, collaborative, persistent, analytical, and detail oriented such that development efforts and deliverables meet deadlines, accuracy and specified purpose. Typically, 5-8 years of IT experience with a minimum of 3+ years of those focused on IT system development work with large data stores. Candidate must also be able to perform analysis against result sets to identify gaps, trends or actionable information.Required job skills:- Hands-on experience with large datasets and tools including data ingestion (batch real time), transformation and delivery5+ years of professional experience writing queries and analyzing output or closely related role- Power BI- SQL development- MS-Reporting Services (SSRS)- MS-Integration Services (SSIS)- Hue (Hive and Impala)- ASP.NET- IIS (Internet Information Services)- Javascript- Excellent research skills - able to identify relevant data sources for information about bank technologies, gain an understanding of how things work and be willing to dig in and help identify usage throughout the firm- Strong analytical skills/problem solving/conceptual thinking.EEO EmployerApex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico.VEVRAA Federal ContractorWe request Priority Protected Veteran & Disabled Referrals for all of our locations within the state.We are an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other protected characteristic. The EEO is the Law poster is available here.PDN-9c1d8156-e02a-4226-8aaa-2b924dd91092"