Senior Business Intelligence Developer

Role Summary / Purpose

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.

Key Responsibilities

• Design, develop, and manage reporting catalogs, including comparing new requests against existing inventory and making recommendations for adding or removing content
• Integrate identified strategies across multiple reporting programs/projects and ensure 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
• Work collaboratively on project teams, systems and data analysis, design, development, integration, and enhancement activities, as well as related maintenance and more complex production support
• Assist and develop the project scope of multiple complex projects with assistance from the project team and serve 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 and 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
• Lead development and integration efforts for new or existing applications
• Troubleshoot complex system issues and provide solutions
• Mentor junior developers and assist in Agile project planning
• Ensure compliance with industry standards, security policies, and best practices

Requirements - Education & Experience

• Bachelor''s degree in Computer Science, Information Systems, or related field or commensurate years of related work 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 and 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, and DAX
• Experience with AWS and Redshift databases
• Experience with writing and optimizing SQL
• Knowledge of Data Warehouse concepts and tools
• Experience with Agile methodology, software lifecycle, and scrum ceremonies

Required Skills

• Proficiency in SQL, Python, Power BI, Java, .NET, AWS, and cloud-based technologies
• Knowledge of DevOps practices, cloud automation, ERP integration, CI/CD pipelines, and microservices architecture
• Experience with SCADA operations, Power BI, AWS Glue, Lambda, SNS, and SQS
• Understanding of security, compliance, and regulatory requirements and cybersecurity best practices
• Strong oral and written communication skills, clearly and accurately communicating complex and/or technical information to both technical and non-technical audiences
• Self-motivated; able to work within a project-based environment
• Ability to work in a team environment

Nice-to-Have / Preferred Skills

• Certifications in AWS, Microsoft Power BI, Salesforce, IT Project Management (PMP, Agile, SAFe) or DevOps methodologies