Senior Data Analyst

Job Title: Senior Data Analyst

Business Unit: Applied General Agency

Location: Southern California

About Applied General Agency

Are you looking to come work for a proven FMO with over 20 years of helping agencies and brokers build their best business? Over twenty years ago Patrick Rodriguez launched Applied General Agency (AGA), Inc. AGA has now become one of the largest Medicare-focused Field Marketing Organizations (FMO) nationwide. Our guiding principle throughout the ever-changing healthcare landscape is to empower our brokers and agencies with the best training and latest strategic tools to succeed. The effectiveness of our service model is measured by nearly fifty carrier partners and thousands of agents we are honored to serve. If AGA sounds like a company you would like to work for because there is no comparison when it comes to the service and dedication, then we want to speak to you.

Job Summary

The Senior Data Analyst will work as part of the Data Management team in completing a variety of tasks relating to data management and cleanup. Their primary responsibility is to prep data received from various sources to be used by AGA for analytics or to provide automated, highly customized marketing channel solutions for our clients. Specific tasks and responsibilities are highly dependent on the individual project but may include data cleansing and organization within Excel, loading data into relational databases for complex data hygiene and aggregation, or maintaining and adjusting established processes to fit the current needs of the project. The Sr. Data Analyst may occasionally be required to perform other responsibilities including working with the development team to create web interfaces for data management, setting up stored procedures, or running periodic processes to keep ongoing databases up to date. 

Primary Responsibilities:

• Prep raw data files for loading into database.

• Perform cleanup, deduping, and suppressions on data.

• Prep data files for use with analytics, marketing automation, or for sending to client.

• Maintain and ensure integrity of data through transformations and cleansing.

• Maintain workflows and scripts used to automate data tasks.

• Create new workflows and scripts to automate repetitive data tasks as projects require.

• Work with various teams and various clients on other projects as needed.

• Other duties as assigned.

Primary Skills & Requirements:

• Must be organized and administratively excellent in handling projects, details, and communication.

• Must excel at using logical reasoning in solving complex problems.

• Must love working in a dynamic fast paced yet fun environment.

• Proactive individual with strong sense of urgency will fit well.

• Highly proficient in Word, Excel, and Power Point.

• Must have some combination of the skills below and a willingness to learn new skills as projects require:

• Understanding of relational database principles – data normalization, data types, relations, keys, constraints, stored procedures, DQL, DML, DDL, ETL, OLTP vs OLAP.

• Understanding of software coding principles – variables, arrays, operators, control flow statements, class objects and methods.

• Understanding of principles relating to raw data – file types, file encodings, delimiters, line breaks, escape characters, special Unicode characters.

• Familiarity with SQL, Java, Visual Basic, PHP, CSS, HTML, XML, JSON, Python.

• Familiarity with MySQL, Microsoft SQL Server, Talend Open Studio, XMPie, Power BI, or Tableau.

• Bachelor’s degree in computer science, management information systems, engineering, supply chain management, marketing or economics, or related degree.

• 2+ years of relevant experience in business intelligence and/or data management & metrics.

• Experience leading successful direct client communications.

• Demonstrated ability to manage multiple complex analyses and relationships.

• Must be organized, detail oriented, flexible and able to prioritize multiple projects.

• Has successfully led large scale and complex marketing analytics and data management engagements.

• 1-2 years working for an agency preferred.

About Integrity

Integrity is one of the nation’s leading independent distributors of life, health and wealth insurance products. With a strong insurtech focus, we embrace a broad and innovative approach to serving agents and clients alike. Integrity is driven by a singular purpose: to help people protect their life, health and wealth so they can prepare for the good days ahead.

Integrity offers you the opportunity to start a career in a family-like environment that is rewarding and cutting edge. Why? Because we put our people first! At Integrity, you can start a new career path at company you’ll love, and we’ll love you back. We’re proud of the work we do and the culture we’ve built, where we celebrate your hard work and support you daily. Joining us means being part of a hyper-growth company with tons of professional opportunities for you to accelerate your career. Integrity offers our people a competitive compensation package, including benefits that make work more fun and give you and your family peace of mind. 

Headquartered in Dallas, Texas, Integrity is committed to meeting Americans wherever they are — in person, over the phone or online. Integrity’s employees support hundreds of thousands of independent agents who serve the needs of millions of clients nationwide. For more information, visit Integrity.com.

Integrity, LLC is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender identity, national origin, disability, veteran status, or any other characteristic protected by federal, state, or local law. In addition, Integrity, LLC will provide reasonable accommodations for qualified individuals with disabilities.