Senior Data Warehouse Analyst
Senior Data Warehouse Analyst
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Responsibilities:
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 nontechnical audiences.
Collaborate with data engineers BI developers and other team members to deliver data solutions.
Stay uptodate with the latest trends and technologies in data warehousing and business intelligence.
Qualifications:
Bachelors degree in Computer Science Information Systems Business Analytics or a related field.
6 years of data experience with 35 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.
Handson experience with at least one major business intelligence and data visualization tool (e.g. Tableau Power BI Looker).
Excellent analytical problemsolving and data interpretation skills.
Strong communication (written and verbal) and presentation skills.
Ability to work independently and as part of a collaborative team.
Detailoriented with a strong focus on data accuracy and quality.
Experience with cloudbased data warehousing platforms (e.g. AWS GCP)
Remote Work :
Yes
Employment Type :
Fulltime
Employment Type
Remote
