Data DcaRawF9 — Greater Pittsburgh Region

Data & Analytics yv287Jwd n openings

Location: Pittsburgh, PA – Financial Center

Work Model: 100% On-Site | 5 Days Per Week

About 6EHrnc

6EHrnc builds Technical Teams. We are a Solutions and Placement firm shaped by decades of interaction with Technical professionals. Our inspiration is continuous learning and engagement with the markets we serve, the talent we represent, and the teams we build. Our Consulting Workforce is encouraged to enjoy career fulfillment in the form of challenging projects, schedule flexibility, and paid training/certifications. Successful outcomes start and finish with 6EHrnc.

Role Overview

6EHrnc is seeking a Data & Analytics gGwYr4ex to support enterprise data initiatives while helping shape the future of a growing data and analytics environment.

This is an opportunity for an gJVZrGx9 who understands both traditional data technologies and the modern platforms transforming how organizations collect, process, analyze, and leverage information. You'll initially work within an established environment built around Microsoft SQL Server, T-SQL, SSIS, and traditional data warehousing technologies while contributing to the evolution toward cloud-based data architecture, Lakehouse solutions, and AI-driven capabilities.

The organization is planning a significant data modernization initiative, with a move toward cloud infrastructure anticipated in 2027. AWS is a leading consideration, creating an opportunity for someone who has already worked with modern cloud data platforms and can help bridge the gap between existing systems and future-state architecture.

Beyond traditional data engineering, this role calls for practical experience with artificial intelligence and emerging data technologies. Whether through Retrieval-Augmented Generation (RAG), Model Context Protocol (MCP), or other applied AI solutions, you'll bring an understanding of how these capabilities can make enterprise data more accessible, intelligent, and valuable.

This is an opportunity to contribute to the data environment that exists today while helping build the foundation for what comes next.

Responsibilities

• Develop, maintain, and enhance data engineering and business intelligence solutions supporting multiple business units.

• Work with business stakeholders, BI professionals, and Data Analysts to understand requirements and translate business needs into technical solutions.

• Develop and optimize SQL queries, stored procedures, views, and data transformation processes using Microsoft SQL Server and T-SQL.

• Support existing ETL processes 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 initiatives involving cloud platforms, Lakehouse architecture, and next-generation data engineering technologies.

• Apply experience with platforms such as AWS, Databricks, Snowflake, and Azure Data Factory to help inform and implement future-state data solutions.

• Explore and implement practical AI capabilities that improve how enterprise data is accessed, processed, analyzed, and utilized.

• Apply emerging AI approaches such as RAG, MCP, or other relevant AI integration technologies to 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.

• Develop and maintain technical documentation covering data models, integrations, processes, and implementations.

• Monitor data quality, application performance, and production processes while troubleshooting issues and identifying opportunities for improvement.

• Partner with business teams to develop reporting and analytical tools that improve operational efficiency, business intelligence, and decision-making.

• Follow established data governance, security, risk management, and regulatory compliance standards.

Required Qualifications

• 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 working with modern data technologies, including cloud platforms, Lakehouse architecture, or contemporary data engineering solutions.

• Experience with one or more modern data platforms such as AWS, Databricks, Snowflake, or Azure Data Factory.

• Practical experience applying artificial intelligence to technical or business solutions. Experience with RAG, MCP, AI integrations, or comparable applied AI implementations is particularly relevant.

• Strong understanding of ETL processes, 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.

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.

Next Steps

No C2C, relocation, recruiter represented referral candidates, or sponsorship for this role. For finer details on how 6EHrnc can impact your career, apply today!