Data Analyst

Job Title: Data Analyst – SQL, Excel and Power BI (DFW Local Only)

Company: Upen Group Location: Dallas–Fort Worth, TX (Hybrid / In-Person)

Job Type: Full-Time

Company Overview Upen Group connects vendors to clients across the Dallas–Fort Worth metroplex, matching highly qualified data professionals with top-tier organizations. We are actively seeking experienced Data Analysts to fulfill immediate requirements for our local client partners.

Role Summary As a Data Analyst, you will be responsible for extracting, cleaning, and analyzing complex business data to deliver actionable insights. The ideal candidate possesses a strong technical foundation in SQL, advanced Excel, and data visualization tools, coupled with the ability to communicate findings effectively to key stakeholders.

Key Responsibilities

• Extract, transform, and validate business data to ensure accuracy and reporting integrity.
• Develop and optimize complex SQL queries for data extraction and analysis.
• Design, build, and maintain interactive dashboards using Power BI or Tableau.
• Utilize advanced Microsoft Excel functions (VLOOKUP, INDEX/MATCH, Pivot Tables, Macros) for financial and operational modeling.
• Identify data quality issues, reporting discrepancies, and market trends to drive strategic decision-making.
• Collaborate cross-functionally with technical teams and business leaders to gather requirements and present analytical findings.
• Create comprehensive documentation for reporting processes and analytical frameworks.

Required Qualifications

• Education: Bachelor's degree in Data Analytics, Computer Science, Information Systems, Business, Finance, Statistics, or a related discipline.
• Technical Proficiency: Demonstrable experience utilizing SQL, Advanced Excel, and Power BI or Tableau in a corporate environment.
• Analytical Skills: Proven ability to translate raw data into comprehensive visual reports and executive dashboards.
• Communication: Exceptional verbal and written communication skills with a track record of presenting complex data to non-technical audiences.
• Experience: Prior professional experience as a Data Analyst is highly preferred; relevant internships, academic capstone projects, and industry certifications will be evaluated.

Strict Eligibility Requirements

• Location: Must currently reside within the Dallas–Fort Worth (DFW) area. Candidates requiring relocation will not be considered.
• Work Authorization: Must be a U.S. Citizen or Green Card holder. Upen Group does not provide and cannot support OPT, CPT, H-1B, or any other employment visa sponsorship.
• Interview Availability: Must be available to participate in an initial Zoom screening with our HR team, followed by in-person interviews with our clients.

Application Process Qualified applicants will be contacted by the Upen Group HR team to schedule an initial Zoom consultation. Candidates who successfully complete the screening process will be connected directly with DFW-based clients actively hiring for this profile.

Pay: $43,700.00 - $68,900.00 per year

Work Location: Hybrid remote in Irving, TX 75038