Sr Data Engineer


Crossword Staffing Solutions LLC
Dice Job Match Score™
🔢 Crunching numbers...
Job Details
Skills
- Analytical Skill
- Application Development
- Attention To Detail
- Backup
- Collaboration
- Communication
- Computer Science
- Conflict Resolution
- Data Engineering
- Data Governance
- Data Integration
- Data Modeling
- Data Processing
- Data Quality
- Data Security
- Database
- Database Design
- Database Performance Tuning
- Dimensional Modeling
- Documentation
- ELT
- Embedded Systems
- Extract, Transform, Load
- FOCUS
- Identity Management
- Information Technology
- Management
- Mentorship
- Microsoft
- Microsoft Azure
- Microsoft Power BI
- Microsoft SQL Server
- Microsoft SSIS
- Microsoft SSRS
- Microsoft Technologies
- Query Optimization
- Regulatory Compliance
- SQL
- Slowly Changing Dimensions
- Optimization
- Performance Tuning
- Problem Solving
- Promotions
- Recovery
- Soft Skills
- Stored Procedures
- Teamwork
- Technical Support
- Transact-SQL
Summary
Sr Data Engineer
The Sr Data Engineer will play a pivotal role in designing, developing, and maintaining robust database structures and data integration processes. This role involves collaborating with software developers, data analysts, and IT team members to ensure data integrity, quality, and performance. The ideal candidate will have a strong background in Microsoft technologies, particularly SQL Server, and will be responsible for optimizing database performance, developing ETL/ELT processes, and ensuring compliance with data governance and security policies.
Responsibilities
- Database Design and Development: Design, implement, and maintain database structures and dimensional data models, including tables, views, indexes, and schemas using Microsoft SQL Server.
- Data Integration and ETL Processes: Design and develop ETL and ELT processes using SQL Server Integration Services (SSIS) to ingest and transform data from multiple sources. Parameterize SSIS packages and create environment variables for SSIS Catalog package deployment. Use expressions in concert with package parameters to make connections dynamic and streamline package deployment/promotion across environments. Ensure data quality, consistency, and integrity across different systems and environments.
- Query Optimization: Analyze and optimize SQL queries to improve execution times and reduce resource consumption. Implement indexing strategies to speed up data retrieval operations. Rewrite complex queries to make them more efficient and easier to maintain. Collaborate with developers to optimize queries embedded within applications.
- Collaboration and Support: Work closely with software developers, data analysts, and other IT team members to understand requirements and provide database solutions. Provide technical support and troubleshooting for database-related issues. Mentor and guide junior data engineers and other team members.
- Documentation and Compliance: Create and maintain comprehensive documentation for database designs, processes, and procedures. Ensure compliance with data governance, security policies, and industry regulations.
Requirements
<>Required Skills>- Education: Bachelor's degree in computer science, Information Technology, or a related field. Master's degree preferred.
- Experience: Minimum of 9 years of experience in data engineering and database development with a focus on Microsoft technologies.
- Technical Skills:
- Proficiency in SQL Server, T-SQL programming, and dimensional data modeling.
- Experience developing ETL and ELT pipelines using SSIS.
- Hands-on experience with SSIS Catalog deployments, including SSIS package parameterization, environment variables, and Package and Project Deployment models.
- Experience with database performance tuning and optimization techniques.
- Knowledge of data security, access management, backup, and recovery practices across SQL Server.
- Soft Skills:
- Strong analytical and problem-solving skills.
- Excellent communication and teamwork abilities.
- Ability to work independently and manage multiple tasks and projects simultaneously.
- Detail-oriented with a focus on quality and accuracy.
- Strong SSIS development skills: Including package parameters, environment variables, catalog deployments, and expressions.
- Knowledge of data modeling and database design principles: Including strong understanding of dimensional data models (star schemas, facts and dimensions, slowly changing dimensions, and data denormalization).
- Nice to Have: Azure/Fabric exposure.
- Dice Id: 91171944
- Position Id: CWDDATAER
- Posted 48 minutes ago
Company Info
About Crossword Staffing Solutions LLC
Crossword is a diversity supplier with global presence specializing in a business service with the blend of talent, technology, and a relentless commitment for the success of our customers. For years, we have been providing a generous repository of manpower and consistent availability of external subject matter experts with the best speed and quality.
We understand how critical talent is to every organization, as well as how the world of work and the workplace is evolving. Crossword offers the most effective means to help you acquire, manage and optimize the right talent whenever you need it. Our goal is to meet expectations of excellence – those of our customers, our employees, our candidates and those of our community.
Combining the depth of our multidisciplinary team of professionals and boundless innovation with our “customer-centric” approach to service, we have the right resources to help companies of all sizes cultivate real business value at the right price.
We further differentiate ourselves with our agile engagement model and proven methodology which attracts premier talent and helps our customers achieve their staffing goals. We seek out and partner with our clients to devise new and innovative ways to exceed their needs while simultaneously finding creative solutions to address dynamic changes within their organizations.
Extensive technology and service experience allows our team to develop a comprehensive understanding of your unique communication and technology needs and respond to those needs quickly and efficiently.
