Senior Data Analyst – SQL

Feb 6, 2025

Design data across the full range from fast/clean ETL streams through to automation. Ability to use big data technologies on AWS cloud services: Athena, Redshift, Lambda, Cloud Formation Stack, EMR. Ability to work with large data sources. Advanced knowledge of SQL (Oracle, Redshift, PostgreSQL).

  1. Writing and Optimizing SQL Queries:

  • Writing complex SQL queries to extract, manipulate, and analyze data from relational databases.

  • Optimizing SQL queries for performance, ensuring efficient execution on large datasets.

  1. Data Management:

  • Managing data import and export processes between databases or systems.

  • Ensuring data consistency, accuracy, and integrity across the database.

  1. Database Performance Tuning:

  • Analyzing and improving database performance using indexing, query optimization, and resource management.

  • Identifying and resolving database bottlenecks and performance issues.

  1. Data Analysis and Reporting:

  • Generating reports based on business requirements and analyzing data to provide insights for decision-making.

  • Do proof of concepts and refine logic for transformation of new data sources.

  • Creating stored procedures, triggers, and views to streamline reporting and analysis.

  • Wrangle financial data to provide reconciliations between different data sources and financial systems.

  • Write test cases to validate data transformations

  1. Collaboration with Other Teams:

  • Working with developers, system administrators, and other stakeholders to ensure data systems are aligned with business goals.

  • Providing SQL-related support for application development, ensuring smooth data interactions between applications and databases.

  1. Troubleshooting and Support:

  • Identifying and resolving data-related issues, including data corruption, missing data, inconsistent data, connectivity problems, or query performance issues.

  • Providing ongoing support for production databases, addressing user queries and performance-related concerns.

  1. Documentation:

  • Documenting SQL scripts, database schemas, and queries for future reference or use by other team members.

  • Maintaining clear documentation of processes and standards for database management and optimization.

  1. Compliance and Best Practices:

  • Ensuring code are compliant with industry standards, regulations, and best practices.

  • Staying updated on new SQL technologies, database tools, and best practices to ensure continual improvement.

  • These responsibilities can vary based on the size of the organization and the specific role of the SQL Specialist, but these are the common core duties associated with the position.

Desired Skills:

  • Time Management
  • Critical Thinking
  • Spreadsheet software
  • Judgment and Decision Making
  • Active Listening
  • Tax preparation software
  • Accounting Software

Learn more/Apply for this position