Data Engineer Senior

Job summary
Data Engineer Senior Full-time position Location: Norfolk, VA preferred
Job seniority: mid-to-senior level
Responsibilities
• Maintains active relationships with customers to determine business requirements and leads requirements gathering meetings; collaborate closely with business analysts, data scientists, and other stakeholders to deliver effective and efficient data warehousing solutions. • Owns the change request process and may coordinate with other teams as necessary. • Provides technical advice and weighs in on technical decisions that impact cross functional teams. • Researches and may propose new technologies; stay up-to-date on the latest trends and advancements in the data warehousing and business intelligence domain, sharing knowledge and insights with the team. • Utilize Informatica to architect and implement scalable and reliable data integration solutions, adhering to industry best practices. • Develops and defines application scope and objectives and prepares technical and/or functional specifications from with programs will be written. • Leverage experience with SSIS to create and maintain data integration workflows, extracting, transforming, and loading (ETL) data from diverse sources into the data warehouse. • May own technical testing to ensures unit test is completed and meets the test plan requirements, system testing is completed, and system is implemented according to plan. • Assesses status and supports data information planning; coordinates on-call support and ensures effective monitoring of system. • Optimizing query performance, ensuring data integrity, and implementing efficient database structures using MSSQL. • Maintains technical development environment; Design, develop, and deploy robust and efficient data warehousing solutions, utilizing advanced proficiency in MSSQL, SSIS, and Informatica. • Mentors others and may lead multiple or small to medium sized projects. • Will begin to set direction at the project/service level and influences decision-making; explore innovative approaches and technologies to enhance data warehousing practices, ensuring scalability, reliability, and improved performance. • Provides technical guidance, and mentoring. • Understands the tradeoffs between technical, analytical and product needs of the technical solutions. Identifies and propose strategies around technical problems affecting team, communicates standards and gets buy-in on solutions. • Facilitates group sessions to elicit complex information on requirements clarification, design sessions, code reviews and troubleshooting issues. • Supports vendor evaluation.
Requirements
• BA/BS degree in Information Technology, Computer Science or related field of study • Minimum of 5 years related experience; multi-dimensional platform experience; expert level experience with business and technical applications. • Experience mentoring others, leading multiple small projects and providing troubleshooting support is preferred. • Multi database and/or multi language strongly preferred. • Hands-on experience with MSSQL, SSIS, and Informatica. • Experience optimizing query performance, ensuring data integrity, and implementing efficient database structures using MSSQL. • Experience writing complex SQL queries involving intricate logic to extract, manipulate, and analyze data efficiently. • In-depth knowledge of the Software Development Life Cycle (SDLC) and experience working on end-to-end development projects. • Excellent problem-solving skills and the ability to analyze complex data requirements to design optimal solutions. • Excellent communication skills, both verbal and written, enabling effective collaboration with technical and non-technical stakeholders.