Data Analyst

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 - $105,000