Business Intelligence Engineer

Azenta Inc.

At Azenta, new ideas, new technologies and new ways of thinking are driving our future. Our customer focused culture encourages employees to embrace innovation and challenge the status quo with novel thinking and collaborative work relationships.

All we accomplish is grounded in our core values of Customer Focus, Achievement, Accountability, Teamwork, Employee Value and Integrity Job Title Business Intelligence Engineer

Job Description How You’ll Add Value:

The Business Intelligence (BI) Engineer is responsible for designing, developing, and maintaining enterprise data and analytics solutions that enable data-driven decision-making across the organization. This role will build and optimize cloud-based data platforms, design scalable ETL (Extract, Transform, Load) pipelines, and develop curated datasets that support reporting, dashboards, advanced analytics, and Artificial Intelligence initiatives.

Working within AWS, Snowflake and PostgreSQL-based data environments, the BI Engineer will transform complex business and operational data into trusted, actionable insights while ensuring data quality, governance, and scalability.

What You’ll Do:

Data Engineering and ETL Development:

Design, develop, and maintain ETL pipelines that integrate data from enterprise applications, operational systems, APIs, and third-party platforms

Build automated processes to extract, load, and transform structured and unstructured data into analytics-ready datasets

Implement data validation, cleansing, enrichment, and monitoring processes

Optimize data pipelines for performance, scalability, and reliability

Snowflake Data Platform:

Design and manage Snowflake databases, schemas, tables, views, and data models

Develop and maintain dimensional, operational, and semantic data models to support analytics and reporting. Create structured and governed datasets that enable self-service business intelligence

Optimize Snowflake performance through effective clustering, partitioning, and query tuningAWS Data Lake & Cloud Analytics:

Develop and support AWS-based analytics solutions utilizing:

Amazon S3

Amazon SageMakerAWS Glue Amazon AthenaAWS Lambda Amazon Aurora PostgreSQL Design and maintain S3 data lake structures and table architectures that support enterprise reporting and analytics

Support data ingestion and transformation processes from multiple internal and external data sources

Design, develop, and optimize PostgreSQL database objects including schemas, tables, views, materialized views, stored procedures, and data transformation logic to support analytics and reporting workloads

Reporting & Business Intelligence:

Partner with business stakeholders to understand reporting and analytics requirements

Create and maintain reusable datasets, KPIs, metrics, and reporting structures

Support dashboard and visualization development utilizing BI and reporting tools

Enable self-service analytics through governed data models and semantic layersAI & Advanced Analytics Enablement:

Collaborate with Data Science and AI teams to prepare and curate datasets for machine learning models

Support data engineering activities required for Amazon Sage Maker and AI initiatives

Develop scalable data assets that support predictive analytics and operational intelligence

Data Governance & Quality:

Establish and maintain data quality standards and controls

Document data lineage, mappings, business rules, and transformation logic

Ensure compliance with data governance, security, and regulatory requirements

Participate in master data and metadata management initiatives

What You Will Bring:

Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or related field4+ years of experience in Business Intelligence, Data Engineering,…