EngineerJobs.io
← Back to all jobs

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.

Similar Jobs