Sr SQL Server Developer
3B Staffing LLC, Brecksville, OH, United States
Day to Day:
Creating SSRS packages
Creating SQL stored procedures
Creating dashboards with python
Extracting and Loading Data using API's
Building ETL processes
Must Haves:
10-15 years of SQL development experience
Azure Data Factory
API's
Python experience
SSRS, ETL
Able to interface with senior leadership
Experience creating dashboards
Title : SQL Server Developer
Location:
Brecksville, OH 44141
Remote / Hybrid Schedule:
3 day onsite and 2 remote (they can choose which)
OR
Fully remote
Hours | shift | On Call | Timezone:
8-5 EST hours
Duration:
6+ months, contract to hire (they will sponsor but must be able to convert after 6 months)
Start:
ASAP
Job Description Summary
Roles & Responsibilities:
Design SSIS/ETL packages to load and transform data to and from various source and destination systems in specified formats (e.g., SQL Server databases, web services, flat files).
Design, develop and support new/existing data marts
Troubleshooting of existing BI processes and timely resolution of the issues.
Work with business users and business analysts to gather requirements for the design, creation, and implementation of changes to existing database systems or new systems.
Support and maintenance of existing processes and systems
Closely work with offshore and onshore development teams and deliver projects on time
Create support documentation and cross-train other development team members on implemented processes so that they can support these solutions.
Must Have:
Expert level experience with T-SQL(10+ years). Should have hands on experience with writing complex and optimized queries, analytical queries and performance tuning.
Extensive hands-on with SSIS (10+ years)
Must have hands-on with architecting end-to-end integration solutions and data syncs between OLTP and BI systems.
Must have experience with extracting & loading data using APIs.
Build custom modules using C#
Experience with Power BI developing Analytical and Operational dashboards.
Experience with Microsoft Azure (ADF) (5+ years)
Experience with Python (3+ years)
Prior experience working with healthcare data
Excellent organizational, interpersonal, presentation, and analytical skills. Ability to perform comfortably in a fast-paced, dynamic and deadline-oriented work environment
Ability to successfully execute multiple complex tasks simultaneously
Good to Have:
Experience with Snowflake
Experience using PowerShell scripts (2+ years)
Creating SSRS packages
Creating SQL stored procedures
Creating dashboards with python
Extracting and Loading Data using API's
Building ETL processes
Must Haves:
10-15 years of SQL development experience
Azure Data Factory
API's
Python experience
SSRS, ETL
Able to interface with senior leadership
Experience creating dashboards
Title : SQL Server Developer
Location:
Brecksville, OH 44141
Remote / Hybrid Schedule:
3 day onsite and 2 remote (they can choose which)
OR
Fully remote
Hours | shift | On Call | Timezone:
8-5 EST hours
Duration:
6+ months, contract to hire (they will sponsor but must be able to convert after 6 months)
Start:
ASAP
Job Description Summary
Roles & Responsibilities:
Design SSIS/ETL packages to load and transform data to and from various source and destination systems in specified formats (e.g., SQL Server databases, web services, flat files).
Design, develop and support new/existing data marts
Troubleshooting of existing BI processes and timely resolution of the issues.
Work with business users and business analysts to gather requirements for the design, creation, and implementation of changes to existing database systems or new systems.
Support and maintenance of existing processes and systems
Closely work with offshore and onshore development teams and deliver projects on time
Create support documentation and cross-train other development team members on implemented processes so that they can support these solutions.
Must Have:
Expert level experience with T-SQL(10+ years). Should have hands on experience with writing complex and optimized queries, analytical queries and performance tuning.
Extensive hands-on with SSIS (10+ years)
Must have hands-on with architecting end-to-end integration solutions and data syncs between OLTP and BI systems.
Must have experience with extracting & loading data using APIs.
Build custom modules using C#
Experience with Power BI developing Analytical and Operational dashboards.
Experience with Microsoft Azure (ADF) (5+ years)
Experience with Python (3+ years)
Prior experience working with healthcare data
Excellent organizational, interpersonal, presentation, and analytical skills. Ability to perform comfortably in a fast-paced, dynamic and deadline-oriented work environment
Ability to successfully execute multiple complex tasks simultaneously
Good to Have:
Experience with Snowflake
Experience using PowerShell scripts (2+ years)