Fulltime Senior SQL Developer with Power BI expertise - San Ramon, CA
Apply on
Senior SQL developer
Full-time role with Epik Solutions-Permanent Opportunity
Location: San Ramon, CA
The role requires the first two weeks of Fully onsite work and then a transition to Hybrid work schedule (2 times a week onsite)
Salary Range: $100,000 - $120,000 annually + Benefits
About the Role:
As a senior SQL developer, 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 to support our business objectives. You will also be responsible for designing, developing, and maintaining complex DAX related solutions The ideal candidate will have extensive experience in SQL development, PowerBI, strong problem-solving skills, and the ability to work collaboratively in a dynamic team environment.
Key Responsibilities:
SQL:
- 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.
- Collaborate with cross-functional teams to gather and analyze business requirements
and translate then into technical solutions. - Troubleshoot and resolve database-related issues in a timely manner.
- Create and maintain documentation for database schemas, data flows, and processes.
Power BI:
- Design and development of Power BI dashboards and reports that provide actionable insights to business stakeholders.
- Manage the entire life cycle of Power BI solutions, from requirements gathering to deployment and maintenance.
- Optimize Power BI dashboards for performance and usability.
Qualifications: - Experience in designing and implementing SSIS packages for ETL processes.
- Proficient in writing complex SQL queries, stored procedures and triggers.
- 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.
- Experience developing reports using Power BI, Tableau or other visualization tools.