Data Engineer
ey
Job Description
- Designing, architecting, and implementing data solutions using Microsoft SQL Server Integration Services (SSIS) to efficiently process and analyze large, complex data sets, meeting, and exceeding business requirements.
- Proficiency in developing and maintaining SQL Server Analysis Services (SSAS) models, including tabular and multidimensional, to support advanced analytics and reporting.
- Expertise in creating, deploying, and managing ETL/ELT pipelines with SSIS and SSAS, ensuring data accuracy and integrity for data warehousing solutions.
- Experience with SQL Server Reporting Services (SSRS) for the development of interactive, tabular, graphical, or free-form reports from relational, multidimensional, or XML-based data sources.
- Proficient in leveraging Power BI for data visualization and business intelligence, creating dashboards and reports that provide actionable insights to stakeholders.
- Strong understanding of data warehousing and modelling concepts, with the ability to design and optimize data storage for both SQL and NoSQL database technologies.
- Evaluating and implementing distributed storage, parallel processing, and advanced query techniques to enhance data retrieval and analysis performance.
- Recommending and building new data platforms and solutions as required, utilizing in-house data platforms, and integrating with external data sources to fulfil business needs.
- Excellent communication skills to convey findings, recommendations, and opportunities to improve data systems and solutions to both technical and non-technical audiences.
- Exposure working in client facing roles, collaborate with cross functional teams including internal audits, IT security and business stakeholders to assess control effectiveness and facilitate remediation activities.
- Good to have experience in IT Controls, Risk and Compliance.
- Testing of internal controls such as IT general controls, IT application controls, IPE related controls, interface controls etc.
- Design IT Risk Controls framework such as IT SOX.