Job Requirements
Farmington, CT
Clearance Unspecified Polygraph not specified
Senior Level Career (10+ yrs experience)
$110,000 - $120,000
Job Description
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
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
group id: 10200989