BI & Data Analytics Consultant, Tableau
Keyrus
ETLSQLTableau
Database Engineer II
SelectQuote Insurance Services
full-time
Posted on:
Origin: • 🇺🇸 United States
Visit company websiteSalary
💰 $100,000 - $115,000 per year
Job Level
JuniorMid-Level
Tech Stack
ETLMS SQL ServerPythonSQL
About the role
- Architect new and existing data warehouse solutions
- Responsible for architecture, development, and some ETL processes for SelectQuote’s data warehousing solutions
- Work on projects and tasks assigned by a project manager
- Look for warehouse improvement opportunities
- Conduct code reviews before code is deployed to production
- Troubleshoot stored procedures, TSQL code, and perform query tuning
- Collaborate with team members and provide/welcome feedback
- Could periodically travel to other office and operational sites
- No direct supervisory responsibilities
Requirements
- Experience developing in Microsoft SQL Server
- Strong understanding in data warehousing methodologies and dimensional modeling
- Proficient with SQL, indexes, refactoring, and tuning
- Troubleshoot stored procedures and other TSQL code
- Adequate performing query tuning techniques by leveraging execution plans and understands how to work with indexes
- Python is desirable but not required
- Bachelor's Degree in a related field or equivalent experience in BI and/or Data Warehouse experience required
- 2 years of related experience required
- Excellent communicator with individuals and groups at all levels
- Strong technical aptitude and enjoys working with data
- Detail oriented, organized, and able to manage expectations
- Proficient in time management and able to stay on task
- Strong analytical and critical thinking skills with a desire to learn
- Must be able to adjust when there is a shift in priorities