DataJobs.io
← Back to all jobs

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

Similar Jobs