Lead Analyst - BI/DW - ETL & Reporting Developer
Core
Designing and creating data warehouses, ETL pipelines, and reporting elements to deliver high-quality data and actionable insights to end users.
Role type
Lead ETL Developer and BI Analyst
Builds
Scalable data warehouses, ETL pipelines, semantic layers (cubes), and reporting dashboards
Domain
Data Engineering and Business Intelligence
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Complex SQL query writing and performance tuning, ETL tool development (Pentaho, Talend, SSIS), Data modeling (dimensional), Big Data technologies (Snowflake), BI tool proficiency (Power BI, SAP BusinessObjects), Data pipeline design and implementation, Unit and integration testing, Requirement gathering from business stakeholders
Preferred skills
Java/.Net programming, Microsoft Azure, Data replication tools (Qlik Replicate, Oracle Golden Gate, Debezium), Semantic layer creation
Technologies
SQL, Snowflake, Pentaho, Talend, SSIS, Power BI, SAP BusinessObjects, Java, .Net, Microsoft Azure, Qlik Replicate, Oracle Golden Gate, Debezium
Responsibilities
Design and implement data extraction, transformation, and loading (ETL) processes; Create semantic layers and reporting elements including filters and hierarchies; Perform data and functionality validation and unit testing; Collaborate with business analysts to gather requirements; Mentor junior team members; Investigate and resolve data integration issues within ETL pipelines; Maintain and improve existing data processes and architectures
Seniority
Senior, hands-on IC with leadership responsibilities
