Lead Business Intelligence Specialist

Job Posting

This position utilizes critical thinking and communication skills to translate business goals into data management functions and requirements to assist in the design and implementation of business intelligence (BI) deliverables, This includes requirements gathering interviews; participating in planning the delivery of BI solutions; explaining to executives, stakeholders, and users the design structure and capabilities of BI deliverables; and testing the implementation of BI solutions for completeness, accuracy, and alignment with user needs. The specialist should oversee the creation and adherence to standards for required design documents. This position should be a subject matter expert in multiple subject areas or data marts and data delivery, business intelligence, and data warehousing best practices. The position manages a small to medium team/individual contributor, provides support and guidance to team members, assigns work and monitors the progress, assesses performance, and assists with goal setting for direct reports. This position performs functions independently and manages team members’ administrative and HR needs.

What You’ll Do:

• Coordinates with team members to assess when units of work can be completed with consideration of competing priorities and tracks units of work through inception, development, testing, and end-user communication, using appropriate tools.
• Acts as a liaison between users and team management and/or executives to ensure work is done in the proper order, according to priority.
• Identifies overarching issues and helps the team understand the total impact.
• Ensure final requirements are clear, complete, and agreed to by the appropriate parties; and performs high level analyses of requirements and detailed research for data quality and/or reporting issues, triaging and escalating questions and issues to appropriate team contacts, providing insight and suggestions to aid developers in quickly resolving issues.
• Performs data analyses and data profiling tasks assigned using technical tools to access and categorize data from various source systems and existing BI repositories.
• Completes the data design for deliverables, mapping source system data to the desired outputs.
• Ensures appropriate parties are involved in requirements gathering sessions with executive, manager, director, stakeholder, and business users; oversees interviews to ensure the questions necessary for successful delivery are answered to analyze business processes; translates them into user needs and goals; and facilitates requirement gathering sessions with users.
• Explains the design structure and capabilities, appropriate changes, issues, and analysis results to executives, managers, directors, and business users.
• Responds to support questions promptly, courteously, and accurately with analysis results and any issues or changes made.
• Oversees testing efforts to ensure all items are tested before the release and performs quality assurance checks to validate for completeness, accuracy, and alignment with user needs on data and/or deliverables for release.
• Contributes to standards and best practices for quality assurance checks.

What You’ll Need:

• Bachelor’s degree from an accredited institution of higher learning or equivalent work experience (10 years or more) in the business or technical world.
• Eight years or more of experience in developing or documenting data warehouses/data marts or business intelligence solutions.

What You Have: 

• Experience reading and documenting data models using SAP PowerDesigner or similar tools; or experience translating business requirements into data model modification needs.
• Knowledge of data quality, data cleansing, data transformation best practices, and data modeling techniques for target structures such as star schemas, snowflake schemas, and highly normalized data models.
• Knowledge of one or more enterprise source systems and the data contained therein (Ex. CLAS, LOGIC, POS, Cyberlife, Policylink, PDA, BPM, PEGA, iSolutions, ParisQuote, etc.).
• Experience developing or maintaining metadata including source to target mapping documents and data definitions.
• Experience or education in writing moderately complex Structured Query Language (SQL) commands.
• Experience developing with business intelligence reporting tools such as Cognos, MicroStrategy or Tableau.
• Proficient with Microsoft Office Tools (Excel, Work and PowerPoint). Knowledge of business (insurance, marketing, accounting, and/or administration) processes and procedures.

American National offers eligible employees and their families medical, dental, vision, and basic life insurance. Employees are able to enroll in our company’s 401k plan. Employees also receive annually a bank of paid time off and paid holidays.   We aspire to see people for what they bring to our corporate culture by supporting an inclusive work environment, including an emphasis on a healthy work-life balance, development opportunities, and a casual dress code.

American National is an established, stable, and successful multi-line insurance corporation that has provided financial strength and a sense of security to employees, customers and business partners since 1905.  With focus on our organization’s values and cultural richness: Financial Strength, Integrity, Respect, Service and Teamwork (FIRST) and Agility, Collaboration, and Engagement (ACE) we continue to pursue our vision to be a leading provider of financial products and services for current and future generations.

Hiring Practices

The preceding job posting was designed to indicate the general nature and level of work performed by employees assigned to this position. It is not intended to be interpreted as a comprehensive list of all duties, responsibilities, and qualifications.  We are dedicated to building a diverse, inclusive, and authentic workplace, so if you’re excited about this role, but your past experience doesn’t align perfectly with the job qualifications, we still encourage you to apply. You may be just the right candidate for this position or other opportunities at American National.

American National’s recruitment policies help us place individuals in a timely and efficient manner. Only the most qualified candidates will be contacted by our recruiting team. Candidates may check the status of their application(s) by logging into our Career Portal.  Learn more about our company, by following us on social media: LinkedIn, Facebook, Instagram

American National is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, veteran status, genetic information or any other legally protected categories. American National is committed to providing access, equal opportunity and reasonable accommodation for individuals with disabilities in employment, its services, programs, and activities.