Job Description

Cenero 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 SUMMARY

The 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 plus
• 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.

Essential Duties and Responsibilities

• Design, 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, maintain, and improve Power Bi reports for KPIs, storytelling, executive summary reporting.
• Develop, maintain, and improve standardized metric definitions, dashboard UX standards (layout, interaction, patterns & drill paths).
• Develop, maintain, and improve Fabric/Power Bi workspace app deployment, release management, versioning, usage monitoring, and refresh SLAs.
• 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.
• Administer database connection strings & database administrative access.
• 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.

QUALIFICATIONS

• Bachelor’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 SKILLS

• Ability 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 ENVIRONMENT

This 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 PERKS

• Industry-leading healthcare coverage begins on your first day of employment. Includes medical, dental, vision, and prescription
• Savings and 401K Investments 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
• Optional Long-Term Disability
• Paid Time Off awarded at hire
• On-site gym, weight room, locker room
• Giving Programs
• Employee Tuition Reimbursement
• Opportunities to network and connect
• Lucrative Employee Referral program
• Delicious Free coffee
• Warm Philly soft pretzels every Wednesday in Malvern

COMPENSATION TRANSPARENCY

• The 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 INFORMATION

Cenero 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 start
• UC Proactive Managed Services monitors rooms and UC platforms like Teams and Zoom to keep spaces fully functional
• Reactive Managed Services provide immediate assistance for all tech issues
• An Analytics Dashboard provides detailed data for more informed business planning
• AV Staffing Services provide on-site support of complex AV technology

At 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. HLH.

Direct candidates only. No-Fee Disclaimer. Note to all employment Agencies. This position is not open to third party employment Agencies. Any unsolicited Agency resumes or candidate summaries which are presented to any Cenero employee without having a signed contract between that Agency and the Cenero Talent Acquisition organization will become the property of Cenero, and no Agency fee will be paid.