The Senior Data Engineer serves both our business partners as well as the Information Technology (IT) organization delivering high quality products with timely business impact.
They are responsible for helping our business partners engage successfully with our products and services acting as a bridge between the IT organization and the various business teams.
The Senior Data Engineer primary responsibilities are to design and maintain our database schemas, analyze and organize raw data from various data sources, to transform raw data into business information, to develop backend ETL processes and to maintain the data model for the data warehouse.
The Senior Data Engineer works collaboratively with other IT teams, including Data Architect, Data Engineers, Software Engineers and managers, QA/Test Engineers and is expected to build close trusting relationships with the business-lines.
He or she will be expected to innovate and provide suggestions and solutions to maintain and improve the current and future developments of the company.
*** VISA sponsorship is not available ***
Responsibilities:
Perform data modeling to design relational and NoSQL/document databases schemas
Design, implement, automate, and maintain ETL processes
Perform data extraction from various sources
Perform data transformation and load data to data warehouse
Perform data modeling to design relational and NoSQL/document databases
Work with various services from Amazon Web Services (AWS) and Microsoft Azure to build, host and maintain data extraction, transformation and loading functions to data warehouse.
Manage and maintain data warehouse
Implement and manage best practices for maintaining source code repositories and branching/merging strategies with Git for multiple code bases and applications
Analyze and resolve technical and application problems
Provide analysis and troubleshooting for production issues & code deployment activity




Work collaboratively with other developers, testers and product owners
Qualifications:
Bachelor's Degree in Computer Science, Electrical or Electronics Engineering, Information Systems, Systems Engineering, or equivalent degree
7 + years of relational database SQL development experience (T-SQL, PLSQL, and/or SQL scripts, views, packages, etc)
5+ years of experience with public cloud (AWS or Microsoft Azure)
3+ years of experience in data warehousing, preferably AWS Redshift
In-depth knowledge in developing and designing databases and data models.
In-depth knowledge in ETL/ELT development.
Experience with AWS and Azure services, i.e., S3, Lambda, Power App.
Experience in NoSQL database (MongoDB)
Ability to be a self-starter and work in a fast-paced environment solving challenging problems in designing, writing, editing, modifying and debugging code
Exceptional oral and written communication skills
Ability to pass federal and state criminal background checks (FBI/BCI)
Additional Preferred Qualifications:
Experience in data analytics platforms, e.g. Microsoft Power BI
Ability to think independently and contribute to the overall effort without much direction
Ability to work well within a team environment
Ability to work well under pressure
EQUAL EMPLOYMENT OPPORTUNITY
It is our policy to abide by all federal, state and local laws prohibiting employment discrimination based solely on a person's race, color, religious creed, sex, national origin, ancestry, citizenship status, pregnancy, childbirth, physical disability, mental and/or intellectual disability, age, military status, veteran status (including protected veterans), marital status, registered domestic partner or civil union status, familial status, gender (including sex stereotyping and gender identity or expression), medical condition, genetic information, sexual orientation, or any other protected status except where a reasonable, bona fide occupational qualification exists.
#J-*****-Ljbffr

📌 Senior Data Engineer (Emilia-Romagna)
🏢 Pansophic Learning
📍 Emilia-Romagna