Data & Analytics Engineer
AI
Ai Agent Engineering
Ai Agent Platform
Analytics
Artificial Intelligence
Azure
Azure Data Engineer
Azure Data Factory
Azure Data Platform
Big Data
Bigdata
Business Intelligence
Cloud
Cloud Data Engineering
Cloud Data Platform
Cloud Data Warehouse
Cloud Data Warehouse
Cloud Engineer
Cloud Operations
Cloud Platform
Cloud Platforms
Cloud Platforms Cloud Platforms
Data
Data Analysis
Data Analytics
Data Architecture
Data Engineer
Data Engineering
Data Factory
Data Factory Azure
Data Integration
Data Integration Tools
Data Lakehouse
Data Pipeline
Data Platform
Data Processing
Data Warehouse
Data Warehousing
Database
Databases
Databricks
Databricks Lakehouse
Databricks Lakehouse Platform
Digital Marketing
ETL
Informatica
Integration
Llm Integrations
Microsoft Azure
Rag Architectures
Reporting and Analytics
Snowflake
Spark
SQL
Vector Databases
Job Description
eNGINE is seeking a Data & Analytics Engineer to support enterprise data initiatives in Pittsburgh, PA with an onsite setup. The work will begin in an environment grounded in Microsoft SQL Server and T-SQL, then expand into cloud, Lakehouse, and applied AI capabilities that improve access to and use of organizational data.
What you’ll do
- Develop, maintain, and enhance data engineering and business intelligence solutions for multiple business units.
- Partner with business stakeholders, BI professionals, and Data Analysts to capture requirements and turn business needs into technical solutions.
- Create and optimize SQL queries, stored procedures, views, and data transformation processes using Microsoft SQL Server and T-SQL.
- Support existing ETL and data integration workflows using SQL Server Integration Services (SSIS).
- Design, build, and maintain databases, analytical data models, reporting solutions, and automated data processes.
- Help drive data modernization initiatives involving cloud platforms, Lakehouse architecture, and next-generation data engineering technologies.
- Apply experience across platforms such as AWS, Databricks, Snowflake, and Azure Data Factory to support future-state data solutions.
- Explore and implement practical AI capabilities that enhance how enterprise data is accessed, processed, analyzed, and utilized.
- Use emerging approaches such as RAG and MCP, or comparable AI integration technologies, for enterprise data solutions.
- Support integrations between analytical platforms, APIs, internal applications, and external data sources.
- Handle data conversions, migrations, imports, and exports across enterprise systems.
- Maintain technical documentation for data models, integrations, processes, and implementations.
- Monitor data quality, application performance, and production processes while troubleshooting issues and identifying improvement opportunities.
- Work with business teams to build reporting and analytical tools that strengthen operational efficiency, BI, and decision-making.
- Follow data governance, security, risk management, and regulatory compliance standards.
Required experience
- At least 3 years of professional experience in data engineering, data warehousing, business intelligence, or a related technical discipline.
- Hands-on experience with Microsoft SQL Server, T-SQL, and SSIS.
- Experience supporting enterprise Business Intelligence or Data Warehousing environments.
- Demonstrated experience with modern data technologies including cloud platforms, Lakehouse architecture, or contemporary data engineering solutions.
- Experience with at least one modern data platform such as AWS, Databricks, Snowflake, or Azure Data Factory.
- Practical experience applying artificial intelligence to technical or business solutions, with particular relevance for RAG, MCP, AI integrations, or comparable applied AI implementations.
- Strong understanding of ETL, data transformation, data modeling, and data integration.
- Experience developing and optimizing analytical queries, databases, and reporting solutions.
- Ability to work across established legacy environments and emerging technologies.
- Strong analytical, troubleshooting, organizational, and communication skills.
Technologies
- Microsoft SQL Server, T-SQL, SSIS, SQL
- AWS, Databricks, Snowflake, Azure Data Factory
- Lakehouse
- Retrieval-Augmented Generation (RAG), Model Context Protocol (MCP)
- APIs, vector databases, LLM integrations, AI
Benefits
- 401(k)
- 401(k) matching
- Dental insurance
- Health insurance
- Life insurance
- Paid time off
- Vision insurance
Preferred experience
- Experience with AWS data services and cloud-based data architecture.
- Databricks, Snowflake, or other modern Lakehouse and data platform technologies.
- Experience with Azure Data Factory or comparable cloud-based ETL/orchestration tools.
- Experience designing and implementing APIs and integrations between enterprise applications and data platforms.
- Hands-on experience with RAG, MCP, vector databases, LLM integrations, or other applied AI technologies.
- Relevant AI certifications or demonstrated real-world experience building AI-enabled solutions.
- Experience with cloud migration, data platform modernization, or transitioning legacy data environments to modern architectures.
- Familiarity with enterprise data governance, metadata management, and data quality practices.
Note: No C2C, relocation, recruiter represented referral candidates, or sponsorship for this role.