Engineer, Business Intelligence ETL

Overview

With more than 40 years of experience, Concentra is dedicated to our mission to improve the health of America’s workforce, one patient at a time. With a wide range of services and proactive approaches to care, Concentra colleagues provide exceptional service to employers and exceptional care to their employees.

The Business Intelligence ETL Developer reviews, develops robust Business Intelligence and data warehouse solutions using appropriate BI technologies. The ETL Engineer demonstrates strong communications skills, aptitude for working with the business, and propensity to lean new technology. Participates in requirements gathering and research, proposes technology solutions, and develops solutions within agreed upon timelines. analyzes, and modifies programming systems including coding, testing, debugging, and documenting programs for new or existing systems in accordance with project plans and specifications. The ETL Engineer is responsible for delivering quality customer service, as well as, incorporating and adhering to requirements defined by Concentra technology standards. The ETL Engineer is responsible for providing accurate and timely completion of technical development and support tasks in accordance with Information Systems standards and methodologies.

Responsibilities

• Administer database systems technical design, performance monitoring and tuning, backup and recovery, data and file distribution, reporting, database upgrades, integrations, migrations, and conversions
• Evaluate, design, and maintain multiple database environments; identify data sources, construct data decomposition diagrams, provide data flow diagrams, and document the process; write codes for database access, modifications and constructions including stored procedures and database server configuration
• Design, implement, and support data warehousing – implement business rules via stored procedures, middleware or other technologies; define user interfaces and functional specifications
• Responsible for verifying accuracy of data in data extracts and data warehouse
• Monitor system details within the data warehouse, including stored procedures and execution time, and implement efficiency improvements
• Troubleshoot and resolve data quality issues, database performance issues, database capacity issues, replication and other distributed data issues
• Resolve database performance issues by looking at query plans, create appropriate indexes, resolve dead locks, and create table hints
• Troubleshoot and resolve issues in reports, dashboards, and ETL packages
• Responsible for any Help Desk tickets relating to Development issues
• Work with end users and other Information Services staff to develop criteria for specific phases of assigned projects, and ensure proper testing of all developed solutions
• Participate in the design and development of database schemas.
• Participate in the development of medium-size software applications with minimal supervision.
• This job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

Qualifications

Education Level : Bachelor’s Degree

Major : Computer Engineering, Computer Science

Degree must be from an accredited college or university.

Experience in lieu of required education is acceptable : Yes

Additional Data

Be part of a committed team that’s growing fast and making a difference.

Concentra is an Equal Opportunity Employer, including disability / veterans