Data Engineer (Remote) – ITS-DATA Galveston, Texas, United States New Information Technology UTMB Health Requisition # 2403064 Minimum Qualifications: Bachelor’s degree in computer science, Information Technology, Mathematics, Public Health, Business, Healthcare Administration or related field. Six years of related experience required, including extensive experience with SQL querying, relational and/or dimensional database development and ETL development. An equivalent combination of education and experience relevant to the role may be considered for this position. Job Summary: Design and build scalable data pipelines that can extract, transform, and load data from cloud and on-premises data sources using Azure Synapse pipelines, Azure Data Factory, SQL, and other cloud data technologies for business/operational use cases and data governance. Develops and maintains data pipelines, including solutions for data collection, management, metadata, and usage. Works closely with Data Scientists, Data Architects, and Analytics Developers to optimize and re-engineer model code to be modular, efficient, and scalable and to deploy models to production. Preferred Qualifications: Experience with Azure Data Factor or Azure Synapse. MS degree in Computer Science or Computer Science/Information Systems. Working experience with Azure Synapse Analytics Data Platform. Working experience with Azure Data Lakes. Working experience with Azure Data Factory or Synapse Pipelines. Working Experience with ER Studio. Experience in high concurrency platforms, graph databases, and applied mathematics. Experience working with EPIC data and Clarity. Knowledge and experience of database management technologies. Knowledge and experience of Data Governance. Job Duties: Use data and information innovatively to drive improved patient care, productivity, and operational efficiency, increased departmental agility, and higher performance. Assist in establishing standards and guidelines for the design & development, tuning, deployment, and maintenance of information, advanced data analytics, and text mining models, and physical data persistence technologies. Create/maintain the Development of Business Intelligence (BI) and data architecture to increase the robustness, performance, and scalability of systems. Maintain data quality in the Development Data Mart and Development Enterprise Data Platform. Ensure integrity of data in the Enterprise Data Platform, correcting any data problems, data consistency, establish and design procedures to purge/archive old data. Guide data consistency between development’s Source Systems, Application, Ancillary Systems, and Enterprise Data Warehouse. Create/maintain the ETL architecture and design. Create streamlined, scalable integration solutions to support BI and analytic environment. Track progress and communicate effectively with key stakeholders to ensure the successful completion of the project within time, cost, and quality. Interact with clinical/academic/research/business partners and 3rd party vendors to highlight the correct information, risks, and open issues and the impact on data architecture and analytic-related projects. Research and design of algorithms to solve problems using medical and healthcare data. Train/update/version/maintain production machine learning systems. Extract and expose external public data sources to enhance medical machine-learning models. Knowledge/Skills/Abilities: Data Modeling Database Development Data Warehousing SSIS SQL Server
T-SQL/PLSQL Perform the professional and technical competencies related to data architecture and analytics. Development of products using distributed computing & big data products. Organization, management, and standardization of enterprise data. Effective use of information that provides insight into better decision making. Building and developing pipelines to handle large volumes of heterogeneous medical data. Strong Dimensional Modeling skills and Database Design. Robust Query Tuning & Troubleshooting Skills. Development of products using distributed computing & big data products. Organization, management, and standardization of enterprise data. Effective use of information that provides insight into better decision making. Work Schedule: Monday through Friday, 8am to 5pm and weekend support as needed. Salary Range: Actual salary commensurate with experience. Equal Employment Opportunity UTMB Health strives to provide equal opportunity employment without regard to race, color, religion, age, national origin, sex, gender, sexual orientation, gender identity/expression, genetic information, disability, veteran status, or any other basis protected by institutional policy or by federal, state or local laws unless such distinction is required by law. As a VEVRAA Federal Contractor, UTMB Health takes affirmative action to hire and advance women, minorities, protected veterans and individuals with disabilities. Compensation
Azure Data Factory Troubleshooting Data Science query-optimization data-warehouse Databases azure-synapse Data Engineering T-SQL dimensional-modeling PL/SQL SQL Server Integration Services (SSIS) data-modeling database-design data governance clarity SQL distributed-programming ETL