AMN Healthcare
Data Architect
AMN Healthcare, Dallas, Texas, United States, 75215
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 PipelineWork 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 BricksImplement best practices for database performance tuning, indexing, and data partitioningConduct regular data maintenance tasks, including data purging and archivingEnsure data consistency and integrityETL (Extract, Transform, Load)
Develop, implement, and maintain robust ETL processes using tools such as Python and PySpark to ensure seamless data integration across various systemsDesign and develop data warehouse structure based on the Language Services needsIdentify and resolve data quality issues during ETL processesMonitor ETL job performance, troubleshoot issues, and optimize workflows for efficiencyImplement security measures to ensure protected information is secured at restSalesforce Integration
Work closely with Salesforce administrators and developers to design and implement data integration solutions between Salesforce and other systemsEnsure the integrity and accuracy of data transferred between Salesforce and other databasesProvide expertise to assist in Salesforce data modeling and architectureSQL Expertise
Utilize advanced SQL skills to create complex queries, stored procedures, functions and triggers for data analysis and reportingOptimize SQL queries for performance and resource utilizationSnowflake Data Management
Leverage the capabilities of the Snowflake data platform to architect and implement scalable and efficient data solutionsUtilize Snowflake features for data warehousing, such as virtual warehouses, clusters, and multi-cluster warehouses to optimize query performanceStay informed about the latest features and functionalities of Snowflake, exploring and applying innovative solutions to enhance data processing and analyticsPython
Successfully build ETL pipelines using PythonLeverage the Python relevant frameworks and libraries, such as workflow management utilities and libraries for accessing and extracting dataPower BI Integration
Collaborate with business analysts to understand reporting requirements and design effective Power BI data modelsIntegrate Power BI solutions with other data sources and ensure optimal performanceGeneral
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 portfolioAdherence to coding policies, technical documentation and operational discipline as defined by software development policiesExcellent communication skills for team leadership, software release documentation, client response and leadership team updatesResponsibilities 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 supportResponsible for risk identification and risk mitigation strategies associated with the software including alignment to AMN Information Security policies and proceduresParticipant in on-call process and events during event escalations for application downtime and degraded performanceShare knowledge and skills across the team through mentorship, coaching, and training of junior staff on integration methodologiesRequired Experience:
Bachelor's degree in Computer Science, Information Technology, or a related field, or a Bachelor's degree and experience in Database design and developmentStrong understanding of database design principles, data modeling, and normalization5 years of experience with utilizing scripting languages to develop ETL pipelines3 years of experience designing databases and working with development teams throughout the development lifecycleExperience developing and troubleshooting integrations with SSIS, Azure Data Factory, or Pentaho Data IntegrationExperience working with Snowflake and DatabricksExperience working with SalesforcePreferred Experience:
Master's degreeCertifications in relevant technologies, such as Snowflake, Python, PySpark, Sql-Server and Power BIExperience with cloud platforms, such as Azure and AWSKnowledge of best practices in data governance and complianceKnowledge 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 SalaryFinal pay rate is dependent on experience, training, education, and location.
***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 PipelineWork 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 BricksImplement best practices for database performance tuning, indexing, and data partitioningConduct regular data maintenance tasks, including data purging and archivingEnsure data consistency and integrityETL (Extract, Transform, Load)
Develop, implement, and maintain robust ETL processes using tools such as Python and PySpark to ensure seamless data integration across various systemsDesign and develop data warehouse structure based on the Language Services needsIdentify and resolve data quality issues during ETL processesMonitor ETL job performance, troubleshoot issues, and optimize workflows for efficiencyImplement security measures to ensure protected information is secured at restSalesforce Integration
Work closely with Salesforce administrators and developers to design and implement data integration solutions between Salesforce and other systemsEnsure the integrity and accuracy of data transferred between Salesforce and other databasesProvide expertise to assist in Salesforce data modeling and architectureSQL Expertise
Utilize advanced SQL skills to create complex queries, stored procedures, functions and triggers for data analysis and reportingOptimize SQL queries for performance and resource utilizationSnowflake Data Management
Leverage the capabilities of the Snowflake data platform to architect and implement scalable and efficient data solutionsUtilize Snowflake features for data warehousing, such as virtual warehouses, clusters, and multi-cluster warehouses to optimize query performanceStay informed about the latest features and functionalities of Snowflake, exploring and applying innovative solutions to enhance data processing and analyticsPython
Successfully build ETL pipelines using PythonLeverage the Python relevant frameworks and libraries, such as workflow management utilities and libraries for accessing and extracting dataPower BI Integration
Collaborate with business analysts to understand reporting requirements and design effective Power BI data modelsIntegrate Power BI solutions with other data sources and ensure optimal performanceGeneral
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 portfolioAdherence to coding policies, technical documentation and operational discipline as defined by software development policiesExcellent communication skills for team leadership, software release documentation, client response and leadership team updatesResponsibilities 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 supportResponsible for risk identification and risk mitigation strategies associated with the software including alignment to AMN Information Security policies and proceduresParticipant in on-call process and events during event escalations for application downtime and degraded performanceShare knowledge and skills across the team through mentorship, coaching, and training of junior staff on integration methodologiesRequired Experience:
Bachelor's degree in Computer Science, Information Technology, or a related field, or a Bachelor's degree and experience in Database design and developmentStrong understanding of database design principles, data modeling, and normalization5 years of experience with utilizing scripting languages to develop ETL pipelines3 years of experience designing databases and working with development teams throughout the development lifecycleExperience developing and troubleshooting integrations with SSIS, Azure Data Factory, or Pentaho Data IntegrationExperience working with Snowflake and DatabricksExperience working with SalesforcePreferred Experience:
Master's degreeCertifications in relevant technologies, such as Snowflake, Python, PySpark, Sql-Server and Power BIExperience with cloud platforms, such as Azure and AWSKnowledge of best practices in data governance and complianceKnowledge 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 SalaryFinal pay rate is dependent on experience, training, education, and location.