Roto-Rooter has been a leader in the industry since 1935.
Roto-Rooter provides excellent and competitive benefits.
Roto-Rooter offers company matched 401k.
Roto-Rooter, a premier provider of plumbing and drain cleaning services, is looking for top notch employees to join our team. If you see a position that you feel qualified for, please click on the open job posting to submit your resume.
"It's not just a job, but a career in plumbing!"
Roto-Rooter Services Company has the opportunity you have been looking for. We are America’s largest plumbing and drain cleaning company and the name that homeowners and businesses turn to for select quality services. We are proud of our 75-year history, but it’s our future that has us so excited!
Our company is looking to hire an experienced Data Architect to work closely with various internal groups in recommending database structures, connectivity, reporting, and dashboards. The Data Architect will be responsible for monitoring and administrating databases for optimal performance and data integrity. The successful candidate will also communicate to senior management regularly on business requests, project status, and other key performance metrics.
This position is located onsite at our Home Office in downtown Cincinnati, OH.
Responsibilities will include:
Develop and implement strategic recommendations for the Roto-Rooter Data Architecture
User Database, ETL Tools, Data Warehouse, BI Tools, AI, CA
Provide insight into the changing database storage and utilization requirements
Development, Capacity, and Lifecycle Management
Troubleshoot and resolve issues reported by customers (internal/external)
Provide Root Cause to management using documented company procedures when requested
Follow company procedures and effectively communicate all scheduled changes for the business
Security Compliance of all Data and Tools throughout the entire process and program
Provide strategies and solutions for proactive monitoring of databases and transaction processing environments
Develop database design and architecture documentation for the business
Candidate requirements include:
Solid Hands On experience with following databases
MSSQL, MYSQL, Oracle, DB2/400, PostgreSQL
Experience with BI reporting and Visualization tools such as Power BI, Tableau, Qlik
Multiple Operating System Experience (Linux, MS Windows, IBM AS/400)
Experience with Data Warehouse principles and methodologies (Kimball, Inmon, Data Lake)
Tools and Utilities: PowerShell, SQL Loader, Stored Procedures, Triggers, VMware
Proven troubleshooting and problem solving skills
Knowledge of C, C#, ASP.Net
Proven ability to work with distributed systems
Education, Experience, and Skill Required:
Bachelor’s Degree in Computer Science or related field
7+ Years of Data Architect Experience
Excellent written and verbal communication skills
Excellent project management skills
Please send resume along with salary history.
We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, gender, age, national origin, disability status, protected veteran status, or any other characteristic protected by law.