Key Responsibilities:
- Data Platform Management: Assess, enhance, and upgrade our data platforms, incorporating emerging technologies and cloud-based solutions to boost scalability, accessibility, and security.
- Process Optimization: Develop and refine standardized procedures for data management, governance, integration, quality, and lifecycle management to ensure data consistency, accuracy, and timeliness.
- Stakeholder Collaboration: Work closely with cross-functional teams, business units, and senior management to promote data-driven initiatives, nurture a data-centric culture, and align with organizational goals.
- Performance and Innovation: Oversee and enhance the Firm’s data platforms (primarily Microsoft SQL Server), optimize data engineering processes, identify improvement opportunities, and drive innovation to improve data processing efficiency, data quality, and system performance.
Qualifications:
Experience:
4+ years of experience as a Data Engineer with a proven track record working with Microsoft SQL Server and related technologies.
Technical Skills:
- Expertise in Microsoft data development tools (SSMS, Visual Studio Data Tools).
- Advanced T-SQL development, troubleshooting, and optimization.
- SQL Server performance monitoring and tuning.
- Extensive SSIS integration experience; experience with Data Factory is a plus.
- Advanced SSRS skills.
- Proficiency in PowerShell scripting for database operations and automation.
- Experience with C# scripting in SSIS (Script Task).
- Data warehousing experience.
- Familiarity with cloud-based data platforms, preferably Azure.
- Knowledge of OpenAI technologies and leveraging data for their effective use.
- Strong understanding of the Microsoft Azure Data Platform.
- Expertise in using and administering Azure “Power” platform tools for data and automation.
- Handling API calls and return data in JSON and XML.
- Intermediate to advanced HTML and CSS skills.
- Basic knowledge of Python.