SQL Server Administrator & Business Intelligence Analyst

Computing Technologies, Inc.
Chesterfield, United States of America
13 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate
Compensation
$ 110K

Job location

Chesterfield, United States of America

Tech stack

Business Analytics Applications
Data analysis
Backup Devices
Business Systems
Cloud Computing
Information Systems
Databases
Data Governance
Data Integration
ETL
Data Warehousing
Database Development
Database Security
Decision Support Systems
Dimensional Modeling
Disaster Recovery
Python
Microsoft SQL Server
SQL Azure
Performance Tuning
Query Optimization
Power BI
SQL Stored Procedures
SQL Databases
SQL Server Integration Services
Tableau
T-SQL
System Availability
Snowflake
Database Optimization
Reliability of Systems
Database Performance
Indexer
Data Layers
Information Technology
Data Analytics
Data Management
Tools for Reporting
SQL Server Management Studio (SSMS)

Job description

We are seeking a highly skilled SQL Server Administrator & Business Intelligence Analyst to manage, optimize, and maintain our Microsoft SQL Server environment while developing business intelligence solutions that support data-driven decision making across the organization. This role is responsible for database administration, performance tuning, data integration, reporting, dashboard development, and analytics using Tableau., SQL Server Administration

  • Install, configure, maintain, and upgrade Microsoft SQL Server environments.
  • Monitor database performance, availability, and security.
  • Perform database backups, restores, disaster recovery planning, and testing.
  • Troubleshoot and resolve database-related issues and outages.
  • Optimize SQL Server performance through indexing, query tuning, and resource management.
  • Implement and maintain database security, user permissions, and compliance standards.
  • Monitor storage utilization and plan for database growth.
  • Develop and maintain database maintenance plans and automated jobs.

Database Development & Data Management

  • Design, develop, and maintain SQL queries, stored procedures, views, functions, and scripts.
  • Create and maintain data models that support reporting and analytics needs.
  • Ensure data quality, integrity, and consistency across systems.
  • Develop and support ETL processes for data integration and transformation.
  • Work with business stakeholders to understand data requirements and provide solutions.

Business Intelligence & Tableau Development

  • Design, develop, and maintain Tableau dashboards, reports, and visualizations.
  • Create data sources and semantic layers to support self-service analytics.
  • Translate business requirements into actionable KPIs, metrics, and dashboards.
  • Ensure dashboards are accurate, performant, and user-friendly.
  • Provide ongoing support and enhancements to existing BI solutions.
  • Train and support business users in leveraging Tableau and reporting tools.

Collaboration & Analytics

  • Partner with business leaders to identify reporting and analytical opportunities.
  • Assist departments in defining data requirements and reporting standards.
  • Provide insights and recommendations based on data analysis.
  • Document systems, processes, data definitions, and reporting methodologies.
  • Participate in data governance and data quality initiatives., * Database Administration
  • SQL Development
  • Performance Tuning
  • Tableau Dashboard Development
  • Business Intelligence
  • Data Warehousing
  • ETL Development
  • Data Modeling
  • Analytics & Reporting
  • Project Management
  • Communication & Stakeholder Engagement

Success Metrics

  • SQL Server uptime and system reliability.
  • Database performance and optimization improvements.
  • Accuracy and adoption of Tableau dashboards.
  • Timely delivery of reporting and analytics solutions.
  • Data quality and governance compliance.
  • User satisfaction with BI and reporting capabilities.

Pay: $85,000.00 - $110,000.00 per year

Requirements

Do you have experience in Tableau?, Do you have a Bachelor's degree?, The ideal candidate will possess strong technical expertise in SQL Server administration, data modeling, ETL processes, and Tableau development, along with the ability to translate business requirements into meaningful reporting and analytics solutions., * Bachelor's degree in Information Systems, Computer Science, Data Analytics, or related field (or equivalent experience).

  • 5+ years of experience administering Microsoft SQL Server environments.
  • Strong expertise in T-SQL, query optimization, and database performance tuning.
  • Experience with SQL Server Integration Services (SSIS) or similar ETL tools.
  • 3+ years of experience developing Tableau dashboards and reports.
  • Strong understanding of data warehousing, dimensional modeling, and business intelligence concepts.
  • Experience with backup, recovery, high availability, and disaster recovery strategies.
  • Knowledge of database security and best practices.
  • Strong analytical and problem-solving skills.

Preferred Qualifications

  • Microsoft SQL Server certifications.
  • Tableau Desktop Certified Professional or equivalent certification.
  • Experience with Azure SQL, Power BI, Snowflake, or cloud-based analytics platforms.
  • Experience working with ERP, CRM, or enterprise business systems.
  • Knowledge of data governance and master data management practices.
  • Experience with Python, R, or other data analysis tools.

Benefits & conditions

Pulled from the full job description

  • Health insurance
  • Retirement plan
  • Paid time off, * Health insurance
  • Paid time off
  • Retirement plan

Apply for this position