Senior Data Engineer

Akumin operates in an environment undergoing immense and rapid change. One of the keys to our success is being able to leverage enterprise data foundations to enable business insights and advanced analytics. The Enterprise Data team is tasked with the responsibility of developing quality data collection processes, maintaining the integrity of our data foundations and enabling business leaders and data scientists across the company to have rapid access to the data they need for decision-making and innovation. 

The Sr. Data Engineer role will be responsible for the infrastructure and operations of the company’s data storage solutions, third-party integrations data provisioning services and overall ETL/ELT code-based solutions and tooling that process data.

Specific duties include, but are not limited to:

• Excellent communication skills (English) to accurately interpret and collaborate with data scientists, clinical data managers, business analysts, and IT teams. Strong willingness to learn, collaborate, communicate, document, and grow data product focused development standards. Ability to document and explain data processes clearly to non-technical stakeholders.

• Google Cloud Platform (GCP) data migration and Big Query. Use of Google Cloud Migration, Data Transfer, Server Migration Services and other migration tools native to GCP. Proficient Programming in C#, SSIS, API’s, Console and Web applications, Python and SQL. Capable of designing and implementing robust ETL/ELT pipelines using custom-tooling (Python/Google, SSIS) and off-the shelf tooling with focus on monitoring, supportability, and resource stewardship. Develop and maintain SSIS packages, RESTful API’s and other tools related to data integrations between business systems and data warehouse. Development of complex SQL queries for data extraction, manipulation, and reporting and transformation technologies. Applies general SDLC best practices, develops (CI/CD) and version control. Performs and restore SQL databases. Performs SQL server troubleshooting and diagnoses. Troubleshoots SQL Agent job nightly processing issues.

• Familiarity with Data Orchestration (DAG), Workflow Tools. Database Design and Query Optimization for responsive web applications. Architect, implement and deploy new data models and data processes in production.

• Builds data pipelines which acquire, cleanse, transform and publish data from a wide variety of sources. Assembles large, complex data sets which meets functional and non-functional business requirements. Partners with data asset managers, architects, and development leads to ensure technical solution provides data which is fit for use and in line with architecture blueprints.

• Contribute to and leverage coding standards and best practices to ensure efficient and re-usable services and components. Identify, document, design, and implement internal process improvements.

Position Requirements:

• Bachelor’s degree required in data science, computer science or MIS, mathematics, engineering, or related field.

• 5-10 years of prior experience in Data Management / ETL / ELT / Data Warehousing.

• Experience in Google Cloud Platform (GCP) data migration and Big Query

• Experience using Google Cloud Migration, Data Transfer, Server Migration Services and other migration tools native to GCP.

• Develop and maintain console applications that call RESTful API’s, Web Services, in C# or SSIS.

• Self-driven with the ability to diagnose and problem-solve complex issues with little to no guidance.

• String development experience using SSIS, C#, PL/SQL, T-SQL

• Basic SQL Server administration

• Experience in writing Data Quality routines for cleansing of data and capturing confidence scores.

• Experience with master data management.

• Experience using scripting languages.

• Experience in Healthcare data models, datasets, and source systems (e.g. EHR, claims, DICOM images, labs, etc.).

• Experience with healthcare reference data (ICD, CPT etc.)

• Data Modeling experience preferred.

• Strong organizational, administrative, and analytical skills required.

• Knowledge of HIPAA; ability to implement systems and processes in accordance with regulations.

• Agile software development,  program management best practices, information protection, System Development Lifecycle configuration management best practices using Azure DevOps or Git.

Preferred:

• Master's degree (in data science, computer science or MIS, mathematics, engineering, or related field)

• Experience working with Clinical Data and Regulatory Governance in a Healthcare setting

• Hands-on design and configuration experience with cloud services Google (related to data storage and processing)

• Data Governance Principles and enterprise frameworks (Warehousing, Data-as-a-Product, MESH, MDM).

Physical Requirements:

Standard office environment. 

More than 50% of the time:

• Sit, stand, and walk.

• Repetitive movement of hands, arms and legs.

• See, speak and hear to be able to communicate with patients.

Less than 50% of the time:

• Stoop, kneel or crawl.

• Climb and balance.

• Carry and lift 10-20 pounds.

Residents living in CA, NY, Jersey City, NJ, WA and CO click here to view pay range  information.

Akumin Operating Corp. and its divisions are an equal opportunity employer and we believe in strength through diversity. All qualified applicants will receive consideration for employment without regard to, among other things, age, race, religion, color, national origin, sex, sexual orientation, gender identity & expression, status as a protected veteran, or disability.