Position : Data Engineer with Power BI
Location : Fort Worth TX (Hybrid)
Duration : 6 Months with EXT
Description:
Lead and execute the cloud migration projects from Onprem SQL Server to Azure SQL ensuring a smooth transition with minimal downtime.
Implement best practices for database security and compliance with data privacy regulations incorporating access controls encryption and auditing mechanisms.
Designing and developing Power BI reports and dashboards to meet the business stakeholders needs.
Develop and implement custom solutions using Power Apps and Power Automate
Power Platform (Canvas/modeldriven apps SharePoint Power BI)
Relational databases (design/SQL/tuning)
Web APIs (SOAP/REST)
Tooling (GIT/JIRA/Azure DevOps)
Gathering and understanding business requirements for data visualization and analysis
Collaborating with data engineers and analysts to acquire clean and transform data for reporting purposes
Ensuring data security and compliance with best practices
Troubleshooting and resolving issues in Power BI reports
Providing training and support to end users on using Power BI
Keeping uptodate with the latest Power BI features and trends
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 problemsolving skills
Excellent communication and collaboration skills
Ability to work independently and as a part of a team
Adaptability to changing business requirements
Power BI certifications are a plus
Proactively identify and resolve performance bottlenecks working closely with development teams to optimize query performance indexing strategies and resource utilization.
Implement and maintain robust monitoring solutions to provide realtime insights into database health ensuring proactive issue resolution.
Conduct regular health checks capacity planning and upgrade/migration activities to maintain system reliability and stability.
Perform essential database administration tasks including installation configuration monitoring tuning backup recovery and troubleshooting.
Innovate and implement automation solutions for routine tasks reducing manual efforts and improving operational efficiency.
Design implement and maintain SQL and Azure database solutions aligned with organizational requirements and industry best practices.
Design develop and enhance ETL processes using Azure Data Factory or other tools to integrate data from diverse sources into the database seamlessly.
Collaborate with teams to optimize and streamline data transformation pipelines.
Collaborate with the teams to troubleshoot and resolve complex database issues efficiently using Azure Insights Monitoring DMVs Query Store etc.
Demonstrate knowledge of SQL TransactSQL.
Develop and maintain comprehensive documentation standards and procedures to foster knowledgesharing.