Power BI Developer - New York, United States - HonorVet Technologies

Description

• 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

• 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