Senior Data Integration Specialist

Sorry, this job was removed at 02:21 p.m. (CST) on Wednesday, Nov 20, 2024
Dallas, TX
118K-140K Annually
Internship
Healthtech • HR Tech
The Role

Job Description

Welcome to AMN Healthcare: Where Your Career Becomes the Next Big Success Story!

Ever wondered what it takes to build one of the largest and most successful healthcare staffing and total talent solutions companies? It takes trailblazers, innovators, and amazing people like you. At AMN Healthcare, we don’t just offer jobs; we pave the way for incredible careers.

Why AMN Healthcare? Because You Deserve the Best:

  • Forbes Recognition: We don’t just make lists; we make headlines. AMN Healthcare proudly claims a spot on Forbes’ prestigious lists not once, but twice! We’re among the “Best Large Employers for Women,” a testament to our commitment to excellence.

  • SIA Approval: Acknowledged by Staffing Industry Analysts (SIA) as one of the “Rapidly Advancing Staffing Firms,” we have no plans to decelerate in the future.

  • Incredible Futures: Join a team that doesn’t just talk about building the future; we’re shaping it. Discover how AMN Healthcare is crafting incredible futures, one amazing career at a time.

Job Summary

The Senior Data Integration Specialist will be a key player in building a modern data pipeline to ingest, process, transform, and model data into the Language Services data lake. This role demands a top-tier professional with expertise in designing and maintaining database management systems, data architecture, data modeling, and data quality. The successful candidate will work closely with the Data Architect offering expertise in the design of the data warehouse structure. Experience developing data warehouses and integrating data from multiple systems is vital. The position may require the use of a combination of Sql-Server Management Studio, Python, PySpark, SQL Services Integration Services (SS(S), Azure Data Factory (ADF)s, and Snowflake.

Job Responsibilities

  • Deliver upon the technology road map in alignment with Language Services leadership to improve the underlying costs and capabilities of the AMN Language Services portfolio

  • Adherence to coding policies, technical documentation and operational discipline as defined by software development policies

  • Excellent communication skills for team leadership, software release documentation, client response and leadership team updates

  • Responsibilities include involvement in all aspects of the Software Development Life Cycle (i.e. Agile/Scrum) including technical requirements analysis, technical design, development, testing, code deployment, and production support

  • Responsible for risk identification and risk mitigation strategies associated with the software including alignment to AMN Information Security policies and procedures

  • Participant in on-call process and events during event escalations for application downtime and degraded performance

  • Share knowledge and skills across the team through mentorship, coaching, and training of junior staff on integration methodologies

Database Design and Management

  • Participate in architecture discussions, design sessions, and fully understand data requirements as provided by the Data Architect

  • Work independently to carry out the development of the data warehouse based on the requirements using PostgreSQL, SQL Server, Snowflake, Python, PySpark, Azure Data Factory and SSIS.

  • Implement best practices for database performance tuning, indexing, and data partitioning

  • Ensure data consistency and integrity

ETL (Extract, Transform, Load)

  • Develop, implement, and maintain robust ETL processes using tools such as Python, PySpark, SSIS, and ADF to ensure seamless data integration across various systems

  • Develop data warehouse structure based on the requirements provided by the Data Architect

  • Identify and resolve data quality issues during ETL processes

  • Monitor ETL job performance, troubleshoot issues, and optimize workflows for efficiency

  • Implement security measures to ensure protected information is secured at rest

Salesforce Integration

  • Work closely with Salesforce administrators and developers to design and implement data integration solutions between Salesforce and other systems

  • Ensure the integrity and accuracy of data transferred between Salesforce and other databases

  • Provide expertise to assist in Salesforce data modeling and architecture

SQL Expertise

  • Utilize advanced SQL skills to create complex queries, stored procedures, functions and triggers for data analysis and reporting

  • Optimize SQL queries for performance and resource utilization

Snowflake Data Management

  • Leverage the capabilities of the Snowflake data platform to architect and implement scalable and efficient data solutions

  • Utilize Snowflake features for data warehousing, such as virtual warehouses, clusters, and multi-cluster warehouses to optimize query performance

  • Stay informed about the latest features and functionalities of Snowflake, exploring and applying innovative solutions to enhance data processing and analytics

Python

  • Successfully build ETL pipelines using Python

  • Leverage the Python relevant frameworks and libraries, such as workflow management utilities and libraries for accessing and extracting data

Power BI Integration

  • Collaborate with business analysts to understand reporting requirements and design effective Power BI data models

  • Integrate Power BI solutions with other data sources and ensure optimal performance

Key Skills

  • Data modeling and database design

  • Metadata management and repository usage

  • Database schema creation and management

  • Backup and recovery

  • Performance management and tuning

  • Experience working with Snowflake

  • Experience working with Salesforce

Qualifications

Education & Years of Experience

  • Bachelor's Degree plus 7-10 years of work experience OR High School Diploma/GED plus 11-14 years of work experience

  • Certifications in relevant technologies, such as Snowflake, Python, PySpark, Sql-Server, SSIS, and Power BI

  • Experience with cloud platforms, such as Azure and AWS

  • Knowledge of best practices in data governance and compliance

Work Environment / Physical Requirements

  • Work is performed in an office/home office environment.

  • Team Members must have the ability to operate standard office equipment and keyboards.

AMN Healthcare will provide reasonable accommodations to qualified individuals with disabilities to enable them to perform the essential functions of the job.

Our Core Values

    ● Respect ● Passion ● Continuous Improvement ● Trust ● Customer Focus ● Innovation

    At AMN Healthcare, our diversity, equity, and inclusion philosophy is grounded in the belief that we should respect all voices, seek different perspectives, and succeed when we act together as a positive force for all of humanity. AMN Healthcare strives to foster a workplace of belonging where all team members can be their authentic selves, where we can apply our collective skills to innovate solutions that empower the future of care. AMN Healthcare is an equal opportunity employer.

    Pay Rate$117,500 - $139,500 Salary

    Final pay rate is dependent on experience, training, education, and location.

    The Company
    HQ: Coppell, TX
    2,830 Employees
    On-site Workplace
    Year Founded: 1985

    What We Do

    AMN Healthcare is the leader and innovator in total talent solutions for healthcare organizations across the nation. The Company provides access to the most comprehensive network of quality healthcare professionals through its innovative recruitment strategies and breadth of career opportunities. With insights and expertise, AMN Healthcare helps providers optimize their workforce to successfully reduce complexity, increase efficiency and improve patient outcomes. AMN total talent solutions include managed services programs, clinical and interim healthcare leaders, temporary staffing, executive search solutions, vendor management systems, recruitment process outsourcing, predictive modeling, language interpretation services, revenue cycle solutions, credentialing and other services. Clients include acute-care hospitals, community health centers and clinics, physician practice groups, retail and urgent care centers, home health facilities, schools and many other healthcare settings. AMN Healthcare is committed to fostering and maintaining a diverse team that reflects the communities we serve. Our commitment to the inclusion of many different backgrounds, experiences and perspectives enables our innovation and leadership in the healthcare services industry.

    Similar Jobs

    Crunchyroll Logo Crunchyroll

    NetSuite Business Analyst

    Digital Media • eCommerce • Gaming • Mobile • News + Entertainment
    Dallas, TX, USA
    1200 Employees

    The Aerospace Corporation Logo The Aerospace Corporation

    2025 Curation Scientist - NASA Astromaterials Research and Exploration Science

    Aerospace • Artificial Intelligence • Cloud • Machine Learning • Cybersecurity • Defense
    Hybrid
    Houston, TX, USA
    4600 Employees

    Apex Fintech Solutions Logo Apex Fintech Solutions

    Senior Data Analyst

    Fintech • Software • Financial Services
    Dallas, TX, USA
    850 Employees

    Apex Fintech Solutions Logo Apex Fintech Solutions

    Senior Business Systems Analyst

    Fintech • Software • Financial Services
    Dallas, TX, USA
    850 Employees

    Similar Companies Hiring

    Sage Thumbnail
    Software • Healthtech • Hardware • Analytics
    New York, NY
    44 Employees
    Zealthy Thumbnail
    Telehealth • Social Impact • Pharmaceutical • Healthtech
    New York City, NY
    13 Employees
    Cencora Thumbnail
    Pharmaceutical • Logistics • Healthtech
    Conshohocken, PA
    46000 Employees

    Sign up now Access later

    Create Free Account

    Please log in or sign up to report this job.

    Create Free Account