About Pinnacle Group
Pinnacle Group is a trusted leader in delivering innovative workforce and technology solutions that help organizations optimize data, systems, and business outcomes.
We partner with clients to build scalable, data-driven platforms that enable informed decision-making and long-term growth.
Our teams combine deep technical expertise with a collaborative mindset to solve complex data and integration challenges.
At Pinnacle Group, we foster an environment where technical excellence and continuous learning are at the core of everything we do.
Summary
The ETL Developer will play a critical role in designing, developing, and maintaining robust data integration and data warehousing solutions.
This position focuses on building reliable ETL pipelines that support business intelligence and analytics initiatives.
The ideal candidate brings strong expertise in T-SQL, SSIS, and Azure Data Factory, along with a passion for data quality and performance optimization.
This role collaborates closely with business and technical stakeholders to deliver scalable, high-impact data solutions.
Job Description
- Design, develop, and maintain ETL processes to support enterprise data integration and reporting initiatives.
- Develop complex T-SQL queries, stored procedures, and transformations to support data extraction and processing.
- Build, deploy, and manage ETL workflows using SQL Server Integration Services (SSIS).
- Design and model data warehouse structures to support analytics and business intelligence requirements.
- Ensure data accuracy, consistency, and integrity through testing, validation, and monitoring processes.
- Collaborate with business analysts and stakeholders to gather requirements and translate them into technical solutions.
- Monitor ETL pipelines and troubleshoot performance or data issues to ensure reliable operations.
- Create and maintain clear documentation for ETL workflows, data mappings, and technical processes.
Requirements
- Proven experience as an ETL Developer or in a similar data engineering role.
- Strong proficiency in T-SQL, including complex queries and stored procedure development.
- Hands-on experience with SSIS for designing and managing ETL processes.
- Experience using Azure Data Factory (ADF) for cloud-based data integration.
- Solid understanding of data warehouse design and dimensional modeling concepts.
- Familiarity with Microsoft Azure services, including Data Factory, data storage solutions, Blob Storage, Power BI, and Power Automate.
- Strong analytical, problem-solving, and communication skills with a high attention to detail.
- Bachelor’s degree in Computer Science, Information Technology, or a related field preferred.
Why Join Pinnacle Group?
At Pinnacle Group, you will work on impactful data initiatives that support critical business decisions across organizations.
We provide an environment that encourages innovation, collaboration, and professional growth while working with modern data and cloud technologies.
You’ll have the opportunity to expand your technical skill set, contribute to meaningful projects, and work alongside experienced professionals.
Our culture values accountability, continuous improvement, and delivering excellence for both our clients and our people.
Instructions:
Please answer the questions below, attach your resume and email your responses to prashanth.santhosh@pinnacle1.com and jason.jordi@pinnacle1.com, as part of your application.
- Describe your experience building complex SQL queries and stored procedures.
Please provide examples. - Have you worked in a Microsoft-based environment (Azure, Azure Data Factory, SSIS, SQL Server)?
Please elaborate. - Do you have basic to intermediate experience with data modeling?
Please explain the types of models you have worked with. - What experience do you have designing or supporting data warehouse solutions for reporting or analytics?
- Please share anything else you would like us to know that highlights your strengths or sets you apart as an ETL Developer.