Senior Data Engineer

Pansophic Learning; Emilia-Romagna; In loco; EUR 80.000 - 110.000; Tempo pieno

Descrizione del lavoro

Pansophic Learning in Italy is seeking a Senior Data Engineer to design and maintain database schemas, transform data into actionable insights, and develop backend ETL processes.

You will collaborate with IT and business teams, work with AWS and Azure, and help ensure data quality and performance across the data warehouse. Visa sponsorship is not available.

Competenze

• 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)

Mansioni

• 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

Conoscenze

SQL development

ETL/ELT development

NoSQL databases

AWS & Azure

Data warehousing

Communication skills

Self-starter

Formazione

Bachelor's Degree in Computer Science or related field

Strumenti

AWS S3

Azure

MongoDB

Descrizione del lavoro

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.