Data Engineer - Databricks - HYBRID with Security Clearance

HKA Enterprises

Farmington, CT

JOB DETAILS
SKILLS
Analysis Skills, Business Intelligence, Cloud Computing, Communication Skills, Data Lake, Data Mart, Data Warehousing, Database Design, Database Extract Transform and Load (ETL), Database Programming, Database Technology, Documentation, Integration Testing, Interpersonal Skills, Microsoft SQL Server, Microsoft Windows Azure, Multitasking, MySQL, Oracle Database, Oracle PL-SQL, Process Development, Process Flow, Process Improvement, Programming Languages, Project/Program Management, Python Programming/Scripting Language, Requirements Management, SQL (Structured Query Language), SQL Databases, Scalable System Development, Security Clearance, Spreadsheets, Stored Procedures, System Migration, Team Player, Unit Test
LOCATION
Farmington, CT
POSTED
1 day ago
We are seeking a Data Engineer with experience in projects emphasizing complex data solutions. This person will be responsible for supporting the data ingestion, transformation, and distribution to end consumers. Candidate will perform requirements analysis, design/develop process flow, and unit/integration testing, to deliver complex data products. Work with the Business Intelligence team and operational stakeholders to design and implement both the data presentation layer available to the user community, as well as the underlying technical architecture of the data warehousing environment.
· Develop scalable and reliable data solutions to move data across systems from multiple sources in real time as well as batch modes. Design and develop database objects, tables, stored procedures, views, etc.
Design and develop ETL Processes that will transform a variety of raw data, flat files, xl spreadsheets into SQL Databases
Understands the concept of Data marts and Data lakes and experience with migrating legacy systems to data marts/lake
Uses additional cloud technologies (e.g., understands concept of Cloud services like Azure SQL server)
Maintain comprehensive project documentation
· Aptitude to learn new technologies and the ability to perform continuous research, analysis, and process improvement. · Strong interpersonal and communication skills to be able to work in a team environment to include customer and contractor technical, end users, and management team members. Manage multiple projects, responsibilities and competing priorities.
Experience Needed: Programming languages, frameworks, and file formats such as: Python, SQL, PLSQL, DBT
Database platforms such as: Oracle, SQL Server, MySQL
Big data concepts and technologies such as Synapse & Databricks
AWS and Azure cloud computing

About the Company

H

HKA Enterprises

HKA Enterprises, Inc (HKA) is committed to a level of service and integrity that will encourage long-term relationships and ensure the success of HKA and of our Clients. For over 30 years we have been serving our nationwide client base. Headquartered outside of Greenville, SC, HKA provides staffing and direct placement services to many market segments with offices across the US, Puerto Rico and Canada. This provides flexibility and promptness for the critical staffing needs of our clients.

Our teams of professionals seek to place talented personnel either directly or indirectly through contractors for industries related to Process, Industrial, Nuclear Power, Aerospace, Life Sciences, Environmental and Government Services. We maintain a corporate staff of over 40 recruiting and staffing support professionals, averaging over 15 years of experience. The services we offer contribute to the success of projects by offering a diversified pool of employees at any point in the project continuum of engineering, procurement, construction, commissioning/validation, as well as operation and maintenance personnel. As a single source provider of staffing solutions, HKA can present cost effective solutions to any project or executive search/direct placement vacancy. The business units at HKA are effectively organized to serve these needs.

Although many are assigned to our corporate office, we establish and maintain field locations as needs dictate. Field offices are mobilized and staffed immediately. Managers, recruiters and administrative personnel assigned to field staff augmentation units have real-time access to our corporate databases which include a refined personnel database of over 100,000 candidates individually selected and maintained.

COMPANY SIZE
1,500 to 1,999 employees
INDUSTRY
Staffing/Employment Agencies
FOUNDED
2016
WEBSITE
http://www.cenergypartners.com/