Data Warehouse Analyst Data Warehouse Analyst …

Argo Incorporated
in Lackland Air Force Base, TX, United States
Permanent, Full time
Be the first to apply
Argo Incorporated
in Lackland Air Force Base, TX, United States
Permanent, Full time
Be the first to apply
Data Warehouse Analyst
Senior Data Warehouse Analyst US TX - San Antonio/en-US/Argo/job/US-TX---San-Antonio/Senior-Data-Warehouse-Analyst_R0002711-1/apply

At Argo Group, our team members are critical to our long-term success so wherever in the world they work, everyone works together. Within our Data Team, we are looking for a Data Warehouse Analyst.

We are seeking a Senior Data Warehouse Analyst to serve as a liaison between business units and the current IT Data Team to gain in-depth understanding of data linked to each business process. The role will report to the Director of Data and will be key in understanding the business needs and aligning them with data teams strategy and architecture.

The focus of this position is to work closely with both the onshore and offshore data teams to ensure accurate and timely closing of the financial period and successful loading of data to the General Ledger. This role will also be responsible for developing a strong relationship with the finance team who we partner with the on the load of financial information.

What does the Senior Data Warehouse Analyst workday look like?

  • Facilitate process design by conducting business and systems process analysis; focusing on quality improvement and data management ensuring reliability and validity of data.
  • Collaborate closely with business teams to develop and implement technical requirements.
  • Guide team thru process of creating SQL Queries that will make our data evaluation process more flexible or scalable across data sets.
  • Research data issues in financial data warehouse and communicate the result of that research to stakeholders, and key business leaders.
  • Lead the process of loading externally sourced data to our financial data warehouse for posting to the general ledger monthly.
  • Work closely with offshore leadership team to align resources for month end processing and raising data flow processes when issues arise.
  • Diving into large data sets, uncovering insights, and providing impactful recommendations.
  • Identify, develop and execute data control requirements, i.e. Reconciliations and validations.
  • Organize complex problems into simple solutions and precise business and technical requirements
  • Ensure Balance and controls are in place for each data movement point, additionally responsible for reviewing those controls with the finance team to obtain sign off for posting to ledger.

What is required for the position?

Required Skills

  • Strong SQL and Excel skills with the ability to learn other analytics tools.
  • 5+ years ETL experience with SSIS required.
  • 5+ years of Structured data analysis and data requirements development experience is required.
  • Experience with documenting data architecture, data flows, and business process flows is required.
  • Experience in insurance industry is preferred.
  • Prior experience with database and model design is required.
  • Ability to communicate complex information to others in a way they can understand.
  • Strong communication and negotiation skills are required.
  • Ability to work in fast paced, rapidly changing environment.


  • Bachelors degree in Business, Computer Science, mathematics, and statistics, or equivalent work experience.
  • Data analysis: 5+ years (Required)
  • 5+ years experience with SQL databases.
  • 3-5 years of work experience in a relevant industry.
  • Leading Scrum/Agile teams is preferred, working knowledge of Agile is required.
  • Experience with Oracle databases is a plus

In addition, you embody our core values as they are the key to our success:

  • We desire to excel
  • We are committed to our clients and to each other
  • We have the courage to do the right thing
  • We apply original thinking

Developing our employees professionally and personally strengthens our organization. Argo Group offers competitive pay and benefits that protect and enhance the lives of employees and their eligible dependents by way of health and wellness plans, life insurance, savings and investment opportunities, adoption assistance, education assistance, and matching gifts for education and charitable causes, just to name a few.

Come join the World Class Leader in Global Specialty Insurance and build your career here! And dont forget to tell your friends, we have a fantastic Employee Referral Program too!

PLEASE NOTE: At this time, Argo Group will not sponsor an applicant for employment authorization for this position.

If you have a disability under the Americans with Disabilities Act or a similar law and you wish to discuss potential accommodations related to applying for employment at Argo Group, please contact our Benefits Department at 210-321-8400.

To all recruitment agencies: Unless you have been requested to work on this position, or other positions with Argo Group, please do not forward any resumes to Argo Group employees. Argo Group is not responsible for any fees related to unsolicited resumes.

We are an Equal Opportunity Employer. We do not discriminate on the basis of age, ancestry, color, gender, gender expression, gender identity, genetic information, marital status, national origin or citizenship (including language use restrictions), denial of family and medical care leave, disability (mental and physical) , including HIV and AIDS, medical condition (including cancer and genetic characteristics), race, religious creed (including religious dress and grooming practices), sex (including pregnancy, child birth, breastfeeding, and medical conditions related to pregnancy, child birth or breastfeeding), sexual orientation, military or veteran status, or other status protected by federal, state and/or local laws.

Applicants: For the most convenient application experience, please use the Apply with LinkedIn button. If manually entering, only include your most recent or relevant job information needed for this role. For either method, please attach your most current resume. Additional job history may be obtained if selected for the interview process.

Posted 2 Days AgoFull timeR0002711

Argo Group International Holdings, Ltd. (NYSE: ARGO) is an international underwriter of specialty insurance and reinsurance products in areas of the property and casualty market. Through its operating subsidiaries, Argo Group offers a comprehensive line of high-quality products and services designed to meet the unique coverage and claims-handling needs of its clients in four business segments.

  • Excess & Surplus focuses on risks that the standard (admitted) market is unwilling or unable to underwrite because of the nature of their businesses, their particular risk exposures or their loss histories.
  • Commercial Specialty provides standard-market property and casualty insurance and surety coverage to highly specialized commercial and public entities.
  • International Specialty writes both insurance and reinsurance business worldwide through the broker market, with offerings including specialty property catastrophe reinsurance along with excess casualty and professional insurance.
  • Syndicate 1200 operates through a Lloyds of London syndicate offering property and liability coverage.

Argo Group International Holdings, Ltd. is headquartered in Bermuda.