Job Title: Data Management Consultant - SQL
Duration: 07+ Months
Location: Irving, TX
Job Description:
1. To provide Information Security (IS) metrics to Executive Management, CISO senior management, ISROC, CIOC, and the IS Community on a timely basis.
2. To provide a platform to define and measure IS risk, process, threat, and operational indicators.
3. To provide IS Monthly Reports and ad-hoc reports to stakeholders.
4. To provide IS Metrics and interactive Analytics in near real-time via CISO Business View application to stakeholders and practitioners.
5. To provide details of IS issues to the Information Security practitioners.
6. To manage enhancements and changes in the IS Reports and CISO Business View in collaboration with IS Program Owners.
7. To maintain historic IS Risk data.
Responsibilities:
- Data analysis and modeling techniques.
- Technical requirements writing.
- Have hands-on experience in data modeling, reporting, and dashboards.
- Have a thorough understanding of SQL, databases, tables, and data design concepts.
- Produce data sets which are the basis for the interactive analytics and update the data sets on a daily / weekly / monthly basis through automatic ETL jobs.
- Create, maintain, and improve the interactive analytics dashboards with appropriate data visualizations.
- Presentation skills: The reports and data analysis artifacts must be presented to stakeholders in a clear and easily understood format in Excel, PowerPoint, Word, or PDF documents.
- Work on CISO Metrics related projects: Work on assigned projects which generally involve the above areas.
Qualifications:
- Have hands-on experience in data modeling, reporting, and dashboards.
- Have a thorough understanding of SQL, databases, tables, and data design concepts.
- Experience SQL programming using Oracle.
- Experience in scheduling tools like Autosys.
- Knowledge in data modeling concepts.
- Understand the concepts of ETL (extraction, transform, and load).
- Must be able to produce precise and well-crafted reports, familiarity with SQL, and databases.
- Understand general Information Security.
- Be proficient in Office products such as Excel, Access, PowerPoint, and Word.
- Data analysis and data design skills are a must.
- Agile Experience.
- Excellent communication, interpersonal, and leadership skills, thrives in both independent and collaborative work environments.
- Crisp and clear written/Verbal communication style.
- Have good presentation skills and produce precise and well-crafted reports.
- Bachelor’s/University degree or equivalent experience.
Company Information: Dexian is a leading provider of staffing, IT, and workforce solutions with nearly 12,000 employees and 70 locations worldwide. As one of the largest IT and professional staffing companies and the 2nd largest minority-owned staffing company in the U.S., Dexian was launched in 2023 and created from the combination of DISYS, Signature Consultants, and other strategic acquisitions. Visit www.dexian.com to learn more.
Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.
#J-18808-Ljbffr
