Business Intelligence Developer

1 week ago


Newport Beach, California, United States Agility Partners Full time

About this Role

Agility Partners is seeking a skilled professional to fill a Business Intelligence Developer position. This role will involve working closely with the Data and Analytics department to validate and test customer data flows, collaborate with data engineers, and contribute to the overall data integration process.

The ideal candidate will have a strong understanding of SQL, modern data tools including Power BI and Snowflake, and a proactive approach to problem-solving.

In this role, you will:

  • Validate and test incoming customer data, ensuring its accuracy and completeness before it is sent to accounting.
  • Collaborate with data engineers to identify and address data gaps, upstream changes, and downstream impacts.
  • Investigate edge cases, particularly in relation to customer interactions (e.g., various ordering methods).
  • Write SQL queries to support manual testing, including searching for nulls and unexpected values.
  • Transition manual testing processes to automated tests using DBT and other tools.
  • Develop and maintain Power BI reports for ongoing business needs.
  • Engage in a fast-paced environment, adapting to changing data structures and requirements.
  • Proactively communicate with development teams to understand data changes and validate the integrity of data transformations.

The Ideal Candidate

  • Proficient in SQL (SQL Server, Snowflake, Power BI, Azure Data Factory).
  • Familiarity with GIT for version control.
  • Experience with DBT in a development environment.
  • Understanding of SSRS and SSIS (legacy systems).
  • Strong analytical skills, with the ability to write queries and validate data.
  • Ability to work in a fast-paced, evolving environment and adapt quickly.
  • Excellent problem-solving skills and a proactive mindset.

