REQUIREMENTS

• Required Education: Bachelor’s degree in Computer Science or Engineering, or related technical discipline
• Proficient with Power Query, DAX, MDX for complex data projects
• Experience with Databricks preferred
• 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
• 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.
• Design 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
• Fluent in English, both written and verbal

PREFERRED SKILLS

• 5+ years of Data Warehouse
• Experience with Oil and Gas
• Experience with Software Industry

• Proficient with Power Query, DAX, MDX for complex data projects
• Experience with Databricks preferred
• 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
• 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.
• Design 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
• And other duties as assigned.