Data Warehouse and Business Intelligence Developer

New Mexico Mutual; Albuquerque (NM); On-site; USD 90,000 - 120,000; Full time

Job summary

New Mexico Mutual is seeking a Data Warehouse and Business Intelligence Developer to join the Business Analytics team. The role focuses on defining, developing, and supporting analytic systems to give end users timely and accurate data for reporting and analysis.

Based on site in Albuquerque, NM, with relocation assistance if needed. The candidate will work with Cognos and related BI tools, ensuring reliable data delivery and insightful reporting for stakeholders across the organization.

Qualifications

• BS/BA in Information Management/Information Systems or related business experience.
• Master’s degree in computer science preferred.
• 3+ years of DW/ETL/BI development and support experience.

Responsibilities

• Monitor and troubleshoot the existing ETL processes.
• Enhance existing and create new ETL processes.
• Monitor and troubleshoot existing BI applications, including Cognos reporting for end users.
• Collaborate to design and implement data extraction programs for BI solutions.
• Analyze data for accuracy and traceability to source.
• Develop technical documentation for ETL and BI processes.

Skills

Attention to detail

Critical thinking

Stakeholder management

Relationship building

Excellent communication skills

Education

BS/BA in Information Management/Information Systems

Master’s degree in computer science (preferred)

Tools

IBM Cognos

Business Objects

Data Services

Framework Manager

Transformer

Job description

Job Title: Data Warehouse and Business Intelligence Developer

Department: Business Analytics

Reports to: Datawarehouse and Analytics Manager

Position Summary

The Data Warehouse and Business Intelligence Developer is responsible for working with the Business Analytics team to define, develop, and support New Mexico Mutual analytic systems. The goal of DW and BI Developer I is to provide end users timely, accurate, and easier access to data for reporting and analysis.

This position is full time on site in Albuquerque, New Mexico. Would require relocation if located out of state.

Essential Functions

• Monitor and troubleshoot the existing ETL processes.
• Enhance existing and create new ETL processes.
• Monitor and troubleshoot existing BI applications, including frameworks, cubes and reports and ensure the availability of Cognos reporting for the end users.
• Enhance existing and create new BI applications.
• Collaborate with the Analytics Technical Manager to design and implement data extraction programs that integrate seamlessly into BI solutions to meet the needs of the end users.
• Analyze data to ensure information is accurate and reconcilable to its source of origin. Perform quality assurance testing as appropriate prior to releasing data/information/reports into production / end users.
• Explore and understand capabilities of BI tools (IBM Cognos) to expand BI knowledge. Demonstrate knowledge acquired by incorporating best practices in projects. Share knowledge acquired with BA team members and end users when appropriate.
• Collaborate with the Analytics Technical Manager to support all aspects of the DW/BI (Cognos/Business Objects) infrastructure including Business Objects Data Services, IBM Cognos Data Manager, IBM Cognos Studios, Framework Manager and Transformer.
• Develop, maintain and deliver technical documentation related to ETL development, scheduled processes, frameworks, transformations, etc.

Education

Job Qualifications

BS/BA in Information Management/Information Systems or related business experience. Master’s degree in computer science preferred.

Experience

A minimum of 3 years of experience in DW, ETL, Business Intelligence development and support, preferably in worker’s compensation or a related field.

Required Skills/Abilities

• Attention to detail and accuracy
• Proven ability to think critically, identify issues and outline solutions
• Ability to partner with internal and external stakeholders
• Ability to build and maintain relationships across the business and corporate department
• Excellent communication skills

Specialized Knowledge, Licenses, Etc.

• MS Office (Word, Advanced Excel, PowerPoint, Outlook)
• SQL, PL/SQL, Oracle preferred.
• ETL (Business Objects), Business Intelligence and OLAP Cubes (IBM Cognos) or similar tools
• Experience with data warehouse models, Ralph Kimball methodology preferred.
• Guidewire knowledge is preferred.

Values And Mission

Adheres to New Mexico Mutual’s values and mission by demonstrating Service Excellence, Trust, Ownership, One Team and Boldness in thought and action.

Positive Attitude

Develops and maintains positive working relationships with team members, customers, co-workers and management by demonstrating effective communication and collaborative skills.

Working Conditions

• NEW MEXICO MUTUAL maintains general office conditions with light physical demands.
• Employees of NEW MEXICO MUTUAL adhere to all safety rules and regulations including building security.
• Employees participate in ensuring safe and efficient operating conditions that safeguard employees and facilities.
• NEW MEXICO MUTUAL maintains a drug free environment, drug testing prior to employment as well as upon a work-related accident.
• Exposure to VDT screens.