Data Analytics Lead - Dax, SQL, Power BI (TA/HR)
Opendoor
Key Requirements:
Power BI, SQL Server, DAX
Due to the rapid expansion of our operations in India we are seeking this key individual to join our analytics team. If you are passionate about data automation, analytics, and leveraging insights to drive organizational success, we invite you to join our innovative team. As a Data Automation Engineer specializing in People Analytics, you will have the opportunity to shape the way we use data to make informed decisions, optimize processes, and enhance employee experiences.
Primary Role
- Design, develop and maintain Power BI dashboards and reports to visualize complex data and provide actionable insights to stakeholders.
- Responsible for the ETL of multiple datasets including Google sheets, SQL Server and multiple API’s using Power Query, SQL or a programming language of your choice.
- Develop API data ingestion software.
Additional Responsibilities:
- Collaboration with cross-functional teams to ensure data integrity including building “Sources of Truth”.
- Collaborate with HR, Engineering and our other departments to understand their data requirements and translate these into effective data solutions that drive insights and operational improvements.
- Implement data quality checks and validation processes to ensure the integrity of the data ecosystem.
- Experience working with HR data, understanding HR processes, metrics, and analytics is a strong plus.
Requirements:
- 2+ years Power BI
- Dax programming experience
- 2+ years SQL
- Programming skills for data manipulation/cleaning and API interface
Nice to Have (but not required):
- Experience working with HR data, understanding HR processes, metrics, and analytics is a strong plus.
- Certification in DAX, Power BI, or related technologies
Next Steps:
As part of the interview process for this role we will be asking about your experience developing Power BI Dashboards for internal use within medium to large corporations. The technical part of the interview will be focused on your Dax programming skills and your ability to ingest and transform data from multiple sources and formats including API’s, Google sheets as well as your Dashboard and Reporting skills in Power BI