Senior Data Integration Specialist

6 days ago


Franklin, Tennessee, United States Loews Hotels & Co Full time

We are seeking a highly skilled Senior Data Integration Specialist to join our Information Technology team at Loews Hotels & Co.

Job Overview

This position is based at the Loews Hotels & Co Business Services Center in Franklin, TN. As a key member of our team, you will be responsible for assisting in the design, development, and administration of our data warehouse.

You will work closely with operations and business peers as well as specialists from other related fields to ensure the successful implementation of our data integration strategy.

Responsibilities
  • Develop and maintain an enterprise dimensional data model to support business intelligence initiatives.
  • Utilize ETL tools to extract, transform, store, and retrieve data from operational systems through the data warehouse system.
  • Analyze data in repositories and analytical systems against source systems to isolate issues in the data lineage.
  • Author complex T-SQL queries and manage database objects such as stored procedures, synonyms, and functions.
  • Provide first-level support to resolve incidents and fulfill requests from the organization.
  • Adhere to information security and governance standards, including Change Management, PCI DSS, and SOX.
  • Promote consistency and effective change management through detailed operational, technical, and procedural documentation and tracking.
  • Manage and support SSRS reports.
Requirements

To be successful in this role, you must have:

  • Familiarity with current Microsoft and Amazon data tools, including SSMS, SSIS, SSAS, SSRS, Amazon RDS, DynamoDB, Redshift, Glue ETL, managed Airflow, Lambda, and Data Migration Service.
  • Experience working with a middleware platform to create sustainable data mining solutions.
  • Working knowledge of Entity-Relationship data modeling, ETL, and ELT processes, warehousing, and normalization techniques.
  • Ability to create ad-hoc analysis on the fly using structured query language.
  • Experience maintaining cloud database instances such as Azure or AWS.
  • Understanding of data lake architecture and related concepts.
  • Experience processing unstructured and semi-structured data utilizing languages such as JSON or Python.
  • Familiarity with API calls and techniques to integrate data sources into a relational database management system.
  • Experience using data tools, such as SSRS, to publish, debug, and enhance custom reports.
  • Experience with Power BI or a related service.

