Hybrid Jr. Business Intelligence Analyst Jr. Business Intelligence Analyst with verification

Summary

The primary purpose of the Jr. Business Intelligence Analyst is to support company initiatives and contribute to the overall success of all Drew Estate data-driven objectives. This position will be a key contributor to measuring and tracking success metrics for the business.

The Jr. Business Intelligence Analyst will be responsible for supporting the day-to-day tasks related to Power BI reporting, Excel data analysis, and SQL queries. This role offers an excellent opportunity for recent graduates or entry-level professionals to develop their skills in data analysis and business intelligence within a dynamic and supportive environment.

Reporting Relationships

The Jr. Business Intelligence Analyst reports to the Sr. Manager of Business Intelligence.

Essential Duties & Responsibilities

Power BI Reporting:

• Develop, maintain, and update Power BI dashboards and reports to provide actionable insights to various business units
• Collaborate with senior analysts to design and implement data visualization solutions that meet business requirements
• Ensure data accuracy and integrity in all reports and dashboards

Excel Data Analysis:

• Perform data analysis and manipulation using Excel, including the use of advanced functions, pivot tables, and macros
• Assist in the preparation of regular and ad-hoc reports to support business decisions
• Conduct data validation and ensure consistency across different data sources

SQL Querying:

• Write and execute SQL queries to extract, manipulate, and analyze data from various databases
• Support the maintenance and optimization of existing SQL queries to improve performance and accuracy
• Assist in the documentation of data models and SQL scripts

Data Quality and Governance:

• Ensure data quality and consistency by performing regular data checks and validations
• Assist in the implementation of data governance policies and procedure

Collaboration and Support:

• Work closely with senior team members to understand business needs and translate them into technical requirements
• Provide support and training to end-users on how to effectively use Power BI reports and Excel tool
• Participate in team meetings and contribute to the continuous improvement of BI processes and tools

Skills and Attributes

• Strong proficiency in Microsoft Power BI and Excel, including advanced data manipulation and visualization techniques
• Basic understanding of SQL and experience writing and executing SQL queries
• Excellent analytical and problem-solving skills with a keen attention to detail
• Strong communication skills and the ability to work collaboratively in a team environment
• Ability to manage multiple tasks and prioritize work effectively
• Knowledge of database management systems and data warehousing concepts preferred
• Familiarity with programming languages such as Python or R a plus
• Bilingual (English/Spanish) a plus
• Excellent oral and written skills are a must
• Ability to work independently while delivering high-quality work and meeting planned deadlines
• Knowledge of relational databases and data warehouses and ability to solve data problems with code

Education and Experience Requirements

• Bachelor’s degree in Computer Science, Information Systems, Data Science, or equivalent work experience in a related field
• Experience with data visualization tools other than Power BI (e.g., Tableau, QlikView) preferred