Power BI & SQL Developer | Data Specialist
Hiring Company: Epik Solutions
Location: Hybrid (2x a week) - San Ramon, CA
Duration of Assignment: Aug/17 to Dec/31
Pay rate Range : $55-65/hr. on W2 with Epik Solutions
Interview Process: Virtual + In person
Job Description:
We are looking for a Senior Power BI/ SQL Developer to join our Business Intelligence team. This role is responsible for building and maintaining Power BI dashboards backed by SQL-based reporting views, with hands -on involvement in our ongoing migration of the data platform to Snowflake.
Job Responsibilities:
- Design, build, and maintain interactive Power BI dashboards, semantic data models, and underlying schema that track operational performance, highlight trends, and support decision-making.
- Work closely with teams to understand reporting needs, connect, and transform data from multiple sources, and ensure accuracy and timeliness of reports.
- Set up permissions so users only see the data they are authorized to view, maintain version control, and perform regular data quality checks.
- Support migration of existing SQL views and procedures to snowflake.
- Handle ad-hoc reporting requests from business teams within agreed turnaround times.
- Perform manual data validation in Excel (pivot tables, lookups) to ensure report accuracy.
- This role will be a subject matter expert on Power BI and Excel (Snowflake is a plus), responsible for making sure data is accurate, accessible, and actionable.
Key Responsibilities
- Partner with operations and stakeholders to gather requirements and translate them into Power BI dashboards and reports.
- Develop, maintain, and enhance Power BI data models that support day-to-day operational decision-making.
- Create automated refresh schedules and data pipelines to ensure timely reporting.
- Build intuitive, interactive visualizations that highlight KPI trends, and variances for quick insight.
- Implement and maintain governance measures, including row-level security, version control, and data quality checks.
- Serve as the go-to resource for Power BI troubleshooting, performance tuning, and best practice guidance.
- Document data sources, logic, and report usage guidelines for consistency and knowledge sharing.
- Provide training and support to end users to maximize self-service analytics adoption.
- Apply data modelling best practices (star schema, relationships) for efficient report performance.
- Understanding complex relationships between tables and sources (fact/dimension, many-to-many).
- Demonstrated experience building KPI-driven dashboards for operational performance monitoring.
- Advanced proficiency in Power BI Desktop and Service, including DAX and Power Query (M) for custom transformations.
- Advanced modelling techniques like calculated columns, measures, and DAX expressions.
- Strong SQL and/or Python skills for querying and shaping data from a large variety of sources (e.g., SQL Server, Excel, Foundry, Snowflake).
- Demonstrated strong understanding of underlying data and its business purposes.
- Maintain documentation for data sources, business logic, and report definitions.
- Mix of project-based and ongoing reporting responsibilities.
Required Skills:
- Strong SQL: joins, group by views, stored procedures
- Power BI: DAX & Power Query
- Working knowledge of Snowflake, or ability to ramp up quickly; knowledge of Python is good to have
- Advanced Excel skills for data validation.
- Experienced with Jira
- Understanding of data modelling concepts and report performance optimization
- Good Communication skills to work directly with business stakeholders.
Epik Solutions is an Equal Opportunity Employer. All qualified applicants are encouraged to apply and will receive consideration for employment. All employment decisions at Epik are based on business needs, job requirements and individual qualifications and merit, without regard to race, color, religion, sex (including pregnancy and gender identity), national origin, political affiliation, sexual orientation, marital status, disability, genetic information, age, membership in an employee organization, parental status, military service, or any other status protected by applicable law or regulations. Epik participates in the E-Verify program.
Never miss an opportunity! Create an alert based on the job you applied for.
