Login
Back to Search New Search

Sr/Lead Bus Intelligence Developer/SQL Server Admin- Omaha, NE

Mutual of Omaha Companies Omaha, NE
Save

Job Description

The IS Enterprise Self-Service Enablement team is currently seeking a Senior Business Intelligence Developer to serve as an administrator and concierge for our enterprise level, business facing reporting and analysis technologies. The team is responsible for modernizing, developing and supporting our reporting and analytical technologies. The tool suite supported by the team consists of Microsoft SQL Server Data Management and Business Intelligence tools (SSIS/SSRS/SSAS), Business Objects, Tableau, SAS, Alation and Trifacta. This position will utilize a variety of platforms (Linux, Windows, VMWare, and Hadoop) as well as a variety of enterprise RDMSs to facilitate and enable self-service, focusing on the Microsoft SQL Server Data Management and Business Intelligence tool administration and enablement. The candidate will have the opportunity to work with our information service and business partners to understand their needs, define, consult and mentor on best practices as well as the proper usage of the tools throughout the enterprise.

Essential Job Functions:

  • Perform administration, integration and support of enterprise level, business facing reporting and analysis technologies.
  • Assist users in navigating our request processes and license management, and troubleshooting any issues associated with our reporting/analysis tools.
  • Assist users of our tools by providing best practices, mentoring, and training for knowledge sharing and improvements.
  • Foster strong relationships with IS teams that support our servers, desktops/laptops, and databases as extensions of our core team in service to our tool users.
  • Performs analysis and design by translating business requirements and developing reporting solutions that yield relevant business information in a user-friendly format by collecting, analyzing and leveraging data. Ensures data accuracy. Relies on extensive experience and judgment to plan and accomplish goals. Identifies and communicates the area-wide impact of interrelated activities.
  • Provides support to customers by investigating, reviewing and analyzing data from multiple internal and external sources and understands the source structures and business relevance of the data within a broad range of the Strategic Business Unit(SBU). Designs, develops, implements and maintains business solutions for medium to large and/or complex projects.
  • Performs development, maintenance and integration of applications and systems that support business operations, process improvement and reporting. Maintains knowledge of current tools, languages and approaches used to develop, test, maintain, and execute systems and applications. Ensures appropriate security and privacy measures are implemented to protect the Company data assets from accidental or intentional misuse.
  • Analyzes and evaluates new and emerging business systems technologies, practices, and methodologies. Supports I/S teams with testing and implementation of new business systems tools, codes, and patches, and assist business customers throughout the conversion. Acts as liaison between I/S teams and business areas by trouble-shooting and translating technical problems related to business applications.
  • Foster strong relationships with IS teams that support our servers, desktops/laptops, and databases as extensions of our core team in service to our tool users.
  • Defines and contributes to data & data quality standards, controls, procedures, and documentation. Identifies areas for data quality improvement and help to resolve data quality problems through the appropriate choice of error detection and correction, process control and improvement, or process design strategies. Develops, documents, promulgates, and maintains data quality goals and standards. This may also include overseeing the organization's data policies. Recommends enhancements to the data acquisition processes to improve accuracy of the data warehouses.
  • Performs data management functions to ensure data rules are being supported and properly maintained. Monitors compliance of information flows and data stores against data quality standards. Measures and reports to management on the progress of data quality improvement, documenting the return on investment associated with improving data quality. Provides data quality training and consulting services to others in the organization.
  • Provides support for product implementations and modifications impacting repositories, project request documentation, CAT testing, and daily monitoring of stored data.
  • Implements approved project plans and activities. Provides technical assistance and training to staff in project management, sales, reporting, I/T, I/S and workflow direction on medium to large projects.
  • Develops and maintains current knowledge of SBU business areas, Mutual of Omaha practices, the insurance industry, and the business environment. Maintains and expands knowledge of application development technologies, methodologies, standards, and enterprise data sources and structures.
  • Provides training and education to IS and business partners within the enterprise on Business Intelligence tools and processes. Helps IS and business partners in understanding the reporting tools to allow them to better access the data independently.
  • Assist users of our tools by providing best practices, mentoring, and training for knowledge sharing and improvements
  • Assist users in navigating our request processes and license management, and troubleshooting any issues associated with our reporting/analysis tools.
  • Monitors recurring processes and ensures output accuracy and timely distribution. Responsible for maintenance, documentation, and enhancements of recurring processes and procedures. Supports business partners in understanding the reports and reporting tools to allow them to better access the data independently.
  • Supports the completion of data submission for industry surveys, annual statements, and regulatory filings based on the requirements. Follows up on inconsistencies or issues, provides recommendations for resolution, and ensures timely adherence.
  • This position requires sitting over 66% of the time.
  • This position requires Visual Acuity at 20 inches (or less) over 66% of the time.

This job posting is reflective of the Sr Business Intelligence Developer essential functions, qualifications, and physical requirements. The Lead Business Intelligence Developer level has variable essential functions, qualifications and physical requirements. Competency and skill set will determine level of placement within the posted job family.

Minimum Qualifications:

  • Bachelor's degree in Computer Science, MIS, Math or equivalent
  • Experience supporting and using Microsoft SQL Server Data Management and Business Intelligence tools (SSIS/SSRS/SSAS)
  • 3-5 years of experience using or providing support for third party vendor data reporting/analysis technologies
  • Expert troubleshooting, problem solving, and analytical skills
  • Advanced oral and written communication skills
  • Excellent presentation skills
  • Able to learn new technologies quickly
  • Detail-oriented, capable of working independently and within a team
  • Working knowledge of relational databases
  • Working knowledge of data extraction and data manipulation
  • Strong analytical and problem solving skills
  • Considerable knowledge of Finance, Customer Services, Marketing, Sales domain and IT objectives and strategy. Considerable knowledge of project and process management and business systems requirements
  • Strong knowledge of technical environment (technologies, applications, projects and processes) in the functional business areas
  • Considerable knowledge of relational database administration, data consumption, and advanced data analysis. Familiar with technical and strategic data management
  • Experience in data validation and quality controls
  • Experience in business analysis and intelligence
  • Ability to research solutions and analyze data independently to provide recommendations
  • Familiar with the concepts of data security and risk management
  • Strong consultative, analytical, conflict and strategic planning skills
  • A wide degree of creativity and latitude is expected

Preferred Qualifications:

  • Training experience, with small and large groups
  • Experience mentoring others in best practices for data reporting and analysis
  • Third party vendor software administration and support experience
  • Strong understanding of business functions and processes related to data usage

If you are a qualified individual with a disability or a disabled veteran, you have the right to request an accommodation if you are unable or limited in your ability to use or access our career center as a result of your disability. To request an accommodation, contact a Human Resources Representative at 1-800-780-0304. We are available Monday through Friday 7 am to 4:30 pm CST.

For all other inquiries, contact our HR Helpline at 1-800-365-1405.

Mutual of Omaha and its affiliates are an Equal Opportunity /Affirmative Action Employer, Minorities/Female/Disabled/Veteran

To All Recruitment Agencies: We do not accept unsolicited agency resumes and we are not responsible for any fees related to unsolicited resumes.

Job Details

Date Posted March 15, 2019
Date Closes May 14, 2019
Requisition 496017
Located In Omaha, NE
Job Type Full-time Employee
SOC Category 00-0000.00
Zipcode 68102
Location