Talent Acquisition Data Engineering & Analytics Intern

This is a fully remote position, open to applicants in California.

📋 Description

• Establish and validate connections between Talent Acquisition source systems and Snowflake in collaboration with Data Engineering and IT.

• Configure Power BI connectivity and manage scheduled refreshes.

• Implement data quality checks and monitor refresh activities.

• Create a query-ready dimensional data model in Snowflake for requisition, funnel, and hiring activity analytics.

• Write and optimize SQL transformations for analysis-ready tables and historical or point-in-time reporting.

• Develop a comprehensive suite of Power BI dashboards that cover executive summaries, requisition and pipeline health, funnel conversion, time-to-fill, time-in-stage, offer metrics, sourcing effectiveness, recruiter workload, and operational SLA metrics.

• Construct a governed semantic model with certified DAX measures.

• Implement row-level security and enhance model performance to handle full data volume.

• Produce documentation detailing pipeline architecture, data lineage, model diagrams, measure definitions, and refresh/troubleshooting procedures.

• Create end-user guides and conduct enablement sessions for TA Operations and HR leadership.

• Collaborate with Talent Acquisition leadership to prioritize requirements, translate business questions into metrics, and provide walkthroughs and insights of dashboards.

• Deliver an operational Snowflake data pipeline, dimensional data model, Power BI dashboard suite, governed semantic model, automated refresh monitoring, documentation, enablement materials, and an analytics roadmap.

⛳️ Requirements

• Currently pursuing a graduate degree in Data Analytics, Data Science, Data Engineering, Computer Science, Information Systems, or a related field.

• Strong proficiency in SQL, including joins, aggregations, window functions, and query optimization.

• Hands-on experience in building dashboards using Power BI, including DAX measures and data modeling.

• Experience with Python or R for data extraction, transformation, and analysis.

• Working knowledge of dimensional data modeling and dataset design principles.

• Familiarity with ETL/ELT concepts and the ability to build or maintain data pipelines.

• Skill in translating ambiguous business questions into structured, measurable analytics requirements.

• Applicants must be authorized to work in the United States without requiring current or future visa sponsorship.

• Comfortable handling confidential candidate and employee data in accordance with Solidigm's data privacy and handling standards.

• Preferred: hands-on experience with Snowflake or a comparable cloud data warehouse.

• Preferred: experience in configuring automated refresh, scheduled jobs, or orchestration tools such as dbt, Airflow, or Azure Data Factory.

• Preferred: experience with Power BI Service administration, including workspaces, gateways, deployment pipelines, or row-level security.

• Preferred: experience with APIs or system-to-system data integrations.

• Preferred: experience handling large datasets in Azure, AWS, or GCP.

• Preferred: exposure to Git and analytics engineering practices.

• Preferred: familiarity with AI/ML techniques and an interest in applying them to workforce data.

• Preferred: a passion for HR, Talent Acquisition, or workforce analytics.

🏝️ Benefits

• Remote work eligibility.

• Flexible remote or hybrid arrangement if located near a Solidigm worksite.

• Part-time schedule of 20 hours per week.

• Six-month internship.

• Opportunity for hands-on experience with global Talent Acquisition data engineering and analytics.

• Enablement and professional development through documentation and training sessions.