Manager, Data Engineering - FlightSafety International
Columbus, OH
About the Job
About FlightSafety International
FlightSafety International is the world’s premier professional aviation training company and supplier of flight simulators, visual systems and displays to commercial, government and military organizations. The company provides training for pilots, technicians and other aviation professionals from 167 countries and independent territories. FlightSafety operates the world’s largest fleet of advanced full-flight simulators and award-winning maintenance training at Learning Centers and training locations in the United States, Canada, France and the United Kingdom.
Purpose of Position
The Manager, IT- Data Integration and Visualization, oversees all teams managing data pipelines, analytic data stores and visualization. The ideal candidate will have a strong technical background in data engineering, proven leadership capabilities, and a strategic mindset. The role is crucial for ensuring design, development, and maintenance of scalable data analytics platforms and products that meet our business needs.
Tasks and Responsibilities
- Design and maintain scalable, high-performance data architectures.
- Ensure reliability, accuracy, and security of data systems.
- Implement and enforce data governance policies and standards.
- Provide regular updates to Program managers and stakeholders.
- Collaborate with cross functional teams - PMs, Scrum Masters, BRMs and BAs
- Facilitate effective communication and collaboration across departments.
- Stay updated with latest trends and technologies in data engineering.
- Continuously evaluate and optimize data infrastructure and processes.
- Manage risks related to data security and privacy.
- Ensure data analytics products are monitored and supported 24*7.
- Identify, define, and assess the properties and specifications necessary for the database management system (DBMS) to meet the current and future needs of the organization.
- Communicate technology issues and potential risks to senior leadership, with associated mitigation plans.
- Prioritize and manage workload and communicate issues clearly.
- Complete other tasks as required.
Minimum Education
- Bachelor’s degree in computer science, Information systems or related field from an accredited institution or equivalent industry experience
Minimum Experience
- 10+ years of experience in data and analytics development, and implementation using cloud data platforms. Prefer MS Azure
- 3+ years of experience leading/supervising Data Engineering teams
In-depth experience in the use of programming languages (i.e., Transact SQL and stored procedures, Python, Power Query)
Knowledge, Skills, Abilities
- Demonstrated ability to manage a team of resources, both directly and indirectly, providing guidance, ensuring alignment, and providing effective feedback
- 5+ years of experience in Azure Databricks, Data Lake, Data Factory and Power BI
- 3+ years of enterprise ETL, analytics & reporting development experience in SSIS, SSRS
- 3+ years of experience in RDBMS design and development. Must demonstrate a clear mastery of the logical and physical database design (for both transactional and data warehouse) and data normalization concepts.
- Experience implementing Data Vault 2.0, Medallion architecture and dimensional models.
- Experience with Autoloader, DLT Pipelines, Unity Catalog
- Experience managing and optimizing utilization of PBI Service and Databricks clusters.
- Experience in change data capture and replication tools like HVR, SQDR etc.
- Expert SQL abilities and use of tools and platforms and troubleshooting skills. Must have extensive hands-on dev experience: T-SQL, UDF, UDAF, View, Trigger, Stored Proc
- Experience working in visual studio development environment and with using DevOps platforms for code management and deployment using CI/CD techniques.
- Familiarity with SDLC and agile methodologies and tools such as TFS, Git or SCRUM
- Experience in communicating with executives and senior leadership.
- Experience with professional software engineering best practices for the full software development life cycle, including coding standards, code reviews, source control management, build processes, testing and operations.
- Ability to create and maintain data flows and data modeling diagrams.
- Knowledge of data governance, data security, privacy, and compliance
- Excellent project management skills with the ability to manage multiple projects simultaneously.
- In-depth experience with Agile development methodology
- Excellent analytical and interpersonal skills
- Strong written and verbal communications skills
- Excellent organizational skills, including the ability to multi-task and prioritize workload
Physical Demands and Work Environment
The physical demands and work environment described here are representative of those that must be met and/or encountered by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
While performing the duties of this job, the employee is regularly required to use hands to finger, handle, or feel; reach with hands and arms; and communicate. The employee may be required to stand, walk, and sit.
Specific vision abilities required by this job include the ability to view monitors, technical documents, and reference material.
The employee must occasionally lift or move up to 25 pounds.
The noise level in the work environment is usually low to moderate.
FlightSafety is an Equal Opportunity Employer/Vet/Disabled. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or disability.