Insight Global
BI Reports Engineer(PowerBI/SQL)
Insight Global, Burbank, California, United States, 91520
We are seeking a highly motivated and experienced Data Engineer with Power BI experience to join our Program Management & Enabling Technologies team. You will be responsible for developing and maintaining data models/visualizations for strategic dashboards and reports serving key stakeholders such as Studio Executives, Financial leaders, Operational leaders, Project/Program Managers and Engineers. The ideal candidate will bring expertise in designing and implementing reports and visualizations using latest technology standards, as well as develop and implement innovative techniques for measuring, analyzing, and reporting on project and various Studios data in an agile team environment.
ResponsibilitiesProficient with Power Query, DAX, and MDX for complex data projectsExperienced in authoring, diagnosing, and altering SQL Server and Postgres objectsExperience creating and maintaining reporting assets in Power BIAnalyze business requirements into technical requirements for reporting/visualizations, data models, and databasesReview technical specifications derived from technical requirementsDevelop reporting for business consumption using a variety of BI toolsWork on drill-through reports using relational modelsAble to integrate Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automationExperience building and maintaining data pipelinesExperienced in developing custom visuals serving various levels of need executive dashboards to individual-usage reportsProvide detailed source analysis and data mappings/transformations to BI developers to implement new data sources and integrationsDevise and deliver testing plans and testing data to validate BI solutionsPerform data analysis, profiling, and quality assessment to ensure the integrity of business data to necessary levelsAssist with complex incident management situations affecting BI capabilities and solutionsReview design proposals of other BI Analysts and vendors; as well as, perform reviews on work during various stages of delivery for adherence to current standardsPerform peer reviews and mentor less experienced BI Analysts on solution approaches and ensuring conformity to standards and qualityWork with technical leads and architects to implement new standards, new technology, and tactical solutions driving the business strategy forwardWorks within the System Development Life CycleMonitor the lifecycle of BI systems by being aware of obsolescence and release dates for the product per the System Development LifecycleExcellent written and verbal communication skillsAbility to work effectively with remote teammates and uDesigning beautifully organized analytics dashboards for upper management
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 opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their 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 or uniformed service member status, 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 HR@insightglobal.com .
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/ .
Required Skills & Experience
5+ years of PowerBI Experience/strong SQL experience5+ years' experience with DAX, Power Query, and MDXExcellent analytical and problem-solving skillsExcellent verbal and written communication skillsCreative and innovative thinkerMeticulous attention to detailGreat team player and able to work efficiently with minimal supervisionRemote; must work PST hours
Nice to Have Skills & Experience
Data Warehouse experienceFamiliar with Media & Entertainment data
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.
ResponsibilitiesProficient with Power Query, DAX, and MDX for complex data projectsExperienced in authoring, diagnosing, and altering SQL Server and Postgres objectsExperience creating and maintaining reporting assets in Power BIAnalyze business requirements into technical requirements for reporting/visualizations, data models, and databasesReview technical specifications derived from technical requirementsDevelop reporting for business consumption using a variety of BI toolsWork on drill-through reports using relational modelsAble to integrate Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automationExperience building and maintaining data pipelinesExperienced in developing custom visuals serving various levels of need executive dashboards to individual-usage reportsProvide detailed source analysis and data mappings/transformations to BI developers to implement new data sources and integrationsDevise and deliver testing plans and testing data to validate BI solutionsPerform data analysis, profiling, and quality assessment to ensure the integrity of business data to necessary levelsAssist with complex incident management situations affecting BI capabilities and solutionsReview design proposals of other BI Analysts and vendors; as well as, perform reviews on work during various stages of delivery for adherence to current standardsPerform peer reviews and mentor less experienced BI Analysts on solution approaches and ensuring conformity to standards and qualityWork with technical leads and architects to implement new standards, new technology, and tactical solutions driving the business strategy forwardWorks within the System Development Life CycleMonitor the lifecycle of BI systems by being aware of obsolescence and release dates for the product per the System Development LifecycleExcellent written and verbal communication skillsAbility to work effectively with remote teammates and uDesigning beautifully organized analytics dashboards for upper management
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 opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their 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 or uniformed service member status, 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 HR@insightglobal.com .
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/ .
Required Skills & Experience
5+ years of PowerBI Experience/strong SQL experience5+ years' experience with DAX, Power Query, and MDXExcellent analytical and problem-solving skillsExcellent verbal and written communication skillsCreative and innovative thinkerMeticulous attention to detailGreat team player and able to work efficiently with minimal supervisionRemote; must work PST hours
Nice to Have Skills & Experience
Data Warehouse experienceFamiliar with Media & Entertainment data
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.