Data Jobs in Malvern, PA

1 job found

Include remote jobs

29d ago

Data Engineer I

Cenero LLC Malvern, PA

Malvern, PA

29d ago

$85k - $116k/yr Full time Data Data Engineer Engineer

Apply Now

Job Description

An on-site Data Engineer I role based in Malvern, PA, partnering with IT and Software Development teams to administer, maintain, optimize, analyze, and architect both Cenero-developed and Cenero-supported applications and systems. The position blends database administration, data engineering, analytics, and data science to keep data reliable, secure, and ready for business use.

Responsibilities

Create and sustain scalable ETL and ELT pipelines to ingest, process, and store data efficiently.
Develop and optimize data storage architectures, including data warehouses and data lakes, for structured and unstructured data.
Apply best practices for data modeling, storage, indexing, and retrieval.
Collaborate with software engineers to embed data solutions into applications, APIs, and services.
Automate data workflows, establish monitoring, and implement alerting to preserve data integrity and performance.
Manage and optimize SQL and NoSQL databases to support operations and analytics.
Ensure data security, compliance, and access control across all data assets.
Monitor database performance and tune queries for speed and efficiency.
Work with analysts and stakeholders to define data requirements and ensure accessibility.
Create and enhance Power BI reports for KPIs and executive-level storytelling.
Develop and refine standardized metric definitions and dashboard UX standards, including layout, interactions, patterns, and drill paths.
Oversee Fabric/Power BI workspace deployment, release management, versioning, usage monitoring, and refresh SLAs.
Support predictive analytics and ML workflows by providing clean, well-structured data.
Conduct exploratory data analysis to uncover trends, patterns, and insights.
Define and maintain data governance policies to ensure consistency and quality.
Contribute to the evolution of a modern data stack by evaluating new tools and technologies.
Design, document, diagram, and implement scalable, high-performance data architectures aligned with business needs.
Administer database connection strings and administrative access.
Adapt to switching between tools as required by business needs, including transitions from SQL to MongoDB or adopting new Azure or GCP tools.

Requirements

Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or a related field.
Master’s degree is a plus.
3+ years of experience in data engineering, database administration, or related roles.
Strong proficiency with SQL, SSIS, PowerShell, Python, and data modeling.
Experience administering and troubleshooting SQL Server and MySQL databases.
Hands-on work with ETL/ELT tools such as Azure Data Factory, SSIS, Azure Synapse, Azure Stream, DBT, Apache Airflow, Apache Talend, among others.
Practical experience with cloud platforms (AWS, Azure, GCP) and their data services.
Experience with business intelligence tools (Power BI, Tableau, Zoho); Power BI and DAX are preferred.
Familiarity with database analysis tools such as SolarWinds.
Knowledge of big data technologies (Spark, Hadoop, Snowflake, Redshift, BigQuery).
Understanding of data governance, security, and compliance best practices.
Some experience with version control systems such as Git.
Some exposure to machine learning workflows and MLOps concepts is preferred.
Certifications in AWS, Azure, CompTIA or GCP are preferred.

Technologies

SQL, SSIS, PowerShell, Python
SQL Server, MySQL
Azure Data Factory, Azure Synapse, Azure Stream
DBT, Apache Airflow, Apache Talend
AWS, Azure, GCP
Power BI, Tableau, Zoho
SolarWinds
Spark, Hadoop, Snowflake, Redshift, BigQuery
MongoDB, Git
Fabric, DAX

Benefits

Industry-leading healthcare coverage begins on day one, including medical, dental, vision, and prescription benefits
Savings and 401K with company match
Health Savings Account (HSA
Flexible Spending Account (FSA)
Dependent Care Spending Account (DCA)
100% company-paid life insurance
100% company-paid short-term disability, with optional long-term disability
Paid Time Off awarded at hire
On-site gym facilities and related amenities
Giving Programs and Employee Tuition Reimbursement
Networking opportunities and an attractive Employee Referral program
Complimentary coffee and weekly treats in Malvern

Other Skills

Strong problem-solving abilities and meticulous attention to detail
Capability to document and visually diagram solutions
Effective communication and collaboration across organizational levels
Proven track record in contributing to or leading operational initiatives
Independence in work, with the ability to compile quantitative data for review
Proficiency with Microsoft Office Suite and related tools

Compensation Transparency

The salary range for this role in Malvern, PA is from $85,250 to $115,750 per year.
The final offer will be within or near this range based on experience and qualifications.
Pay is determined by factors including work experience, location, skills, education, certifications, and trainings completed.
Health and wellness benefits commence on Day 1 of employment with no mandatory waiting period.

View full job page →

Get Job Alerts

New jobs delivered to your inbox.