Power BI & SQL Data Analyst

Socket.dev; Sacramento (CA); On-site; USD 65,000 - 90,000; Full time

Job summary

Socket.dev in Sacramento is seeking a Data Analyst to support Power BI reporting, data requests, and data quality initiatives. You will work with stakeholders and the Data Engineer to translate business questions into accurate, well-documented data outputs.

Responsibilities include developing Power BI dashboards, handling data requests with SQL, and contributing to data validation and documentation processes. Strong communication and problem-solving skills are essential.

Qualifications

• Bachelor's degree in data analytics, information systems, computer science, mathematics, statistics, or related field, or equivalent experience.
• 1-3 years of professional experience in Power BI, SQL, and data analysis; or demonstrable equivalent through internships, coursework, or independent projects.
• Strong SQL skills, including joins, aggregations, window functions, filtering, troubleshooting, and writing queries that answer business questions accurately.
• Hands-on Power BI experience: dashboards, semantic models, DAX measures, Power Query.
• Working understanding of data modeling and report optimization concepts, including relationships, filter context, model design, refresh behavior, and report usability.
• Strong analytical and problem-solving skills.
• Clear communication skills, including the ability to manage intake, clarify requests, provide status updates, and support non-technical users.
• Attention to detail and commitment to accurate, well-documented work.

Responsibilities

• Power BI Development: Develop, maintain, troubleshoot, and optimize Power BI dashboards, reports, semantic models, DAX measures, refresh behavior, and performance.
• Data Requests & Analysis: Clarify requirements, define metrics, and complete data requests using SQL, Power BI, and other tools.
• Data Quality: Investigate discrepancies, document findings, support validation, and maintain metric standards.
• Ticket Management: Triage, prioritize, resolve data-related tickets; document resolutions; escalate complex issues.
• Business System Support: Field data questions related to Power BI, Dynamics 365, and other systems from curated reporting datasets.
• Documentation: Document report logic, SQL queries, metric definitions, dependencies, and recurring processes in the knowledge base.

Skills

SQL

Power BI

Data analysis

Communication

Education

Bachelor's degree in Data Analytics

Tools

Dynamics 365

Python

Microsoft Fabric

Job description

Socket.dev in Sacramento is seeking a Data Analyst to support Power BI reporting, data requests, and data quality initiatives. You will work with stakeholders and the Data Engineer to translate business questions into accurate, well-documented data outputs.

Responsibilities include developing Power BI dashboards, handling data requests with SQL, and contributing to data validation and documentation processes. Strong communication and problem-solving skills are essential.