Sr. BI Analyst

3 months ago


SeaTac, United States Proliance Consulting Full time

We are looking for experienced analysts to help his lead analyst and BIE. These individuals will need to dive deep into the details of the data to help translate data into something consumable for our client's systems and visualization. One of the 3 data analysts will also support the Analytics Transformation project


Length: Through March 2025 – potential to extend to July 2025

Location: 5 days/week onsite – SeaTac, WA

Associate Vendors: We are accepting applications from candidates who are currently authorized to work in the US for any employer without sponsorship.


Role & Responsibilities

  • Develop and deliver financial insights reports within the first 60 days.
  • Ensure financial reports are accurate, timely, and critical for business decision-making.
  • Create integrated profitability reports to support key business decisions.
  • Translate data from the Snowflake cloud into our client's models for data ingestion and visualization.
  • Collaborate closely with the team to ensure seamless data migration and integration.
  • Work with the lead analyst and Business Intelligence Engineer (BIE) to deeply analyze data details.
  • Support the Analytics Transformation project by providing detailed data analysis.
  • Coordinate with the team to understand the architecture and field names of data.
  • Communicate effectively with stakeholders to ensure data translation meets business needs.
  • Utilize Azure Databricks, Python, SQL, Spark, and the Snowflake cloud data store for data processing and analysis.
  • Apply statistical data analysis and prorate experience to financial data mapping.
  • Assist in hiring two additional experienced data analysts to support the lead analyst and BIE.
  • Provide guidance and support to new team members as they onboard.
  • Leverage PySpark and customer-facing experience, if available.
  • Apply BIE skill sets, statistical data, and prorate experience to enhance project outcomes.
  • Utilize experience in mapping financial data (P&L) and integration to improve data accuracy and usability.
  • Bring any relevant airline data background to support project objectives.


Required Qualifications

  • Proficiency in using Azure Databricks for data processing and analysis.
  • Experience in developing and managing data pipelines within the Databricks environment.
  • Advanced skills in Python for data analysis, transformation, and automation tasks.
  • Ability to write efficient and scalable code to handle large datasets.
  • Strong knowledge of SQL for querying and manipulating data in various databases.
  • Experience in optimizing SQL queries for performance and efficiency.
  • Expertise in using Apache Spark for big data processing.
  • Experience in writing and maintaining Spark jobs for data transformation and analysis.
  • Proficiency in working with Snowflake for data storage and retrieval.
  • Experience in designing and implementing Snowflake schemas and data models.
  • Desired Qualifications


How Do I Apply?

Apply on this website or send an updated resume to recruiters@prolianceconsult.com.


About Proliance:

We are a technical & digital marketing staffing agency based in Seattle, WA that specializes in matching you with quality opportunities that meet your professional aspirations. We offer contract, contract to hire and direct placement services to top Fortune 500, mid-market, and emerging companies from a variety of industries. Our staffing success in the telecommunication, financial, insurance, retail, travel, healthcare, professional service and technology industries are how we've built a reputation for long-lasting, authentic relationships.


Follow us on Facebook, Twitter, LinkedIn, and Google+ for recent news and current openings.


Why Work for Us?

Proliance Consulting offers a competitive salary and benefits package which includes the following:

  • Medical: Proliance covers 50% of our employee’s premiums and 25% of any dependents on a plan administered through Regence.
  • Vision: Proliance covers 50% of our employee’s premiums and 25% of any dependents on a plan administered through Regence.
  • Dental: Proliance offers a plan administered by Delta Dental.
  • Retirement: Proliance offers a matching 401K savings plan for pre-tax or Roth retirement savings.
  • Direct Deposit: Proliance offers direct deposit to all employees.
  • Safe/Sick Time Off: Proliance offers accrued paid time off to all employees.
  • Paperless Pay Statements: Proliance offers the flexibility to view and manage your paycheck online.
  • Employee Referral Program: Proliance offers competitive bonuses for employee referrals.

Proliance Consulting provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Proliance Consulting complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfers, leaves of absence, compensation, and training.