Deskripsi Pekerjaan
Affirm Data is looking for a talented and analytical SQL Writer to join our growing Information & Communication Technology team in a full-time, remote capacity. This is an exceptional opportunity for a data professional who thrives on transforming complex data requirements into elegant, efficient, and high-performance SQL scripts. As a core member of our data operations, you will play a pivotal role in ensuring our data systems are robust, scalable, and capable of delivering actionable insights.
At Affirm Data, we value precision and innovation. Our remote-first culture is designed for self-motivated individuals who excel in a collaborative environment without the constraints of a traditional office. You will work closely with data architects, software developers, and business analysts to document, develop, and optimize the data layer of our applications. Whether you are tuning slow-running queries or designing complex reporting structures, your contribution will directly impact our business intelligence capabilities and overall technical excellence.
The ideal candidate possesses a deep understanding of relational database management systems and a passion for technical writing. We are looking for someone who doesn't just write code, but creates clear, maintainable documentation that serves as a single source of truth for our technical ecosystem. If you are a SQL expert with a keen eye for detail and a desire to work for a forward-thinking company, we want to hear from you.
Tanggung Jawab
- Author and optimize complex SQL queries, stored procedures, and triggers to support application requirements.
- Collaborate with cross-functional teams to translate business needs into technical data specifications.
- Perform database tuning and query optimization to ensure maximum performance across various platforms.
- Develop and maintain comprehensive technical documentation for database schemas and data flows.
- Ensure data integrity and security by implementing best practices in script writing and data handling.
- Troubleshoot and resolve database-related issues in a timely and efficient manner.
- Assist in the design and implementation of ETL processes to facilitate seamless data migration and integration.
- Participate in peer code reviews to maintain high standards of code quality and consistency.
Kualifikasi
- Bachelor’s degree in Computer Science, Information Technology, or a related field.
- Minimum of 3 years of professional experience in SQL development or database administration.
- Expert proficiency in various SQL dialects (PostgreSQL, MySQL, or T-SQL).
- Strong understanding of relational database design, normalization, and indexing strategies.
- Proven experience in technical writing or creating detailed technical documentation.
- Excellent analytical and problem-solving skills with a high degree of attention to detail.
- Ability to work independently and manage time effectively in a 100% remote environment.
- Effective communication skills in English, both written and verbal.