LaunchPoint is seeking a highly skilled Data Analyst with deep expertise in SQL administration, T-SQL scripting, and SQL Server performance optimization. The ideal candidate will have a strong technical background in managing multiple databases, optimizing SQL queries, writing complex stored procedures, and working with SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS). This role will involve data analysis and database management tasks to support our business intelligence initiatives and ensure data integrity, availability, and performance across our systems.
Key Responsibilities:
SQL Administration & Optimization:
- Administer, monitor, and maintain SQL Server databases to ensure high levels of performance, availability, and security.
- Optimize database performance by identifying and resolving performance bottlenecks, including tuning SQL queries and indexing strategies.
- Implement and manage SQL replication, backups, and disaster recovery processes.
T-SQL & Stored Procedures:
- Write, optimize, and maintain complex T-SQL queries and stored procedures to support business applications and reporting needs.
- Develop and automate data extraction, transformation, and loading (ETL) processes using T-SQL and SSIS.
- Ensure code quality through best practices in SQL development, including code reviews and performance testing.
Database Management:
- Manage multiple SQL Server instances, ensuring their optimal performance and reliability.
- Perform regular database maintenance tasks such as backups, restores, indexing, and data migrations.
- Monitor database health, performance, and capacity planning.
Data Visualization:
- Design, develop, and deploy reports using tools such as SSRS, Tableau, etc. to meet business reporting requirements.
- Collaborate with stakeholders to gather requirements and deliver meaningful insights through data visualization and reporting.
SQL Server Integration Services (SSIS):
- Develop, maintain, and optimize SSIS packages for data integration and ETL processes.
- Ensure the reliability and efficiency of data workflows and integrations across different systems.
Collaboration & Support:
- Work closely with data analysts, developers, and business stakeholders to understand data needs and provide solutions.
- Provide technical support and guidance to other team members on SQL-related matters.
- Participate in the design and implementation of data governance and data quality initiatives.
Qualifications:
Education & Experience:
- Bachelor's degree in Computer Science, Information Systems, or a related field.
- 3-5+ years of experience in SQL Server administration, database management, and data analysis.
- Proven experience with T-SQL, SQL query optimization, and writing complex stored procedures.
- Experience with SSIS and at least one reporting service is required.
Technical Skills:
- Strong knowledge of SQL Server 2019/2022 or later versions.
- Expertise in SQL Server administration, including security, backups, replication, and disaster recovery.
- Proficiency in writing and optimizing T-SQL queries and stored procedures.
- Familiarity with data modeling, ETL processes, and database design principles.
- Experience with Azure is strongly preferred
Soft Skills:
- Excellent problem-solving and analytical skills.
- Strong communication and collaboration skills.
- Ability to work independently and manage multiple priorities in a fast-paced environment.
Please apply by visiting https://easyapply.co/job/data-analyst-missoula-montana?rcid=linkedin
WE ARE AN EQUAL OPPORTUNITY EMPLOYER