What are the responsibilities and job description for the Database Developer position at OP Consulting Group LLC?
Join our dynamic team in St Paul, MN, a city known for its vibrant culture and thriving tech scene. Here, you will have the opportunity to work on innovative projects and contribute to the development of cutting-edge database solutions.
Tasks
- Design and maintain various databases, including stored procedures, indexing, and data models.
- Develop and optimize ETL pipelines and workflows using SSIS, Python, PySpark, and SQL Server.
- Execute large-scale data migrations, including cleansing, validation, and transformation across enterprise systems.
- Develop and optimize SQL scripts and stored procedures to support data conversion, validation, and ongoing processing needs.
- Build data ingestion and transformation workflows across raw, staging, curated, and analytics layers.
- Build and maintain various reporting solutions using SSRS and PowerBI.
- Design and implement logical and physical data models (ERDs) for various applications.
- Develop stored procedures, views, SQL scripts, and other database components supporting transactional and reporting systems.
- Provide production support, including troubleshooting performance issues and on-call support when needed.
- Collaborate with cross-functional teams and participate in Agile ceremonies, development activities, code reviews, and release cycles.
- Provide knowledge transfer.
Desired Skills
- 10 years of experience in database development or data engineering.
- Expertise in SQL Server, T-SQL, and performance tuning.
- Experience with ETL tools (SSIS), Python, or PySpark.
- Strong background in data modeling and data integration.
- Experience with reporting tools (SSRS, PowerBI).
- Working knowledge of DevOps tools such as Azure DevOps, GitHub, or Jenkins.
- Experience supporting critical applications in financial, government, or legal industries.
Duration: 1 year with possible extension.
Remote/Hybrid/Onsite: Remote
Mode of Interview: Virtual Interview