Data Services Optimization Engineer
Location: India
Location: Sri Lanka (Colombo)
Location: Philippines (Metro Manila)
Job description
Data Services Optimization Engineer for maintaining and enhancing the performance of our data environments, primarily focused on Microsoft SQL and Microsoft Azure data services. The ideal candidate will proactively manage and optimize data sources, analyze data growth patterns, and implement advanced analytics solutions.
Responsibilities
- Data Source Optimization: Continuously monitor, tune, and optimize data sources to ensure optimal performance and scalability within our Microsoft SQL and Azure data service environments.
- Data Growth Analysis: Analyze and forecast data growth trends to proactively plan for storage scaling, performance tuning, and cost management.
- Analytics Implementation: Develop and deploy robust reporting solutions and dashboards using data analytics tools such as Power BI, integrating insights directly into business decision-making processes.
- Data Quality Assurance: Implement data quality controls, ensuring accuracy and consistency across data sources; rectify any data quality issues.
- Collaboration and Support: Work closely with IT, database administrators, and business analysts to align data service enhancements with organizational goals and user needs.
- Continuous Improvement: Stay updated with the latest industry trends and technologies in data management and analytics to bring innovative practices to our data services.
- Security and Compliance: Ensure that all data management practices comply with legal and regulatory requirements and company policies regarding data security and privacy.
- Documentation: Maintain comprehensive documentation of processes, data models, and reporting protocols to support data governance and compliance.
- Troubleshooting and Problem Resolution: Provide high-level support for data-related issues, including troubleshooting and resolving complex problems in the data infrastructure.
Requirements
- Proficiency in Microsoft SQL Server: Extensive experience in managing, optimizing, and administering Microsoft SQL databases.
- Expertise in Microsoft Azure Data Services: Strong understanding of Azure data solutions like Azure SQL Database, Azure Data Factory, and Azure Data Lake.
- Advanced Analytics Tools: Demonstrated experience with analytics and visualization tools, particularly Power BI.
- Data Modeling and Reporting: Skilled in designing data models and creating insightful, actionable reports.
- Programming Languages: Knowledge of SQL, Python, or other scripting languages commonly used in data manipulation and automation.
- Problem-Solving Skills: Excellent analytical and troubleshooting skills, with a proven ability to address high-level challenges.
- Education and Experience: Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field.
- At least 3-5 years of experience in a data engineering role with a focus on database optimization and analytics.
- Communication Skills: Strong verbal and written communication skills, capable of working collaboratively across various teams and explaining complex technical details to non-technical stakeholders.