Kelly Services BI Analyst (Tableau and SQL) in Portland, Oregon
BI Analyst (Tableau and SQL)
Duration: 6 Months Location: Portland, OR 97201
Here is a short summary of what you will be doing: The Business Intelligence Analyst will assist in developing analytical models and dashboards that transform mass amounts of data into information that answers critical questions presented by business units. Requires a minimum of 2 years of experience performing data analytics that includes advanced competencies in SQL, Excel, report writing, and working with relational databases. Preferred skills are SSRS and Tableau.
The Business Intelligence Analyst will assist in developing analytical models and dashboards that transform mass amounts of data into information that answers critical questions presented by business units. The Analyst will be a subject matter expert in various data tool sets and contribute to enabling analytics across the organization. This includes responsibility for report creation of operational data using standard reporting tools such as Tableau, Excel, and SQL to access and compile analytics for key performance metrics and critical measures.
Report-writing SQL knowledge. We use SQL Server and would need someone familiar with the various Microsoft relational database products (primarily SSMS and SSRS). We don’t need someone skilled in ETL processes or writing stored procedures, but we do need someone competent at writing typical reporting SELECT statements utilizing table joins, subqueries, etc.
We need someone familiar with creating reports in Tableau utilizing both custom SQL data sources as well as published Tableau Server data sources. Familiarity with the Tableau server environment and the ability to trace published data sources back to their original SQL in order to troubleshoot the SQL code would be extremely helpful.
We also need someone with familiarity writing SSRS reports from scratch, and troubleshooting existing SSRS reports from both the data source and dataset side of it as well as the display side of it.
Familiarity with the concepts of Kimball-style data warehousing concepts would be a plus, but not a requirement.
Finally, on the non-technology side, our ideal contractor would be someone comfortable asking questions instead of making assumptions, and someone extremely detail-oriented. There will be a lot of tedious troubleshooting of numbers not matching between systems, etc., and we need someone willing to push through long, complicated research projects to make sure the final reports are accurate. Someone comfortable working with users to gather requirements and to gather a business-perspective when troubleshooting discrepancies would be extremely helpful.
Why Kelly ® ?
With Kelly, you’ll have direct connections to leading IT organizations in the best companies around the globe—offering you the chance to work on some of today’s most intriguing, innovative and high-visibility projects. In a field where change is the only constant, our connections and opportunities will help you take your career exactly where you want to go. We work with 95 of the Fortune 100™ companies, and more than 3,000 IT hiring managers turn to us each year to access the best talent: people like you.
Last year we found 8,000 opportunities for IT professionals. Let us help advance your career today.
About Kelly Services ®
As a workforce advocate for over 70 years, we are proud to directly employ nearly 500,000 people around the world and have a role in connecting thousands more with work through our global network of talent suppliers and partners. Revenue in 2017 was $5.4 billion. Visit kellyservices.com and connect with us on Facebook , LinkedIn and Twitter .
Kelly Services is an equal opportunity employer including, but not limited to, Minorities, Females, Individuals with Disabilities, Protected Veterans, Sexual Orientation, Gender Identity and is committed to employing a diverse workforce. Equal Employment Opportunity is The Law.
- Kelly Services Jobs