Director Software Engineering (BI Engineer)

SUMMARY

Responsibilities:

• Collaborate with business power users to gather and document requirements for new datasets, pipelines, transformation & enhancement logic, measures, data models, and Power BI dashboards.
• Work within the execution strategy and division of responsibilities between the IT / Analytics team and the business power users.
• Development and maintenance of the components that IT / Analytics team is responsible for, coordinating with other members of IT.
• Own and manage the dashboard lifecycle from the time that enterprise distribution begins through Certification by IT Analytics and ongoing support and troubleshooting as needed.
• Documentation of development requirements, technical designs, test plans, and end product functionality.
• Perform functional testing and validation to ensure that business users agree with the accuracy of data, transformations, enhancements, measures, and dashboard presentations prior to handoff for UAT.
• Maintain the overall Azure data and Power BI environment to ensure accurate, reliable, resilient, and efficient operation of all functionality and excellent user experience.
• Ensure compliance with data governance policies and data privacy regulations and manage security and access rights to protect data accordingly.
• Work with data and SMEs from all business disciplines at all business levels (local, regional, corporate).
• All other duties as assigned or duties, responsibilities, and activities may change at any time with or without notice.

Requirements

Requirements:

 

• Bachelor’s or master’s degree in computer science or information technology.
• 10 plus years of experience in report building, data analytics and cloud data processing services, preferably Azure.
• Expertise in designing and maintaining complex SQL queries and procedures.
• Strong modeling experience.
• 10 + years of experience with BI tools, e.g. PBI, Tableau, SSRS.
• 10 + years of experience with ETL tools, e.g. Azure Data Factory, snowflake, SQL, AWS Glue.
• Firm grasp of security standards, access control, Row Level Security, and data governance principles.
• Knowledge of programming languages such as Python or R is preferred.
• Expert level developer utilizing DAX.
• Microsoft Certification in Azure Enterprise Data Analyst Associate or Data Analyst Associate.