Senior Data Engineer

Pansophic Learning; Parma; In loco; EUR 70.000 - 110.000; Tempo pieno

Descrizione del lavoro

Pansophic Learning seeks a Senior Data Engineer who will bridge the IT organization and business teams to deliver high-quality data products. The role focuses on designing and maintaining database schemas, ETL development, and data warehouse management, with cloud experience across AWS and Azure.

You will collaborate with Data Architects, Engineers and QA, driving efficient data pipelines, data modeling, and production issue resolution. Visa sponsorship is not available.

Competenze

• Bachelor’s degree or equivalent in a technical field.
• 7+ years of relational database SQL development experience (T-SQL, PLSQL, or SQL scripts).
• 5+ years of experience with public cloud (AWS or Azure).
• 3+ years of experience in data warehousing, preferably AWS Redshift.
• Strong knowledge of databases, data models and ETL/ELT development.
• Experience with AWS/Azure services such as S3, Lambda.
• Experience with NoSQL databases (MongoDB).
• Ability to work in fast-paced environment and solve complex coding problems.
• Excellent written and verbal communication skills.
• Ability to pass background checks.

Mansioni

• Design and maintain database schemas for relational and NoSQL databases.
• Develop backend ETL processes and data warehouse loading.
• Transform raw data into business information for partners.
• Collaborate with Data Architect, Data Engineers, and developers to improve systems.
• Build and maintain data extraction from various sources and cloud services.

Conoscenze

Data modeling

ETL development

SQL

AWS

Azure

MongoDB

Redshift

Data warehousing

Git

Communication

Formazione

Bachelor’s Degree in Computer Science, Electrical or Electronics Engineering, Information Systems, Systems Engineering, or equivalent degree

Strumenti

AWS

Azure

Power BI

Git

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.