ETL Senior Technical Lead - Military Veterans
at R&R Integrated Solutions
Position: Data Architect
Location: Louisville, KY (Onsite)
Duration: Long Term
Role:
As a Data Architect, you will be responsible for designing and managing the overall data architecture strategy and framework. You will work closely with ETL developers, business analysts, and other stakeholders to understand data requirements, ensuring that data solutions align with business goals and technical requirements. This role requires expertise on migrating current state DTS packages to Future state SSIS Packages as per standards. Required to manage internal and customer stack holders.
Key Responsibilities:
Design and implement data architecture solutions that meet business requirements and technical constraints.
Oversee the design, development, and maintenance of ETL processes using SQL Server Integration Services (SSIS).
Lead the migration of legacy DTS packages to SSIS, ensuring optimal performance and minimal disruption.
Develop and enforce best practices for data integration, data quality, and data governance.
Collaborate with business analysts, ETL developers, and other stakeholders to understand data requirements and translate them into data architecture solutions.
Ensure data quality and integrity throughout the data lifecycle.
Develop and maintain comprehensive documentation for data architecture, data flows, and ETL processes.
Provide technical leadership and mentoring to ETL developers and other team members.
Conduct regular reviews and updates to the data architecture to ensure it meets changing business needs and technological advancements.
Stay current with industry trends and best practices in data architecture, data integration, and data management.
Technical Skills:
Extensive experience with SQL Server, including database design, development, and performance tuning.
Strong expertise in SSIS and proven experience migrating DTS packages to SSIS.
In-depth understanding of data warehousing concepts, data modeling, and data governance.
Excellent problem-solving skills and attention to detail.
Strong communication and interpersonal skills, with the ability to work effectively with stakeholders at all levels.
Experience leading and mentoring technical teams.
Certification in data architecture or related fields
Louisville, KY
R&R Integrated Solutions (R&R) is a specialized recruiting firm that connects top talent to essential telecommunications roles, including tower technicians, fiber optic installers, maintenance technicians, and data center professionals. Focused exclusively on the telecom industry, R&R understands the high standards for technical and safety skills required in this field, carefully vetting candidates to match the unique needs of each employer. By aligning telecom companies with skilled professionals, R&R supports the continued growth and reliability of communication infrastructure in an ever-connected world.
From installing and maintaining fiber optic networks to ensuring data centers operate efficiently and securely, RR’s targeted approach meets the demands of today’s telecommunications landscape. R&R excels in sourcing professionals with the certifications and experience necessary to advance connectivity across industries, fostering teams that ensure data flow, high-speed internet, and network reliability nationwide. With a commitment to quality placements, Our firm plays a vital role in building the workforce that powers global communication networks