What are the responsibilities and job description for the Sr Business Intelligence Analyst position at LUXURY BRAND PARTNERS?
Job Description
Job Description
Luxury Brand Partners, LLC has a full-time opening for Sr. Business Intelligence Analyst in Miami, FL. Duties are to build and maintain Data Warehouse for Sales, Accounting, and Supply Chain teams by bringing in data from multiple sources. Perform ETL (Extract, Transform, Load) to clean and organize data using Python and Apache Airflow. Write advanced SQL queries, T-SQL, and performance tuning of databases. Create and maintain MS Power BI report for different departments and executive team in the company. Perform server configuration, AWS cloud infrastructure management, and ODBC setup for different applications, scripts, and BI reports. Create complex DAX expressions and MDX queries as per the requirements of the report. Create automation scripts for Supply Chain using Python and Java. Build end-to-end machine learning solutions using AWS, Snowflake, and Python. Resolve production environment issues. Design infrastructure, perform complex upgrades, capacity planning, monitor server performance and usage, deployments, and releases. Transform and consolidate large and complex datasets into reports and dashboards that will lead to actionable insight. Performance Optimization : Optimize report and dashboard performance by improving data queries, data model efficiency, and report rendering speed. Tools and technologies used : IntelliJ, PyCharm, Git, Python, AWS, Snowflake, MS Power BI, Retool, and NetSuite. MINIMUM REQUIREMENTS : Bachelor’s degree or its foreign equivalent in Business Analytics or Information Systems. Higher degree accepted but not a minimum requirement. Plus 3 years of experience in the job or closely related occupation. SPECIFIC SKILL SETS : 3 years of experience with Power BI or Shiny or Tableau or similar tools; 3 years of experience with SQL 1 year experience with using ERP (specifically, NetSuite) database; 3 years RDBMS experience (MySQL, PostgreSQL, SQL Server, or Oracle, etc.); 2 yrs of experience in programming languages (Python, R, SQL, etc.); 6 months experience building robust ETL data pipelines. Short-travel required to attend meetings once a year to company HQ in Miami, FL. Remote / telecommuting benefits available but in-office presence required to attend meetings approximately once a year.
