Hilton - McLean, VA

posted about 2 months ago

Full-time - Mid Level
McLean, VA
Accommodation

About the position

As a Senior Analyst in Reporting Applications, you will play a crucial role in supporting the Senior Manager with various project management tasks. Your primary responsibilities will include guiding Analysts in completing development and recurring reporting tasks, ensuring that projects are delivered on time and meet quality standards. You will be tasked with designing, developing, and testing SQL queries and stored procedures, which are essential for data retrieval and reporting processes. Additionally, you will develop data modeling concepts that will help in structuring and organizing data effectively for analysis. Your role will also involve performing thorough analysis and validation of data to ensure accuracy and reliability. You will identify opportunities to convert ad-hoc report requirements into standardized report designs, which will enhance efficiency and consistency in reporting. Furthermore, you will be responsible for identifying areas where the performance of queries and stored procedures can be improved, thereby optimizing the overall data processing workflow. This position requires a proactive approach to problem-solving and a keen eye for detail, as you will be working with complex data sets and reporting requirements.

Responsibilities

  • Assist Senior Manager in project management-related tasks.
  • Guide Analysts on completion of development and recurring reporting tasks.
  • Design, develop, and test SQL queries and stored procedures.
  • Develop data modeling concepts.
  • Perform analysis and validation of data.
  • Identify opportunities to convert ad-hoc report requirements to canned report design.
  • Identify areas for queries/store procedures performance improvements.

Requirements

  • Master's degree in Data/Business Analytics or related field.
  • Two (2) years of experience as Data/Business Analyst or related field.
  • Experience with developing complex queries using SQL.
  • Proficiency in relational databases, SSRS/SSAS/SSIS, and Excel.
  • Experience with SQL Server and business intelligence tools (Tableau and PowerBI).
  • Knowledge of data modeling concepts and database design.
  • Understanding of data quality concepts and methodologies.
  • Experience in converting ad-hoc report requirements to report design.
  • Ability to clean data using Python.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service