Manager Data Engineering

Job Description

• Role Summary:
  A Manager of Data Engineering will provide technical expertise to our data engineering practice, implement the roadmap for the Data Engineering practice, and deliver data products that will allow your business partners to make successful, timely, data-driven decisions. Will be responsible for building and maintaining data systems, constructing datasets that are easy to analyze, and supporting company requirements. They will implement methods to improve data reliability and quality. They combine basic information from different sources to create consistent and machine-readable formats. They also develop and test architectures that enable data extraction and transformation for predictive or prescriptive modeling.
  Primary Responsibilities:
  
• The primary objective is to create the data products and make sure they are delivered
  through reliable data pipelines.
• Design and develop database objects, tables, stored procedures, views, triggers, and SSIS packages.
• Analyze, solve, and correct issues in real-time, providing problem resolution end-to-
  end.
• Design a data pipeline and develop ETL processes to transform raw data, flat files, and xl spreadsheets into SQL Databases.
• Provide database support for developing and deploying database scripts in Development, Test, Pre-Production, and Production environments.
• Design and develop enterprise and departmental business intelligence and data warehousing solutions.
• Test programs or databases, correct errors, and make necessary modifications
• Plan, coordinate and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification, or disclosure.
• Modify existing databases and database management systems or direct programmers and analysts to make changes.
• Develop methods for integrating different products, so they work properly together.
• Develop standards and guidelines to guide the use and acquisition of software and to protect changes to the database.
• Revise/write the company definition of data in the data dictionary.
• Train users and answer questions.
  
• Approve, schedule, plan, and supervise the installation and testing of new products and computer system improvements, such as installing new databases.
• Identify and evaluate industry trends in database systems to serve as a source of
• information and advice for upper management.

Job Requirements

• Software engineering background specializing in big data
• Work experience as a DevOps Engineer or similar software engineering role
• Exceptional SQL Server programming skills
• Advanced Business Intelligence experience
• Proficient in BIML scripting, SSIS, SSRS, SSAS, and Power BI
• Extensive experience with reporting using Power BI
• Skilled in coding complex stored procedures using T-SQL
• Experienced in developing SSIS packages
• Performs ad-hoc analysis using a process-oriented approach with T-SQL
• Knowledge of Data Marts, Data Warehouses, and Data Lakes
• Experience migrating legacy systems to Data Marts/Warehouses/Lakes
• Familiar with cloud technologies, especially Azure SQL Server
• Uses SQL Server Analysis Services (SSAS) to enhance or develop OLAP cubes in EDW systems
• Experience troubleshooting and resolving:
• Database integrity issues
• Performance issues
• Blocking and deadlocking issues
• Excellent leadership and communication skills
• Experience mentoring developers on processes and best practices
• Strong understanding of data modeling concepts
• Critical thinker with strong problem-solving skills
• In-depth knowledge of database management principles and practices
• Proven analytical, problem-solving, and debugging skills
• Preferred: knowledge of healthcare data and processes (USA and Australian standards)
• Bonus: knowledge of Python and R
• Extensive knowledge of database design and modeling
• Hands-on experience with Microsoft data technologies
• Fluent in Java (Python is a plus)
• Strong analytical and troubleshooting capabilities