BI Engineer

Job Highlights

Using AI ⚡ to summarize the original job post

Responsibilities

• Lead and execute the cloud migration projects from On-prem SQL Server to Azure SQL, ensuring a smooth transition with minimal downtime.
• Implement best practices for database security and compliance with data privacy regulations.
• Design and develop Power BI reports and dashboards to meet the business stakeholders' needs.
• Develop and implement custom solutions using Power Apps and Power Automate.
• Gather and understand business requirements for data visualization and analysis.
• Collaborate with data engineers and analysts to acquire, clean, and transform data for reporting purposes.
• Ensure data security and compliance with best practices.
• Troubleshoot and resolve issues in Power BI reports.
• Provide training and support to end users on using Power BI.
• Keep up-to-date with the latest Power BI features and trends.
• Identify and resolve performance bottlenecks, working closely with development teams to optimize query performance.
• Implement and maintain robust monitoring solutions for real-time insights into database health.
• Perform regular health checks, capacity planning, and upgrade/migration activities.
• Perform essential database administration tasks.
• Innovate and implement automation solutions for routine tasks.
• Design, implement, and maintain SQL and Azure database solutions.
• Design, develop, and enhance ETL processes using Azure Data Factory.
• Collaborate with teams to optimize and streamline data transformation pipelines.
• Troubleshoot and resolve complex database issues efficiently.
• Develop and maintain comprehensive documentation, standards, and procedures.

Qualifications

Required

• Proficiency in Power BI development, including report and dashboard creation.
• Strong understanding of data modeling and data visualization concepts.
• Experience with SQL for data manipulation and extraction.
• Knowledge of Data Analysis Expressions (DAX) for creating calculations.
• Familiarity with data warehouse concepts.
• Excellent attention to detail and problem-solving skills.
• Excellent communication and collaboration skills.
• Ability to work independently and as a part of a team.
• Adaptability to changing business requirements.
• Proficiency in SQL, Transact-SQL.
• Demonstrate knowledge of SQL, Transact-SQL.

Preferred

• Power BI certifications.