Work Authorization: Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.
Job Summary
This role is for Data Engineer contractors supporting a Databricks migration engagement. This role is 100% remote.
Key Responsibilities
Ingests: Design and implement Databricks ingestion processes, leveraging Databricks skills, St. Luke's tools and skills with different types of sources.
Design and Build: Design silver and gold tables in Databricks based on existing solutions deployed in Health Catalyst installed on Microsoft SQL Server.
Collaborate and Develop: Work collaboratively with Business Intelligence analysts and Business Intelligence developers to design and build silver and gold tables.
Design and Code Reviews: Prepare for and participate in design and code reviews according to St. Luke's design standards.
Test and Troubleshoot: Participate in testing methodologies, ensuring the functionality and integrity of our reporting solutions. Troubleshoot and resolve errors and solve complex technical problems.
Compliance: Ensure adherence to corporate policies and privacy regulations like HIPAA.
Required Skills
SQL Proficiency: Strong SQL experience writing queries, creating tables, and performing updates with Transact SQL and DB SQL.
ETL Expertise: Strong experience writing ETL with Azure Databricks, DBSQL, Microsoft SQL Server, Transact SQL, SSIS.
Data Ingestion: Experience ingesting data from many different types of sources (RDBMS, XML files, JSON files, Flat files, APIs).
Database Expertise: Experience with database management systems, including performance optimizing and tuning and security.
Design Experience: Experience with data warehousing methodologies and data model development.
Communication/Collaboration: Speak up quickly when something is discovered, listen and work with others to solve problems, share lessons learned from prior migrations.
Preferred Skills
Additional Experience: Experience with Power BI, Health Catalyst, and Epic is a plus.
Required Experience
Minimum of 4 years of related experience.
Benefits
Medical, Vision, and Dental Insurance Plans
401k Retirement Fund
Important Notes
Data Architects will not be considered for this role; please do not submit Data Architect profiles.
Interview process: 1-hour panel interview over MS Teams.
About GTT
GTT is a minority-owned staffing firm and a subsidiary of Chenega Corporation, a Native American-owned company in Alaska. We highly value diverse and inclusive workplaces and support Fortune 500 organizations across banking, financial services, technology, life sciences, biotech, utilities, and retail sectors throughout the U.S. and Canada.
Job Number: 26-16021 Industry: Data & Analytics
#LI-Remote #gttjobs
Numbers & Facts
Location
Boise, ID (Remote)
Industry
Staffing/Employment Agencies
Company Size
100 to 499 employees
Year Founded
2004
Website
http://www.gttit.com
About Company
Global Technical Talent is a subsidiary of Chenega Corporation (www.Chenega.com) with over 1.3 billion US$ in revenue and 5800 US employees. We provide Total Talent Solutions, Global staffing, SOW, RPO, Direct Sourcing, and Global Payroll with physical offices in US, Canada, and India. GTT Digital headquartered in Toronto specializes in providing high-tech digital and banking talent to some of the nation’s largest financial institutions. GTT has been a leader in the staffing industry for over 22 years and is one of the largest staffing firms in the New England region. We are known for our Fortune 500 clientele and cutting-edge, technology-driven recruiting infrastructure.
We are a Native American-owned, economically disadvantaged corporation that highly values diverse and inclusive workplaces. Our clients and partners are among the most successful and innovative organizations in the world. Our top clients are Fortune 500 banking, insurance, and financial services firms, some of the nation’s largest life sciences, biotech, utility, and retail companies, and prestigious educational institutions in the Ivy League tier.
There is always a new opportunity for success when you look through all of the open job opportunities on our website’s career page. Just click on this link: https://bit.ly/gttcareers
Awards SIA’s Best Staffing Firm to Work for ( 2019 -2023) SIA’s Fastest Growing Staffing Firm Inc 5000 Company NH Business Magazines Fast 5 fastest growing companies.
Skills
Application Programming Interface (API)unmatched
Banking Servicesunmatched
Biologyunmatched
Biotech and Pharmaceuticalunmatched
Business Intelligenceunmatched
Code Reviewsunmatched
Data Analysisunmatched
Data Warehousingunmatched
Database Extract Transform and Load (ETL)unmatched