ETL QA/Data Analyst

Sammons® Financial Group Companies offer some of today’s most sought after life insurance, annuity, and retirement planning products.

Unlike most financial organizations, our companies are not publicly traded, which means we’re focused on long-term value rather than short-term earnings pressures.

As a privately held company, our leaders and employees remain consistently focused on long-term growth, making decisions that allow us to deliver on our commitments to customers, distribution partners, our employees, and our communities.

Individually, our companies provide value in the products and services they offer.

Together we represent a history of strength and longevity.What you can expect when you join Sammons Financial Group:* A casual dress code including jeans* A rich company culture driven by private ownership and intentional leadership inspiring employees to engage in our healthy, high-performing and values based culture* Healthy balance between work and personal lives.

Friday afternoons off all year long, competitive PTO and generous number of paid holidays* Great benefits including medical, dental, vision, wellness plan, charitable giving programs, education assistance… to name a few* ESOP-A generous 100% company funded retirement planWhat you can expect* Test the data to ensure corresponding ETL code is developed as per Data Design Documents.* Report test defects.* Leading Defect Triage discussions.* Reporting QA progress to team leadership.* Lead offshore team members.* Coordinate and organize user acceptance testing activities.* Complete data profiling and define data transformations for use by the ETL Developers.Qualifications:* Advanced SQL Skills* Understanding of Data projects and Data Design Documents* Previous Experience with Data Design and Development concepts* Previous experience with testing Operational Data Store (ODS) and Enterprise Data Warehouse (EDW).* Previous experience in an agile analytics environment preferred.* Proactive, problem solver and self-motivated.* Bachelor’s Degree business or information technology related major preferred* Minimum 6 years’ quality assurance experience relative to the development and execution of test cases and analysis of testing results preferred* Proven experience with test automation tools preferred* Proven experience working in Agile teams preferred* demonstrated leadership experience; preferably in a quality assurance role preferred* Strong mathematical aptitude* Strong Microsoft Excel skills and familiarity with other Microsoft tools such as Word and Access.

Ability to understand and create SQL queries* Understanding of complex life or annuity products and processes* Strong communication skills including verbal, written, and presentation skills* Strong interpersonal skills and proven ability to work and communicate with a variety of personalities, across locations and varying organizational levels* Proven ability to research, analyze, and resolve problem situations using strong judgment and high level decision making skills* Strong initiative, self-motivation, and ability to work independently and oversee work of others* Ability to handle multiple projects simultaneously and work effectively under deadline pressures on complex projects* Demonstrated mastery of previous levels skills and responsibilities* Criminal background check required.