BI Data Analyst Job Description Template
Our company is looking for a BI Data Analyst to join our team.
Responsibilities:
- Analyzing data and effectively communicating findings to stakeholders;
- Creating new business intelligence and automation services and support to address emerging needs;
- Leading the development and implementation of advanced recurring automated report and dashboard solutions in support of business objectives;
- Interpret data, analyze results using statistical techniques and provide ongoing reports;
- Build predictive models;
- Build and maintain data warehouse using Snowflake, sourcing data from a variety of data sources;
- Write data transformation scripts, as necessary, to integrate all data across organization;
- Create informative data visualizations to communicate data insights to business stakeholders;
- Acquire data from primary or secondary data sources and maintain databases/data systems;
- Define KPIs, create reports and dashboards using large data sets;
- Understand, analyze complex data models and tell a story from data;
- Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality;
- Support and maintain dashboards and data refreshes;
- Identify, analyze, and interpret trends or patterns in complex data sets;
- Work with management to prioritize business and information needs.
Requirements:
- Documentation of business rules, processes,
- SQL Postgres, Redshift (AWS);
- Oracle/ SQL;
- Business Intelligence system experience; Birst, Tableau, MicroStrategy preferred;
- Basic understanding of data tools (databases, reporting, analytics);
- Proficient with MS Excel;
- Experience building predictive models. SAS or R skills required;
- Technical expertise regarding data models, database design development, data mining and segmentation techniques;
- Strong SQL skills. Experience with Microsoft SQL server and Snowflake;
- Bachelor’s in computer science or related field;
- Knowledge of statistics and experience using statistical packages for analyzing datasets (Excel, Access, SPSS, SAS etc.);
- Experience with data models and data analytics;
- Bachelor’s degree in business or I.T. related discipline accepted;
- Extensive experience and Expert level knowledge in Tableau. Experience with other BI platforms a plus;
- BS in Mathematics, Economics, Computer Science, Information Management or Statistics.