Data & Analytics Engineer

eNGINE

Pittsburgh (Allegheny County)

On-site

USD 80,000 - 110,000

Full time

2 days ago
Be an early applicant

Get a reply from this employer

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

Get past ATS filters

Benefits offered by this job

401(k)
401(k) matching
Dental insurance
Health insurance
Life insurance
Paid time off
Vision insurance

Job summary

eNGINE in Pittsburgh, PA is hiring a data engineer to support enterprise data initiatives focused on MS SQL Server, T-SQL, and SSIS. You will collaborate with business units to deliver robust data pipelines, data models, and reporting solutions.

This role emphasizes cloud modernization using Lakehouse architectures and tools like AWS, Databricks, Snowflake, and Azure Data Factory. Ideal candidates have 3+ years in data engineering or BI, strong SQL skills, and experience with modern data

Qualifications

  • 3+ years of professional experience in data engineering, data warehousing, BI, or related fields.
  • Hands-on experience with Microsoft SQL Server, T-SQL, and SSIS.
  • Experience supporting enterprise BI and/or data warehousing environments.
  • Exposure to cloud platforms and modern data architectures such as Lakehouse.

Responsibilities

  • Develop, maintain, and improve data engineering and BI solutions for multiple business units.
  • Partner with stakeholders to capture requirements and translate them into technical deliverables.
  • Write and optimize SQL, stored procedures, views, and ETL logic using SQL Server and T-SQL.
  • Support ETL and data integration workflows using SSIS.
  • Design, build, and maintain databases, data models, and reporting solutions.
  • Contribute to data modernization across cloud and Lakehouse architectures.
  • Apply AWS, Databricks, Snowflake, and Azure Data Factory to future-state solutions.
  • Explore applied AI capabilities to improve data access, processing, and analytics.

Skills

Data engineering
Data warehousing
BI solutions
Stakeholder collaboration
ETL

Tools

Microsoft SQL Server
T-SQL
SSIS
AWS
Databricks
Snowflake
Azure Data Factory
Lakehouse
RAG
MCP

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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer
Data Engineer

eNGINE • Pennsylvania

On-site
USD 90,000 - 140,000
Azure Data Engineer
Azure Data Engineer

Recru • Fort Worth (TX), Arlington (TX), Dallas (TX)

On-site
USD 120,000 - 150,000
Data Engineer Lead
Data Engineer Lead

VSE AVIATION INC (US) • Phoenix (AZ)

On-site
USD 140,000 - 200,000
Enterprise Data Architect
Enterprise Data Architect

The Value Maximizer • Kentucky

Hybrid
USD 120,000 - 150,000
Data Engineer
Data Engineer

Trisearch • Denver (CO)

Hybrid
USD 160,000 - 190,000
Health, dental, vision coverage
Hybrid/Remote work options
401(k) with company match
+5
Associate Data Engineer
Associate Data Engineer

Baker Tilly Advisory Group, LP • Milwaukee (WI)

On-site
USD 86,000 - 163,000
Data Engineer
Data Engineer

Northbound Executive Search • Austin (TX)

On-site
USD 80,000 - 120,000
Data Engineer Lead
Data Engineer Lead

VSE AVIATION INC (US) • Florida

On-site
USD 130,000 - 190,000
Data Platform Engineer
Data Platform Engineer

Christ Panos Food Corporation • Itasca (IL)

On-site
USD 90,000 - 110,000
Data Engineer
Data Engineer

ASHFORD CONNEX, LLC • Pittsburgh

On-site
USD 110,000 - 160,000