SQL Database Administrator/Developer

Softec Solutions Denver , CO 80208

Posted 2 months ago

CONTRACT TO HIRE

SQL Database Administrator / Developer

Founded in 1996, based in Denver, CO, Softec Solutions is a leading IT staffing solutions and services company that takes the challenge out of finding high-demand technical skill sets. Softec takes a proactive approach in understanding business challenges and local market analytics, provides customized recruiting solutions, and delivers value and results.

Softec Solutions is currently seeking an SQL Database Administrator/Developer.

This role is designed to ensure integrity of compile complex data sets, produce an effective reporting environment, generate insight, and help draw conclusions and recommendations about our clients business using our client's people data. The role would have a focus on developing and maintaining our SQL database and Tableau tools, acting as a liaison between the People Insights & Analytics team and IT. The scope of work includes developing business intelligence, and empirically supported recommendations to leaders, in summary and executive ready formats. The successful candidate will also develop new analytical solutions, improve SQL/Tableau, and drive decisions.

Duties & Responsibilities

  • Develops, maintains and enhances the HR Analytics SQL Server database in SQL Server Management Studio, using Informatica workflows, and current and future direct access needs for customers via Tableau and other BI tools.

  • Understands in depth the data, sources and reporting outputs need to ensure quality data

  • Acts as owner for database integrity, developing and maintaining a cohesive audit process

  • Collaborates with vendors and partners to structure and integrate outside data sources

  • Identifies opportunities to automate and streamline reports and BI tools, redesigns to include these efficiencies

  • Identify problems and propose potential analytical solutions

  • Make recommendations aligned with business goals and strategy

  • Participate and lead projects and programs with people data, prioritizing work based on changing demands

  • Create effective visualizations tailored to the context of the data and the audience

  • Proactively seek to improve processes and programs

  • Ensure the integrity of sensitive, confidential data

  • Proficiency in software tools like Excel, Workday (or other HRIS), SQL, and Tableau

  • Explain complex, technical issues in a simple, effective way

  • Proactively collaborate, guide, and provide expertise to internal business partners

  • Present to audiences at varied skill-levels, telling a story with the data

  • Build strong partnerships with stakeholders within and outside of the team

  • Other duties as assigned

Minimum Qualifications

Bachelors Degree required in business, economics, engineering, finance, mathematics, statistics, psychology, technology or other applicable quantitative or management related field.

1+ year in a business environment, gathering and using data to solve business problems. Management consulting or similar experience a plus.

2 years of experience in database querying and understanding of relational database design. Advanced SQL Server skills required. Workday preferred.

1 year or more of intermediate to advanced ETL development using Informatica required.

1 year of experience in building and maintaining Tableau.

Experience using working with multiple data sources to generate insights from analyses, answering questions, creating solutions, and manipulating large data sets to measure the effectiveness of projects, programs, and efforts for an organization.

Strong written and verbal communication skills; experience collaborating on project teams, managing relationships with clients, and presenting to audiences a plus.

Intermediate to advanced skills in Excel, Word, Outlook and PowerPoint required.

Human Resources experience preferred.

Softec Solutions, Inc is an EEO/Affirmative Action Employer.

PEOPLE. EXPERIENCE. RESULTS.


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Senior SQL Database Administrator Minneapolis Denver Or Atlanta Market

US Bank

Posted 1 week ago

VIEW JOBS 3/19/2020 12:00:00 AM 2020-06-17T00:00 U.S. Bank is seeking a detail-oriented Senior SQL Database Administrator with data security and application resiliency experience to contribute toward the success of our technology initiatives. Manages physical databases on specific database technologies (SQL). Designs and implements back-up, recovery, archiving, and conversion strategies. Manages and maintains data definitions in all production and non-production databases and replication servers. Manages database distribution, security, and access requirements. Designs and develops logical and physical layers of databases. Handles testing, reporting, back-up, and restores. Provides technical assistance and mentoring to staff for developing conceptual and logical database design and the physical database. Recommends, installs, and maintains database software. Monitors performance and performs database training and assists application developers with train tuning efforts. A successful candidate will have 6 years of progressive experience managing and administering SQL Databases, ideally SQL 2012 . This individual will also have a strong background in troubleshooting for high availability and application resiliency. Experience in utilizing Powershell in system administration, Performance Tuning and Idera Diagnostic Manager knowledge is strongly preferred. This is a remote opportunity, but must be based in the Minneapolis, Denver or Atlanta markets. This position does require a quarterly, 1 week, 24/7, on-call rotation. Basic Qualifications * Bachelor's degree or equivalent work experience * 6 years of experience with tools, facilities and techniques for managing and administering data. Preferred Skills/Experience * Extensive experience in SQL server administration; any version newer than 2012 * Experience with configuration and troubleshooting for High Availability and Application Resiliency * Knowledge in utilizing Powershell in system administration * Knowledge in Idera Diagnostics Manager for performance analysis * Past SQL DBA experience strongly preferred * Ability to partner and troubleshoot with other technical teams, including application teams to identify and build out solutions. US Bank Denver CO

SQL Database Administrator/Developer

Softec Solutions