Sr Data Engineer

Tential Solutions; Dresher (Montgomery County); On-site; USD 100,000 - 130,000; Full time

Job summary

Tential Solutions is seeking a Senior Data Engineer to facilitate data-driven decision-making in Dresher, United States. This role emphasizes building and maintaining data processing systems with a focus on security, reliability, and efficiency.

Key responsibilities include securing confidential data, creating data models, and mentoring junior team members. The ideal candidate has over 5 years of experience, strong knowledge of data warehousing and ETL tools, and excellent communication skills.

Qualifications

• 5+ years of relevant experience in data/software development, including data warehousing and ETL tools.
• Strong knowledge of dimensional data modeling and star schema design.
• Experience with Python for data manipulation and analysis.

Responsibilities

• Design and build data processing systems for transformation and visualization.
• Create conceptual, logical, and physical data models.
• Proactively mentor junior team members.

Skills

Data warehousing

ETL tools

Oracle PL/SQL

Data modeling techniques

Communication skills

Python

SQL Server Analysis Services (SSAS)

Education

Bachelor's degree or equivalent work experience

Tools

Power BI

IDERA's Embarcadero ER/Studio Data Architect

Job description

Senior Data Engineer

As a Senior Data Engineer, you will enable data-driven decision-making by collecting, transforming, and visualizing data. You will design, build, maintain, and troubleshoot data processing systems with an emphasis on security, reliability, fault tolerance, scalability, data integrity, and efficiency. You will be part of the Enterprise Information Management (EIM) team.

Responsibilities

• Responsible for protecting, securing, and properly handling all confidential data to ensure against unauthorized access, improper transmission, and/or unapproved disclosure of information that could result in harm to the organization or its clients.
• Demonstrate professionalism, quality, integrity, and a commitment to organizational values in day-to-day activities.
• Utilize Artificial Intelligence (AI) tools to accelerate ETL development and data analysis.
• Design, build, and maintain data structures and data processing systems, including tools, infrastructure, frameworks, and services.
• Assist with EIM project planning and definition.
• Implement, support, and troubleshoot deployments.

Data Modeling

• Create conceptual, logical, and physical data models.
• Develop Entity Relationship Diagrams (ERDs) and dimensional models.

Data Integration Services

• Design and build data ingestion tools, metrics, alerts, notifications, and metadata management solutions.
• Design and build data replication services and Change Data Capture (CDC) processes to incrementally update data warehouses and data marts from systems of record.

ETL Development

• Contribute to standards and best practices for implementing ETL tools in support of the EIM vision and reference architecture.
• Build and maintain ETL solutions and supporting platforms.
• Participate in creating long-term ETL application support models.

Data Warehouse & Data Marts

• Develop technical standards and specifications addressing ETL performance, security, orchestration, and data warehouse management.
• Organize metadata and define processes for loading data into and extracting data from data warehouses and data marts.

Leadership & Support

• Proactively mentor junior team members.
• Participate in an on-call rotation supporting production issues and outages.
• Assist with other tasks and projects as assigned.

Experience, Skills, And Knowledge Requirements

Required Skills and Experience

• 5+ years of relevant experience in data/software development, including data warehousing and ETL tools, techniques, and technologies.
• Bachelor's degree or equivalent work experience.
• Excellent analytical skills.
• Strong verbal and written communication skills, including active listening, asking effective questions, clarifying requirements, and producing clear documentation.
• Strong knowledge of Oracle PL/SQL or other database programming languages.
• Solid understanding of data modeling techniques.
• Strong knowledge of Data Warehousing concepts and ETL design/tools.
• Experience with relational databases such as Oracle, Sybase ASE, and MySQL.
• Working knowledge of SQL Server Analysis Services (SSAS).
• Experience utilizing AI agents and AI-assisted development tools for code generation, code analysis, and data analysis.
• Experience with Python for data manipulation and analysis, including Pandas and PySpark.
• Proven experience diagnosing and resolving performance issues.
• Strong understanding of data storage, partitioning, and retention strategies.
• Strong understanding of dimensional data modeling and star schema design.
• Ability to conduct code reviews and provide constructive, actionable feedback.

Preferred Skills And Experience

• Experience with data modeling tools such as IDERA's Embarcadero ER/Studio Data Architect.
• Experience with Power BI or similar reporting and analytics platforms.
• Experience with CI/CD processes for database deployments using Liquibase or similar tools.

Must be a U.S. Citizen or Green Card holder. No sponsorship provided for this position.