Data Engineer

Introduction:

The candidate is an experienced Senior Data Engineer with a strong background in data infrastructure, design, implementation, and support, particularly in Microsoft’s on-premise and modern data platforms. With a focus on data-driven solutions, the candidate has expertise in SQL, ETL processes, and data analysis, having worked extensively with tools such as Power BI, T-SQL, SSIS, and Azure services like Azure Data Factory and Azure DevOps. They have a strong command over database architecture, both OLTP and OLAP, and are adept at working with data warehouses and building custom reporting solutions. Additionally, the candidate is skilled in designing and managing CI/CD pipelines, using GitHub and PowerShell for automation. They also possess experience in the creation of data models, risk and compliance management, and Agile methodologies. Furthermore, the candidate has a solid track record in developing data solutions in cloud environments and implementing business intelligence tools, including Power BI dashboards for performance measurement. Their work spans across various business domains, with a proven ability to collaborate with stakeholders, define technical requirements, and deliver tailored data solutions.

Responsibilities:

• Designing and implementing database architecture for OLTP and OLAP systems.
• Developing T-SQL scripts for storing, processing, and managing data.
• Extracting and processing data through SSIS flows using APIs and excel sheets.
• Building SSAS tabular models for data analysis and reporting.
• Developing Power BI dashboards to measure data flow performance and display key metrics.
• Creating custom Power BI functionalities for specific reporting requirements.
• Generating dummy data for testing purposes in development and UAT environments.
• Setting up infrastructure solutions in private cloud environments, including machines, networks, and security protocols.
• Automating CI/CD pipelines using PowerShell scripting and TFS release pipelines.
• Managing risk, compliance, and process-related tasks, including systems account usage.
• Collaborating in Agile Scrum teams to deliver data solutions through iterative development.
• Conducting demos and POCs to showcase work and proactively solve business challenges.
• Tracking change requests and implementing new features in ERP applications.
• Debugging and providing support for existing features within applications.
• Writing documentation for business processes, data models, and technical specifications.
• Developing BI reports using T-SQL and reporting services.
• Administering and tuning databases for optimal performance.
• Handling database migrations from legacy systems to modern platforms.