Data Analyst
Santa Barbara, CA, United States
Opportunity
Angeion Group is looking to welcome a Data Analyst to its rapidly growing team. This is a full-time, remote position. Hours are West Coast Hours.
About the Company
Angeion Group is a leading provider of comprehensive settlement management services for class actions, mass tort, and bankruptcy administration. Leveraging world-class technology, proven best practices, and expert consulting, Angeion delivers the services and capabilities that drive greater efficiency in settlement administration. Formed by a proven and experienced executive leadership team, Angeion is bringing novel ideas and fresh approaches to notice and claims administration. For more information, please visit our website, http://www.angeiongroup.com.
About the position
The Data Analyst will be working with high volumes of data to support project needs. Your success is dependent on building a strategic partnership and becoming aligned with the operations and technology teams. We require a candidate with the motivation to succeed and a passion to excel. The candidate must be capable of rising to the challenge of working for a preeminent organization that serves national clients. As an industry leader, we expect our team to be willing to learn to accomplish their work with the highest operational excellence. You will work internally across departments and externally with clients and vendors, so it is imperative to always demonstrate the highest level of professionalism.
Duties and Responsibilities Manipulate large amounts of data (mass insert, update, upsert, delete) using SQL statements
Perform data transfer functions by importing and exporting data to and from the MySQL, Redshift, or other sources, leveraging SQL and Python for data migration and pivoting
Review project requirements and provide expert advice regarding the structure of databases and forms
Utilize data analysis and SQL skills to design and develop database queries, extract participant-level data from databases and analyze the data using a variety of analytical techniques
Generate and analyze data reports from internal and external sources
Research and data mine as directed to retrieve data/status and develop/provide metrics as required
Collaborate in all aspects of the collection, verification and entry of data
Perform data transfer functions by importing and exporting data to and from Redshift, SQL Server and MySQL
Conduct quality control and auditing of databases in a client/server environment to ensure accurate and appropriate use of data
Design workflows to control access to data and optimize the flow of information
Provide all activities related to the administration of databases
Provide data and analytical support for cases
Document guidelines for appropriate database usage, data maintenance and key report processing
Monitor data management repositories and communicate documentation to team
Support with organization, tracking, maintenance and validation of spreadsheets
Develop a process and associated plan for the maintenance of existing reports, trackers, and documents for the creation, incorporation and maintenance of new reports
Design, implement, and maintain complex databases with respect to access methods, access time, device allocation, validation checks, organization, protection and security, documentation, and statistical methods
Fully document all work and comply with development best practices
Participate in and conduct code reviews of both team and vendor-supplied code and determine quality, identify bugs and evaluate risks
Ensure architecture is consistent with organizational development standards and align with industry guidelines and best practices
Continually work towards strengthening industry knowledge and all relevant applications
Communicate regularly and effectively with all colleagues
Exhibit a very organized approached and superior attention to details
Meet regularly with managers to provide feedback and facilitate communication
Adhere to all business processes while performing tasks
Able to take on new tasks and responsibilities as needed
Perform other work-related duties as assigned by management
Qualifications Bachelors degree in computer science, business or other related field or discipline
Database system(s) experience required
Complex data analytics experience required
Python Language - 5 years experience
LAW PreDiscovery LexisNexis experience preferred
5 years experience with SQL, advanced Excel (including VBA), data mining; prior coding experience constitutes an advantage
System implementation and system integration experience
Skilled in business analysis, process improvement, and project management
Minimum of 3-5 years of experience and a demonstrated track record of accomplishments
Aggressive problem diagnosis and creative problem-solving skills
Demonstrate a high degree of productivity while handling multiple tasks simultaneously
Ability to perform comfortably in a fast-paced, deadline-oriented work environment
Excellent written, verbal, communication, and research skills a must
Ability to be flexible to adapt and act quickly when urgent matters require it
Able to work effectively with diversified individuals of various ethnic backgrounds and professional competencies
Project a positive, professional image toward clients, vendors and staff in all interactions and situations
Maintain the highest level of confidentiality
Problem analysis and resolution skills at both a strategic and functional level
Excellent computer skills including all MS Office applications. (Word, Excel, Outlook, PowerPoint) required
Must be presently authorized to work in the U.S. without a requirement for work authorization sponsorship by our company for this position now or in the future
Benefits Include: 15 Days Vacation, 3 Floating Holidays, Sick Time, Medical, Dental, EAP, Spending Accounts and 401K.
Annual Salary - $80,000 - $90,000