Senior BI Engineer

JustAnswer is an online marketplace that is revolutionizing professional services by making fast, affordable expert help accessible to people everywhere. Hailed by The Huffington Post as “destined for glory,” our company is made of smart, hard-working people who know how to have fun and get things done. From doctors, lawyers, and vets to auto mechanics and tech support, the 10,000 experts on JustAnswer have helped over eight million people in 196 countries since 2003. Headquartered in the beautiful Presidio of San Francisco, our mission is simple and inspiring: “We help people.” JustAnswer, LLC is backed by investors Crosslink Capital, Glynn Capital, and Charles Schwab.

Responsibilities:

• Develop reporting and data-warehouse data structures together with applications that load them and report on them
• Develop and Maintain systems that interact with Paid Search vendor APIs including Google AdWords and Bing Ads
• Advocate for your architectural and design choices among your peers
• Ensure successful completion of stories by identifying and resolving blockers and other issues as they arise
• Promote effective Agile processes in teams and establish best practices
• Have creative ideas for continuously improving our processes, including CI/CD
• Engineer quality into our product with unit testing and integration testing
• Refactor the code base regularly
• Review designs and code of peer BI software engineers
• Work with stakeholders to balance business priorities with development time
• Work with Technical Operations to ensure deliverables meet service level objectives for run times and reliability

Requirements:

• 6-8+ years of experience in the delivery of data warehouse applications including ETLs and Reporting
• Expert knowledge of SQL (SQL Server preferred)? and at least one ETL platform (SSIS preferred)
• Experience writing code which calls APIs for the purpose of exchanging data
• Experience developing reporting/dashboard applications and cubes
• Experience in an Agile software development environment
• Ability to deliver consistently at a high level of quality within weekly Agile cycles
• Must be a creative problem solver who is self-motivated with effective communication skills and a track record of high productivity
• Experience in project planning and task prioritization
• BS or MS in Computer Science or equivalent work experience
• Schedule flexibility to collaborate with team members in San Francisco

Nice to have:

• Domain knowledge of PPC (Pay Per Click) and SEM (Search Engine Marketing)
• Knowledge of Google Analytics, Google Big Query
• Database Administrator skills in SQL Server

We offer:

• Time off throughout the year (paid and unpaid)
• Professional development support and encouragement
• Resources to help improve your overall well-being
• Free membership to dive into JA product

About us: 

JustAnswer is the best way to talk to doctors, lawyers, vets, mechanics and more in minutes—24/7. We connect customers with verified and vetted Experts to provide reliable answers at any hour and on any budget, democratizing professional services. Our mission is simple: we help people. 

Since 2003, JustAnswer has helped 10 million customers across 196 countries. JustAnswer is based in the Presidio and backed by Charles Schwab, Crosslink Capital and Glynn Capital Management.

Our culture 

Our hiring criteria: Smart. Fun. Get things done. We love what we do and celebrate our success together with regular happy hours, team offsites and amazing holiday parties (think renting out an island, taking over an arcade and cruising around the Bay on a chartered yacht). Perks include catered lunches on Tuesdays and Thursdays, medical/dental/vision, 401K with matching and more. Best of all, you get to work at a hot company that’s (drum roll, please) profitable!