Insight Global
Job Description
Insight Global is seeking a BI Developer to join their clients team. They will be working with the BI Architects, Data Engineers, and other BI Developers on the team in designing and developing enterprise data models in our data warehouse used by our Private Client Group business. Our team extracts data from operational systems to our Azure Data Lake/Synapse environment, builds dimension and fact tables, and creates tabular models for use in Power BI. The scope of responsibilities will include eliciting requirements from various stakeholders, modeling the data into dimension and fact tables, implementation of tabular models, including DAX calculated measures and columns and securing the model through RBAC and roles. Responsible for operational support, incident investigation, and problem management, including logging, instrumentation, performance analysis, cross team collaboration, and process improvements. You will collaborate with the business on data visualization and report generation to meet reporting needs.
Day-to-Day:
Based on evaluation, recommend, implement, maintain, support, and improve business intelligence solutions, including designing, coding, testing, and deployment of datasets, data models, dashboards, and reports
Independently manage product issues such as defects, patches, and upgrades, including deployment, testing, and post-production validation
Define, guide, and deliver medium-to-large business intelligence projects from beginning to end, with guidance from BI Architects
Test business intelligence solutions, including creating and implementing test plans/cases/scripts
Provide operational support and incident management for assigned systems, including proactively update internal clients and relevant parties on status changes and issues encountered
Author and maintain accurate and up-to-date documentation for processes, procedures, and dashboard/report designs
We are a company committed to creating inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity employer that believes everyone matters. Qualified candidates will receive consideration for employment opportunities without regard to race, religion, sex, age, marital status, national origin, sexual orientation, citizenship status, disability, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to Human Resources Request Form (https://airtable.com/app21VjYyxLDIX0ez/shrOg4IQS1J6dRiMo) . The EEOC "Know Your Rights" Poster is available here (https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12ScreenRdr.pdf) .
To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .
Skills and Requirements
5+ years of experience as a BI Developer
Building logical physical data models and implementing those in Power BI
3+ years of experience with Azure Synapse or Azure SQL
Experience with DAX(data analysis expressions) / MDX(multidimensional expressions) and SQL
*** Will be in an on call rotation for one week every two months
If any of the pipelines fail overnight, they will be responsible for the initial investigation and escalation of that problem - Huge benefit if they have any experience with ADF (Azure Data Factory)
o This is what they are doing on the backend for loading data but this can be taught if they dont have it
o Git Hub for source control null
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion,sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to HR@insightglobal.com.
Insight Global is seeking a BI Developer to join their clients team. They will be working with the BI Architects, Data Engineers, and other BI Developers on the team in designing and developing enterprise data models in our data warehouse used by our Private Client Group business. Our team extracts data from operational systems to our Azure Data Lake/Synapse environment, builds dimension and fact tables, and creates tabular models for use in Power BI. The scope of responsibilities will include eliciting requirements from various stakeholders, modeling the data into dimension and fact tables, implementation of tabular models, including DAX calculated measures and columns and securing the model through RBAC and roles. Responsible for operational support, incident investigation, and problem management, including logging, instrumentation, performance analysis, cross team collaboration, and process improvements. You will collaborate with the business on data visualization and report generation to meet reporting needs.
Day-to-Day:
Based on evaluation, recommend, implement, maintain, support, and improve business intelligence solutions, including designing, coding, testing, and deployment of datasets, data models, dashboards, and reports
Independently manage product issues such as defects, patches, and upgrades, including deployment, testing, and post-production validation
Define, guide, and deliver medium-to-large business intelligence projects from beginning to end, with guidance from BI Architects
Test business intelligence solutions, including creating and implementing test plans/cases/scripts
Provide operational support and incident management for assigned systems, including proactively update internal clients and relevant parties on status changes and issues encountered
Author and maintain accurate and up-to-date documentation for processes, procedures, and dashboard/report designs
We are a company committed to creating inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity employer that believes everyone matters. Qualified candidates will receive consideration for employment opportunities without regard to race, religion, sex, age, marital status, national origin, sexual orientation, citizenship status, disability, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to Human Resources Request Form (https://airtable.com/app21VjYyxLDIX0ez/shrOg4IQS1J6dRiMo) . The EEOC "Know Your Rights" Poster is available here (https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12ScreenRdr.pdf) .
To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .
Skills and Requirements
5+ years of experience as a BI Developer
Building logical physical data models and implementing those in Power BI
3+ years of experience with Azure Synapse or Azure SQL
Experience with DAX(data analysis expressions) / MDX(multidimensional expressions) and SQL
*** Will be in an on call rotation for one week every two months
If any of the pipelines fail overnight, they will be responsible for the initial investigation and escalation of that problem - Huge benefit if they have any experience with ADF (Azure Data Factory)
o This is what they are doing on the backend for loading data but this can be taught if they dont have it
o Git Hub for source control null
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion,sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to HR@insightglobal.com.