Job Title - Power BI Developer Location - New York, NY This title will create dashboards and reports using the PowerBI tool. 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. MicroStrategy)
- 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
- Supports deployment and training activities for developed solutions
- Support sustainment efforts, with a focus on the scoping of BI solution sessions with business lines to capture business objectives and prioritize opportunities.
- This position will play a primary role in the sustainment of the existing Power BI solutions under the management of the DOS EAM Department, with a focus on availability and maintenance as needs arise.
- Under the direction of the Report Development Lead, extract transform and load data, using SQL.
- Support the scoping of BI solution sessions with business lines to capture business objectives and prioritize opportunities
- Create mock-up reports for proof-of-concept reviews.
- Support and develop activities related to end-to-end data lifecycle management, including the review of data loads for accuracy and completeness.
- Support Business lead in developing system reporting solutions based on business needs.
- Support Business lead in creating, validating, executing and documenting test cases
- Assist in the development of end-user training and reference materials
- Perform or assist in end-user training
- Assist in implementation go-live and post-go-live activities
- Support requests from users to research system problems or errors, and to assist in their resolution
Qualifications:
- Proven experience as a BI Developer or Data Scientist
- Industry experience is preferred
- Background in data warehouse design (e.g. dimensional modeling) and data mining
- In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
- Familiarity with BI technologies (e.g. Microsoft Power BI, Oracle BI)
- Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
- Proven abilities to take initiative and be innovative
- Analytical mind with a problem-solving aptitude
- BSc/BA in Computer Science, Engineering or relevant field
- Experience developing and implementing Power BI solutions, including modelling, design, development and testing of data visualization or paginated report solutions
- Proficiency in Data Analysis (DAX), M, ETL (Power Query), SQL (or data extraction and integration tools) and performance optimization
- Strong ability to work on multiple initiatives simultaneously and work within tight deadlines
- Microsoft Power BI certifications or Azure certifications are an asset
- Experience working in an Agile project delivery model is an asset
- Understanding of complex relational database organization, design, and functionality.
- Ability to communicate clearly in conversation and in presentations to both technical and non-technical staff and to provide updates to all levels of management and stakeholders
- Ability to effectively prioritize and execute in a high-pressure environment
- Ability to independently set priorities and meet deadlines in a fast-paced environment, a self-starter
- Excellent inter-personal skills including the ability to work with individuals at all levels of the organization