Advisor Cloud Engineer (Databricks)

Job Title: Advisor Cloud Engineer (Databricks)

Hybrid (Onsite 1 or 2 days/wk)

Description:

DSI is searching for an Advisor Cloud Engineer who 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.

Responsibilities:

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.

utomate 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.

Requirements:

nalytical and data analysis skills using Microsoft SQL.

Excellent team, verbal and written communication skills

Experienced SQL Server/MS-SQL scripting and Databricks expertise.

Experience with Data mining, Data Science, and Predictive analytics is a plus.

bility to build complex queries and reports using Microsoft SQL.

Recommended Additional 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.

bility to abide by Gainwell policies.

bility to maintain attendance to support required quality and quantity of work.

Maintain confidentiality and comply with Health Insurance Portability and Accountability Act (HIPAA)

bility to establish and maintain positive and effective work relationships with coworkers, clients, and customers.

Design and guide other developers on complicated interfaces and should have strong debugging skills.

About Diversified Systems

Founded in 1990, Diversified Systems is an award-winning Technology Services corporation providing all levels of IT project consulting services nationwide. DSI is headquartered in Columbus, Ohio with regional offices in the American Midwest and East Coast. We offer our consultants a number of flexible and competitive compensation benefit packages.

Diversified Systems is committed to the principles of equal employment. We are committed to complying with all federal, state, and local laws providing equal employment opportunities, and all other employment laws and regulations.

Diversity, Equity and Inclusion

DSI values authenticity and is committed to making sure our employees and partners are valued and respected. At DSI, we believe building a diverse culture is important because we know when people work together, we can achieve better results as a team. DSI realizes that everyone comes from various backgrounds. We celebrate these differences because our employees are our greatest asset as we strive to best meet the needs of those we serve. As part of our ongoing efforts, DSI is focused on advancing equality, diversity, and inclusivity by setting high standards to continually evolve our culture. This includes but is not limited to recruiting, community involvement, client delivery, and career development.