Senior Data Engineer

Pansophic Learning; Parma (OH); On-site; USD 110,000 - 165,000; Full time

Job summary

Pansophic Learning is seeking a Senior Data Engineer to bridge IT and business teams, designing relational and NoSQL schemas, and building robust ETL pipelines for the data warehouse.

You will work with AWS/Azure services, contribute to data modeling, and ensure high-quality data products for business partners. Strong communication and background check clearance are required.

Qualifications

• Bachelor's degree in CS, EE, IS, Systems Eng or equivalent.
• 7+ years of relational SQL development experience (T-SQL, PLSQL, SQL)
• 5+ years of public cloud experience (AWS or Azure)
• 3+ years in data warehousing, preferably AWS Redshift
• Experience with AWS/Azure services: S3, Lambda, Power Apps
• Experience with NoSQL: MongoDB
• Strong self-starting ability in fast-paced dev environments
• Excellent oral and written communication
• Ability to pass FBI/BCI background checks

Responsibilities

• 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 IT teams to deliver solutions.
• Build and maintain data models and pipelines in AWS/Azure environments.
• Implement code management and Git branching strategies.
• Troubleshoot production issues and coordinate deployments.
• Work with cross-functional teams to improve data platforms.

Skills

SQL development

Public cloud (AWS/Azure)

ETL/ELT design

Data modeling

NoSQL (MongoDB)

Data warehousing (Redshift)

Python/SQL scripting

Communication skills

Education

Bachelor's Degree in Computer Science or related

Tools

AWS

Azure

S3

Lambda

Power Apps

MongoDB

Job description

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.