Chartis

Data Engineer, Advanced Analytics Team

Chartis

full-time

Posted on:

Origin:  • 🇺🇸 United States • New York

Visit company website
✨ AI Apply
Manual Apply

Salary

💰 $90,000 - $125,000 per year

Job Level

Mid-LevelSenior

Tech Stack

AWSAzureBigQueryCloudETLPythonSQLTableau

About the role

  • Role Overview: The Chartis Group’s Advanced Analytics team is responsible for providing high quality data and analytic support to client engagements, internal research, and development initiatives within the firm.
  • They apply advanced data methodologies and sophisticated analytical tools and skills to derive compelling quantitative findings from client, industry, and proprietary datasets.
  • Data Engineers play an exciting role within the Analytics team at Chartis, helping to design, build, and deploy cutting-edge capabilities to aid our clients across the healthcare industry while growing the firm’s overall data and analytics acumen.
  • We’re looking for collaborative, creative problem solvers with a strong desire to materially improve the delivery of healthcare.
  • This role will help us further our data integration capabilities with Epic EHR systems, supporting our ability to more rapidly deliver analytically driven insights to healthcare organizations.
  • Responsibilities: Play a pivotal role in scaling up data processing and analytics infrastructure, ensuring efficient and secure data ingestion and processing using Snowflake SQL, Python, and dbt. Using SQL, create data extracts scripts from Epic EHR systems for use across client projects and teams. Design, build, and maintain data pipelines and ETL/ELT processes within our secure data processing platform to support derivative analytics (from requirements gathering to data transformation, data modeling, metric definition, reporting, etc.) Lead the translation, integration, and evolution of analytics artifacts deployed on client engagements into standardized and scalable components of the Chartis analytics infrastructure. Develop compelling proofs of concept for data solutions using emerging technologies for big data ingestion and processing. Identify opportunities to optimize existing data workflows, improving performance, reliability, and scalability. Assist in the setup, configuration, and ongoing maintenance of analytics infrastructure, including data warehouses, pipelines, and visualization environments. Support the continued development of data and analytics culture across Chartis through knowledge share, cross-functional training, and mentorship.

Requirements

  • 3 to 5 years of applicable experience in Data Engineering, Data Science, or Analytics.
  • Bachelor’s degree in technology-related field of study (e.g. Computer Science, Health Informatics, MIS, Data Science, Analytics, etc.)
  • Current or previous experience in Cogito with a focus on Resolute Hospital Billing, Resolute Professional Billing, and/or the Patient Access models (Cadence, Prelude, Grand Central).
  • Certification with experience directly supporting any Epic Cogito or Clarity data models is preferred.
  • Familiarity with common healthcare data formats (835s, 837s, etc.) and/or experience working in the healthcare revenue cycle industry, preferred
  • Strong programming experience developing and delivering analytics with languages and tools such as SQL, Python, Snowpark, dbt, Jupyter Notebooks, R, and Git.
  • Experience with emerging big data processing technologies such as Snowflake, Databricks, or BigQuery, and platforms including Microsoft Azure and Amazon AWS.
  • Proven ability to develop and manage scalable data ingestion pipelines for real-time and batch processing.
  • Exposure to frontend/visualization analytical tools, including Tableau and Power BI, to design and support data-driven dashboards and reports.
  • Hands-on experience with cloud-based environments, especially in Microsoft Azure, for managing and optimizing analytic workloads.
  • Complex problem-solving and critical thinking skills – the ability to identify, critically assess, evaluate options, and implement solutions in a fast-paced and dynamic environment.
  • Excellent verbal and written communication skills and a capacity for translating product and business needs into technical specifications
  • Top-notch analytical and problem-solving skills, deep curiosity, and a desire to learn more
  • While there are no location requirements, geographic proximity to either our Chicago, New York, or Boston offices is preferred.