Lead Business Intelligence Specialist
Glenmont, NY, US, 12077
Applications have closed
American National
American National offers personalized insurance coverage for life, home, business, auto and much more.Find an agent near you.
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.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Business Intelligence Data management Data quality Data Warehousing Excel Research Security Snowflake SQL Tableau Testing
Perks/benefits: 401(k) matching Career development Health care Insurance Team events
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Lead Data Analyst jobs
- Open Data Engineer II jobs
- Open Data Science Manager jobs
- Open Marketing Data Analyst jobs
- Open Senior Business Intelligence Analyst jobs
- Open MLOps Engineer jobs
- Open Principal Data Engineer jobs
- Open Power BI Developer jobs
- Open Data Scientist II jobs
- Open Data Analytics Engineer jobs
- Open Business Intelligence Developer jobs
- Open Junior Data Scientist jobs
- Open Business Data Analyst jobs
- Open Sr Data Engineer jobs
- Open Product Data Analyst jobs
- Open Data Analyst Intern jobs
- Open Senior Data Architect jobs
- Open Sr. Data Scientist jobs
- Open Big Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Research Scientist jobs
- Open Azure Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Manager, Data Engineering jobs
- Open Data Product Manager jobs
- Open GCP-related jobs
- Open Data quality-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Business Intelligence-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Deep Learning-related jobs
- Open Data visualization-related jobs
- Open PhD-related jobs
- Open Finance-related jobs
- Open NLP-related jobs
- Open PyTorch-related jobs
- Open TensorFlow-related jobs
- Open APIs-related jobs
- Open Consulting-related jobs
- Open LLMs-related jobs
- Open CI/CD-related jobs
- Open Generative AI-related jobs
- Open Snowflake-related jobs
- Open Hadoop-related jobs
- Open Kubernetes-related jobs
- Open Data governance-related jobs
- Open Databricks-related jobs
- Open DevOps-related jobs