Mgr, IT - FlightSafety International

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 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 noise level in the work environment is usually low to moderate.