Sr Data Analyst - Reporting
Horizontal Talent

Job Description: We are seeking a skilled Data Analyst to join our growing analytics team. The ideal candidate will be responsible for gathering business requirements, tracking data, and delivering actionable insights. This technical role demands a strong background in writing complex SQL queries, experience working with business users to understand their needs, and a deep understanding of data flow and analysis processes. You will dive deep into data exploration with SQL Server and assist with report creation using Power BI. Familiarity with Azure Data Factory and Microsoft Dynamics is a plus.

Key Responsibilities:

• Collaborate with business stakeholders to understand data needs and translate business requirements into technical specifications.
• Ensuring that data being captured, processed, and reported is accurate and timely. This involves collaborating with various stakeholders (e.g., data engineers, business analysts, product teams) to resolve data discrepancies or delays.
• Design, develop, and optimize complex SQL queries to extract, manipulate, and analyze large datasets.
• Ensure data integrity and accuracy through regular validation, testing, and quality assurance of datasets.
• Assist in the development and maintain detailed reports and dashboards using Power BI, ensuring that key metrics and KPIs are easily accessible for decision-making.
• Assist in the integration of data from various sources, leveraging Azure Data Factory to manage and automate data pipelines.
• Collaborate with IT and business teams to continuously improve data processes and data management systems.

Required Qualifications:

• Proven experience as a Data Analyst or in a similar role with a strong understanding of business requirements gathering and tracking.
• Extensive experience writing complex SQL queries to extract, manipulate, and analyze large datasets.
• Strong ability to translate business requirements into clear data analysis and reporting solutions.
• Strong understanding of data modeling, data warehousing concepts, and database management.
• Strong attention to detail and ability to work with large volumes of data.
• Ability to effectively communicate technical information to non-technical stakeholders.
• Excellent problem solving, analytical, and critical thinking skills
• Excellent interpersonal and collaboration skills, with the ability to work in cross-functional teams

Preferred Qualifications:

• Experience working with Power BI or similar reporting tools to create interactive dashboards and reports.
• Experience with Azure Data Factory or similar for data integration, ETL processes, and automation.
• Experience with Microsoft Dynamics (or similar CRM/ERP systems) and its integration with data analytics platforms.

---