Job Description

The Senior Business Intelligence Engineer, Decisions Sciences role will require partnering with key internal (intra-team and cross-disciplinary) stakeholders to implement automated reporting deliverables and work with our broader team to contribute to and evolve our automation and reporting services. The ideal candidate will be able to help support the team in development work by unifying multiple data sources and evolving our process to create and maintain reporting and analytical tools. Additionally, they will be able to act as a subject matter expert and be a partner to our internal teams.

You'll be responsible for:

The Senior BI Engineer will be responsible for interacting with internal and external stakeholders to develop products and services focused on data automation. They will ingest data in our database from multiple sources using API calls and ETL tools, manipulate data for reporting using SQL to consolidate dimensions and metrics across tables, link the SQL view to a variety of visualization tools, and customize the reports to meet the customers’ needs. Additionally, the Senior BI Engineer role will require work with Javascript to automate anomaly detection.

Work with the internal teams, external partners, and the client to assess automation needs
Build tools that expand upon automation via 3Q’s existing systems
Take lead on projects and contribute to the evolution of processes by working with the team as well as independently with the goal of driving efficiency
Manage creation, implementation, validation and ongoing support of data visualization tools and recurring reports
Serve the client as an expert on data visualization best practices
Grow credibility with internal and external stakeholders by exceeding expectations and delivering valuable products and services
Develop and refine best practices and documentation around onboarding and usability
Contribute to the company's knowledge base by creating and sharing case studies and POVs
Develop logic to create an alert system for anomaly detection using Javascript

You'll need to have:

Expertise with data visualization tools such as Tableau, Google Sheets, Data Studio, required
Advanced experience developing custom SQL
Experience with MS SQL Server, Snowflake, Azure or other data extraction, transformation and storage tools preferred
Knowledge of collecting and storing data using data transfer tools such as SSIS or Matillion, and experience with Secured Storage (sFTP, S3, etc.)
Requires excellent organizational, written, and communication skills
Ability to manage multiple tasks to completion within established deadlines
The ability and strong desire to innovate with strong problem solving, technical, and communication skills
Understanding of the digital analytics and marketing landscape preferred
Exposure to Javascript and anomaly detection or alert systems preferred
3-5 years of relevant work experience

Valid through: 1/23/2021