Cloud BI Engineer: Snowflake, AWS & AI Analytics

azenta; Plainfield (IN); On-site; USD 90,000 - 150,000; Full time

Job summary

Azenta Inc. is seeking a Business Intelligence Engineer to design, develop, and maintain enterprise data and analytics solutions.

You will build cloud-based data platforms, ETL pipelines, and curated datasets to support reporting, dashboards, and AI initiatives using Snowflake, PostgreSQL, and AWS. You will partner with stakeholders to translate business needs into scalable data models, ensure data quality and governance, and optimize data pipelines for performance and reliability in a

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 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
• 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
• Optimize Snowflake performance through clustering, partitioning, and query tuning
• Develop AWS-based analytics solutions utilizing Amazon S3, SageMaker, Glue, Athena, Lambda, Aurora PostgreSQL
• Design, maintain S3 data lake structures and table architectures
• Support data ingestion and transformation from multiple sources
• Design, develop, and optimize PostgreSQL database objects (schemas, tables, views, materialized views, stored procedures)
• Collaborate with stakeholders to understand reporting requirements
• Create and maintain reusable datasets, KPIs, metrics, and reporting structures
• Support dashboards and visualization development leveraging BI tools
• Enable self-service analytics through governed data models and semantic layers
• Collaborate with Data Science and AI teams to prepare datasets for ML models
• Develop scalable data assets for predictive analytics and operational intelligence
• Establish and maintain data quality standards and controls
• Document data lineage, mappings, and transformation logic
• Ensure compliance with data governance, security, and regulatory requirements
• Participate in master data and metadata management

Skills

ETL development

Snowflake

PostgreSQL

SQL development

AWS

Data modeling

Python

Data integration

Analytics

Dimensional modeling

Education

Bachelor's degree

Tools

Snowflake

PostgreSQL

AWS

Power BI

Tableau

Job description

Azenta Inc. is seeking a Business Intelligence Engineer to design, develop, and maintain enterprise data and analytics solutions.

You will build cloud-based data platforms, ETL pipelines, and curated datasets to support reporting, dashboards, and AI initiatives using Snowflake, PostgreSQL, and AWS. You will partner with stakeholders to translate business needs into scalable data models, ensure data quality and governance, and optimize data pipelines for performance and reliability in a