Consulting Engineer - Data

Elevate Technology Partners is looking for a Data Consulting Engineer to join our growing Data Engineering team. In this role, you will design and deliver database and data integration solutions that enable clients to manage, transform, and leverage their data effectively. You will translate business requirements into reliable database architectures, configure and maintain SQL Server environments, optimize performance, and build data pipelines to move data across systems. This role combines technical expertise in SQL Server administration and development with proficiency in Microsoft's modern data platform tools including Fabric and Azure Data Factory.

Who We Are

At Elevate Technology Partners, we’re not your typical IT services firm. We’re an engineering-led, relationship-driven team that believes in solving the right problems, not just selling solutions. Our clients trust us because we take the time to understand their business, tailor every engagement to their needs, and stick with them through delivery and beyond.

We specialize in modern workplace solutions, data engineering, hybrid cloud, and technical placement, but what sets us apart is how we do it. We’re nimble enough to move fast, senior enough to guide strategy, and humble enough to do the work others overlook. Whether it's helping a client navigate a complex migration or just being the reliable partner who picks up the phone, we show up with purpose.

If you're looking to be part of a team that values trust over transactions, outcomes over ego, and real relationships over rinse-and-repeat playbooks, you’ll fit right in at Elevate.

Who You Are

• Relationship-driven : You enjoy building long-term client relationships and being the “go-to” resource for guidance.
• Technically skilled : You understand Data Platform solutions (Azure SQL, Data Factory, Fabric, Power BI, t-SQL, Snowflake, Databricks) and can translate technical capabilities into business value.
• Proactive & solution-oriented : You anticipate client needs, solve challenges, and uncover opportunities for improvement.
• Detail-focused & organized : You manage multiple client projects, meetings, and follow-ups without missing a beat.
• Growth-minded : You can spot opportunities for clients to expand their technology use and elevate their business outcomes.

Key Responsibilities

SQL Server Administration

• Install, configure, and maintain SQL Server instances in on-premises and hybrid environments
• Implement and manage backup and recovery strategies, high availability solutions, and disaster recovery plans
• Configure security settings, user permissions, and auditing to meet compliance requirements
• Apply patches, updates, and perform capacity planning

Performance Tuning & Optimization

• Analyze and optimize query performance using execution plans, indexing strategies, and query rewrites
• Monitor server health and proactively identify performance bottlenecks
• Troubleshoot and resolve database performance issues

Database Development

• Design and implement database schemas, stored procedures, functions, and views
• Ensure data quality, integrity, and adherence to best practices in database design
• Develop and maintain T-SQL scripts for data management and automation
• Build and maintain data pipelines using Microsoft Fabric and/or Azure Data Factory
• Implement ETL/ELT processes to move and transform data across sources and destinations
• Monitor pipeline performance and troubleshoot data flow issues

Solution Design & Delivery

• Translate business requirements into database and data integration solutions aligned with industry best practices
• Collaborate with stakeholders to understand data needs and define technical approaches
• Deliver projects on time and within budget while maintaining customer satisfaction

Technical Collaboration

• Work with customers to plan, design, configure, and diagnose SQL Server and data pipeline technologies
• Partner with other engineers and technical leads on complex projects
• Document solutions and share knowledge with team members

Preferred Qualifications

• 3–5 years in SQL Server administration, database development, data engineering , or related consulting
• Demonstrated experience installing, configuring, and managing SQL Server environments
• Proven track record of performance tuning and query optimization
• Hands-on experience building data pipelines in Microsoft Fabric and/or Azure Data Factory

Skills

• Strong proficiency in T-SQL, stored procedures, indexing, and database design
• Solid understanding of SQL Server internals, execution plans, and performance monitoring tools
• Familiarity with high availability and disaster recovery solutions (Always On, log shipping, replication)
• Experience with Azure data services and the Microsoft data platform ecosystem
• Understanding of data modeling and ETL/ELT patterns

Benefits of Joining Elevate

• Competitive salary + performance-based incentives
• Comprehensive medical, dental, and vision coverage
• 401(k) with company match
• Hybrid work environment
• Generous paid time off + holidays
• Ongoing training and Microsoft certification support
• Collaborative team environment with opportunities for career growth

Elevate Technology Partners is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.