Back to Job Search

Business Intelligence Engineer II

  • Location: California
  • Job Type:Contract

Posted about 1 month ago

  • Expiry Date: 13 June 2021

​Job Description:

Key Skills:

  • PowerBI Development, Support, and Enhancements

  • SQL On-Prem Query Development and extract into Excel

  • Cloud is a plus but not the primary need at this time

Job Summary

  • As an experienced BI/SQL Developer, you will be responsible for delivering solutions related to data management, developing data models, data architecture, data integration, data consumption, data ingestion, and data quality within the CRB segment. The role expects you to apply modern day best practices and agile project delivery principles to ensure clients CRB Tech rapidly delivers value to the business using SQL On-Premises and future Azure Cloud platform. The role expects you to develop reports and dashboards for different programs. You should act as a role model for others within the team by collaborating with the worldwide team and promoting a can-do delivery culture whilst adhering to high quality standards.

  • Successful candidates are humble, thoughtful and respectful of ideas, while bringing passionate solutions that strengthen the products. Our goal is to produce quality solutions while having fun in a casual, results-driven environment. Ultimately, you will ensure that our products, applications and systems work correctly and meet the needs of the teams and functional consumers.


  • As a BI/SQL Developer you will be working with your software developers and other technology colleagues, actively developing solutions that focus on bringing data and analytics to life with mature data integration, data ingestion and data consumption strategies.

  • Contributing to the overall CRB data vision and strategy that underpins the CRB technology strategy.

  • Building functionality to advance the CRB data strategy with a focus on data integration, data consumption, and data visualization

  • Providing visualization of the data through the use of PowerBI and like tools that allow the consumer to understand their data.

  • Utilizing On-Prem and Azure Cloud technologies to extend the data offering within the eco-system, through reporting or other data extraction processes

  • Working with appropriate stakeholders to understand system and functional requirements.

  • Planning and executing data development using Agile processes.

  • Collaborating on delivering technical excellence across the organization.

  • Ability to handle multiple development streams within a given time period

  • Be able to think BIG and deliver iteratively at the same time

Must have:

  • Bachelor’s degree in an IT related subject from a reputed university

  • Knowledge of designing, implementing and evolving data solutions using the Microsoft’s SQL functions and Azure Cloud tools related to the Modern Data Warehouse

  • Knowledge of professional software engineering practices & best practices for the full software development life cycle, including coding standards, code reviews, source control management, build processes, continuous deployment, testing, and operations

  • Experience (12 – 16 years)

  • SQL development demonstrating a mastery of use to handle data extraction, storage, and movement within an enterprise environment

  • Competent in working with large data sets and co-mingling the data for business/system consumption

  • Ability to convert business requirements and complex source datasets into technical designs and functional, high quality, code

  • Designing and building solutions in SQL Server and MS BI Stack (SQL, SSIS, SSAS, SSRS)

  • Hands on experience in Database design and Data warehousing

  • Support critical production data systems, assuring high-availability, and urgently execute hotfix processes when needed

  • Experience with Azure SQL DB, Azure Data Lake, Azure SQL Data Warehouse (Synapse Analytics)

  • Hands on Data Integration using Azure Data Factory 2.0, Logic Apps, Azure Data Bricks, Azure Functions, and Polybase

  • Proficient in using Azure Cloud Services such as Azure Data Factory v2.0, Azure Data Lake, Key Vaults, Service Bus, Logic Apps, Power Automate, etc

  • Interactive data presentation to the user using reporting tools like Power BI for various data quality, presentations, and confidence reviews

  • Provide the ability to provide outputs of the data that is stored in our On-Prem SQL databases and making that available for consumers (Excel based outputs)

  • Experience and knowledge of Data Modeling and Management techniques, including Modern Data Warehouse Architecture

  • A successful history of manipulating, processing and extracting value from large disconnected datasets in order to integrate the data sets for business usage

  • Experience with Agile methodologies and processes

  • Ability to quickly assimilate new and complex technologies and concepts and disseminate to other team members

  • Develop data and analytics capabilities in collaboration with the Data Analysts and other relevant stakeholders.

  • Develops and builds frameworks/prototypes that integrate data within the data warehouse to address business needs

  • Implements new areas of data technologies, (ingestion, processing, distribution) and research delivery methods that can remove technical barriers to data access and distribution

  • Utilize effective work planning techniques to break down complex requirements into tasks, manage the scope of requirements, and ensure deadlines are kept for own work and fellow data engineers

  • Strong problem solving and data-driven analysis skills

  • Dev-ops experience using GIT, developing, deploying code to production

About ASK: ASK Consulting is an award-winning technology and professional services recruiting firm servicing Fortune 500 organizations nationally. With 5 nationwide offices, two global delivery centers, and employees in 42 states-ASK Consulting connects people with amazing opportunities

ASK Consulting is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all associates.