Exciting Career Opportunity for a Senior Data Analyst! You are a curious Data Analyst with a passion for uncovering discrepancies, tracing data lineage, and optimizing automated processes – if this sounds like you, we want you on our team! If you thrive in writing complex SQL queries and leveraging Python for automation and data analysis, this role is for you. Location: Sydney Job Type: Contract About INGRITY: INGRITY is a Microsoft data and AI solution partner, working closely with Microsoft to create value for our customers. We collaborate with some of the best ASX-listed companies and many medium-sized businesses, delivering transformative data and AI-driven solutions. Our success is built on innovation, customer advocacy, and our strategic partnership with Microsoft. At INGRITY: Imagine the Impossible: It's not just an aspiration for our clients; we expect the same from our team. INGRITY isn't your typical workplace; we thrive on the fusion of Intelligence & Grit. Prioritising personal growth, open communication, continuous learning, career progression, and accountability, we're on the lookout for individuals like you. Do you seek roles fostering personal growth, allowing you to excel? Do you flourish in a culture that values open communication and diverse perspectives? Are you passionate about expanding your skills and eager to join a company that invests in employee development? Are integrity and accountability at the core of your values? If you answered yes to any of these questions, we invite you to explore opportunities with us and join a team committed to data-smart excellence. About the Role We are seeking a highly skilled Senior Data Analyst with expertise in writing complex SQL queries and a strong background in Python for data analysis and automation. This role involves deep diving into large datasets, uncovering discrepancies, tracing data lineage, and optimizing automated processes. If you are passionate about data accuracy, query performance, and solving complex data problems, this is the perfect opportunity for you. Key Responsibilities Conduct in-depth data investigations to identify discrepancies and analyze how incorrect data propagates through systems. Write and optimize complex SQL queries to extract, transform, and analyze large datasets. Trace data lineage from source to target systems to ensure data integrity and completeness. Debug, optimize, and troubleshoot SQL-based workflows, stored procedures, and ETL pipelines. Leverage Python for data manipulation, automation, and enhancing analytical capabilities. Work closely with cross-functional teams to improve data quality, streamline data processes, and implement robust data governance frameworks. Identify lineage gaps, particularly where TMP rules depend on attributes such as country code. Develop and maintain documentation related to data pipelines, transformations, and business rules. Key Skills & Qualifications 7 years of experience in a similar role, with strong hands-on expertise in data analysis, investigation, and root cause analysis. Expert-level SQL skills, with experience in writing and optimizing complex queries, stored procedures, and handling large-scale databases. Strong proficiency in Python for data manipulation, automation, and statistical analysis. Hands-on experience with data lineage mapping and tracing data flows across multiple systems. Familiarity with ETL processes, metadata management, and data governance best practices. Experience working with automated processes, and transactional data. Knowledge of cloud platforms (AWS, Azure) and data warehousing technologies. Experience with data visualization tools (Power BI, Tableau) for reporting and data monitoring. Understanding of regulatory data requirements related to transaction monitoring and financial data governance. Ability to work in a fast-paced environment and collaborate with multiple stakeholders. Note : The candidate must have full working rights in Australia to be eligible for this role.