Benefits and Perks

  • Work with modern toolsets including Snowflake, ADF, and DBT.
  • Enjoy a balanced work-life environment, free from excessive stress.
  • Experience a collaborative culture where your contributions are valued.
  • Benefit from catered Chipotle lunches on Mondays and a fantastic office view.
  • Engage in a dynamic team atmosphere with opportunities for professional growth.


  • Long Beach, California, United States SCAN Health Plan Full time

    About the RoleWe are seeking a highly skilled Business Intelligence Analyst to join our team at SCAN Health Plan. As a Business Intelligence Analyst, you will play a critical role in supporting organizational decision-making by transforming healthcare operations data into concise and actionable system solutions.Key ResponsibilitiesReview, analyze, and...


  • Long Beach, California, United States Relativity Space Full time

    At Relativity Space, we are committed to pushing the boundaries of aerospace technology and additive manufacturing. As a Business Intelligence Analyst II, you will play a crucial role in helping us achieve our audacious goals.Our Accounting team is responsible for the financial integrity of the entire organization. We collect and maintain the business's...


  • Long Beach, California, United States SCAN Health Plan Full time

    About SCAN Health PlanSCAN Health Plan is a not-for-profit organization dedicated to improving the health and well-being of older adults in the United States.We are committed to creating a workforce that reflects our community through inclusive programs and initiatives such as equal pay, employee resource groups, inclusive benefits, and more.As a Business...


  • Long Beach, California, United States Relativity Space Full time

    About the Role:We are seeking a highly skilled Business Intelligence Analyst II to join our team at Relativity Space. As a key member of our Accounting team, you will be responsible for translating reporting requirements into technical requirements and developing data models or dashboards that facilitate data-driven decision-making.You will work closely with...


  • Newport Beach, California, United States Chipotle Full time

    Transforming the Future of Food SecurityAt Chipotle, we're revolutionizing the way we think about food security. As an IT Security Engineer, you'll play a pivotal role in shaping our cybersecurity strategy, ensuring the integrity of our systems, and protecting our customers' data. With a strong focus on threat intelligence, you'll analyze security events,...


  • Newport Beach, California, United States Canterbury Consulting Incorporated Full time

    Business Development AssociateJoin Canterbury Consulting Incorporated as a Business Development Associate and play a pivotal role in raising capital from wealth managers for the firm's private capital solutions program.Key Responsibilities:Prospect, establish, and cultivate relationships with potential investors, including RIAs and wealth managers, by...


  • Newport Beach, California, United States Arthur J. Gallagher & Co. Full time

    About the RoleWe are seeking a highly motivated and results-driven Business Development Manager to join our team. As a key member of our sales team, you will be responsible for developing and acquiring new business revenue through sales to new and existing clients.Key ResponsibilitiesDevelop and execute sales strategies to drive revenue growth and expand our...


  • Newport Beach, California, United States AllView Real Estate Full time

    Business Development ManagerAt AllView Real Estate, we are seeking a highly motivated and results-driven Business Development Manager to join our team. As a key member of our sales team, you will be responsible for identifying and pursuing new business opportunities, building relationships with clients, and driving revenue growth.Key Responsibilities:Develop...


  • Newport Beach, California, United States Atlas Copco Full time

    Job Title: Business Development ManagerWe are seeking a highly motivated and experienced Business Development Manager to join our team. As a Business Development Manager, you will be responsible for managing a network of compressor and industrial distribution accounts across the West Coast region of the USA.Key Responsibilities:Prospect, source, and maintain...


  • Newport Beach, California, United States Fifth Third Full time

    Job SummaryWe are seeking a highly motivated and detail-oriented Business Development Associate to join our team at Fifth Third Bank. The ideal candidate will have a strong understanding of commercial banking and a passion for building relationships with clients.Key Responsibilities Partner with Relationship Managers to identify and develop client solutions...


  • Newport Beach, California, United States Lim Group Full time

    Job Title: Devoucoux Business ManagerAt Lim Group, we are dedicated to the partnership between horse and rider, and we are seeking a highly skilled Business Manager to join our team.Job Summary:We are looking for a dynamic and experienced Business Manager to lead our sales and marketing efforts. The successful candidate will be responsible for identifying...


  • Newport Beach, California, United States SmartFinancial , Inc. Full time

    Drive Growth and Success for Insurance AgenciesAt SmartFinancial, we're on a mission to empower insurance agents with cutting-edge technology. As a Business Development Representative, you'll play a key role in driving growth and success for our insurance agency partners.What You'll DoArrange webinar appointments with District Managers, Territory Leaders,...


  • Newport Beach, California, United States Fastway Aviation Group Full time

    Company OverviewFastway Aviation Group is a leading global flight operation specialist, supporting hundreds of monthly flights with its 3 global dispatch centers. We prioritize clients' smooth and successful flight operations.Job SummaryThis is a full-time remote role for a Regional Business Development Manager at Fastway Aviation Group. The successful...


  • Newport Beach, California, United States Fastway Aviation Group Full time

    Company OverviewFastway Aviation Group is a leading global flight operation specialist, supporting hundreds of monthly flights worldwide. Our global dispatch centers ensure seamless flight operations for our clients.Job SummaryWe are seeking a highly skilled Regional Business Development Manager to drive business growth in designated regions. The ideal...


  • Newport Beach, California, United States Bank of Montreal Full time

    Job SummaryWe are seeking a highly skilled and experienced professional to join our team as a Managing Director, Asset Based Lending. This is a key leadership role that requires a strong background in commercial banking, lending, and business development.Key ResponsibilitiesDevelop and execute business growth strategies to drive revenue and profitabilityLead...


  • Newport Beach, California, United States Michele Ellena - State Farm Agent Full time

    Job OverviewAs a key member of Michele Ellena - State Farm Agent's team, the Account Manager plays a vital role in driving business growth and customer satisfaction. The ideal candidate will possess strong leadership and interpersonal skills, with a proven track record of meeting sales targets. Key responsibilities include developing and maintaining client...


  • Newport Beach, California, United States CalPrivate Bank Full time

    Job Title: SBA Business Development AssociateAt CalPrivate Bank, we are seeking a highly motivated and experienced SBA Business Development Associate to join our team. As a key member of our SBA team, you will be responsible for supporting the Business Development Officers with marketing, loan review, submission, and loan closing.Key Responsibilities:Market...


  • Newport Beach, California, United States Pacific Life Full time

    About the RolePacific Life is seeking a seasoned sales professional to drive growth in General Agent (GA) Distribution within the Workforce Benefits organization. As an Account Executive, GA Distribution, you will play a pivotal role in establishing and expanding a $1 billion revenue, profitable business in the Workforce Benefits market. This role is 100%...


  • Newport Beach, California, United States Arthur J. Gallagher & Co. Full time

    About the RoleWe are seeking a highly motivated and experienced Area Vice President to lead our business development efforts. As a key member of our team, you will be responsible for developing and acquiring new business revenue through sales to new and existing clients.Key Responsibilities:Develop and execute business plans to drive revenue growth and...


  • Newport Beach, California, United States Lim Group Full time

    Job Title: Devoucoux Business ManagerAt Lim Group, we are dedicated to fostering a strong partnership between horse and rider. Our company has been at the forefront of promoting this relationship since 1985. Our saddles and accessories require the expertise of six different trades, which are central to our workshops in the Basque region. Our unique approach...