Database Developer

Expleo•Saint Paul, MN

1d•$120,000 - $129,000•Hybrid

About The Position

Trissential is seeking an experienced Database Developer to join their client's team. This role involves designing, developing, and maintaining critical database, ETL, reporting, and data integration solutions. The position offers the opportunity to work on high-impact data initiatives in a modern, Agile environment, collaborating with skilled professionals. The role focuses on enterprise-scale database modernization, integration, and migration initiatives, influencing the design and performance of data platforms, and utilizing modern data engineering practices with technologies like SQL Server, Python, PySpark, SSIS, and Power BI.

Requirements

10+ years of experience in database development, database engineering, or data engineering roles
Strong expertise with Microsoft SQL Server and advanced T-SQL development
Proven experience with SQL performance tuning, query optimization, indexing, and troubleshooting
Hands-on experience developing and supporting ETL processes using SSIS
Experience with Python and/or PySpark for data processing and transformation
Strong understanding of data integration, data governance, and enterprise data management principles
Experience designing logical and physical data models and implementing scalable database architectures
Experience developing reporting solutions using SSRS and Power BI
Ability to work effectively in Agile development environments and collaborate across technical and business teams
Strong analytical, problem-solving, and communication skills
Authorized to work in the United States

Nice To Haves

Experience supporting mission-critical systems within financial services, government, legal, or highly regulated industries
Experience with Azure DevOps, GitHub, Jenkins, or similar DevOps platforms
Familiarity with CI/CD processes supporting database deployments
Experience with enterprise-scale data warehouse environments and modern analytics platforms
Exposure to cloud-based data engineering and integration solutions
Experience leading data migration or modernization initiatives
Microsoft SQL Server, Azure Data, Power BI, or related certifications are preferred but not required
Additional cloud, database, or DevOps certifications are considered a plus

Responsibilities

Design, develop, and maintain enterprise databases, including stored procedures, indexing strategies, and data models
Develop and optimize ETL pipelines and workflows using SSIS, Python, PySpark, and SQL Server technologies
Lead and execute large-scale data migration initiatives, including data cleansing, validation, transformation, and reconciliation activities
Create and optimize SQL scripts, stored procedures, and database objects to support data conversion and ongoing operational processes
Develop robust data ingestion and transformation workflows across raw, staging, curated, and analytics layers
Build, enhance, and maintain reporting and dashboard solutions using SSRS and Power BI
Design logical and physical data models, including ERD development and database architecture documentation
Develop views, stored procedures, SQL scripts, and other database components supporting transactional and reporting environments
Provide production support by troubleshooting data, performance, and system-related issues
Participate in Agile ceremonies, code reviews, development activities, testing, and deployment cycles
Collaborate with business and technical stakeholders to deliver scalable and maintainable data solutions
Provide knowledge transfer and technical documentation to support ongoing operations and future enhancements