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.
Any graduate