Job Description

Key Responsibilities: SQL Expertise: Develop, optimize, and maintain complex SQL queries for data extraction, manipulation, and reporting. Perform database troubleshooting and resolve issues related to SQL performance and integrity. Collaborate with ops teams to understand data requirements and provide appropriate SQL solutions. Ensure data consistency and integrity by adhering to best practices in database management. Advanced Excel Skills: Proficient in Excel formulas and functions such as VLOOKUP, INDEX-MATCH, SUMIF, and array formulas. Design and implement PivotTables to summarize and analyze data. Apply advanced data validation techniques to ensure accuracy and consistency in data. Use conditional formatting and complex data analysis tools to derive actionable insights. Power BI (Basic Understanding): Support the creation of Power BI reports and dashboards, ensuring data is accurately represented. Assist in connecting various data sources to Power BI for analysis and visualization. Provide basic Power BI troubleshooting and assistance to team members. Communication: Clearly communicate technical concepts, data findings, and insights to non-technical stakeholders. Present reports, findings, and progress updates in a clear, concise, and impactful manner.