Senior Business Intelligence (BI) Developer

The Senior Business Intelligence (BI) Developer works collaboratively with the agile team and end users to develop reporting systems that provide accessible information for decision-making. They use the data platform and associated databases to solve organizational problems through reports, analysis, and data visualization. The Senior BI Developer will also provide data warehouse expertise with an emphasis on data design, access, usage, security, and quality of information assets.

Job Duties

• Design, develop, and manage reporting catalogs, including comparing new requests against existing inventory and making recommendations for adding or removing content
• Integrates identified strategies across multiple reporting programs/projects and ensures alignment with business strategies and management priorities
• Facilitate the inclusion of multiple disparate data sources located in the data platform/data warehouse into the overall reporting framework
• Collaborate with Principal Solutions Architects to ensure the data platform design/process is optimally aligned with reporting tool(s) for best performance and to enhance the 'end-user experience'
• Works collaboratively on project teams, systems and data analysis, design, development, integration, and enhancement activities, as well as related maintenance and more complex production support
• Assists and develops the project scope of multiple complex projects with assistance from the project team and serves as a project point of contact when necessary
• Participate in functional, technical, and user acceptance testing efforts and resolve identified defects
• Build and modify database tables and views and optimize SQL queries, indexes
• Contribute to the creation and maintenance of reporting best practices and standards
• Build effective partnerships with coworkers and coordinate overall efforts to contribute to the team, department, and organizational objectives

Required Experience

• 6+ years in business intelligence, developing/managing reports and data sources
• Demonstrated knowledge of developing a reporting architecture, dashboards, and portals with Power BI
• Demonstrated detailed knowledge of business intelligence security and administration concepts with Power BI
• Demonstrated detailed knowledge of Power BI technology & understanding of the Microsoft BI stack
• Demonstrated knowledge of proficiency in advanced-level computations on Power BI datasets
• Demonstrated knowledge of familiarity with MS SQL Server BI Stack tools and technologies such as SSRS, SQL, Power Query, MDX & DAX
• Experience with AWS and Redshift databases.
• Experience with writing and optimizing SQL
• Possesses strong oral and written communication skills, clearly and accurately communicating complex and/or technical information to both technical and non-technical audiences
• Knowledge of Data Warehouse concepts and tools
• Self-motivated; able to work within a project-based environment
• Ability to work in a team environment

Education: Bachelor's degree in Computer Science, Information Systems, or related field or commensurate years related work experience.