Share this Job
Location: 

Southfield, MI, US

BI Administrator

 

Drive Your Career


Lear Corporation is the leading Tier 1 automotive supplier serving all of the world's major automotive manufacturers with our world-class automotive seating and automotive electrical products. Our products are developed and produced by a diverse, talented team of more than 165,000 people. With operations in 39 countries, Lear operates in every major automotive manufacturing region in the world. For our globally positioned and successful teams, we are looking for dedicated talents with zest for action and enthusiasm. If you love challenges, want to experience development opportunities unrestrained, and want recognition that pays off, then you've come to the right place with Lear.

 

BI ADMINISTRATOR

SOUTHFIELD, MICHIGAN –WORLD HEADQUARTERS

 

Lear is looking for a Business Intelligence Admin to join out talented project team in building modern data analytics platform for our business users. Ad a BI admin, your primary responsibility is to administer, maintain and manage various BI applications and servers including Windows Servers, Qlik Replicate, Pro2, SQL Server, Snowflake, Power BI, SSIS & SSRS servers.

 

The Role:

Your work will include, but not be limited to:

  • Administer, maintain, and manage Windows Servers, Qlik Replicate Servers, Snowflake, Pro2 & Power BI Premium capacity
  • Install Windows & application service packs, cumulative updates, and security patching as necessary
  • Creation and maintenance of Windows Tasks using the Task Scheduler
  • Design and develop End to End ETL & ELT tasks using to various sources and targets, including Log Stream tasks
  • Writing Snow SQL or other SQL languages queries, tasks, procedures, and user defined functions in Snowflake
  • Migration of the code from Development to UAT to Production in Snowflake is preferred
  • Development of Power BI dashboards or any other visualization tools
  • Migrating the Power BI Dashboards to different environments using the deployment pipelines

 

Your Qualifications:

  • In-depth understanding of Data Warehouse/ODS, ETL concepts, modeling structure principles, reporting tools and analytical tools
  • Experience gathering, documenting, and analyzing business requirements
  • Experience in converting business requirements into technical requirements
  • Experience working with Snow SQL & Power Shell
  • 1+ years of experience in implementing Qlik Replicate Server and upgrading to newer versions
  • 3+ years of working in Data Warehousing
  • 1+ years of experience in code migration from lower to higher environments
  • Experience working in the automotive industry or with other large manufacturing companies
  • 1+ years of working experience with Power BI or any other visualization tools
  • Proven analytical skills and problem-solving attitude
  • Fluent in English

 

Bonus If You Have:

  • 1+ years of experience working with Snowflake (preferred)
  • Experience working with Python is a plus

 

#LI-DNI

Lear Corporation is an Equal Opportunity Employer, committed to a diverse workplace.

 

Applicants must submit their resume for consideration using our applicant tracking system. Due to the high volume of applications received, only candidates selected for interviews will be contacted. Candidates must be legally authorized to work in the United States without sponsorship. Unsolicited resumes from search firms or employment agencies, or similar, will not be paid a fee and will become the property of Lear Corporation.

 


Nearest Major Market: Detroit