Title: Data Engineer, Senior (NJUS)
Company: NetJets Services, Inc.
Area of Interest: Business Insights and Analytics
Location:
Columbus, OH, US
Req ID: 2827
Purpose of Position
Under the direction of the Data Engineering Manager, The Data Engineer Senior is responsible for the design, development, testing, and on-going management of the NetJets data pipeline processes. This role will utilize industry best practices to assemble and transform data from disparate systems into data stores. This person will provide mentorship to less experienced team members. The ideal candidate will have prior experience on a data warehouse development team and a passion for working with data. This position will collaborate with business and team members to understand requirements and design robust data solutions.
Tasks and Responsibilities
- Design, develop, and test data solutions to support enterprise reporting
- Perform root cause analysis and troubleshooting/monitoring of existing processes
- Collaborate with business and team members to understand/document requirements
- Documentation and/or meeting with partners to support NetJets initiatives
- Mentor team members and overseeing project delivery
- Continuous learning and curiosity toward process improvement initiatives
Education
Bachelor's in Computer Science or Information Technology
Certifications and Licenses
Years of Experience
6-8 years of experience
Core Competencies
Adaptability
Collaboration
Curiosity
Service-Oriented
Strives For Positive Results
Knowledge, Skills, Abilities and Other (KSAOs)
- Demonstrated ability to apply analytic and problem-solving skills to design data solutions
- Proven ability to work independently to accomplish tasks while providing assistance to others
- Proven ability to learn and apply new concepts and technology
- Ability to work effectively with technical and business associates at all levels of the organization
- Open to new ideas and practices; and a willingness to adapt as needed
- Able to understand complex technical processes and explain to non-technical people
- Demonstrated collaboration and communication skills across business and technology teams
- Expert level SQL skills including use of stored procedures, triggers, and query tuning
- Development experience with one or more industry standard DBMS platform
- Data warehouse/data mart development experience
- Proficient with data modeling techniques (eg dimensional, 3NF)
- Experience working in cloud data platforms/PaaS environments (eg AWS, SnowFlake) ETL Focus
- Development experience with at least one ETL tool; Informatica or Wherescape is preferred
- Has developed data integrations with Change Data Capture (CDC)
- Has experience utilizing a variety of sources for data ingestion (eg API, flat file, database)
- BI Focus:
- Development experience with at least one BI tool; Tableau or Business Objects is preferred
- Hands-on experience with creating dashboards and reports in an enterprise environment
- Understands various data visualization techniques
Nearest Major Market: Columbus
Nearest Secondary Market: Dublin