Location
Pleasanton, CA | United States
Job description
Job Title: Sr ETL Tech Lead
Location: Philadelphia, PA / Hybrid
Duration : 18-24+mth
Must have:
- 15+ years of experience in data mart and data warehouse environments
- ETL or ELT design and development
- Development and project management experience implementing analytic applications including all phases of system development lifecycle (SDLC)
- Is recognized as an external thought leader within strategic function or discipline. Has broad and comprehensive expertise in leading-edge theories, techniques and/or technologies within own function or discipline.
- Supports the standards and conventions set by Data Architecture and Data Governance teams in the BTS Enterprise Information Management team and design and implement architecturally compliant applications.
- Participates in the development of the product or business strategy.
- Design, develop, document, test, and debug new and existing software systems and/or applications (cloud and/or in-house).
- Serve as technical expert on development projects. Participate in full development life cycle including requirements analysis and design.
- Determine opportunities to redesign business processes to achieve better business results and automate business processes and functions.
- Write technical specifications based on conceptual design and stated business requirements.
- Support, maintain, and document software functionality. Identify and evaluate new technologies for implementation.
- Analyze code to find causes of errors, revise programs as needed and coordinate issues resolution activities with varied stakeholders.
- Participate in software design meetings and analyze user needs to determine technical requirements.
- Serve as liaison between Divisions/Functions and IT on projects and enhancements and drive technical validity of solution.
- Collect and evaluate information, formulate as well as test hypothesis.
- Consult with end user to prototype, refine, test, and debug programs to meet needs.
- Proactively identifies and solves the most complex problems that impact the management and direction of the business.
- Leads multidisciplinary projects or initiatives.
- Participate in data strategy and road map exercises, business intelligence/data warehouse product selection, design, and implementation.
- Holistically design solutions in a complex environment by considering the impact on entire landscape in the design sustainable for the long term
Requirements
- Bachelor’s Degree in Computer Science or related field.
- 15+ years of experience in data mart and data warehouse environments
- Development and project management experience implementing analytic applications including all phases of system development lifecycle (SDLC)
- Deep understanding of enterprise data and how it is being used by business for analytical and operational purposes.
Excellent experience preferred in the following areas:
- ETL or ELT design and development
- Strong solutions design experience
- Demonstrated ability to interact effectively with all levels of the organization.
- Excellent organization, analytical, interpersonal, written and verbal communication skills.
Job tags
Salary