Data Architect

Job Description

***This role doesn't provide sponsorship or H1 transfers.

Hybrid role for Dallas, TX | San Diego, CA | Boca Raton, FL

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.

The Data Architect will be a key player in designing and building a modern data pipeline to ingest, process, transform, and model data into the Language Services Data Lake. This role demands a seasoned professional with expertise in designing, developing, and maintaining database management systems, data architecture, data modeling, and data quality. Experience in designing and developing data warehouses and integrating data is necessary. The position may require the use of a combination of SQL-Server Management Studio, SQL Server Integration Services, Azure Data Factory, Python, PySpark, Azure Databricks, and Snowflake.

If you are a data visionary with a passion for leveraging technology to unlock the power of data, we invite you to join our dynamic team and contribute to the evolution of our data infrastructure. Your expertise will play a crucial role in driving our data-driven initiatives and ensuring the integrity, efficiency, and scalability of the Language Services data ecosystem.

Duties and Responsibilities

Database Design and Management

• Lead architecture discussions, design sessions, and fully document data requirements for a Language Services Data Pipeline
• Work with the Database Engineer and Developer to carry out the development of the data warehouse based on the requirements using PostgreSQL, SQL Server Integration Services, SQL Server Management Studio, Snowflake, Python, PySpark, Azure Data Factory and Azure Data Bricks
• Implement best practices for database performance tuning, indexing, and data partitioning
• Conduct regular data maintenance tasks, including data purging and archiving
• Ensure data consistency and integrity

ETL (Extract, Transform, Load)

• Develop, implement, and maintain robust ETL processes using tools such as Python and PySpark to ensure seamless data integration across various systems
• Design and develop data warehouse structure based on the Language Services needs
• 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

General

• Accept ownership of the Language Services data pictures – data dictionary, determination of systems of record, application of business rules, data migration processes, etc.
• 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

Required Experience:

• Bachelor’s degree in Computer Science, Information Technology, or a related field, or a Bachelor’s degree and experience in Database design and development
• Strong understanding of database design principles, data modeling, and normalization
• 5 years of experience with utilizing scripting languages to develop ETL pipelines
• 3 years of experience designing databases and working with development teams throughout the development lifecycle
• Experience developing and troubleshooting integrations with SSIS, Azure Data Factory, or Pentaho Data Integration
• Experience working with Snowflake and Databricks
• Experience working with Salesforce

Preferred Experience:

• Master’s degree
• Certifications in relevant technologies, such as Snowflake, Python, PySpark, Sql-Server and Power BI
• Experience with cloud platforms, such as Azure and AWS
• Knowledge of best practices in data governance and compliance
• Knowledge of AMNs Language Services Platform - SVEN

Our Core ValuesRespect ● 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.

We have observed a significant uptick in fraudulent activities where bad actors masquerade as recruiters, offering fictitious job opportunities in exchange for service or processing fees. Please exercise caution and due diligence when reviewing job offers. Verify the sender’s email address carefully. AMN representatives will always communicate via official company email accounts and never through free email services such as Yahoo, Gmail, or Hotmail.

Pay Rate$168,500 - $200,500 Salary

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