A minimum 2-year college degree and 2+ years directly related work experience specific to job requirements are required for this position.



  • Franklin, Tennessee, United States Open Systems Technologies Full time

    About the JobOpen Systems Technologies is seeking a highly skilled Technical Data Integration Specialist to join our team in Franklin, TN. As a key member of our organization, you will play a critical role in designing and developing a consolidated enterprise data warehouse and data lake that store all critical data across Customer, Provider, Claims, Client,...


  • Franklin, Tennessee, United States Reliable MicroSystems LLC Full time

    We are seeking a highly skilled Senior Electrical Engineering Specialist to join our team at Reliable MicroSystems LLC.Estimated salary range for this role is $120,000 - $180,000 per year.Job OverviewThis position involves performing complex technical tasks and providing expertise in electrical engineering. The ideal candidate should possess excellent...


  • Franklin, Tennessee, United States Five Iron LLC Full time

    About the role: Senior IT Service Management SpecialistAt Five Iron LLC, we redefine industry expectations by providing best-in-class managed cybersecurity operations in the financial sector. Our goal is more than notification; our goal is remediation and resolution.We are currently seeking a highly skilled Senior IT Service Management Specialist to join our...


  • Franklin, Tennessee, United States Della Infotech, Inc. Full time

    About the JobDella Infotech, Inc. is seeking an experienced Data Entry Specialist for our Music Publishing team in North America. This role involves accurate and timely data entry, research, and problem-solving to support our administration team. The successful candidate will possess excellent data entry skills, attention to detail, and the ability to work...


  • Franklin, Tennessee, United States Reliable MicroSystems LLC Full time

    Job OverviewWe are a leading technology company seeking an experienced Senior Electrical Engineering Specialist to join our team. With a strong background in electrical engineering and a proven track record of delivering complex projects, this role is ideal for a professional looking to take on new challenges.


  • Franklin, Tennessee, United States Bridge Senior Living Full time

    Senior Care Specialist OpportunityJoin Bridge Senior Living as a Senior Care Specialist, delivering exceptional care to our residents while working collaboratively with our interdisciplinary team. This is an exciting opportunity to make a meaningful difference in the lives of others.About the RoleThis position offers a challenging yet rewarding experience,...


  • Franklin, Tennessee, United States Henderson Engineers Full time

    About Henderson EngineersHenderson Engineers is a leading firm that provides innovative solutions for complex engineering projects.Job SummaryWe are seeking an experienced Senior Technical Plumbing Design Specialist to join our team. As a key member of our design team, you will be responsible for designing and implementing plumbing systems for various...


  • Franklin, Tennessee, United States Vitality Senior Living Full time

    About Vitality LivingWe are a vibrant community dedicated to creating meaningful experiences for our residents, families, and team members.Our mission is to provide a supportive environment that allows individuals to thrive and reach their full potential.At Vitality Living, we celebrate diversity and encourage our team members to be themselves.Job SummaryWe...


  • Franklin, Tennessee, United States Vitality Senior Living Full time

    Job Summary:Caregiver/Personal Care Specialist at Vitality Living Franklin is a vital role that requires empathy, compassion, and excellent communication skills. As a Home Health Support Specialist, you will be responsible for assisting residents with daily activities, providing emotional support, and maintaining a safe and comfortable living...


  • Franklin, Tennessee, United States Community Health System Full time

    Job Title: Health Information Manager - Inpatient Coding SpecialistEstimated Salary: $60,000 - $80,000 per yearAbout the Role:We are seeking an experienced Health Information Manager to join our team as an Inpatient Coding Specialist. This role is responsible for providing accurate and timely coding services to our hospitals, ensuring compliance with...


  • Franklin, Tennessee, United States Reliable MicroSystems LLC Full time

    Job OverviewWe are seeking a highly skilled Senior Electrical Engineer to lead our team in delivering complex technical solutions. This is a challenging role that requires strong leadership and engineering expertise.The ideal candidate will have a degree in Electrical Engineering and significant work experience in integrated circuit design, layout, and...


  • Franklin, Tennessee, United States 3D Infotech Inc Full time

    At 3D Infotech Inc, we are seeking an experienced Metrology Applications Specialist to join our team in the St. Louis, MO area. This full-time position offers a competitive salary of $65,000.00 per year and is perfect for professionals with a strong background in mechanical engineering.Job OverviewWe provide innovative portable and automated metrology...


  • Franklin, Tennessee, United States Vitality Senior Living Full time

    Job OverviewWe are seeking a skilled and compassionate LPN/Charge Nurse to join our team at Vitality Living Franklin. As an LPN, you will play a vital role in providing high-quality care to our residents, collaborating with our interdisciplinary team to ensure seamless delivery of services.Responsibilities* Administer or assist residents with medication...


  • Franklin, Tennessee, United States American Health Partners Full time

    About the RoleWe are seeking a skilled Healthcare Coding Specialist to join our team at American Health Partners. As a critical member of our organization, you will play a key role in ensuring the accuracy and completeness of medical records and claims data.


  • Franklin, Tennessee, United States Healthpeak Properties, Inc. Full time

    Job Title: Senior Financial AccountantAbout the Role:We are seeking a skilled and detail-oriented Senior Financial Accountant to join our team at Healthpeak Properties, Inc. This is an exciting opportunity for a highly motivated individual to take on key responsibilities in our accounting department.Key Responsibilities:Financial Reporting: Prepare accurate...


  • Franklin, Tennessee, United States NHC Full time

    NHC Place at Cool Springs, a leader in senior care, seeks a skilled and compassionate Senior Care Professional to join our team. As a patient advocate, you will play a vital role in ensuring the well-being and independence of our patients.Job SummaryWe are looking for an experienced Certified Nursing Assistant (CNA) to provide exceptional patient care in our...


  • Franklin, Tennessee, United States Prime Health Services Full time

    Job Title: Healthcare Contracting SpecialistSalary: $70,000 - $90,000 per yearAbout UsAt Prime Health Services (PHS), we specialize in medical provider network development and offer clients a tailored approach to medical cost containment. Our tech-focused nature allows clients to take advantage of the flexibility of customization while not compromising on...


  • Franklin, Tennessee, United States National Healthcare Corporation Full time

    Compensation: $55,000 - $65,000 per yearA career with National Healthcare Corporation as a Patient Care Specialist offers a unique opportunity to make a meaningful difference in the lives of seniors. As part of our interdisciplinary team, you will play a vital role in ensuring that patients receive the highest quality care and support in their homes.About...


  • Franklin, Tennessee, United States BlueSprig Full time

    At BlueSprig, we're on a mission to change the world for children with autism. As an Autism Therapy Specialist, you'll play a critical role in delivering high-quality ABA therapy services.Job Description:We're looking for driven individuals who are passionate about working with kids and making a positive impact on their lives. As an Autism Therapy...


  • Franklin, Tennessee, United States Williamson Health Full time

    OverviewWilliamson Health is a dynamic and patient-centered healthcare system that prioritizes excellence in care. With a commitment to compassion, integrity, and cultural competence, we strive to provide world-class services to the residents of Williamson County and surrounding communities.We are seeking a dedicated Critical Care Nurse Specialist to join...