Advisor Cloud Engineer

Company and Role: Dedicated Tech Services, Inc. (DTS) is an award-winning IT consulting firm based in Columbus, OH. We now have an opening for a Advisor Cloud Engineer (Databricks) to join our team. Highlights and Benefits: • Hybrid - Columbus, OH (1-2 Days a week onsite) • W2 hourly pay rate up to $60hr or salaried equivalent • Government Environment • Direct W2 hourly or salaried applicants only (no corp-to-corp subcontractors, third parties, or agencies) • Paid time off and holidays for salaried employees • 401K, billable bonus, and health, life, vision, dental and short-term disability insurance options for all • DTS is a proud Women Business Enterprise (WBE) and Woman Owned Small Business (WOSB)! • Check out our benefits and company information at www.dtsdelivers.com! Job Description: We are hiring an experienced Advisor Cloud Engineer (Databricks) to work for us as our direct, W2 salaried or hourly employee to join our team. You will: you will support the business intelligence and data science migration and build strategies that deliver comprehensive data models for actionable data reporting and analysis within healthcare for functional, business leaders, and team members. Under general direction, the Advisor Cloud Engineer will be responsible for designing and/or creating, maintaining, deploying, and managing Databricks and SQL applications for internal business teams and our customers. Candidates will work collaboratively with IT staff, and business stakeholders to create, maintain, and support ETL packages in a compliant, regulated environment. Escalate concerns to project management or Team Lead, assist in determining best practices and provide suggestions on how to improve current practices. Required Skills and Experience: • Participate in JAD (Joint Application Design), RAD (Rapid Application Development) and DSD (Design Specifications Document) sessions to define and understand the business requirements and present detailed systems design documentation for reports, data interface files, data conversion and any other method of data exchange. • Develop, test, manage and implement Databricks/SQL Packages from development server to production server using package configuration. • Work on maintenance and Administration of Databricks by creating Jobs, Alerts, SQL Mail Agent, and schedules. • Develop with Python, Spark, or similar tools • Design and guide other developers on complicated interfaces and should have strong debugging skills. • Automate the execution of Databricks packages using SQL Server Agent Jobs. • Proactively engage on continuous improvement efforts. • Diagnose and resolve incident tickets and errors. • Develop ETL specifications, data mapping and other documentation required for ETL development. • Use SQL, data models, data element dictionary and schema to perform data and business analysis. • Understand business data and perform quality assurance testing to ensure the data presented is correct. • Establish and maintain positive and effective work relationships with coworkers, clients, members, providers and customers. • Support Unit Testing, System Integration Testing, End-to-End System Testing, and User Acceptance Testing. Required Skills/Experience: 1. Analytical and data analysis skills using Microsoft SQL. 1. Excellent team, verbal and written communication skills 1. Experienced SQL Server/MS-SQL scripting and Databricks expertise. 1. Experience with Data mining, Data Science, and Predictive analytics is a plus. 1. Ability to build complex queries and reports using Microsoft SQL. Desired Skills/Experience • Experience in Healthcare IT working with claims, member and provider data strongly desired. • Experience working with AWS cloud services: EC2, S3, RDS, Redshift and Glacier/Archival • Experience creating Logical and Physical data models and documentation. • Experience with visualization tools like Power BI, Tableau. US Citizens and those authorized to work in the US are encouraged to apply. We are unable to sponsor at this time. Dedicated Tech Services, Inc. is an Equal Opportunity Employer