$100,000–$130,000 Per Year
Application Programming Interface (API), Automation, Best Practices, Business Analysis, Business Support, Cloud Computing, Cross-Functional, Data Analysis, Data Management, Data Modeling, Data Processing, Data Quality, Data Sets, Data Structures, Database Administration, Database Design, Database Extract Transform and Load (ETL), Database Technology, Database Triggers, Documentation, E Programming Language, Federal Laws and Regulations, Genetics, Identify Issues, Information/Data Security (InfoSec), Metrics, Microsoft SQL Server, Military, Performance Metrics, Performance Tuning/Optimization, Power BI, Problem Solving Skills, Process Flow, Python Programming/Scripting Language, Query Optimization, Regulations, Reporting Dashboards, Requirements Management, SQL (Structured Query Language), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Software Engineering, State Laws and Regulations, Stored Procedures, Team Player, Time Management
Sr. Data Analyst - SQL/ Power BI / Python (2 Openings)
Hiring Company: Epik Solutions
Fulltime w/Epik Solutions
Location: San Ramon, CA
The role may require First 2 weeks onsite and then transition to Hybrid Work Schedule (2 or 3 days a week onsite as per business needs)
Salary Range: $110,000 $130,000 annually plus benefits.
Job Description:
About the Role:
In this role, you will play a critical role in our data management and analytics initiatives. You will be responsible for designing, developing, and maintaining complex SQL queries, Stored Procedures, and database solutions and Power BI Visualizations to support our business objectives. The ideal candidate will have extensive experience in SQL and Python development, strong problem-solving skills, and the ability to work collaboratively in a dynamic team environment.
Key Responsibilities:
- Design, develop and optimize SQL queries, stored procedures, and database solutions to meet business requirements.
- Develop and maintain SSIS packages for ETL processes to integrate data from various sources.
- Utilize Python for data processing, automation, and ETL support tasks.
- Collaborate with cross-functional teams to gather and analyze business requirements and translate then into technical solutions.
- Troubleshoot and resolve database-related issues in timely manner.
- Create and maintain documentation for database schemas, data flows and processes.
Qualifications:
Years of experience --- (5+) years
SQL
- Must have Proficient in writing complex SQL queries, stored procedures and triggers.
- Experience in designing and implementing SSIS packages for ETL processes.
- Experience in other SQL Server components such as SSRS and SSAS is a Plus.
- Strong understanding of database design principles and normalization techniques.
- Experience with database performance tuning and optimization techniques.
Python
- Proficiency in Python programming language and strong understanding of native data structures.
- Experience using Python for data manipulation, automation, and ETL processes.
- Familiarity with libraries such as Pandas, NumPy, or similar for data analysis is a plus.
Power BI / Data Analyst
- Designed, developed, and maintained interactive dashboards and reports using Power BI to deliver actionable business insights.
- Translated complex datasets into clear visualizations by leveraging DAX, Power Query, and advanced data modeling techniques.
- Integrated data from multiple sources (SQL Server, Excel, APIs, cloud platforms) ensuring data accuracy, consistency, and performance optimization.
- Collaborated with cross-functional teams to define KPIs, track metrics, and support data-driven decision-making.
- Implemented row-level security (RLS) and governance best practices to protect sensitive information.
- Automated reporting processes, reducing manual effort and improving report delivery speed by X%.
------------------------------------------------------------------------------------------------------------------------------
Epik Solutions is an equal-opportunity employer committed to building a diverse and inclusive work environment. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, protected veteran status or disability status and any other classification protected by Federal, State and local laws. Qualified applicants with arrest records and/or conviction records will be considered for employment in a manner consistent with Federal, State and local laws.
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.