Data Engineer I

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.