Business Intelligence Engineer

Azenta

Plainfield (IN)

On-site

USD 85,000 - 110,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Azenta Inc. seeks a Business Intelligence Engineer to design, build, and maintain enterprise data platforms on AWS and Snowflake. You will design ETL pipelines, curate datasets for reporting and analytics, and ensure data quality and governance across scalable pipelines.

You will collaborate with analytics teams to deliver dashboards and self-service BI solutions, supporting AI initiatives and advanced analytics with robust data models.

Qualifications

  • Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or related field.
  • 4+ years of experience in Business Intelligence, Data Engineering, Analytics Engineering, or related disciplines.
  • Strong experience with ETL development and data integration.
  • Hands-on experience with Snowflake.
  • Hands-on experience with PostgreSQL, including query optimization, schema design, indexing strategies, and performance tuning.
  • Strong SQL development, data modeling, and PostgreSQL database development expertise.
  • Experience working within AWS cloud environments.
  • Experience developing and managing enterprise reporting datasets.
  • Knowledge of dimensional modeling, data warehousing, and analytics best practices.
  • Experience with Python or other scripting languages for data processing.

Responsibilities

  • Design, develop, and maintain ETL pipelines that integrate data from enterprise applications, operational systems, APIs, and third-party platforms
  • Build analytic-ready datasets for reporting and dashboards
  • Design and manage Snowflake databases, schemas, tables, views, and data models
  • Develop and optimize AWS-based analytics solutions using S3, SageMaker, Glue, Athena, and Lambda
  • Support dashboard and visualization development using BI tools
  • Enable self-service analytics through governed data models and semantic layers
  • Collaborate with Data Science/AI teams to prepare data for ML models
  • Ensure data governance and quality across pipelines and datasets

Skills

SQL development
Data modeling
Python
ETL development
Cloud data architectures

Education

Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or related field

Tools

Snowflake
PostgreSQL
AWS
Power BI
Tableau
SageMaker
AWS Glue
Athena
Lambda

Job description

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 tuning
AWS Data Lake & Cloud Analytics:
  • Develop and support AWS-based analytics solutions utilizing: Amazon S3
  • Amazon SageMaker
  • AWS Glue
  • Amazon Athena
  • AWS 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 layers
AI & 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 SageMaker 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 field
  • 4+ years of experience in Business Intelligence, Data Engineering, Analytics Engineering, or related disciplines
  • Strong experience with ETL development and data integration.
  • Hands-on experience with Snowflake
  • Hands-on experience with PostgreSQL, including query optimization, schema design, indexing strategies, and performance tuning
  • Strong SQL development, data modeling, and PostgreSQL database development expertise
  • Experience working within AWS cloud environments
  • Experience developing and managing enterprise reporting datasets
  • Knowledge of dimensional modeling, data warehousing, and analytics best practices
  • Experience with Python or other scripting languages for data processing
Preferred Qualifications:
  • Experience with Amazon SageMaker and machine learning data preparation
  • Experience with AWS Glue, Athena, Lambda, and S3-based data lake architectures
  • Experience with Power BI, Tableau, or similar analytics platforms
  • Familiarity with Apache Iceberg, Parquet, or modern data lake table formats
  • AWS and/or Snowflake certifications
  • Experience supporting AI, predictive analytics, or enterprise data strategy initiatives
  • Experience with PostgreSQL advanced features such as partitioning, materialized views, JSON/JSONB, extensions, and analytical que
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer
Data Engineer

Compunnel Inc. • Pennsylvania

Hybrid
USD 85,000 - 125,000
Sr Data Engineer
Sr Data Engineer

Cox Automotive • Atlanta (GA)

On-site
USD 140,000 - 190,000
Data Engineer: Scalable ETL & Analytics Pipelines
Data Engineer: Scalable ETL & Analytics Pipelines

Compunnel Inc. • Pennsylvania

Hybrid
USD 85,000 - 125,000
Data Engineer
Data Engineer

Venteon • United States

On-site
USD 100,000 - 130,000
Cloud BI Engineer — Snowflake & AWS Data Platform
Cloud BI Engineer — Snowflake & AWS Data Platform

Azenta Inc. • Plainfield (IN)

Hybrid
USD 101,000 - 126,000
Hybrid work schedule
BI Engineer: Cloud Data Platforms & AI
BI Engineer: Cloud Data Platforms & AI

Azenta • Plainfield (IN)

On-site
USD 85,000 - 110,000
Senior Data Analyst – Enterprise Data & Analytics
Senior Data Analyst – Enterprise Data & Analytics

ASB Resources • New York (NY)

On-site
USD 110,000 - 150,000
Business Intelligence Engineer
Business Intelligence Engineer

Azenta Inc. • Plainfield (IN)

Hybrid
USD 101,000 - 126,000
Hybrid work schedule
Senior Data Engineer
Senior Data Engineer

RBA, Inc. • United States

On-site
USD 120,000 - 190,000
Business Intelligence Analyst & Data Engineer- Remote
Business Intelligence Analyst & Data Engineer- Remote

DeepSource Technologies • United States

Hybrid
USD 90,000 - 130,000