Position: Senior SQL Server Analyst
Company: Devtorium
Experience required: 5y
English level: upper

**Project Description:**
SMI, a global leader in providing independent and real advertising spend data, is seeking a skilled SQL Analyst. Our platform enables stakeholders such as media agencies, media owners, financial investors, and advertisers to make better decisions through a unified view of actual advertising demand across all media types and vendors.

The SQL Analyst will play a crucial role in providing data extracts to our customers by writing advanced SQL queries and troubleshooting existing ones.

**Requirements:**
- Extensive experience with SQL, including writing advanced queries and troubleshooting
- Proficiency in MS SQL Server 2014/2016
- Strong skills in T-SQL, including scripting, performance tuning, and troubleshooting
- Experience with data analysis and interpretation
- Excellent problem-solving skills, with a knack for turning complex data into meaningful insights
- Strong written and verbal communication skills
- Experience with Visual Studio Database Projects is a plus
- Ability to work both independently and in a collaborative team environment

**Scope of Work:**
- SQL Queries: Writing and optimizing advanced SQL queries that provide data extracts to our customers
- Troubleshooting: Identifying issues in existing SQL queries and implementing effective solutions
- Data Analysis: Analyzing SQL query results, interpreting the data, and providing insights to enhance customer understanding
- Process Improvement: Continually improving processes and systems for more efficient data extraction and analysis