CharlotteRecruiter Since 2001
the smart solution for Charlotte jobs

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

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Log In or Create An Account

Get the latest North Carolina jobs by following @recnetNC on Twitter!

Charlotte RSS job feeds