Title: Data Analyst – (Subcontract at a Core BTS Client)
Through Core BTS Resource Management Services (RMS), we offer custom talent solutions to help our clients meet their evolving technology and business needs. We help effectively match the right technology professional to their organization, recruiting for contract, contract-to-hire, and direct roles. Our client in (area/region) has an immediate need for a (job title). Please note that this is a (contract/contract to hire/direct hire) opportunity with our client and NOT with Core BTS.
Job Summary:
Our client is seeking a skilled Data Analyst to join their team to support their financial and operational decision-making processes through insightful data analysis and reporting. The Data Analyst will be responsible for extracting, cleaning, analyzing, and reporting on financial and operational data. This role requires proficiency in Power BI, SQL Server, Alteryx, and ERP systems to create interactive dashboards and provide actionable insights to various departments.
Key Responsibilities:
Data Extraction and Integration:
- Extract data from various databases using SQL queries, ensuring data integrity and accuracy.
- Pull data from ERP systems to analyze financial and operational performance.
Data Cleaning and Transformation:
- Use Alteryx to clean, transform, and prepare data for analysis, handling missing values, outliers, and ensuring data consistency.
- Utilize Power Query in Power BI to further clean and shape data.
Financial Analysis and Reporting:
- Create interactive financial dashboards and reports in Power BI to visualize key metrics such as revenue, expenses, profit margins, and other financial KPIs.
- Perform financial data analysis using SQL queries to identify trends, patterns, and insights.
Data Validation and Quality Assurance:
- Ensure the accuracy and reliability of financial data by validating it against predefined business rules.
- Regularly audit data processes to maintain high data quality standards.
Collaboration and Communication:
- Work closely with finance, operations, and other departments to understand their data needs and provide actionable insights.
- Present findings to stakeholders through reports and dashboards, making data-driven recommendations.
Automation and Optimization:
- Use tools like Alteryx to automate repetitive data tasks, improving efficiency.
- Continuously seek ways to optimize data workflows and reporting processes.
Support for Business Decisions:
- Provide data-driven insights to support strategic business decisions, such as cost reduction, investment opportunities, and performance improvement initiatives.
Qualifications:
- Bachelor’s degree in Data Science, Finance, Business, or a related field.
- Proficiency in Power BI, SQL Server, Alteryx, and ERP systems.
- Strong analytical and problem-solving skills.
- Excellent communication and collaboration abilities.
- Attention to detail and a commitment to data accuracy.
