- Plan, design, and implement complex data interfaces, transformations, and OLTP and OLAP databases
- Model, develop, and implement transactional, ETL staging, and analysis/reporting databases, data structures, and cubes to satisfy business and technical requirements
- Complete continuous improvement projects to further automate, fix issues, and increase efficiency across database, ETL, and business line processing
- Focus on SQL and PL/SQL application development using packages, store procedures, functions, triggers, and views
- Automate complex processes using SQL agent jobs, SQL Server Integration Services, etc
- Manage SQL code in a source control system
- Implement database performance monitoring and tuning
- Establish and enforce SQL development coding standards and best practices
- Lead/participate in SQL code reviews
- Train other development teams on the implementation of the code
- Write clean, fast code that is free of bloat and unnecessary overhead
- Ensure accuracy and integrity of data through the development of constraints and validation rules
Requirements
- Bachelor’s degree in computer science or related field is preferred
- A combination of education and experience will be considered
- Experience with: SQL Server 2019 or above, SSIS, SSRS, SSAS
- Extensive (ideally at least 7 years of) experience developing ETL
- A strong technical background and substantial experience in managing and administering Microsoft SQL Server infrastructure
- Demonstration of a deep understanding of database architecture, performance, security, and integrity
- Data access and table maintenance, developing and administering ETL processes using SSIS and other tools
- SQL coding and performance tuning, and proactive monitoring and alerting
- Experience utilizing and interpreting data models, developing reporting, data marts, analytic cubes, and visualization
- Strong analytical and critical thinking skills
- Ability to clearly articulate complex technical information to non-technical stakeholders and collaborate effectively with cross-functional teams
- Ability to manage multiple projects and priorities while meeting deadlines and maintaining high-quality work
- Ability to find innovative solutions to data management challenges, especially when dealing with complex or ambiguous situations
- Ability to evaluate and interpret data-related requirements, anticipate issues, and propose effective, scalable solutions
- Commitment to staying current with database/reporting/Microsoft SQL Server tools and technologies
Core Competencies
Demonstrates expertise in SQL and PL/SQL application development, including ETL processes and database performance tuning. Proficient in managing Microsoft SQL Server infrastructure and implementing data solutions that ensure accuracy, integrity, and efficiency.
Hard Skills
- SQL Development
- PL/SQL Application Development
- ETL Processes
- Database Architecture
- Performance Monitoring
- Data Structures
- Data Analysis
- Data Integrity
- SQL Coding Standards
- Data Visualization
Soft Skills
- Analytical Thinking
- Collaboration
- Project Management
- Problem Solving
- Communication
Industry Keywords
- OLTP
- OLAP
- Data Marts
- Analytic Cubes
- Continuous Improvement
Tools & Technologies
- SQL Server Integration Services
- SQL Server Reporting Services
- SQL Server Analysis Services
- Source Control Systems
- SQL Agent Jobs
#J-18808-Ljbffr
Sign in
To continue your applicationor continue with email
By continuing you agree to our Terms & Privacy Policy.
Similar jobs
Show more