SQL Data Analyst

Job Description:

Technical Requirements:

• Writing SQL scripts, queries, and stored procedures to extract data.

• Responsible for Data preparation, Data analysis and execution of requests that require data pull from various databases using SQL.

• Develops complex advancement reports using SQL, Microsoft Office and other utilities or languages as necessary.

• Performing ad hoc and structured data analysis

• Identify data issues proactively and flag them to respective stakeholders.

• Plan the development process and work towards meeting the defined timelines.

• Share the activity status report to immediate managers.

• Document the development procedure at every stage of the project.

• Uses modeling techniques and tools in analyzing and specifying data structure in large and/or complex data sets.

• Implements best practices in data management to ensure the integrity of the data, the quality of data processes and delivers analyzable or analyzed data to a variety of internal and external clients.

• Responsible for collecting and analyzing data to provide valuable insights.

• Manage databases, troubleshoot issues, and optimize performance.

• Generate reports and present findings to aid decision-making.

Qualifications:

• 7+ or more years of experience mining data as a SQL data analyst

• Attention to detail contextual grasp of business and industry trends strong attention to detail and solid organizational skills.

• Ability to write clearly composed documentation for business requirements documentation information that will be distributed to auditors.

• Advanced data modeling experience, SQL skills, and ETL design

• Database Administration tasks (work with DBAs to create new DBs, archive data, manage storage resources)

• Experience with advanced data analytics, data transformation and data management projects.

• Dimensional modeling and business intelligence support

• In-depth experience of analyzing data and creating reports, working with data to identify trends and make recommendations.