Sr BI Engineer

MW Partners is currently seeking a Sr BI Engineer to work for our client who is a leader in the media and entertainment industry.

Responsibilities and duties:

• Develop, maintain, and optimize business intelligence solutions, including data models, dashboards, and reports.
• Collaborate with cross-functional teams to gather requirements and ensure data solutions meet business needs.
• Ensure data quality and integrity by implementing data validation and monitoring processes.
• Create and manage complex SQL queries including those used in ETL scripts.
• Establish and maintain best practices for the design, development and support of BI solutions.
• Provide technical expertise and guidance to team members and stakeholders.
• Respond and resolve operational problems as necessary. Document, troubleshoot, and resolve day to day data issues.
• Process, clean, and validate the integrity of data to be used for analysis.
• Perform Tableau support work including training and provisioning access.
• Analyze large amounts of information to find patterns and solutions.
• Proactively and continuously pursue professional development and training

Requirements:

• Bachelor's or master's degree in business, economics, computer science, information systems, statistics, or similar quantitative field.
• 4+ years of business intelligence development experience including designing data models and developing BI dashboards.
• High proficiency in SQL.
• Proficiency in designing, developing, and managing SQL-based ETL pipelines using tools such as Airflow, dbt, or Databricks.
• Proficiency in Tableau
• Experience with cloud-based data warehouses (ex. Snowflake, Google BigQuery, Amazon Redshift).
• Experience collecting business requirements and building reporting solutions to convert large amount of data into usable information for analysts and business users.
• Familiarity with relational and dimensional database concepts and principles, data modeling, data warehouse design, and data management.
• Strong written and documentation skills for communicating specifications, processes, and metadata to both technical and non-technical audiences.
• Strong organizational, prioritization, and planning skills with an ability to work on multiple projects simultaneously and collaboratively with cross-functional units.
• Strong analytical and problem-solving skills with high attention to detail.

Nice to Have:

• Experience working with large and complex data sets generated by websites and mobile/tv applications.
• Experience with Python.
• Experience with Google BigQuery.
• Experience with Adobe Analytics, Google Analytics or similar digital analytics tool.
• Experience with git and git providers such as Github, Bitbucket, Gitlab.

For a confidential discussion or to find out more, contact Rhea Ann on (601) 436-6909 or apply now.