View Our Website View All Jobs

Data Architect

Data Architect

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
  • Incident Management
  • Troubleshoot and resolve issues reported by customers (internal/external)
  • Provide Root Cause to management using documented company procedures when requested
  • Change Management
  • 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.

#ZR

Read More

Apply for this position

Required*
Apply with Indeed
Attach resume as .pdf, .doc, or .docx (limit 2MB) or Paste resume

Paste your resume here or Attach resume file

To comply with government Equal Employment Opportunity / Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more.
Gender
Race
Veteran/Disability status
Human Check*