What are the responsibilities and job description for the Data Analyst position at Transglobal Services?
Location : Diamond Bar, CA
Work Model : Onsite (Mon-Fri)
Position Overview
We are seeking a highly skilled and detail-oriented Data Analyst to join our team. The primary responsibility of this role is to manage and streamline the flow of data between Snowflake , Azure Database , Power BI , and Excel to support the company's customized business needs. The ideal candidate will be proficient in data extraction, transformation, and loading (ETL) processes, with a focus on ensuring accurate and timely reporting through Power BI dashboards .
Key Responsibilities
- Data Extraction and Integration
- Extract data from Snowflake and Azure Database and import it into Power BI for further analysis and visualization.
- Export datasets from Power BI to Excel for additional ETL and customization tasks based on business needs.
- ETL Processes
- Conduct ETL operations using Excel to clean, organize, and transform raw data into meaningful formats.
- Develop and maintain custom Excel templates and processes to meet specific organizational requirements.
- Data Visualization and Reporting
- Load cleaned and processed data into Power BI dashboards for monthly reporting.
- Design and optimize Power BI dashboards to provide actionable insights for stakeholders.
- Collaborate with business units to ensure dashboards reflect key performance indicators and priorities.
- Data Quality Assurance
- Perform data validation to ensure accuracy and consistency across all reports.
- Identify and troubleshoot data discrepancies and recommend process improvements.
- Collaboration and Support
- Work closely with cross-functional teams to understand reporting needs and deliver customized solutions.
- Provide training and support to end-users on Power BI dashboards and Excel-based reports .
Qualifications
Preferred Qualifications
What We Offer