Job Description
A client is looking for a SQL Data Analyst/Developer to join their team and sit onsite in San Ramon. They're seeking a Power BI Developer to build and maintain BI and analytics solutions that transform data into knowledge.
- Recognize business requirements in the context of BI and create data models to transform raw data into relevant insights
- Using Power BI, create dashboards and interactive visual reports
- Define key performance indicators (KPIs) with specific objectives and track them regularly
- Analyze data and display it in reports to aid decision-making
- Convert business needs into technical specifications and establish a timetable for job completion
- Create, test, and deploy Power BI scripts, as well as execute efficient deep analysis
- Use Power BI to run DAX queries and functions
- Create charts and data documentation with explanations of algorithms, parameters, models, and relationships
- Construct a data warehouse
- Use SQL queries to get the best results
- Make technological adjustments to current BI systems to improve their performance
- For a better understanding of the data, use filters and visualizations
- Analyze current ETL procedures to define and create new systems
Required Skills & Experience
- 4 years experience as SQL Data Analyst/Developer
- Ability to write complex SQL queries
- Experience building data pipelines
- Solid reporting and analytical experience and MS Access, VBA coding, development, and support.
- Should have experience in connecting to data sources, importing data, and transforming data for Business intelligence.
- Must have an experience in MS SQL (Performance Tuning, T-SQL SSRS/SSIS, Stored Procedures)
Nice to Have Skills & Experience
- Demonstrated experience in Power BI (DAX Queries, Data Visualization, Content Packs, Connectors)
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.