Senior Data Analyst - SQL

SUMMARY:

POSITION INFO:

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.