Data Analyst

Airswift has been tasked by a major client in the energy sector to find a qualified Data Professional for a long-term assignment at their headquarters in Berlin/Hartford, CT. This role is crucial for transforming data into strategic insights to support project monitoring and performance tracking. Join us to make a significant impact by leveraging your expertise in data analysis and reportingResponsibilities:• Data Transformation: Utilize Power Query to extract, transform, and load data from various sources for detailed reporting.• Database Management: Develop and maintain Access Databases to systematically organize data for reporting purposes.• Report Creation: Design and generate standardized weekly and monthly reports using Excel or Power BI.• Ad Hoc Analysis: Address ad hoc data requests and conduct comprehensive analysis to reveal trends and insights.• Data Accuracy: Ensure data integrity through rigorous validation checks and reconciliation processes.• Quality Assurance: Perform quality assurance on reports and data outputs to uphold high standards of accuracy.• Documentation: Document reporting processes and create instructional video guides for end-users.• Collaboration: Work closely with the Planning and Scheduling team to understand their needs and deliver effective tools.• Presentation: Present findings and recommendations to stakeholders in a clear and actionable format.• Process Improvement: Identify opportunities for automation and efficiency, and implement solutions.• Technical Development: Develop macros, scripts, or tools in Excel or Access to streamline repetitive tasks.Qualifications:• Power Platform Expertise: Proficiency in Microsoft Power BI, PowerApps, and Microsoft Flow; experience with DAX is highly desirable.• SQL Skills: Strong background in Microsoft SQL Server, T-SQL, and SSIS.• Data Science Knowledge: Familiarity with data science tools (e.g., R, NumPy, MatLab) and applied statistics (e.g., distributions, regression).• Excel & Access Proficiency: Advanced skills in Excel and Access, including VBA programming for development and enhancement.