Engineer, Business Intelligence ETL

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.

• 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.

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

• Minimum 5 years' experience as an ETL developer with proven track record of successful project implementation
• Minimum of 6 years' experience in reports and data warehouse development
• Software development experience on Microsoft BI Platform – SSIS, SSRS, MS SQL Server and Data Factory
• DB Development using MS SQL
• Experience supporting a Data Warehouse environment
• Large scale multi-site IS operations experience
• Strong understanding of data modeling principles and experience with designing efficient and scalable data models
• Concentra Core Competencies of Service Mentality, Attention to Detail, Sense of Urgency, Initiative and Flexibility
• Ability to make decisions or solve problems by using logic to identify key facts, explore alternatives, and propose quality solutions
• Outstanding customer service skills as well as the ability to deal with people in a manner which shows tact and professionalism
• The ability to properly handle sensitive and confidential information (including HIPAA and PHI) in accordance with federal and state laws and company policies
• Outstanding customer service skills as well as the ability to deal with people in a manner which shows tact and professionalism
• The ability to properly handle sensitive and confidential information (including HIPAA and PHI) in accordance with federal and state laws and company policies
• Superior teamwork skills
• Strong interpersonal and communication skills; the ability to read, write, and speak in a professional manner
• Excellent analytical and problem-solving skills
• Possess a personal sense of urgency
• Ability to effectively multi-task and adapt to changing business priorities
• Excellent time management and organizational skills
• Excellent attention to detail
• Knowledge of Microsoft or Java productivity applications
• Knowledge of browser-based technology
• Understanding of operating systems such as Windows and OS X/iOS

• 401(k) Retirement Plan with Employer Match
• Medical, Vision, Prescription, Telehealth, & Dental Plans
• Life & Disability Insurance
• Paid Time Off & Extended Illness Days Offered
• Colleague Referral Bonus Program
• Tuition Reimbursement
• Commuter Benefits
• Dependent Care Spending Account
• Employee Discounts

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

Concentra is an Equal Opportunity Employer, including disability/veterans