Data Warehouse Specialist (Remote)

Data Warehouse Specialist | Aptita | India Urgent Hiring!!! Role : Dataware house Lead /Analyst Location : Remote Experience : 7+ years 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 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-8 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. ● Basic DBT understanding ● 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)