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