Data Engineer (SQL, Azure, Power BI) from INSPYR Solutions
Fort Worth, TX 76155
About the Job
Title: SQL/Azure Database Administrator
Location: Fort Worth
Duration: Contract
Hourly Rate: $65-78
Qualified candidates may send a copy of their resume (Word Format) to jrogers@inspyrsolutions.com
Description:
• 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, 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/model-driven 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 up-to-date 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 problem-solving 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 real-time 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, Transact-SQL.
• Develop and maintain comprehensive documentation, standards, and procedures to foster knowledge-sharing.
Our benefits package includes: (EXCLUDE on perm placements)
About INSPYR Solutions
Technology is our focus and quality is our commitment. As a national expert in delivering flexible technology and talent solutions, we strategically align industry and technical expertise with our clients' business objectives and cultural needs. Our solutions are tailored to each client and include a wide variety of professional services, project, and talent solutions. By always striving for excellence and focusing on the human aspect of our business, we work seamlessly with our talent and clients to match the right solutions to the right opportunities. Learn more about us at inspyrsolutions.com.
INSPYR Solutions provides Equal Employment Opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, INSPYR Solutions complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities.
Location: Fort Worth
Duration: Contract
Hourly Rate: $65-78
Qualified candidates may send a copy of their resume (Word Format) to jrogers@inspyrsolutions.com
Description:
• 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, 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/model-driven 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 up-to-date 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 problem-solving 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 real-time 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, Transact-SQL.
• Develop and maintain comprehensive documentation, standards, and procedures to foster knowledge-sharing.
Our benefits package includes: (EXCLUDE on perm placements)
- Comprehensive medical benefits
- Competitive pay
- 401(k) retirement plan
- …and much more!
About INSPYR Solutions
Technology is our focus and quality is our commitment. As a national expert in delivering flexible technology and talent solutions, we strategically align industry and technical expertise with our clients' business objectives and cultural needs. Our solutions are tailored to each client and include a wide variety of professional services, project, and talent solutions. By always striving for excellence and focusing on the human aspect of our business, we work seamlessly with our talent and clients to match the right solutions to the right opportunities. Learn more about us at inspyrsolutions.com.
INSPYR Solutions provides Equal Employment Opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, INSPYR Solutions complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities.
Salary
65 - 78 /hour
