Job Category : ITRequisition Number : DATAE001585Apply nowPosted : February 27, 2026Full-TimeLocations Showing 1 locationCenero employees are truly empowered to innovate at every level, in every function. We hire high energy activators, that aren't afraid to leverage their passion and expertise. And we're agile, which means you can make a difference with your career, while learning, growing and having fun!OPPORTUNITY SUMMARYThe On-Site Data Engineer in Malvern, PA works with our IT and Software Development teams, playing a key role in administering, maintaining, optimizing, analyzing, and architecting both Cenero developed and Cenero supported applications and systems. This position is multifaceted requiring a dynamic blend of database administration, data engineering, data analytics, and data science to ensure our data remains reliable, secure, and optimized for various business applications.Cenero is unable to offer H1B sponsorship, transfer over H1B sponsorship, or transfer any employment visas at this time.Bachelor's degree in Computer Science, Data Engineering, Information Systems, or a related field. Master's degree is a plus3+ years of experience in data engineering, database administration, or related fields.Strong expertise in SQL, SSIS, PowerShell, Python, and data modeling.Proficiency in SQL Server and MySQL database administration and troubleshooting.Experience with ETL/ELT tools such as Azure Data Factory, SSIS, Azure Synapse, Azure Stream, DBT, Apache Airflow, Apache Talend, etc.Hands-on experience with cloud platforms (AWS, Azure, GCP) and their data services. Azure preferred.Hands-on experience with business intelligence tools (Power BI, Tableau, Zoho). Power BI and DAX preferred.Familiar with Database analysis tools such as SolarWinds.Proficiency with big data technologies (Spark, Hadoop, Snowflake, Redshift, BigQuery).Knowledge of data governance, security, and compliance best practices.Some experience with code versioning tools such as Git preferred.Some experience with machine learning workflows and MLOps concepts preferred. Certifications in AWS, Azure, CompTIA or GCP preferred.Essential Duties and ResponsibilitiesDesign, build, and maintain scalable ETL/ELT pipelines to ingest, process, and store data efficiently.Develop and optimize data warehouses, data lakes, and databases for structured and unstructured data.Implement best practices for data modeling, storage, indexing, and retrieval.Collaborate with software engineers to integrate data solutions into applications, APIs and services.Automate data workflows, monitoring, and alerting to ensure data integrity and performance.Manage and optimize SQL and NoSQL databases to support business operations and analytics.Ensure data security, compliance, and access control for all data assets.Monitor database performance and optimize queries for speed and efficiency.Work closely with analysts and stakeholders to define data requirements and ensure accessibility.Develop and maintain Power BI semantic models and reports.Support predictive analytics and machine learning workflows by ensuring clean, well-structured data.Conduct exploratory data analysis (EDA) to identify trends, patterns, and insights.Define and maintain data governance policies to ensure data consistency and quality.Contribute to the development of a modern data stack, evaluating new tools and technologies.Design, document, diagram and implement scalable, high-performance data architectures that align with business needs.Adaptability to switch between various tools based on business needs, such as transitioning from SQL to MongoDB or utilizing new tools in Azure or GCP.QUALIFICATIONSBachelor's or Master's degree in Computer Science, Data Engineering, Information Systems, or a related field.3+ years of experience in data engineering, database administration, or related fields.Strong expertise in SQL, SSIS, PowerShell, Python, and data modeling.Proficiency in SQL Server and MySQL database administration and troubleshooting.Experience with ETL/ELT tools such as Azure Data Factory, SSIS, Azure Synapse, Azure Stream, DBT, Apache Airflow, Apache Talend, etc..Hands-on experience with cloud platforms (AWS, Azure, GCP) and their data services. Azure preferred.Hands-on experience with business intelligence tools (Power BI, Tableau, Zoho). Power BI and DAX preferred.Familiar with Database analysis tools such as SolarWinds.Proficiency with big data technologies (Spark, Hadoop, Snowflake, Redshift, BigQuery).Knowledge of data governance, security, and compliance best practices.Some experience with code versioning tools such as Git preferred.Some experience with machine learning workflows and MLOps concepts preferred. Certifications in AWS, Azure, CompTIA or GCP preferred.OTHER SKILLSAbility to troubleshoot, solve problems and analyze code of varying software languages.Highly detail-oriented and strong organizational skills.Must be able to document and diagram solutions visually.Must be able to communicate effectively and collaborate with team members at varying levels of understanding.Strong interpersonal and communication skills (written and oral), with the ability to work effectively with all levels of the organization, both internally and externally.Proven ability to significantly contribute toward or lead operation initiatives.Strong problem-solving skills and creative thinking to ensure success of objectives, whether project, process, or personnel related.Ability to work and think independently and compile quantitative data for review.Proficient with Microsoft Office Suite and other related software.WORK ENVIRONMENTThis is not a remote position. The work environment is 5 days a week, on-site in our Malvern, PA headquarters.This position may include occasional travel to other environments including Cenero offices, educational buildings, corporate office buildings, government locations, and construction sites. Ability to maintain focus and productivity on tasks for extended periods. Flexibility to work outside standard business hours when necessary either in emergencies related to our systems or to meet project deadlines. Adaptability to switch between various tools based on business needs, such as transitioning from SQL to MongoDB or utilizing new tools in Azure or GCP. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.BENEFITS AND PERKSIndustry-leading healthcare coverage begins on your first day of employment. Includes medical, dental, vision, and prescriptionSavings and 401K Investments with company matchHealth Savings Account (HSA)Flexible Spending Account (FSA)Dependent Care Spending Account (DCA)100% Company paid Short-Term DisabilityOptional Long-Term DisabilityPaid Time Off awarded at hireOn-site gym, weight room, locker roomGiving ProgramsEmployee Tuition ReimbursementOpportunities to network and connectLucrative Employee Referral programWarm Philly soft pretzels every Wednesday in MalvernCOMPENSATION TRANSPARENCYThe salary range for a Data Engineer I based in Malvern, PA can range from $85,250 to $105,750 per year. The actual amount to be offered to the successful candidate will be in or near that range. Individual pay is determined by different factors, including work experience, geographic location, job-related skills, education level, position specific technical certifications, and additional trainings completed.All health and wellness benefits will begin on Day 1 of employment. There is no mandatory 90-day waiting period.COMPANY INFORMATIONCenero employees are truly empowered to innovate at every level, in every function. We hire high-energy activators, that aren't afraid to leverage their passion and expertise. And we're agile, which means you can make a difference with your career, while learning, growing, and having fun!Since 1999, Cenero has offered a range of Audio-Visual solutions that improve communication, drive productivity, and empower collaboration. Our suite of solutions includes systems design, fabrication, installation, and managed services, which fits in perfectly with Ricoh's portfolio of digital workplace solutions. Our corporate revenue growth has averaged 30% year over year for the past 6 years. We are growing rapidly, and our recent acquisition by Ricoh in October 2022 has accelerated our growth. We have a new headquarters building in Malvern, PA, plus 4 other U.S. offices. (New York, Baltimore/Washington DC, Charlotte, and Dallas)Our Constant Connect solution is a suite of managed services that assures technology readiness for all collaboration spaces. The suite includes:Proactive Managed Services identify and solve issues before meetings even startUC Proactive Managed Servicesmonitors rooms and UC platforms like Teams and Zoom to keep spaces fully functionalReactive Managed Servicesprovide immediate assistance for all tech issuesAnAnalytics Dashboardprovides detailed data for more informed business planningAV Staffing Servicesprovide on-site support of complex AV technologyAt Cenero, we have a vibrant corporate culture which focuses on work/life balance. Cenero has won numerous awards including Best Place to Work and Inc Magazine's List of the 5000 Fastest Growing Companies (both awards 4 times). You can choose from a broad selection of medical, dental, vision, life insurance, and disability insurance options. You can contribute to your financial security with a Retirement Savings Plan (401K) with a company match. You can augment your education with tuition assistance programs. Enjoy paid vacation time and paid holidays annually. All of your benefits begin on Day One of employment.Cenero provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. Direct candidates only. HLH. No unsolicited employment agency or third-party resumes will be accepted.Equal Opportunity Employer/Protected Veterans/Individuals with DisabilitiesThis employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.
#J-18808-Ljbffr