Job details
Job type full-time
Full job description
Description:
The bi developer will support the data engineering team, working close with business users, you’ll be responsible to support end user data needsThis position requires to be able to convert business needs in technical requirements to support bi team to build the robust multi cloud dwBusiness acumen or the desire to dig deep into the details focused on the customer experience & revenue generation is desired.
Ability to partner with the business in an extremely agile, iterative, and collaborative process to generate “simplified” operational and business views of a very complex and fragmented set of enterprise sales and operations data.
Experienced and comfortable with production prototyping and devops type delivery.
Hands on experience with bi / data analysis, collecting business needs and converting those into technical reporting and dashboardsAct as liaison between the end users & tech team.
Support users in the learning process for the reporting tools, user training on the data platform
Skilled communication, data presentation and storytelling skillsPromote the self-service bi culture.
Create and maintain replicable and scalable data pipelines for data generation, integration and dashboards displaying the metrics to facilitate business decisions.
Maintain the dw standardization guidelines and methodologies, design sampling strategies to achieve the precise metrics of data standardization algorithms and ensure the quality of assessment.
Experience conducting quantitative and qualitative financial & operational analyses working with complex unstructured datasetsExperience in project scoping, process-design, ba and pm work.
Understand descriptive, predictive, prescriptive and diagnostic analyticsFamiliarity with advanced analytics and data science techniques to support data mining, forecasting and predictive modeling.
Maintain web analytics platform to track and analyze site visits, conversions, promo tracking, hit maps etcExperience with tools like google analytics, heap, matomo etc.
Requirements:
5+ years of experience with reporting tools like google data studio, power bi, ms excel, looker, tableau, etcProficiency with tsql, python, r etc.
Assemble large and complex heterogeneous data sets that meet functional/non-functional business requirements under the big data frameworks i.eAdls, hdfs, hive, spark.
In-depth understanding of rdbms systems and usage of olap, oltp for bi needs - ms sql, my sql, maria db and oracle hands on experience preferred.
Demonstrated data visualization experience (power bi / ssrs / tableau / looker / google data studio)Etl experience such as ssis, segment, azure data factory, data prep etc.
Ability to write complex sql, cohort / comparative analysis, and data modeling skillsStrong knowledge of data warehousing and multidimensional data modelingMultidimensional vs tabular data modelingStar schema vs snowflake, fact & dimension tables etc.
Technical expertise with db design / development, etl, data mining and segmentation techniques, handling large volumes of data and building scalable systems
Knowledge of back-end and front-end technologies: sql, html, .net, json, dax, mdx, ssas, etc.
Experience with gcp and ms azure, migrate legacy etl, reporting to multi-cloud dw environment.
Certification: microsoft azure / gcp data or dw engineer certification a plus
