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 AreAt 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 AreRelationship-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 ResponsibilitiesSQL Server AdministrationInstall, configure, and maintain SQL Server instances in on-premises and hybrid environmentsImplement and manage backup and recovery strategies, high availability solutions, and disaster recovery plansConfigure security settings, user permissions, and auditing to meet compliance requirementsApply patches, updates, and perform capacity planningPerformance Tuning & OptimizationAnalyze and optimize query performance using execution plans, indexing strategies, and query rewritesMonitor server health and proactively identify performance bottlenecksTune SQL Server configuration settings for optimal resource utilizationTroubleshoot and resolve database performance issuesDatabase DevelopmentDesign and implement database schemas, stored procedures, functions, and viewsEnsure data quality, integrity, and adherence to best practices in database designDevelop and maintain T-SQL scripts for data management and automationData Pipeline DevelopmentBuild and maintain data pipelines using Microsoft Fabric and/or Azure Data FactoryImplement ETL/ELT processes to move and transform data across sources and destinationsMonitor pipeline performance and troubleshoot data flow issuesSolution Design & DeliveryTranslate business requirements into database and data integration solutions aligned with industry best practicesCollaborate with stakeholders to understand data needs and define technical approachesDeliver projects on time and within budget while maintaining customer satisfactionTechnical CollaborationWork with customers to plan, design, configure, and diagnose SQL Server and data pipeline technologiesPartner with other engineers and technical leads on complex projectsDocument solutions and share knowledge with team membersPreferred Qualifications3–5 years in SQL Server administration, database development, data engineering, or related consultingDemonstrated experience installing, configuring, and managing SQL Server environmentsProven track record of performance tuning and query optimizationHands-on experience building data pipelines in Microsoft Fabric and/or Azure Data FactorySkillsStrong proficiency in T-SQL, stored procedures, indexing, and database designSolid understanding of SQL Server internals, execution plans, and performance monitoring toolsFamiliarity with high availability and disaster recovery solutions (Always On, log shipping, replication)Experience with Azure data services and the Microsoft data platform ecosystemUnderstanding of data modeling and ETL/ELT patternsBenefits of Joining ElevateCompetitive salary + performance-based incentivesComprehensive medical, dental, and vision coverage401(k) with company matchHybrid work environmentGenerous paid time off + holidaysOngoing training and Microsoft certification supportCollaborative team environment with opportunities for career growthEqual OpportunityElevate Technology Partners is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.