BI Data Engineer — Tempe, AZ
Зарплата не указана
ОткликнутьсяLocation: Tempe, AZ – Onsite
Employment Type: Direct Hire
Salary: $100,000–$125,000
Thisis a direct hire role/ the client is not able to sponsor
We are looking for a hands-on Senior SQL Server / BI Data Engineer who can bridge the gap between database engineering, data warehousing, ETL, and enterprise reporting.
This is not a traditional people-management role and it is not a pure infrastructure DBA position. The ideal candidate is someone who enjoys working directly with SQL Server, data warehouses, ETL pipelines, reporting platforms, and production data issues while also serving as a senior technical resource to the team.
What You’ll Be Doing
• Support and enhance SQL Server databases, data warehouses, and reporting environments across production, development, and test.
• Design, develop, troubleshoot, and optimize ETL/data integration workflows using SSIS and related technologies.
• Support enterprise reporting solutions using SSRS and other BI/reporting platforms.
• Develop and optimize T-SQL, stored procedures, views, indexes, and database objects supporting reporting and analytical workloads.
• Design and maintain dimensional data models, fact/dimension structures, and data warehouse solutions.
• Troubleshoot performance issues across SQL Server, ETL pipelines, reporting workloads, and data integrations.
• Support data migrations, schema changes, application integrations, and database upgrades.
• Monitor production data processes, investigate failures, perform root-cause analysis, and help improve reliability and performance.
• Partner with business users, developers, infrastructure teams, and reporting teams to translate requirements into scalable data solutions.
• Help establish technical standards, documentation, development practices, and reporting/data-quality processes.
• Provide technical guidance and mentorship to other team members while remaining highly hands-on.
• Participate in production support and occasional on-call responsibilities.
What We’re Looking For
• Strong professional experience with Microsoft SQL Server.
• Hands-on experience with data warehousing and dimensional modeling.
• Strong experience with SSIS / ETL development and troubleshooting.
• Experience developing or supporting SSRS and enterprise reporting solutions.
• Strong T-SQL skills, including stored procedures, query optimization, indexing, and performance tuning.
• Experience supporting production databases, data pipelines, and reporting environments.
• Ability to troubleshoot complex data and performance issues across multiple systems.
• Experience with database migrations, schema changes, deployments, and release processes.
• Strong understanding of data quality, security, access controls, and production support.
• Ability to communicate effectively with both technical teams and business stakeholders.
• Experience mentoring, providing technical direction, or acting as a senior SME.
Nice to Have
• Power BI experience.
• Azure SQL, Azure Data Factory, Synapse, Fabric, or other cloud data-platform experience.
• SSAS / OLAP experience.
• Healthcare or other regulated-industry experience.
• Experience with SQL Server backup/recovery, disaster recovery, or high-availability environments.
• PowerShell or other scripting/automation experience.
• Experience with CI/CD, Azure DevOps, Git, or database deployment automation.