Business Intelligence Data Analyst
This is an exciting opportunity for a skilled Business Intelligence Data Analyst to join our team. As a key member of the organization, you will play a critical role in designing, developing, and maintaining robust data models to support analytical and product data needs across the organization.
Responsibilities:
* Data Modeling: Develop and maintain data models that meet business requirements, ensuring data quality, reliability, and performance.
* Reporting and Dashboarding: Build visually appealing, high-performing reporting and dashboard products using tools like Tableau/Sigma, providing insights into large datasets.
* Collaboration: Work closely with data engineers, data scientists, and business stakeholders to understand data requirements and translate them into scalable data solutions.
* ETL/ELT Processes: Implement and optimize ETL/ELT processes to ensure data quality, reliability, and performance.
* KPIs and Measurement Plans: Own and define business KPIs, their measurement plans, data requirements, and reporting.
* Reporting Processes: Build processes to ensure correct, timely, and reliable reporting.
* Ad-hoc Reporting: Address ad-hoc reporting requirements and find pathways for automation.
* Design Patterns: Build and enforce common design patterns to increase report reusability, readability, and standardization.
Requirements:
* 7+ Years of IT Experience: Proven experience in IT with a focus on business intelligence, data analytics, or a similar role.
* Strong SQL Skills: Expertise in SQL and experience with data modeling techniques (e.g., dimensional modeling, 3NF, data vault).
* Programming Language Proficiency: Proficiency in a programming language such as Python or Scala.
* Reporting and Dashboarding Tools: Experience building reporting and dashboarding solutions using Tableau, Sigma, Data Lake/Snowflake, or similar ecosystems.
* Database Fundamentals: Expert knowledge of database fundamentals, SQL, and performance tuning.
* Communication Skills: Excellent communication skills with experience working with technical and non-technical teams.
* Strategic Thinking: Ability to think strategically, analyze, and interpret market and consumer information.
Nice to Haves:
* Real-time Data Processing: Experience with real-time data processing and streaming technologies.
* Modern Data Warehousing Platforms: Familiarity with modern data warehousing platforms (e.g., Snowflake, DataBricks, Redshift) and knowledge of data visualization tools (e.g., Looker, Tableau).
* Machine Learning Concepts: Familiarity with machine learning concepts and their data requirements.