Data Engineer - Remote Opportunity
About the Company
GTT is a minority-owned staffing firm and a subsidiary of Chenega Corporation, a Native American-owned company based in Alaska. The company supports Fortune 500 organizations across banking, financial services, technology, life sciences, biotechnology, utilities, and retail throughout the United States and Canada. GTT values diversity and inclusion in the workplace.
About the Role
GTT is seeking a Data Engineer 3 for a six-month contract supporting a Databricks migration engagement for St. Luke’s. This fully remote role focuses on developing data ingestion processes and building silver and gold data tables in Databricks based on existing solutions running in Health Catalyst on Microsoft SQL Server. You will work closely with Business Intelligence analysts and developers to design, build, test, and maintain reporting solutions. The role requires strong SQL and ETL development skills, experience working with different data sources, and an understanding of data warehousing and data modeling. You will also participate in design and code reviews, troubleshoot technical issues, and ensure that data solutions follow applicable corporate policies and privacy regulations, including HIPAA.
Key Responsibilities
Design and implement data ingestion processes in Databricks using available tools and established approaches for different source systems. Design and build silver and gold tables in Databricks based on existing Health Catalyst solutions deployed on Microsoft SQL Server. Collaborate with Business Intelligence analysts and developers to design, develop, and maintain silver and gold data tables. Prepare for and participate in design and code reviews in accordance with St. Luke’s design standards. Participate in testing activities to verify the functionality, accuracy, and integrity of reporting solutions. Troubleshoot errors, investigate data issues, and resolve complex technical problems. Ensure data engineering work complies with corporate policies and privacy regulations, including HIPAA. Apply SQL and ETL development skills to support data migration and reporting requirements. Share lessons learned from previous migrations, communicate issues promptly, and work collaboratively with team members to resolve problems. Support database performance optimization, tuning, and security practices.
Required Qualifications
At least four years of related professional experience. Strong SQL skills, including writing queries, creating tables, and performing updates using Transact-SQL and Databricks SQL (DBSQL). Strong experience developing ETL processes using Azure Databricks, DBSQL, Microsoft SQL Server, Transact-SQL, and SSIS. Experience ingesting data from multiple source types, including relational database management systems, XML files, JSON files, flat files, and APIs. Experience with database management systems, including performance optimization, tuning, and security. Experience with data warehousing methodologies and data model development. Strong communication and collaboration skills, including the ability to raise issues promptly, listen to colleagues, solve problems as a team, and share lessons learned from previous migrations. Authorization to work for any employer in the United States. Visa sponsorship and transfer of existing employment visa sponsorship are not available for this position. Preferred Qualifications / Requirements Experience with Power BI, Health Catalyst, and Epic is preferred. Location and Work Arrangement Location: Boise, Idaho. Work arrangement: 100% remote. Position type: Contract. Contract duration: Six months. Interview process: One-hour panel interview conducted through Microsoft Teams. Submission restriction: Data Architect profiles will not be considered for this role. Salary & Benefits Pay rate: $60.00 per hour (USD). Benefits include medical, vision, and dental insurance plans, along with a 401(k) retirement fund.