Business Intelligence BI Data Warehouse Engineer

Job Id
201829
Job Location
Addison, TX
Employment Type
Full Time Regular
Industry
Health Care
Concentra
20220523T192931Z
Overview

Do you want to apply your skills and knowledge of business intelligence to help the mission to improve the health of America's workforce? With a national footprint of more than 500 medical centers and more than 130 onsite clinics nationwide, Concentra colleagues are fueled by our drive to provide an exceptional experience for our customers and exceptional care for their employees.

The Business Intelligence (BI) Data Warehouse Engineer reviews, analyzes, and modifies programming systems including coding, testing, debugging, and documenting programs for new or existing systems in accordance with  project plans and specifications. They are responsible for delivering quality customer service, as well as, incorporating and adhering to requirements defined by Concentra technology standards. Additionally, this position is  esponsible for providing accurate and timely completion of technical development and support tasks in accordance with Information Systems standards and methodologies.

Read More
Responsibilities
  • Develop software tasks in accordance with Information System standards and methodologies
  • Rely on instructions and pre-established guidelines to perform the function of the job.
  • Handle help desk tickets relating to development issues
  • Develop reports, upon request, utilizing various report-writing tools in all applications
  • Ensure management awareness of problems that are severe in nature or that are exceeding documented targets
  • Review outstanding issues daily to assure that troubleshooting and resolutions are current
  • Recognize potential areas where policies and procedures require change, or where new ones need to be developed, especially regarding future business expansion. Submit recommendations as appropriate
  • Participate in relevant information-sharing activities
  • Monitor and report on any security violations related to the unwarranted access to corporate data
  • Ensure that all problems are resolved in a timely and efficient manner
  • Help build team spirit by assisting other staff members and promoting a positive workplace
  • Maintain awareness of the rapidly changing environment and recommend cost efficient techniques
  • Support the mission and direction of Concentra, both within the Information Services department and throughout the corporation
  • Collaborate with Data architects and other team members in data analysis to build effective solutions
  • Contribute to the database design collaborating with Data Analysts and Data Modelers
  • Develop SQL scripts for various reporting and ad-hoc analysis
  • Provide support for all phases of testing such as integration and user acceptance
  • Generate appropriate unit test plans and assure quality of work
  • Produce technical design documentation
  • Perform analysis design, build, implementation and support tasks
  • Create, maintain and update disaster recovery procedures when changes in hardware or applications occur
  • Ensure all changes comply with change management policies and procedure
  • Complete any activities, tasks, and projects assigned
  • Ensure work is completed at assigned times
  • Mentor more junior developers
  • 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
  • Lead the design and development of database schemas
  • Lead 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
Read More
Qualifications

Education/Credentials

  • Bachelor’s degree in Computer Science or Computer Engineering from an accredited college or university
  • Current on latest MicroStrategy features via Udemy or other courses

Job-related Experience

  • Customarily has at least 5 or more years of software development experience to include:
    • 3 years of experience
      • MS SQL Server Full BI Stack (particularly SSIS)
      • Relational database experience (snowflake, star schema, etc.)
      • Strong experience with SQL development and performance tuning
    • 2 years of experience
      • Planning, organizing, coordinating, and controlling software promotion cycles from DEV environment to PRD environment for weekly BI deployments
    • Exposure to JIRA, Service Now, GitKraken, BitBucket
  • Knowledge of:
    • XML Parsing and JSON
    • Microsoft or Java productivity applications
    • Browser-based technology
    • Operating systems such as Windows and OS X/iOS
    • Large scale multi-site IS operations
    • PC Hardware and peripherals
    • Microsoft or Java productivity applications
    • Browser-based technology
    • Exposure to the following is a plus:
    • MicroStrategy
    • AVAYA system data
    • Working with Active Directory data
    • Agile
    • Data Warehousing & Data Modeling

Job-related Skills/Competencies

  • 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
  • Ability to rapidly learn new software development technologies and environments
  • Requires superior teamwork skills
  • Strong interpersonal and communication skills a must; 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
  • Strong attention to detail
Read More
Benefits
  • 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

This job requires access to confidential and critical information, requiring ongoing discretion and secure information management. 

We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.

CONCENTRA IS AN EQUAL OPPORTUNITY EMPLOYER, INCLUDING DISABILITY/VETERANS

Read More

Talk to a Recruiter

Demetrius Daniels
Phone: 6785956845