Position: MSSQL Server DB Engineer
Company: CIGen
Experience required: 2y
Category: Data Engineer
English level: upper
Published: 2022-12-01T00:00:00+02:00

At CIGen we partner with both startups and experienced enterprises to help them achieve their business goals through software solutions.

Our company is driven by the core values that are professionalism, trust, and mutual respect.

We believe that the only way to achieve long-term business success is to build long-term trusted relationships with clients, employees, and partners.

Hence, the quality of our services is crucial!

Our team consists of active and open-minded professionals, who constantly grow and share their knowledge.

Flexible schedule, open management and a friendly environment are part of our culture.

We are Microsoft Gold Partner.

Currently, we are looking to add a **MSSQL Server DB Engineer** to our team.

This position could be fully remote.

 🔹**Requirements:**
• Have 2-3 years of experience in creating highly dynamic SSIS packages supporting package parameters, programmatic control flows, exception handling, and reporting
• Demonstrate an advanced proficiency with SQL (dynamic SQL, recursive CTEs, row hashing)
• Have a strong understanding of relational database design principles
• Comfortably break down business user requests into actionable technical steps, and raise clarifying questions to the team when more information is needed
• Demonstrate creativity and adaptability in an environment where tasks vary from day to day and often require investigation and planning rather than being explicitly defined
• Possess a balance of **curiosity** in an environment where answers tend to be discovered and discussed, and **caution** in an environment where best practices are adopted to ensure consistency and accuracy
• Upper-Intermediate level of English

🔹**Would be a plus:**
• Experience gathering requirements from business users and/or stakeholders and defining key objectives
• Experience with one or more change data capture methods
• Have working knowledge of customer matching and householding methods and principles
• 2-3 years of experience in database design

🔹**Responsibilities:**
• Work primarily with MS SQL Server AND SQL Server Integration Services (SSIS) to create and maintain processes which receive client data sets and move them along our flow of services, including staging, transformation, customer matching, and loading into our Velocity CDP platform
• Perform thorough data profiling methods to understand the structure, substance, and quality of client data sets
• Provide continuous client support across our services, including investigating data discrepancies, researching matching outcomes, and providing product support of our Velocity CDP platform
• Create and contribute to processes using internal data matching, transformation, and integration tools.

🔹 **About the project:**
The Modern Marketing Platform. We develop different products in marketing related to data analysis & data processing. One of those projects is a classic Big Data solution aimed at simplifying the sorting of millions of data loads daily. The project follows an ETL process scenario for decision support suitable for data warehouses and Business Intelligence tools. Users can upload huge chunks of data loads from various sources and transform them to get some valuable marketing/advertisement insights.  

🌻 **We offer:**
• Interesting and challenging projects 
• Flexible working hours to support your work-life balance 
• Transparent and flexible processes 
• Endless possibilities for your professional growth and continuous support from management 
• Comfortable office in Lviv or an opportunity to work remotely 
• Paid vacations and sick leaves 
• In-house English tutor 
• Cozy, friendly and fun atmosphere
...and much more! 

We look forward to hearing from you! 

🚀 Apply today!