Senior SQL Developer

This position is primarily responsible for developing, tuning and refactoring data solutions to support business applications and analytical tools. Includes some database administrative duties along with development and design roles.

Essential Duties and Responsibilities

Support Data Architect in designing data solutions for analytical and operational needs in conjunction with business analysis personnel

Develop, tune, and refactor SQL databases and database objects, ETL processes, and reporting and analytics solutions, to support business needs

Identify and suggest areas in existing data solutions that can be improved, assist in planning and implementing identified improvements

Work with application developers, project managers, business stakeholders, and QA to develop database solutions that meet business requirements

Document datastreams, and database and ETL objects

Database and ETL optimization and tuning

Knowledge-share with team members and perform peer code review to ensure efficient database code

Some availability during non-business hours to resolve system issues as needed

Ensure adherence to coding, documentation, solution, and source control standards

Other duties as assigned

Knowledge, Skills, and Abilities

Strong T-SQL, SSIS, and SSRS programming and debugging skills is highest priority

Experience developing successful database solutions and troubleshooting as needed

Advanced analytical and problem-solving skills

5+ years of experience in all phases of SDLC and working within development teams including project planning, estimating, application architecture, programming and testing

Experience with Microsoft development tools and technologies including: SQL Server 2014 and later, SSIS, SSRS, Visual Studio, source control

Familiarity with usual office productivity tools (MS Office, email, phone, etc.)

Experience with Power BI or related tools a plus

Familiarity with RedGate family of SQL Server tools a plus

Education and Experience

This position requires a four-year degree or equivalent years’ experience working in service, or customer/ client relations. Previous experience in pharmacy, health insurance field is preferred, but not required. On the job training is provided and requires continuous product knowledge development in the areas of manufacturers, healthcare, pharmacy, PBM, company specific product offerings, and company capabilities and limitations.

Work Environment / Physical Demands

This position is in a typical office environment which requires prolonged sitting in front of a computer. Requires hand-eye coordination and manual dexterity sufficient to operate standard office equipment including operation of standard computer and phone equipment. May have occasional high stress when dealing with customers/clients or in emergency situations. May require long hours on business-critical projects or in case of emergency.

Related Jobs

Clear All

Filter

Email Me Jobs Like These

QA Analyst II

WellDyneRx LLC Lakeland, FL 33810 November 4, 2020 Information Technology

Send to friend Save

View more 5 years ago

Company Description

Voted as one of the best places to work in IT, our exceptional company culture is fueled by autonomy, collaboration, empowerment and transparency. We encourage innovation, continuous learning and personalized career development plans. Our focus on rapid growth and company culture equips us with a great platform to mentor, coach and lead our future architects.

When it comes to hiring, we don’t just look for the right person for the job, we seek out the right person for us. Along the way, we provide plenty of opportunity to be creative and grow professionally in a fun, high-energy environment.

Job Description

Do you think in code?

You will drive several exciting initiatives, help solve problems, no matter how big or small, work on business-critical projects built around cutting-edge technologies, and convey strategy and accuracy to our top level decision makers.

We believe that our competitive advantage is based on accurate, reliable, and well architected data. We have a large multi company environment with many online transactional systems creating vast amounts of data used to make strategic decisions.

Our Stack Rocks! (and includes the latest technology)

Microsoft Stack

SQL Server 2008-2016
ETL – (SQL Server Integration Services (SSIS), Informatica, SQL Service Broker)
SQL Server Analysis Services (SSAS Multi-Dimensional and Tabular)
Red-Gate Developer Bundle
MSDN Subscriptions (Visual Studio Enterprise)
Visual Studio (and Team Foundation Server)
Big Data
Windows Azure
SQL Server Reporting Services (SSRS), Tableau, Power BI

Qualifications

Experience developing MS SQL Server 2008-2016 solutions, Azure SQL, or other relational databases.
Experience with an ETL tool such as SSIS or Informatica PowerCenter.
Experience with Microsoft Reporting Services 2012-2016, Power BI, or Tableau.
Comprehension of relational and dimensional modeling.
Familiarity with performance tuning techniques such as indexing and analyzing query execution plans.
Experience with agile development (Scrum, Kanban).
Service Broker knowledge would be a plus.
Bachelor’s Degree or higher in Computer Science or related field.
Ability to take ownership and facilitate consensus among a diverse group of stakeholders.
Must be willing to collaborate and problem solve in an open team environment.
Flexible and adaptable in regards to learning and understanding new technologies.
Highly self-motivated and directed.

Benefits

Competitive Salary + Full Benefits: Medical, Dental, and Vision
401K, life, Long-term Disability Insurance
Starting Vacation at 3 weeks per year, gradually increasing up to 5 weeks at 5 years
Continuous Learning: Tuition Reimbursement Program & Technical Training

More Info

Industry: Automotive, Financial Services, Retail
All your information will be kept confidential according to EEO guidelines.
Third-party and C2C are not available. This is a full-time, permanent position.
Sponsorship is not an option for this position. Candidates must be US citizens or “Green Card” holders.

Job Type: Full-time