Hilton - McLean, VA

posted about 2 months ago

Full-time - Mid Level
McLean, VA
Accommodation

About the position

In this role, you will assist the Senior Manager in various project management-related tasks, ensuring that projects are completed efficiently and effectively. You will guide Analysts in their work, particularly in the completion of development and recurring reporting tasks. A significant part of your responsibilities will involve designing, developing, and testing SQL queries and stored procedures to support data analysis and reporting needs. You will also be tasked with developing data modeling concepts that will enhance the organization’s data architecture and reporting capabilities. Your role will require you to perform 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, streamlining the reporting process. Additionally, you will be responsible for identifying areas where the performance of queries and stored procedures can be improved, contributing to the overall efficiency of data retrieval and reporting processes. This position may involve approximately 10% domestic travel, allowing you to engage with various teams and stakeholders across the organization.

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.
  • Familiarity with 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