PowerBI Developer-Lead
Required Skills
- 10+ years of progressive experience in Database Development/Data Engineering/Data Warehouse/BI Reporting (Data Management) related functions/roles.
- 5+ years of professional experience in Reporting Applications. o Must have 3+ years working with PowerBI minimum; with ideal candidate having 5+ years of PowerBI. o Extensive experience in creating data visualizations and dashboards from scratch. o Experience driving requirements gathering process and designing visualizations and dashboards.
- 7-10+ years of SQL development: o Advanced knowledge of SQL, database technologies, and data warehouse design philosophies including dimensional modelling, Star, & Snowflake schema. o Expert SQL development skills including, but not limited to, table design, queries, table-valued functions, window functions, and index optimization.
- Knowledge of connecting to a disparate data stores and combine data to develop reports.
- Knowledge in financial risk reporting – KRIs and KPIs.
- Strong experience in SDLC, DevOps processes – CI/CD tools, Git, etc.
Additional Skills
Job Description
Vendors – we have a Business Intelligence Lead (PowerBI) role here for BNY. Candidates must be able to convert to FTE in future and must work on-site 2-3 days in Lake Mary, FL or Pittsburgh, PA. We will spend this week only reviewing local profiles (no relocations). Please feel free to send relocation candidates though as if we don’t find candidate locally, we will consider relocation candidate down the line.
Primary Functions/Job Description
- Works directly with business leaders to understand the business needs, critical path, and timeline to meet project goals.
- Develops business intelligence solutions to fulfill short and long-term priorities with solutions ranging from traditional, to more modern, interactive reporting tools.
- Leverages an analytic mindset to develop visualization of key trends and insights for decision making.
- Communicates/interacts with business partners up to the VP level.
- Collaborates with development team, project managers, and business analysts to determine requirements and develop solutions to meet business goals.
- Develops relational and dimensional data models to support reporting and analytics (SQL Server BI Platform).
- Assists leadership with advocating for and maturing the BI program using the latest methodologies as well as classic data warehouse and operational data store design patterns.
- Supports production reporting and data warehouse environments including shared after-hours rotation.
- Leads design and code reviews of BI solutions.
Qualification & Experience - Bachelor’s degree in computer science engineering or a related discipline, or equivalent work experience required.
- 10+ years of progressive experience in Database Development/Data Engineering/Data Warehouse/BI Reporting (Data Management) related functions/roles.
- 5+ years of professional experience in Reporting Applications.
- Must have 3+ years working with PowerBI minimum; with ideal candidate having 5+ years of PowerBI.
- Extensive experience in creating data visualizations and dashboards from scratch.
- Experience driving requirements gathering process and designing visualizations and dashboards.
- 7-10+ years of SQL development:
- Advanced knowledge of SQL, database technologies, and data warehouse design philosophies including dimensional modelling, Star, & Snowflake schema.
- Expert SQL development skills including, but not limited to, table design, queries, table-valued functions, window functions, and index optimization.
- Knowledge of connecting to a disparate data stores and combine data to develop reports.
- Knowledge in financial risk reporting – KRIs and KPIs.
- Strong experience in SDLC, DevOps processes – CI/CD tools, Git, etc.
- Knowledge of Scrum and XP methodologies and ability to work in a fast paced and rapidly changing environment.
- Strong analytical skills and attention to detail.
- Strong desire to improve data quality and performance.
- Knowledge in data pipelines and snowflake databases.