Data Engineer
CommonSail Investment Group
Location: Brighton, Michigan
Overview: As a Data Engineer, you will design, build, and maintain the data infrastructure within CommonSail Investment Group. You will work at the intersection of senior housing data, healthcare operations data and modern data engineering — building robust pipelines, maintaining our Snowflake cloud data lake, developing APIs, and partnering with IT and data professionals to ensure the right data reaches the right people at the right time. This role is pivotal in ensuring that CommonSail’s data assets are accurate, secure, accessible, and leveraged effectively to support strategic business initiatives and operational excellence.
Qualifications:
Bachelor’s degree in Information Systems, Computer Science, Data Science, or a related field.3 - 7 years of experience in data engineering, data infrastructure, API development, data integration, and data governance.Strong command of SQL and Python for data transformation, automation, and pipeline developmentDemonstrated hands-on experience with Snowflake, including performance tuning, clustering, and access control.Proficiency with dbt (data build tool) for transformation layer development, testing, and documentation.Experience building and consuming RESTful APIs, with working knowledge of authentication patterns (OAuth 2.0, API keys). Knowledge of data privacy, compliance, and security standards (e.g., HIPAA, GDPR).Strong communication, problem-solving, and analytical skills.Experience in healthcare, long-term care, or related regulated industries — familiarity with PointClickCare, MatrixCare, or similar EHR/EHR-adjacent systems is a strong plus.Primary Responsibilities:
Data Pipelines: Design, build, and maintain scalable data pipelines for ingestion, transformation, and delivery of healthcare operations data from multiple client systems and third-party sources.Data Architecture & Administration: Architect and administer the organization's Snowflake data warehouse, including database design, role-based access control, query optimization, and cost governance.DBT: Develop and maintain dbt models for data transformation, testing, documentation, and lineage across all data domains (census, financials, clinical, acquisition targets).API Development: Build and maintain RESTful APIs and integration services that connect source systems, internal tools, and analytical platforms.Data Lake Administration: Design and implement data lake strategies for raw data storage, archival, and cost-efficient processing of high-volume datasets.Data Modeling: Create and enforce data modeling standards — dimensional modeling, star/snowflake schemas, and normalized models — across the enterprise data warehouse.Stakeholder Collaboration: Partner with business leaders and technical teams to align data strategy with organizational goals, translating requirements into scalable solutions.Performance Monitoring: Monitor pipeline health, establish alerting and data quality checks, and resolve incidents with urgency and rigor.Data Support: Support business operation engagements with data room analysis, source system evaluation, and integration planning for EHR entities.Data Engineering Practices: Champion data governance, documentation, and best practices across the data engineering function.Skills:
Cloud Data Warehousing (Snowflake): Design, administer, and optimize cloud-based data warehouses, including schema design, performance tuning, cost governance, security, and role-based access control.Data Transformation & Modeling: Develop scalable transformation layers using dbt and SQL, implementing dimensional and normalized models to support analytics and downstream consumption.Programming & Analytics: Use Python and SQL for data transformation, automation, pipeline logic, and analytical problem-solving across batch and event-driven workloads.Data Pipelines & Orchestration (ETL / ELT, Airflow or Similar): Build, schedule, and monitor ETL/ELT pipelines with orchestration tools to ensure timely, accurate, and resilient data processing.Data Ingestion & Integration (Fivetran, Airbyte, APIs): Ingest data from SaaS platforms, databases, and systems using managed connectors and custom integrations, ensuring scalability and data reliability.API Development & Data Services (REST APIs, JSON): Design and consume RESTful APIs to exchange data between systems, using standard formats such as JSON and secure authentication patterns.Cloud Platforms & Supporting Technologies (AWS, Azure, GCP): Leverage major cloud platforms and supporting services for storage, compute, networking, and security to build flexible and scalable data solutions.Data Storage Formats & Lakes (Data Lakes, Parquet, Avro): Implement data lake architectures using efficient, columnar storage formats to support large-scale analytics, archival, and cost-effective querying.Development Practices & Tooling (Git, VS Code, Database Administration): Apply modern development workflows using version control, IDEs, and database administration best practices to maintain high-quality, well-documented data systems.General Working Conditions: While performing the duties of this job, the employee is required to communicate effectively with others, sit, stand, walk, and use their hands to handle the keyboard, telephone, paper, files, and other equipment and objects. The employee is occasionally required to reach with hands and arms. This position requires the ability to review detailed documents and read computer screens. The employee will occasionally lift and/or move up to 25 pounds. The work environment requires appropriate interaction with others. The noise level in the work environment is moderate. Occasional travel to different locations may be required.
Equal Opportunity Employer
#SPIND
Read LessSafety & Risk Manager
CommonSail Investment Group
Overview:
Location: 7927 Nemco Way, Brighton, MI 48116Position: Safety & Risk ManagerJob Type: Full TimeLicensure Required: Healthcare Risk Management Certification / QualificationsBenefits:
Medical, Dental, Vision, 401kGenerous PTOCell Phone ReimbursementEmployee First CulturePosition Summary:
The Safety & Risk Manager will lead the development, implementation, and oversight of comprehensive risk management, quality assurance, and compliance initiatives. This position will proactively identify and mitigate potential risks, ensure regulatory compliance, foster resident safety, and enhance operational performance through strategic collaboration and effective leadership.
Required Experience for Safety & Risk Manager:
Education: Bachelor’s degree in Healthcare Administration, Risk Management, Nursing, or a related field. Master's degree preferred.Experience: Minimum of 3-5 years of experience in risk management, compliance, or quality assurance leadership roles, specifically within assisted living, memory care, or independent living environments.Licensure/Certification: Certification in Healthcare Risk Management (CPHRM) or equivalent preferred.Regulatory Knowledge: Comprehensive understanding of state-specific regulatory requirements governing assisted living, memory care, and independent living communities.Leadership Skills: Proven capability to lead cross-functional teams, manage complex projects, and drive cultural change toward a proactive, safety-first mindset.Accountabilities for Safety & Risk Manager:
Develop and oversee risk management programs and quality assurance initiatives tailored specifically to assisted living, memory care, and independent living environments.Conduct regular risk assessments, investigations, and audits to identify and address compliance gaps and operational risks.Collaborate closely with community leadership to proactively address and mitigate risk issues identified through resident feedback, incident reports, and compliance audits.Lead operational meetings with community leaders to discuss immediate safety and quality concerns and proactively address anticipated issues.Facilitate continuous improvement activities integrating data from resident satisfaction surveys, grievance outcomes, incident reports, and regulatory audits.Coordinate with insurance brokers and legal counsel to effectively manage litigation risks and regulatory compliance issues.Oversee annual risk assessments and ensure the ongoing refinement of policies and practices in alignment with regulatory standards and company objectives.Ensure accurate documentation practices and the secure management of electronic records across all communities.Quality Assurance & Compliance Management:
Develop, implement, and monitor comprehensive quality and compliance programs to ensure regulatory adherence and high standards of resident care.Establish and enforce internal policies, standards, and practices reflecting the latest regulatory requirements and best practices.Ensure communities are well-prepared for regulatory inspections, surveys, and audits.Risk Management & Incident Reporting:
Manage incident reporting, analysis, and resolution processes.Conduct root cause analyses and implement corrective actions to prevent recurrence of incidents and compliance issues.Staff Training & Development:
Create and deliver comprehensive training programs related to risk management, regulatory compliance, resident safety, and quality improvement.Collaborate with Human Resources and Learning & Development teams to ensure effective training and ongoing education of staff.Skills for Success:
Building solid cross-functional relationships aligned with the organization's 1440 Care Standards.Making timely and effective decisions.Managing multiple complex projects simultaneously with a strong sense of urgency.Demonstrating proficiency in analyzing data to implement effective solutions.Exceptional communication skills, capable of engaging stakeholders at all levels.Effectively resolving compliance issues and quality concerns.Flexibility, approachability, and resilience in addressing difficult situations.General Working Conditions: This position involves frequent standing, sitting, and walking. The employee will regularly communicate effectively, handle keyboards, telephones, and documentation. Occasional lifting of up to 25 pounds may be required. Occasional travel to community locations is expected. The work environment involves moderate noise levels and requires positive interaction with colleagues and residents.
Equal Opportunity Employer
Common Sail Investment Group is committed to fostering a culture of excellence, safety, and continuous improvement in all areas of resident care.
#CSALL
Read Less