Data Security Analyst in Charlotte, NC
Company: AccruePartners
Location: Charlotte
Posted on: May 27, 2023
Job Description:
THE TEAM YOU WILL BE JOINING:
- Top 25 U.S. digital financial services company committed to
developing award-winning technology and services.
- Named one of the top three fastest-growing banking brands in
the U.S. in 2020.
- Offers a full suite of products including mortgage lending,
personal lending, and a variety of deposit and other banking
products (savings, money-market, and checking accounts,
certificates of deposit (CDs), and individual retirement accounts
(IRAs)), self-directed and investment-advisory services, and
capital for equity sponsors and middle-market companies.
- Where permitted by applicable law, must have received or be
willing to receive the COVID-19 vaccine by date of hire to be
considered. WHAT THEY OFFER YOU:
- Fast paced, highly collaborative, teamwork-oriented
environment
- Make an immediate impact in this high visibility role
- Ability to drive change within the organization with a focus on
advancement in technology and programs
- Top-notch leadership committed to developing people THE
BACKGROUND THAT FITS
Roles and Responsibilities
- Min 2+ years of experience in "Snowflake Cloud Data warehouse"
hands on "Snowflake Cloud Development/Support
- Must have extensive hands-on experience in designing,
developing, and maintaining software solutions for a medium to
large scale Datawarehouse Exposure in Snowflake
- Leveraged data quality by classifying data using Policies,
Rules and generate reports using Macros, Vlookup, Pivot Table, Data
Manipulation.
- Experience with data identification and classification
taxonomy, tools and processes
- Deploy and maintain security systems relating to Database
Monitoring and Firewall, Data Masking, Data Discovery and
Classification, DB vulnerability management, Data Encryption and
intrusion detection and prevention, etc
- Be involved in all aspects of the development life cycle
including, requirements gathering, architecture, development,
testing, training, implementation, and support of reporting
applications to be used internally by our employees.
- Understand business requirements in BI context and design data
models to transform raw data into meaningful insights
- Retrieve data from multiple data sources and build data sets
for end user business consumption using using SQL, SAS or Python
(Prefer Python)
- Create dashboards and interactive visual reports using PowerBI
, Tableau or other tools
- Analyzing data and present data through reports that aid
decision-making
- Analyze data and situations, reason logically and creatively,
identify problems, draw valid conclusions, and develop effective
solutions
- Advanced working knowledge of SQL, SAS, Python, R, and
Databases with the ability to write complex SQL statements to build
data tables and produce reports
- Convert business requirements into technical specifications and
decide timeline to accomplish
- Using your creativity and curiosity to partner with associates
in other business areas to define business needs and help translate
those needs into reporting system requirements
- Interface with other teams and departments to develop new and
modify existing reporting applications.
- Ability to identify security risks and work with IPRM team to
report and lead the remediation efforts.
- Identify bottlenecks and issues and develop creative solutions
Required Qualification
- Deploy and maintain security systems relating to Database
Monitoring and Firewall, Data Masking, Data Discovery and
Classification, DB vulnerability management, Data Encryption and
intrusion detection and prevention
- Advanced working knowledge of SQL, SAS, Python, R, and
Databases
- All Cloud Database Activity/Monitoring & Data
Classification
- Bachelor`s degree in Computer Science, Business Administration,
related field, or equivalent experience
- 2+ years of experience in the development Snowflake/other Cloud
Data warehouse
- 2+ Years of Experience in Data Classification
tool/techonology
- Ability to optimize dashboard performance to handle large
volumes of data
- Proven knowledge of handling both structured/unstructured data
in data lakes (with Hadoop Hive) is a plus
- Working experience in Power Bi
- Strong T-SQL knowledge is preferable
- Advanced working knowledge of SQL, SAS, Python, R, and
Databases
- Identify key performance indicators (KPIs) with clear
objectives and consistent monitoring
- Excellent written and verbal communication skills are required
to communicate with business managers and end users
- Required hands on experience on Security Policies, rules,
Security Incidents
- At least 4 years` experience in securing data in databases like
Oracle, DB2, SQL server, RDS, DynamoDB and MYSQL.
- Ready to learn new technologies and new initiatives
- 1+ years in configuration item inventory management
- Knowledge of Compliance aspects of PCI, SOX, GLBA, NYDFS,
Sarbanes-Oxley, and other relevant laws and regulations
- Experience on SIEM tools preferably Splunk
#LI-PO1
Keywords: AccruePartners, Charlotte , Data Security Analyst in Charlotte, NC, Professions , Charlotte, North Carolina
Didn't find what you're looking for? Search again!
Loading more jobs...