Data Engineer

As a Data Engineer, you will be developing, testing and implementing data engineering solutions to generate analytical and reporting solutions.

You will be also in charge of for implementing, maintaining, and optimizing our SQL Server database infrastructure, ensuring the availability, performance, and security of our data management systems.

In this role, you will:

• Leverage technical data dictionaries and business glossaries to analyze the datasets,
• Perform data profiling and data analysis for any source systems and the target data repositories,
• Understand metadata and the underlying data structures needed to standardize the data load processes,
• Develop data mapping specifications based on the results of data analysis and functional requirements,
• Perform / coordinate scheduled maintenance and supports release deployment activities,
• Create, refine, and automate recurring processes, tracks issues, and documents changes,
• Provide support for critical production SQL Server data management processes,
• Manage databases through multiple product lifecycle environments, from development to mission-critical production data systems,
• Identified pain points and bottlenecks and recommends solutions,
• Analyze database performance and conducts performance tuning,
• Build automated Extract, Transform & Load (ETL) jobs based on data mapping specifications,
• Validate the data mapping results and match with the expected results,
• Implement Data Quality (DQ) rules provided.

Required Qualifications & Soft Skills

Technical Expertise

• Hands-on experience in writing SQL scripts for Microsoft SQL Server,
• Ability to understand logical and physical data models, big data storage architecture, data modeling methodologies, metadata management, master data management & data lineage techniques,
• Experience with performance tuning and optimization tools in a SQL Server environment,
• Hands-on experience in programming languages like Java or Python,
• Experience in handling both Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) data models,
• Exposure to unstructured datasets and ability to handle XML, JSON file formats
• Exposure to Extract, Transform & Load (ETL) tools like SSIS.

Domain Expertise

• Knowledge of industrial applications in commercial/finance/industrial/manufacturing settings,
• Exposure to handling HL7 or FHIR data format.

Leadership

• Ability to partner with other team members to understand the project objectives and resolve technical issues.
• Ability to communicate project status or challenges in a clear and concise manner to the cross team members.

Additional Information

Relocation Assistance Provided: No