Data Engineer
Description
Tower Point, 6th Floor, 27-43 Wormwood Street, Boston, MA 02210, United States of America, Boston 02210, US
Company description
We believe in the power of ingenuity to build a positive human future.
As strategies, technologies, and innovation collide, we create opportunity from complexity.
Our diverse teams of experts combine innovative thinking and breakthrough technologies to progress further, faster. Our clients adapt and transform, and together we achieve enduring results.
We are over 4,000 strategists, innovators, designers, consultants, digital experts, scientists, engineers, and technologists. And we have deep expertise in consumer and manufacturing, defence and security, energy and utilities, financial services, government and public services, health and life sciences, and transport.
Our teams operate globally from offices across the UK, Ireland, US, Nordics, and Netherlands.
PA. Bringing Ingenuity to Life
We’re an innovation and transformation consultancy that believes in the power of ingenuity to build a positive-human future in a technology-driven world. Our diverse teams of experts combine innovative thinking with breakthrough-technologies to progress further, faster.
Are you ready to harness the power of data to drive advancements in healthcare? Are you passionate about deg, building, and maintaining data infrastructure that plays a pivotal role in improving patient outcomes and shaping the future of medicine? If you're seeking a rewarding career at the intersection of healthcare and technology, we invite you to be part of our dynamic team. This is a unique, multi-year, project-based opportunity to build and grow a clinical data registry platform over many years working with a dedicated team of collaborators and customers. As a Data Engineer for our cutting-edge medical data registry, you'll be at the forefront of managing, optimizing, and expanding our data infrastructure, enabling critical insights that can positively impact patient outcomes. If you're excited about leveraging your data engineering skills to make a difference in the world of healthcare, we want to hear from you.
Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take over sponsorship of an employment visa at this time
Minimum qualifications:
5-7 years of industry working experience
Advanced SQL and Python
Expertise in the design and construction of Big Data Lakes and Data Warehouses capable of ingesting, standardizing, and serving billions of data rows spanning diverse datasets ranging from tens to hundreds
Experience building dynamic, metadata driven pipelines and analyses
Building and managing fully automated data pipelines (ETL, ELT, ELTL) including: Deg and building data interfaces to source systems Combining and transforming data into the appropriate format for storage Developing data sets for analytics purposes Developing pipelines that can handle common issues/errors in a robust and automated way
Deg and building data interfaces to source systems
Combining and transforming data into the appropriate format for storage
Developing data sets for analytics purposes
Developing pipelines that can handle common issues/errors in a robust and automated way
Cloud experience in Azure, AWS or GCP
Preferred qualifications:
Spark / PySpark experience highly preferable
Working in Agile and DevOps environments
Basic Python, Bash, or PowerShell for automation
Data modelling
- Kimball, Data Vault, Star/Snowflake schema, Query-first etc.
Data visualisation in Power BI, Tableau, Qlik or similar
Architecting Data Platforms - deg BI/MI/Analytics solutions using Big Data, Relational or Streaming technologies
One or more of the following certifications: Microsoft Certified: Azure Data Engineer Associate AWS Certified Data Analytics - Specialty GCP Professional Data Engineers
Microsoft Certified: Azure Data Engineer Associate
AWS Certified Data Analytics - Specialty
GCP Professional Data Engineers
Additional information
The salary range for this role is between $118,000 - $125,000k
Life At PA encompasses our peoples' experience at PA. It's about how we enrich peoples’ working lives by giving them access to unique people and growth opportunities and purpose led meaningful work.
We are currently operating a discretionary hybrid working model which is designed to help you plan your work and your life. We want our people to come into the office at least two days a week.
We believe diversity fuels ingenuity. Diversity of thought brings exciting perspectives; diversity of experience brings a wealth of knowledge, and diversity of skills brings the tools we need. When we bring people together with diverse backgrounds, identities, and minds, embracing that difference through an inclusive culture where our people thrive; we unleash the power of diversity
- bringing ingenuity to life. We are dedicated to supporting the physical, emotional, social and financial well-being of our people.
Group medical insurance
Group medical insurance
Health Savings Account with company match
Health Savings Account with company match
Teladoc and informed Nurse line resources
Teladoc and informed Nurse line resources
Long term care plan
Long term care plan
Group dental insurance
Group dental insurance
401(k) Savings Plan with company profit sharing contribution
Commuter and Parking tax-savings benefit
Commuter and Parking tax-savings benefit
15 days paid vacation days with the opportunity to buy five additional days
10 paid Holidays plus 10 paid sick days
10 paid Holidays plus 10 paid sick days
Company and Voluntary income protection benefits
Company and Voluntary income protection benefits
Gym and health incentive reimbursement
Gym and health incentive reimbursement
Pet and legal insurance Plans
Pet and legal insurance Plans
Employee Assistance Plan
Employee Assistance Plan
Annual performance-based bonus
Annual performance-based bonus