The Role
Design, build, and maintain SQL Server databases, ETL pipelines (SSIS, Python, PySpark), and data models. Execute large-scale data migrations, cleansing, validation, and transformation. Develop and optimize T-SQL, stored procedures, and reporting solutions (SSRS, PowerBI). Build ingestion and transformation workflows across raw, staging, curated, and analytics layers. Provide production support, performance troubleshooting, on-call support, collaborate in Agile teams, and deliver knowledge transfer.
Summary Generated by Built In
PLEASE NOTE:
- IT IS A 100 % REMOTE POSITION
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.
Requirements
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.
Skills Required
- 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.
Similar Jobs
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Omm IT Solutions is a leading provider of IT consulting, analysis, and advisory services, specializing in delivering technical solutions for federal and state government agencies. Their offerings include application development, cybersecurity services, cloud advisory, network modernization, and data analytics.
