Job Description
Responsibilities
• Proficient with Power Query, DAX, and MDX for complex data projects
• Experienced in authoring, diagnosing, and altering SQL Server and Postgres objects
• Experience creating and maintaining reporting assets in Power BI
• Analyze business requirements into technical requirements for reporting/visualizations, data models, and databases
• Review technical specifications derived from technical requirements
• Develop reporting for business consumption using a variety of BI tools
• Work on drill-through reports using relational models
• Able to integrate Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation
• Experience building and maintaining data pipelines
• Experienced in developing custom visuals serving various levels of need – executive dashboards to individual-usage reports
• Provide detailed source analysis and data mappings/transformations to BI developers to implement new data sources and integrations
• Devise and deliver testing plans and testing data to validate BI solutions
• Perform data analysis, profiling, and quality assessment to ensure the integrity of business data to necessary levels
• Assist with complex incident management situations affecting BI capabilities and solutions
• Review design proposals of other BI Analysts and vendors; as well as, perform reviews on work during various stages of delivery for adherence to current standards
• Perform peer reviews and mentor less experienced BI Analysts on solution approaches and ensuring conformity to standards and quality
• Work with technical leads and architects to implement new standards, new technology, and tactical solutions driving the business strategy forward
• Works within the System Development Life Cycle
• Monitor the lifecycle of BI systems by being aware of obsolescence and release dates for the product per the System Development Lifecycle
• Excellent written and verbal communication skills
• Ability to work effectively with remote teammates and users
• Designing 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 experience
• 5+ years' experience with DAX, Power Query, and MDX
• Excellent analytical and problem-solving skills
• Excellent verbal and written communication skills
• Creative and innovative thinker
• Meticulous attention to detail
• Great team player and able to work efficiently with minimal supervision
Remote; must work PST hours
Nice to Have Skills & Experience
• Data Warehouse experience
• Familiar 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.