Current open positions
Data Architect
CaseWorthy, Inc. is the market leader in whole-person care software with the flagship CaseWorthy case management solution as well as offerings from its newest acquisitions, Accessible Solutions, Inc. and MediSked, LLC. We offer a suite of technology solutions, each that support and connect all data and systems into a single, configurable platform, so our partners can easily get to the information they need, when they need it.
CaseWorthy is on a mission to improve the lives of the individuals and communities we all care about. We believe that each of us has the responsibility to use our time and talents to support those around us and make the world a better place for all. We do this by providing innovative, whole-person care software and partnering with like-mind organizations to support people on the journeys they choose for themselves.
Job Summary
The Data Architect is responsible for the design, development, operation, and administration of data management solutions as required to deliver CaseWorthy’s suite of human services Software-as-a-Service solutions. The incumbent in this role has deep expertise with Microsoft SQL Server and is comfortable working with next generation data technologies, including open-source database management platforms, database as a service solutions, NoSQL, and data pipelining and warehousing tools.
Responsibilities
- Serves as a subject-matter-expert in data management, processing, and storage technologies, database development, implementation, integration, and administration.
- Monitors performance, reliability, security, availability, and recoverability of the databases to ensure that CaseWorthy SaaS services are delivered in accordance with contractual requirements and SLAs.
- Performs advanced database administration functions, including but not limited to configuration of Resource Governor and AlwaysOn.
- Proactively tunes the databases to ensure proper operation of all applications.
- Implements and maintains automated system for deployment of database changes according to customer commitments and release cycle processes and timelines and change management procedures.
- Maintains knowledge of CaseWorthy products as required to perform the role of Data Architect.
- Works with CaseWorthy Engineering teams to design, implement, and operate data management solutions, database structures, and queries so that CaseWorthy solutions have best-in-breed performance. Troubleshoots database performance issues in support of this objective.
- Optimizes spend associated with data management, processing, and storage solutions.
- Performs research, provides education, and input related to overall technical architecture and data processing and warehousing technology stack.
- Determines, documents, and enforces database management policies, procedures, and standards.
- Performs other duties as requested.
- Occasional travel, up to 10% travel.
- 5 years or more of related experience as a Microsoft SQL Server database administrator.
- Experience with Big Data Platforms, Data Warehousing, Data Lake, and Data Mart concepts.
- A strong understanding and experience using T-SQL and PowerShell to automate tasks.
- Ability to perform incident response analysis and root cause analysis.
- Proficiency in Database as a Service solutions in Amazon Web Services, Azure or other cloud platform.
- Expertise in database backup and restore, replication, mirroring, and AlwaysOn features.
- Expertise in database migration, ETL, and reporting solutions including SSRS, SSIS and SSAS.
- Expertise in building and managing SQL jobs, monitoring, and alerts.
- Expertise in SQL security roles and access management, encryption, and SQL hardening.
- Expertise in managing large volumes of data and performance tuning.
- Production support experience with excellent troubleshooting and problem-solving abilities.
- Self-starter that demonstrates initiative and ability to work independently with minimal direction and proven project leadership abilities.
- Possesses strong verbal and written communication skills and effectively relays information to the organization.
- Strong attention to detail and excellent organizational skills.
Senior Integration Engineer II
Job Type
Full-time
Description
CaseWorthy, Inc. is the market leader in whole-person care software with the flagship CaseWorthy case management solution as well as offerings from its newest acquisitions, Accessible Solutions, Inc. and MediSked, LLC. We offer a suite of technology solutions, each that support and connect all data and systems into a single, configurable platform, so our partners can easily get to the information they need, when they need it.
CaseWorthy is on a mission to improve the lives of the individuals and communities we all care about. We believe that each of us has the responsibility to use our time and talents to support those around us and make the world a better place for all. We do this by providing innovative, whole-person care software and partnering with like-mind organizations to support people on the journeys they choose for themselves.
Job Summary
The Sr. Integration Engineer / Data Engineer is a technical and passionate individual who enjoys defining, building, validating, and operating back-end mission-critical ETL processes (data pipelines, interfaces, and data lake transmissions) among CaseWorthy’s internal systems and various external trading partners.
Responsibilities
- Design, build, and maintain data pipelines, infrastructure, and ETL processes based on best practices.
- Produce solution design recommendations and delivery plans based on client-facing consultative engagements, understanding business requirements to create meaningful technical specifications.
- Consult with trading partners on behalf of CaseWorthy customers to define data exchange specifications, interface delivery timelines and interface operations standard-operating procedures.
- Understand integration and downstream reporting requirements to model data flows and design ETL procedures that ensure data quality and integrity.
- Design and develop reliable data pipelines between multiple systems with various CaseWorthy products.
- Create, monitor, operate and maintain interfaces and data pipelines using ETL tools, JavaScript, Microsoft T-SQL, Python, and other technologies.
- Manage projects and work items to ensure that requests and issues are closed in a timely manner, commensurate with customer commitments, and priority-level-based service-level agreements (SLAs).
- Design, develop and manage out-of-the-box interfaces/code libraries in NextGen Mirth Connect, AWS Glue and SQL and customize for client implementations as needed.
- Maintain best-in-class availability, reliability, and data integrity for CaseWorthy interface solutions.
- Create and maintain specification documentation for all interfaces created or modified.
- Perform other duties as assigned.
- Occasional travel, up to 10%.
Requirements
Job Skills & Qualifications
- Minimum of 5 years of experience with:
- ETL tools such as SQL Server Integration Services, NextGen Mirth Connect
- JavaScript, Python, and Microsoft T-SQL
- XML and JSON
- HL7 2.x, CCD/CCDA, FHIR, and HIPAA ANSI X12 messaging standards (preferred)
- Web services, REST APIs
- AWS Cloud Services (Glue, Lambda, Step-Functions, SQS, CloudWatch, CloudFormation)
- A passion for deeply understanding specifications, clearly and effectively collaborating with stakeholders around data specifications, and demonstrating flexibility when adjustments are needed.
- Great teamwork and communication skills.
- Great documentation, design, and problem-solving skills.
- Strong written and verbal communication skills with both technical and non-technical audiences.
- Ability to succeed in a fast-paced, high-intensity environment.
- Experience with version control systems such as Git, SVN, etc.
- Self-starter and able to multitask with minimal supervision.
Salary Description
Salary Range – $75,000-$115,000
See All Positions & Apply Now
Join Our Team
CaseWorthy is committed to creating and maintaining a business culture with a foundation of trust, integrity, passion, accountability and a strong work ethic. Joining our team means becoming part of a community that supports not only our nonprofit clients, but also each other. We work collaboratively and intentionally to provide valuable data and software solutions to the community-aiding organizations with whom we partner. To work with us in this field is to have a career with purpose and to know that your job truly makes a difference.
Our Values
Excellence:
We strive for excellence. We take pride in our work. We go above and beyond the call of duty.
Collaboration:
We’re stronger together, our team has a cooperative spirit and mutual respect. Good ideas come from anywhere, so the more voices the better.
Service:
Our clients are at the heart of everything we do. We strive to provide a service that’s anything but basic.
Compassion:
It’s compassion and kindness that wins over our clients at the end of the day, and that effort of understanding and accepting others is one of our biggest strengths.
Empower:
We have the resources and freedom needed to complete our projects. We work to enrich the lives of everyone we serve.
We are pleased to offer a wide variety of competitive benefits to our employees.
- Medical, Dental, Vision, Life, 401K, Short / Long Term Disability, Accident, Critical Illness, Hospitalization
- Paid Holidays
- Unlimited PTO
- Sick Time
- Parental Leave
Do you want to make a difference in a challenging and highly rewarding job? Apply today!