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
Support enterprise data initiatives with a foundation in Microsoft SQL Server, while helping evolve toward cloud, Lakehouse, and practical AI capabilities.
Responsibilities
- Develop, maintain, and improve data engineering and BI solutions for multiple business units
- Partner with business stakeholders, BI professionals, and Data Analysts to capture requirements and translate them into technical deliverables
- Write and optimize SQL, stored procedures, views, and data transformation logic 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
- Contribute to data modernization efforts across cloud, Lakehouse architecture, and next-generation data engineering approaches
- Apply experience with AWS, Databricks, Snowflake, and Azure Data Factory to influence and implement future-state solutions
- Explore and implement applied AI capabilities that improve enterprise data access, processing, analysis, and usage
- Use emerging AI integration techniques such as RAG and MCP (or comparable approaches) in enterprise data solutions
- Support integrations between analytical platforms, APIs, internal applications, and external data sources
- Perform data conversions, migrations, imports, and exports across enterprise systems
- Create and maintain technical documentation for data models, integrations, processes, and implementations
- Monitor data quality, application performance, and production processes; troubleshoot issues and identify improvement opportunities
- Collaborate with business teams to deliver reporting and analytics tools that enhance operational efficiency and decision-making
- Adhere to data governance, security, risk management, and regulatory compliance standards
Requirements
- At least 3 years of professional experience in data engineering, data warehousing, business intelligence, or a related technical field
- Hands-on experience with Microsoft SQL Server, T-SQL, and SSIS
- Experience supporting enterprise BI and/or data warehousing environments
- Demonstrated exposure to modern data technologies such as cloud platforms, Lakehouse architecture, or contemporary data engineering solutions
- Experience with one or more modern data platforms, including AWS, Databricks, Snowflake, or Azure Data Factory
- Practical AI experience applied to technical or business outcomes, 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 both 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 and 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
Next Steps
- No C2C
- No relocation
- No recruiter-represented referral candidates
- No sponsorship for this role
Location: Pittsburgh, PA (onsite) | Compensation: USD 80,000 - 110,000 per year | Experience: 3+ years