- Participate in the full life cycle of data and analytic solutions, broadly from requirements through ETL / ELT, production, consumption, and ad-hoc reporting
- Develop end-to-end data warehouse / data mart solutions, utilizing Databricks and Microsoft technologies. Patterns include traditional dimensional modeling (Kimball), and schema-less (big data) models.
- Develop data modeling expertise on one or more insurance-specific data / workflows, such as claims, care management (CM), utilization management (UM), eligibility, and population health
- Partner with Data Solutions Analysts, and line-of-business stakeholders in product ideation, requirements gathering, data reviews, ongoing data quality, and troubleshooting
- Serve as a champion and mentor for junior colleagues and data consumers, through training, mentorship, architectural design, testing, and documentation
- Develop or support reports, dashboards, and ad-hoc analysis supporting business consumers
- Test, debug, and performance tune data pipelines and end-user queries
- Maintain the highest level of data security and confidentiality, conforming to all HIPAA and contract requirements
- Perform any other job duties as requested
- Bachelor's degree in computer science, engineering, mathematics, a related field, or equivalent combination of education and experience is required
- A minimum of six (6) years' data engineering-level SQL experience (including data modeling, profiling and cleansing, and building complex data sets) is required
- A minimum of four (4) years' experience building enterprise data solutions (data warehouses and data marts) is required
- A minimum of four (4) years' experience building customer facing data solutions (PowerBI, Tableau, Oracle, advanced Excel, etc.) is required
- A minimum of three (3) years' experience in healthcare data is required
- Expert SQL skills, including the ability to develop upon and maintain systems utilizing contemporary data warehousing patterns including ETL / ELT, fact and dimension modeling, and deploying analytic resources via staging tiers and consumption layers
- Skilled in working with and warehousing data from multiple sources, such as operational data stores (ODS), flat file, EDI/HL7, API, etc.
- Proficiency with the Microsoft data ecosystem (SSRS, SSIS, PowerBI)
- Advanced knowledge of Azure Databricks and SparkSQL, or similar data lake platforms (Azure Data Lake, Snowflake, Hadoop, etc.)
- Knowledge of Python, including Python-specific data modeling skill supporting data transformation and data science
- Data expertise within healthcare insurance-specific domains, such as claims (medical and pharmacy), health information exchange (HIE), utilization management (UM), demographics, and common healthcare code sets and processes (patient registry, billing, diagnosis, procedure codes)
- Proficient with the Microsoft 365 suite, including extensive use of Teams, SharePoint, and Excel
- Excellent written and verbal communication skills
- Relevant Microsoft certifications (SQL, PowerBI, Azure) is preferred
- Databricks certification and/or badging is preferred
- General office environment; may be required to sit or stand for extended periods of time
- Create an Inclusive Environment
- Cultivate Partnerships
- Develop Self and Others
- Drive Execution
- Influence Others
- Pursue Personal Excellence
- Understand the Business
-
Electrical Engineer III
16 hours ago
Alliance Automation Van Wert, United StatesJob Description · Job DescriptionSalary: $85,000 - $94,000 based on experience · POSITION OVERVIEW: The Electrical Engineer turns projects into realities using experience in electrical power systems, pneumatic power systems, hydraulic power systems, and industrial controls design ...
-
Quality Engineer III
1 week ago
Alliance Automation Van Wert, United StatesJob Description · Job DescriptionSalary: · POSITION OVERVIEW · Works closely with cross-functional teams including Applications, Engineering, Project Management, and Manufacturing to identify and mitigate quality risks. Audits production processes, raw materials, and suppliers/v ...
-
Quality Engineer III
1 day ago
The Ladders Van Wert, United StatesPOSITION OVERVIEW · Works closely with cross-functional teams including Applications, Engineering, Project Management, and Manufacturing to identify and mitigate quality risks. Audits production processes, raw materials, and suppliers/vendors to ensure that established quality s ...
-
Controls Engineer III
16 hours ago
Alliance Automation Van Wert, United StatesJob Description · Job DescriptionSalary: · Position Overview: Controls Engineers work in both an office environment when engineering control systems and on the shop floor in Van Wert Ohio for commissioning and debugging of equipment. The Controls Engineers work closely with the ...
-
Systems Engineer III
1 week ago
Adex Corporation New Haven, United StatesPay Rate: $78 to $83 per hour. · The System Architect III is part of a diverse team within the Enterprise Technology Operations Org. You will work on the design, planning, implementation, and support of our OnPrem and Cloud based compute infrastructure and application ecosystem. ...
-
Project Engineer
1 week ago
LanceSoft West Harrison, United StatesDetailed Job description: · Title: Project Engineer · Location: Hybrid/Remote work in White Plane NY (exact address and hybrid/remote option TBD) · Duration: Temp-direct (Eligible for conversion after 520 hours worked on W2) for the right fit · PROJECT ENGINEER · Project Engine ...
-
Facilities Manager
1 week ago
The Nightingale-Bamford School East White Plains, United StatesJob Description · Job DescriptionFacilities Manager · The Facilities Manager at Nightingale-Bamford School will support building management initiatives and strategic maintenance goals. · Reporting to the Director of Building Operations and Capital Management, this role will ensur ...
-
Water/Wastewater Resident Engineer
4 weeks ago
STV West Harrison, United StatesSTV is a nationally recognized leader for delivering value and excellence in construction management, engineering, architecture, planning and environmental services, and is seeking a Water/Wastewater Assistant Resident Engineer in Maspeth, Queens, New York. The project has two ph ...
-
Operator III 1st Shift
2 weeks ago
Danfoss Van Wert, United StatesJob Description · Danfoss is currently hiring Operator III - 1st Shift in our Van Wert, OH location. Operator II will safely and efficiently perform manual labor during the production process of Danfoss products. Operate and troubleshoot production machinery. Perform minor repair ...
Data Solutions Engineer III - Ohio City, United States - CareSource
![Default job background](https://contents.bebee.com/public/img/bg-user-ex-1.jpg)
Description
This is Data Engineering with Purpose Bring your strong ETL and architecture skills to our state-of-the-art Databricks platform and join us as we change lives- together This role focuses upon financial subjects within the health insurance industry: Claims, membership, eligibility, and financial accounting. You will be hands-on in transforming and delivering datasets that impact the lives of millions of members within a dynamic, growing organization
Job Summary:
The Data Solutions Engineer III is responsible for bringing advanced knowledge of Data Warehousing (including ETL, development, testing, ad-hoc reporting, and business analysis) to the Finance function, and is regarded as subject-matter expert and mentor for one or more data domains.
Essential Functions:
$90, $158,400.00
CareSource takes into consideration a combination of a candidate's education, training, and experience as well as the position's scope and complexity, the discretion and latitude required for the role, and other external and internal data when establishing a salary level. We are highly invested in every employee's total well-being and offer a substantial and comprehensive total rewards package.
Compensation Type (hourly/salary):
Salary
Organization Level Competencies