What are the responsibilities and job description for the Data Engineer position at Yulista?
StraitSys Inc
Regular
PRIMARY FUNCTION
StraitSys is seeking a skilled Data Engineer / SQL Server DBA to manage, optimize, and enhance our SQL Server environments. This role is responsible for designing and maintaining SQL Server Integration Services (SSIS) ETL pipelines and supporting database operations across multiple environments. You will play a key role in the administration, configuration, development, and deployment of SSIS services, ensuring seamless execution of automated processes and enabling efficient data integration from various sources.
While SSIS expertise is critical for immediate projects, we value forward-thinking individuals who are eager to expand their skills, as we continue to evolve our data architecture and explore opportunities to leverage cloud-native tools. This role offers a unique opportunity to support both immediate business needs and to grow with the organization as we continually work to modernize.
ESSENTIAL FUNCTIONS
- SSIS Development & Deployment : Design, develop, and maintain enterprise-grade SSIS ETL pipelines to facilitate data integration from various data sources.
- SSIS Administration & Configuration : Install, configure, and manage SSIS environments across development, testing, and production environments. You will ensure that SSIS services are properly configured for automated execution, including security settings, service accounts, and failover capabilities.
- Cross-Environment Deployment : Deploy SSIS-developed services across multiple environments, ensuring automated execution on the appropriate servers. You will configure, fine-tune, monitor, and support the continuous execution of ETL services.
- Data Engineering : Perform data engineering tasks, including data cleansing, transformation, and integration, to optimize data flows and support business-critical processes.
- Database Performance & Optimization : Monitor and optimize database performance, addressing bottlenecks in SSIS ETL workflows and / or SQL queries, and ensuring efficient use of resources across the system.
- SQL Server Administration : Manage SQL Server instances, including backup, recovery, query optimization, performance tuning, and security management.
- Data Pipelines & Automation : Automate data workflows using SQL Server Agent jobs, ensuring efficient execution of scheduled jobs across environments.
- Security & Compliance : Maintain database security, encryption, and access controls, ensuring compliance with Security Technical Implementation Guides (STIGs), industry standards, and internal security policies. Implement and audit security configurations to ensure databases adhere to required security benchmarks and best practices.
- Collaboration with Development Teams : Partner with application development teams to design and implement database solutions that align with business needs and application requirements.
- Backup & Recovery : Ensure high availability and data integrity through robust backup and recovery processes, minimizing downtime.
SUPERVISORY RESPONSIBILITIES
None
DESIRED KNOWLEDGE, SKILLS, & ABILITIES :
QUALIFICATIONS :
PREFERENCE STATEMENT
Preference will be given to Calista shareholders and their descendants and to spouses of Calista shareholders, and to shareholders of other corporations created pursuant to the Alaska Native Claims Settlement Act, in accordance with Title 43 U.S. Code 1626(g).
EEO STATEMENT
Additionally, it is our policy to select, place, train and promote the most qualified individuals based upon relevant factors such as work quality, attitude and experience, so as to provide equal employment opportunity for all employees in compliance with applicable local, state and federal laws and without regard to non-work related factors such as race, color, religion / creed, sex, national origin, age, disability, marital status, veteran status, pregnancy, sexual orientation, gender identity, citizenship, genetic information, or other protected status. When applicable, our policy of non-discrimination applies to all terms and conditions of employment, including but not limited to, recruiting, hiring, training, transfer, promotion, placement, layoff, compensation, termination, reduction in force and benefits.
REASONABLE ACCOMMODATION
It is Calista and Subsidiaries' business philosophy and practice to provide reasonable accommodations, according to applicable state and federal laws, to all qualified individuals with physical or mental disabilities.
The statements contained in this job description are intended to describe the general content and requirements for performance of this job. It is not intended to be an exhaustive list of all job duties, responsibilities, and requirements.
This job description is not an employment agreement or contract. Management has the exclusive right to alter the scope of work within the framework of this job description at any time without prior notice.