Job description

About Job Title : Data Analyst ( Data profiling & Reporting) Location : Cupertino, CA or Austin Education Qualification Bachelor's degree in Computer Science, Statistics, Mathematics, Economics, Business Analytics, Information Systems, or a related field. Experience • 5+ Years of IT Experience as Data Analyst or in similar role. • Proven experience in data requirements gathering, data profiling, and data analysis. • Experience with data quality management and data governance principles. Technical Skills • Expertise in data profiling and Data Modeling. • Experience with data visualization tools (e.g., Tableau, Power BI, Qlik Sense, Google Data Studio). • Solid understanding of database structures, data warehousing concepts and ETL processes. • Proficiency in SQL for data querying and manipulation. • Proficiency in Microsoft Excel (advanced functions, pivot tables). • Adept in translating business requirements into technical specifications. • Strong organizational skills and ability to manage multiple tasks concurrently. • Collaborative mindset and ability to work effectively in a team environment. • Ability to facilitate discussions and build consensus among diverse stakeholders. • Adept in Agile and Waterfall methodologies, known for delivering complex projects on time and enhancing efficiency. • Ability to work independently and collaboratively in a fast-paced environment. • Excellent analytical, problem-solving, and critical-thinking skills. • Excellent verbal and written communication skills, with the ability to present complex information clearly. Good To Have • Experience with statistical programming languages (e.g., Python, R). • Experience analyzing data from project management software (e.g., Jira, Microsoft Project, ServiceNow). • Experience with cloud-based data services (e.g., AWS Redshift, Azure Synapse Analytics, Google BigQuery). • Certification in data analytics or relevant technologies. Key Responsibilities • Collaborate with business stakeholders to elicit, analyze, and document data requirements for new business capabilities, functional enhancements, and reporting solutions. • Create, define, and document detailed requirements for data integration, migration, and transformation processes, including current-to-future state mapping and non-functional requirements. • Perform comprehensive data profiling and availability analysis by engaging with Subject Matter Experts (SMEs) and business representatives to understand existing data landscapes and sources. • Evaluate the quality of data, identify and interpret trends, patterns, and anomalies within complex datasets. • Define and document data quality rules for critical data elements . • Collaborate with data quality analysts and business stakeholders to implement strategies for data quality improvement and monitor their effectiveness. • Facilitate data harmonization discussions with global business stakeholders to ensure consistency and alignment of data definitions and usage. • Support data governance initiatives by participating in discussions, defining data standards, and assisting business stakeholders in understanding and adhering to governance policies for key data attributes. • Develop, maintain, and update data dictionaries , business glossaries , and metadata repositories for assigned data domains. • Participate in data testing and validation activities to ensure data accuracy, integrity, and fitness for purpose of solutions and reports. • Effectively communicate analytical findings, insights, and recommendations to both technical and non-technical audiences. • Work closely with cross-functional teams including business users, IT, data engineers, and project managers. Nice-to-have skills • Reporting • Data Modeling • Tableau • Power BI • Qlik Sense • Google Data Studio • SQL • Microsoft Excel • Python • R • Google BigQuery • JIRA • Microsoft Project • ServiceNow • Cupertino, California Work experience • Data Analyst Languages • English

Requirements