Business Intelligence Developer

Domo Expertise

Experience in developing and managing dashboards and reports in Domo.

Proficiency in using Domo's ETL tools, such as Magic ETL, SQL DataFlows, and MySQL DataFlows.

Strong knowledge of Domo Cards, Domo Apps, and Beast Mode calculations.

Understanding Domo Workbench for data extraction and transformation.

Experience in integrating various data sources into Domo (APIs, databases, cloud storage, etc.).

2. SQL Proficiency

Strong expertise in writing optimized SQL queries for data transformation and reporting.

Experience in handling complex joins, window functions, and stored procedures.

Ability to create and manage database schemas, tables, and indexes for efficient querying.

Understanding of performance tuning and query optimization techniques.

3. Snowflake Knowledge

Experience in working with Snowflake as a data warehouse.

Writing efficient Snowflake queries and connecting Snowflake to Domo.

4. Data Modeling & ETL

Strong understanding of data modeling concepts such as star schema and snowflake schema.

Experience in data extraction, transformation, and loading (ETL) processes.

Knowledge of data governance, data quality, and best practices in BI development.

5. Dashboard Development & Reporting

Creating interactive and visually appealing dashboards in Domo.

Ability to work with stakeholders to gather reporting requirements and deliver actionable insights.

Expertise in Domo Analyzer for building and optimizing data visualizations.

Soft Skills

Strong analytical and problem-solving skills.

Attention to detail to ensure data accuracy and reliability.

Effective communication to collaborate with cross-functional teams.

Ability to work independently and deliver high-quality solutions.

Understanding of Agile methodologies and working in sprint-based development.

Job Responsibilities

Develop and maintain Domo dashboards, reports, and ETL processes.

Optimize SQL queries and Snowflake performance for reporting needs.

Work closely with stakeholders to understand business requirements and translate them into data solutions.

Integrate various data sources into Domo and ensure data accuracy and integrity.

Monitor and troubleshoot data pipeline issues, ensuring smooth data flow.

Automate data workflows and reporting processes using scripting and scheduled jobs.

Stay updated with the latest features and best practices in Domo, SQL, and Snowflake.