Your competitors' favorite marketing platform used by 10,000,000 marketers
Senior BI Engineer
Location
Spain
Posted
6 days ago
Salary
0
Seniority
Senior
No structured requirement data.
Job Description
Senior BI Engineer
Semrush
Role Description Ensure solutions are scalable, maintainable, and secure, meeting both technical and business requirements. - Oversee the end-to-end development process, from initial concept to deployment of the BI Dashboards. - Lead hands-on development using report builder tools and custom coding where necessary. - Review and optimize performance of SQL statements. - Work closely with UX/UI designers to ensure user-centric design and functionality. - Partner with marketing and content teams to deliver flexible and easily manageable content solutions. - Engage with clients and internal stakeholders to gather and translate requirements into technical solutions. - Automate workflows where possible to reduce manual effort and increase efficiency. - Conduct thorough testing of all solutions to ensure stability, functionality, and performance. - Implement and enforce best practices for code quality, security, and compliance. - Act as a subject matter expert for customer facing BI dashboards and provide troubleshooting and issue resolution. Qualifications - 5+ years of experience in data analytics and developing analytical dashboards. - Strong SQL expertise, including query performance optimization (ideally with BigQuery). - Hands-on experience designing and building dashboards/reports following UX/UI best practices. - Experience in building and maintaining data pipelines. - Strong analytical skills with the ability to interpret data and derive actionable insights. Requirements - Experience working with APIs, webhooks, and 3rd-party integrations (e.g., Supermetrics, Funnel, Zapier) - Not required, but a plus. - Experience using Python for data extraction, transformation, and integration - Not required, but a plus. - Experience with digital marketing and SEO data - Not required, but a plus. Benefits - Unlimited PTO. - Hobby & team building budget allowance. - Employee Support Program. - Loss of family member financial aid. - Employee Resource Groups.
Related Guides
Related Categories
Related Job Pages
More Business Intelligence Developer Jobs
SAP SAC/PowerBI Consultant
3Core Systems, IncDelivering end-to-end SAP System Integration and IT Professional Services for Emerging Technologies
• Create complex dashboards, reports, and interactive visualizations using Power BI and SAP SAC • Connect, import, and model data from SAP BW, SAP HANA, and SQL sources • Develop PowerBI planning models and Advanced Formulas for financial or operational planning • Collaborate with stakeholders to define business requirements and translate them into technical specifications • Optimize dashboard performance, manage data pipelines, and maintain report stability
• Join a ~100-person team of experienced problem solvers building real products across Cloud, Data & AI, and Software Development. • Work across different data ecosystems, reporting tools, and business domains. • Handling varied analytical challenges across diverse sectors - publishing, banking, healthcare, and beyond.
• Develop proper specifications of data requests based on stakeholder needs • Transform requirements into actionable visualizations/reports • Design, develop, test, maintain, and support reporting solutions including new reports, visualizations, and dashboards
Power BI Lead
Partner One CapitalAt NetWitness, we believe in challenging the established mindsets, approaches, and product categories in the information security industry. Every product that we deliver to market is based on a core set of principles grounded in the major paradigm shifts in play and the implications that they have for our customers. Do the right thing – by our customers, employees, and shareholders...think long-term, but act with a sense of urgency. What we do matters – our work makes a difference in the world. We give a damn – about our customers, about what we’re doing, about each other...we’re in this together. We are a fun company – building cool products with technical insight that help our customers solve meaningful problems. Our mission is delighting our customers with everything we do. We provide thousands of customers around the world with essential security capabilities, leading with our Intelligence Driven Security Strategy and Vision, to protect their most valuable assets from cyber threats. With NetWitness’s award-winning products, organizations effectively detect, investigate, and respond to advanced attacks; reduce IP theft and cybercrime.
Role Description The Power BI Lead is the technical and architectural authority for all BI reporting across MCP/LOS. This person sets the standard - owns the semantic layer, governs the data model, mentors the analyst, and manages intake - while remaining hands-on building the most complex reports and dashboards. The role requires equal parts technical depth, design discipline, and stakeholder credibility across operations, IT/Engineering, and executive leadership. - Design and own the Power BI semantic layer (datasets, shared models, calculated measures) - Define the strategy for sourcing data from both MCP/LOS directly and the data warehouse/mart - Establish medallion or equivalent layering conventions for data freshness and reliability - Govern gateway configuration, scheduled refresh, and performance optimization - Define and enforce naming conventions, measure libraries, and report templates - Own workspace organization, access control, and row-level security (RLS) patterns - Establish version control and deployment pipeline practices (e.g., PBIP/Git) - Maintain documentation standards for datasets, measures, and data lineage - Build and own the most complex reports - executive dashboards, KPI scorecards, regulatory outputs - Write advanced DAX for complex time intelligence, ratios, and dynamic filtering - Design Power Query/M transformations from both MCP DB and warehouse sources - Review and approve analyst-produced reports before publishing to business stakeholders - Manage and prioritize the BI request intake queue across all stakeholder groups - Assign, scope, and review analyst work; provide technical mentorship - Represent BI capability in cross-functional planning and project discussions - Partner with IT/Engineering on data model changes that affect reporting Qualifications - Advanced Power BI Desktop - complex data models, composite models, DirectQuery - Advanced DAX - time intelligence, iterators, context transition, dynamic measures - Power Query / M - multi-source transformation, parameterization, error handling - SQL proficiency - query optimization, joins, aggregations against relational DBs - Familiarity with data warehouse concepts - star schema, slowly changing dimensions - Power BI Service administration - workspaces, deployment pipelines, RLS, gateway - Version control fundamentals (Git or equivalent) - Proven ability to define BI standards and enforce adoption across a team - Experience designing executive-facing dashboards with clear KPI storytelling - Mortgage/lending industry familiarity - pipeline metrics, pull-through, cycle time, regulatory reporting - Ability to translate ambiguous business asks into structured analytical requirements - Player/coach orientation - willing to stay hands-on while providing oversight - Comfortable presenting to and defending design decisions with executive stakeholders



