Senior Data Warehouse Analyst

Responsibilities Job Description Collaborate with business users, analysts, and other stakeholders to understand their data and reporting requirements. Translate business needs into clear and concise functional and technical specifications for data warehouse development. Analyze source system data to understand its structure, quality and potential for integration into the data warehouse. Work closely with developers to contribute to the design and implementation of logical and physical data models. Closely integrate with Quality Analysts to identify and troubleshoot data quality issues within the data warehouse. Assist in performance tuning efforts for SQL queries and data retrieval processes for business stakeholders. Participate in data quality initiatives, including defining data quality rules and monitoring data accuracy. Adhere to data governance/security policies and procedures. Assist in the creation and maintenance of data dictionaries and documentation. Effectively communicate technical concepts to both technical and non-technical audiences. Collaborate with data engineers, BI developers, and other team members to deliver data solutions. Stay up-to-date with the latest trends and technologies in data warehousing and business intelligence. Qualifications Bachelor's degree in Computer Science, Information Systems, Business Analytics, or a related field. 6+ years of data experience with 3-5 years of experience as a Data Warehouse Analyst or a similar role. Strong proficiency in SQL and experience querying large datasets across various database platforms (e.g., GCP, Snowflake, Redshift). Solid understanding of data warehousing concepts, principles, and methodologies (e.g., dimensional modeling, star schema). Good understanding on Affiliate Marketing Data (GA4, Paid marketing channels like Google Ads, Facebook Ads, etc - the more the better) Experience working with ETL/ELT processes and tools. Hands-on experience with at least one major business intelligence and data visualization tool (e.g., Tableau, Power BI, Looker). Excellent analytical, problem-solving, and data interpretation skills. Strong communication (written and verbal) and presentation skills. Ability to work independently and as part of a collaborative team. Detail-oriented with a strong focus on data accuracy and quality. Experience with cloud-based data warehousing platforms (e.g., AWS, GCP) Show more Show less