Business Intelligence Engineer

Azenta; Plainfield (IN); Hybrid; USD 101,000 - 126,000; Full time

Benefits offered by this job

Hybrid work model

Equal Opportunity Employer

Job summary

Azenta Inc. seeks a Business Intelligence Engineer to design, build, and maintain enterprise data platforms and analytics solutions across AWS, Snowflake, and PostgreSQL environments.

You will develop and optimize ETL pipelines, curate datasets for reporting and AI initiatives, ensure data quality and governance, and partner with stakeholders to enable data-driven decisions with scalable, governed analytics assets.

Qualifications

• Bachelor's degree in a related field.
• 4+ years of experience in BI, data engineering, or analytics engineering.
• Strong ETL development and data integration experience.
• 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 data into analytics-ready datasets.
• 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.
• Design, develop, and optimize PostgreSQL database objects to support analytics workloads.
• Collaborate with data science/AI teams to prepare datasets for models.

Skills

ETL development

SQL development

Data modeling

Python

Education

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

Tools

Snowflake

PostgreSQL

AWS

Power BI/Tableau

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 IntegrityJob TitleBusiness Intelligence EngineerJob DescriptionHow 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 platformsBuild automated processes to extract, load, and transform structured and unstructured data into analytics-ready datasetsImplement data validation, cleansing, enrichment, and monitoring processesOptimize data pipelines for performance, scalability, and reliabilitySnowflake Data Platform:Design and manage Snowflake databases, schemas, tables, views, and data modelsDevelop and maintain dimensional, operational, and semantic data models to support analytics and reporting. Create structured and governed datasets that enable self-service business intelligenceOptimize Snowflake performance through effective clustering, partitioning, and query tuningAWS Data Lake & Cloud Analytics:Develop and support AWS-based analytics solutions utilizing:Amazon S3Amazon SageMakerAWS GlueAmazon AthenaAWS LambdaAmazon Aurora PostgreSQLDesign and maintain S3 data lake structures and table architectures that support enterprise reporting and analyticsSupport data ingestion and transformation processes from multiple internal and external data sourcesDesign, develop, and optimize PostgreSQL database objects including schemas, tables, views, materialized views, stored procedures, and data transformation logic to support analytics and reporting workloadsReporting & Business Intelligence:Partner with business stakeholders to understand reporting and analytics requirementsCreate and maintain reusable datasets, KPIs, metrics, and reporting structuresSupport dashboard and visualization development utilizing BI and reporting toolsEnable 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 modelsSupport data engineering activities required for Amazon SageMaker and AI initiativesDevelop scalable data assets that support predictive analytics and operational intelligenceData Governance & Quality:Establish and maintain data quality standards and controlsDocument data lineage, mappings, business rules, and transformation logicEnsure compliance with data governance, security, and regulatory requirementsParticipate in master data and metadata management initiativesWhat 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, Analytics Engineering, or related disciplinesStrong experience with ETL development and data integration.Hands-on experience with SnowflakeHands-on experience with PostgreSQL, including query optimization, schema design, indexing strategies, and performance tuningStrong SQL development, data modeling, and PostgreSQL database development expertiseExperience working within AWS cloud environmentsExperience developing and managing enterprise reporting datasetsKnowledge of dimensional modeling, data warehousing, and analytics best practicesExperience with Python or other scripting languages for data processingPreferred Qualifications:Experience with Amazon SageMaker and machine learning data preparationExperience with AWS Glue, Athena, Lambda, and S3-based data lake architecturesExperience with Power BI, Tableau, or similar analytics platformsFamiliarity with Apache Iceberg, Parquet, or modern data lake table formatsAWS and/or Snowflake certificationsExperience supporting AI, predictive analytics, or enterprise data strategy initiativesExperience with PostgreSQL advanced features such as partitioning, materialized views, JSON/JSONB, extensions, and analytical query optimizationExperience implementing medallion architecture (Bronze/Silver/Gold) or similar multi-layer data lake design patternsExperience with Change Data Capture (CDC), event-driven architectures, data products, and operational analytics platformsYour Working Conditions:General office settingThis position qualifies for a hybrid schedule - 4 days in-office,1 day working remoteJoin us and help enable life‑changing discoveries by keeping critical life science systems running reliably—every day.#IND123*This position is currently not eligible for any employment sponsorship.*If any applicant is unable to complete an application or respond to a job opening because of a disability, please email at [e-mail] for assistance.Azenta is an Equal Opportunity Employer. This company considers candidates regardless of race, color, age, religion, gender, sexual orientation, gender identity, national origin, disability or veteran status.United States Base Compensation: $101,000.00 - $126,000.00The posted pay range for this position is an estimate based on current market data and internal pay structure. Final compensation may vary above or below this range depending on factors such as experience, education (including licensure and certifications), qualifications, performance, and geographic location, among other relevant business or organizational needs.