IT Architect II - SQL/PowerBI/Python or R

Title: IT Architect II - SQL/PowerBI/Python or R

Talent Acquisition Data Engineering & Analytics Specialist

Specialty: Data Analytics / Data Engineering / Business Intelligence

Remote / Hybrid / Onsite: Remote (PST Hours) / Hybrid Available

Location: San Jose, CA or Rancho Cordova, CA

Applicants must be currently authorized to work in the United States on a full-time basis. Sponsorship is not available for this position now or in the future.

Our client is a leading technology organization. Based out of California, they are looking to hire a Talent Acquisition Data Engineering & Analytics Specialist on a Contract basis.

COOL PITCH

This is an opportunity to build an enterprise-scale Talent Acquisition analytics platform from the ground up. The successful candidate will own the complete reporting lifecycle, including data ingestion, transformation, dimensional modeling, and executive dashboard delivery. If you enjoy creating scalable analytics solutions, partnering with business leaders, and building systems that drive strategic decisions, this project offers significant visibility and ownership.

Contract Duration

12-month contract through June 2027 with potential extension based on business needs.

Required Skills & Experience

• Advanced Power BI development experience
• Strong DAX expertise
• Advanced SQL skills
• Experience with dimensional data modeling and star schemas
• Cloud data warehouse experience
• ETL/ELT pipeline development experience
• Python or R experience
• Experience translating business needs into measurable analytics solutions
• Bachelor's degree or equivalent practical experience

Desired Skills & Experience

• Snowflake experience
• Workday or SmartRecruiters experience
• dbt, Airflow, or Azure Data Factory
• Power BI Service administration
• Workforce or HR analytics experience
• API integration experience
• Git/version control
• Consulting or contract delivery experience

What You Will Be Doing

Tech Breakdown

• Power BI
• DAX
• SQL
• Python or R
• Snowflake, Databricks, BigQuery, Redshift, or similar cloud platforms
• Data Warehousing
• ETL/ELT
• API Integrations
• Data Modeling
• Power BI Service

Daily Responsibilities

• Build and maintain automated reporting pipelines
• Design and deploy dimensional data models
• Develop executive and operational Power BI dashboards
• Create reusable semantic models and KPI definitions
• Partner with business stakeholders to define reporting requirements
• Monitor data quality and reporting reliability
• Develop technical documentation and runbooks
• Support knowledge transfer and enablement activities
• Present findings and dashboard solutions to leadership

Benefits

• Medical Insurance - Four medical plans to choose from for you and your family
• Dental & Orthodontia Benefits
• Vision Benefits
• Health Savings Account (HSA)
• Health and Dependent Care Flexible Spending Accounts
• Voluntary Life Insurance, Long-Term & Short-Term Disability Insurance
• Hospital Indemnity Insurance
• 401(k) including match with pre and post-tax options
• Paid Sick Time Leave
• Legal and Identity Protection Plans
• Pre-tax Commuter Benefit
• 529 College Saver Plan

Motion Recruitment Partners (MRP) is an Equal Opportunity Employer. All applicants must be currently authorized to work on a full-time basis in the country for which they are applying, and no sponsorship is currently available. Employment is subject to the successful completion of a pre-employment screening. Accommodation will be provided in all parts of the hiring process as required under MRP’s Employment Accommodation policy. Applicants need to make their needs known in advance.