Senior Data Engineer & BI Specialist

TriSource Staffing Solutions

Maryland

Hybrid

USD 120,000 - 150,000

Full time

14 days+

Application generator

Get a reply from this employer — a resume and cover letter tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

TriSource Staffing Solutions is seeking a Senior Database Developer to design, build, and optimize scalable data pipelines and BI assets. This role focuses on robust SQL, ETL/ELT processes, and data quality across enterprise platforms.

You will mentor junior developers, collaborate with analytics teams, and support Power BI/SSRS reporting. The position requires 7+ years in database development, strong Microsoft tech skills, and a hybrid work arrangement with 1 day in the office per week.

Qualifications

Bachelor’s degree in Computer Science, Information Technology, or a related technical field.
7+ years of progressive experience in the IT industry, with a strong focus on database development, data engineering, and business intelligence solutions.
Hands-on experience with Microsoft technologies including SQL Server, SSIS, SSRS, Microsoft Fabric, PySpark, and Power BI.
Experience working with modern development and deployment platforms, including Azure DevOps.
Familiarity with cloud-based database solutions, such as Azure SQL Database, preferred.
Familiarity with Microsoft Fabric is preferred and will be considered a plus.
Proficiency with scripting and automation languages such as Python and/or PowerShell.
Working knowledge of Microsoft 365 applications, including Office 365 and SharePoint Online.

Responsibilities

Design, build, and maintain scalable data pipelines to ingest, process and transform data efficiently and reliably.
Design, develop, optimize, and maintain complex SQL queries, stored procedures, functions, and database views to ensure efficient and reliable data.
Develop and optimize ETL/ELT processes to support analytics and reporting needs.
Ensure data quality, consistency, and reliability across all data platforms through validation, monitoring, and continuous improvement practices.
Optimize database performance by tuning queries through effective use of indexing, execution plan analysis, and advanced query optimization techniques.
Implement data validation and monitor to detect and resolve issues proactively.
Optimize large-scale data loads and batch processing workflows to ensure efficient, reliable, and high performance data operations.
Support reporting tools such as SSRS and Power BI.
Mentor junior developers and provide technical guidance.
Performs other similar and related duties as required.