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

LAW PreDiscovery – LexisNexis experience preferred

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

#J-18808-Ljbffr