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