Senior BI Engineer

Summary

Join DEPT®, a pioneering technology and marketing agency, as a Senior Business Intelligence Engineer. Partner with internal and external stakeholders to implement automated reporting and contribute to evolving automation and reporting services. You will build tools, manage data visualization, serve as a data visualization expert, and develop anomaly detection logic using Python. This role requires expertise in data visualization tools and advanced SQL skills. DEPT® offers a collaborative environment and a comprehensive benefits package, including healthcare, 401k, PTO, paid holidays, and parental leave. The role is either remote or hybrid, with specific location requirements within 50 miles of select US cities.

Requirements

• Expertise with data visualization tools such as Tableau, Google Sheets, Data Studio is required
• Advanced experience developing custom SQL
• 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
• 3-5 years of relevant work experience

Responsibilities

• Work with the internal teams, external partners, and the client to assess automation needs
• Build tools that expand upon automation via DEPT’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 Python

Preferred Qualifications

• 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.)

Benefits

• Healthcare, Dental, and Vision coverage
• 401k plan, plus matching
• PTO
• Paid Company Holidays
• Parental Leave