Sign upLog in

Database Developer

OP Consulting Group LLC

St Paul, MN(remote)

Apply
JOB DETAILS
SKILLS
Agile Programming Methodologies, Code Reviews, Cross-Functional, Data Migration, Data Modeling, Database Administration, Database Extract Transform and Load (ETL), Database Programming, DevOps, Finance Software, GitHub, Government Regulations, Identify Issues, Jenkins, Knowledge Transfer, Leading Edge Technology, Legal, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Microsoft Windows Azure, On Call, Performance Tuning/Optimization, Power BI, Procedure Development, Production Support, Python Programming/Scripting Language, SQL (Structured Query Language), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Scripting (Scripting Languages), Software Administration, Stored Procedures
LOCATION
St Paul, MN(remote)
POSTED
7 days ago

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

 

About the Company

O

OP Consulting Group LLC