Job Details
Experience Needed:
Career Level:
Education Level:
Salary:
Job Categories:
Skills And Tools:
Job Description
- The Business Intelligence (BI) developer is responsible for building, implementing, and supporting BI solutions for Union Coop.
- The right individual will possess experience in all stages of BI project work (requirements and logical design, physical design, implementation, testing, and deployment).
- The BI Developer should have a firm grasp of BI implementation methodologies and will have had in-depth experience with the Microsoft BI Stack (SSIS, SSRS, and SSAS), Power BI, and other Visualization tools like Tableu, Qlik, etc.
To qualify for the BI Developer position, the candidate should possess the following:
Analysis and Communication Skills
- Data gathering, research, and analytical abilities so as to develop insightful conclusions and generate solutions to address user needs
- Create written communication materials that effectively summarize findings and support recommendations
- Direct quality assurance and user acceptance testing by writing test plans and managing the execution of testing (Unit and UAT)
Responsibilities
- Translate business needs to technical specifications
- Design, build and deploy BI solutions (e.g. reporting tools)
- Maintain and support data analytics platforms (e.g. MS BI, Tableu, Algonomy)
- Create tools to store data (e.g. OLAP cubes)
- Conduct unit testing and troubleshooting
- Evaluate and improve existing BI systems
- Collaborate with teams to integrate systems
- Develop and execute database queries and conduct analyses
- Create visualizations and reports for requested projects
- Develop and update technical documentation
Job Requirements
REQUIRED SKILLS / EXPERIENCE:
- 3+ years of comprehensive report analysis and design experience with demonstrated knowledge of data warehouse/database structures.
- 3+ years of recent experience developing reports on SSRS and Power BI.
- 3+ years of recent experience writing complex SQL statements.
- Demonstrated experience working with business partners, development of functional and technical specifications, and general project management in service of the report development cycle.
- Strong communication skills with demonstrated experience managing development cycles and project management.
Technical Skills
The BI Developer should understand and have expertise in the various technologies needed to implement BI solutions. The developer must have experience with the Microsoft BI stack and exposure to other technologies is a plus (Oracle, IBM, Qlik, Tableu, etc.).
Specific technical skills desired include:
- Relational Database and SQL Language
- Extraction, Transformation, and Loading (ETL) (Microsoft SSIS)
- Data Warehouse / Solution Design
- Dimensional Modeling (Kimball Methodology)
- Analytics / OLAP Cube Development (Microsoft SSAS and MDX)
- Report Development (Microsoft SSRS, Power BI, Tableu)
