What You Will Do:
- Modernize the Data Warehouse and build Analytical Data Store, while also maintaining the existing legacy Data warehouses.
- Design, develop, and implement scalable batch/real time data pipelines (ETLs) to integrate data from a variety of sources into Data Warehouse and Data Lake
- Design and implement data model changes that align with warehouse dimensional modeling standards.
- Proficient in Data Lake, Data Warehouse Concepts and Dimensional Data Model.
- Responsible for maintenance and support of all database environments, design and develop data pipelines, workflow, ETL solutions on both on-prem and cloud-based environments.
- Design and develop SQL stored procedures, functions, views, and triggers
- Design, code, test, document, and troubleshoot deliverables
- Collaborate with others to test and resolve issues with deliverables
- Maintain awareness of and ensure adherence to standards regarding privacy.
- Create and maintain design documents, Source to Target mappings, unit test cases, data seeding.
- Ability to perform Data Analysis and Data Quality tests and create audit for the ETLs.
- Perform Continuous Integration and Deployment using Azure DevOps and Git
Skills and Experience You Will Need:
Required:
-
10+ years of previous experience
-
Experience in Cloud architecture (Azure/AWS)
-
Experienced with Azure Data Factory
-
Proficient in Snowflake:
-
Design of data marts
-
Hands-on experience with RBAC setup
-
Solid knowledge of architecture
-
Hands-on experience with admin setup
-
Extensive ETL experience
-
Excellent SQL capabilities
-
Agile methodology
Desired
Who We Are:
GalaxE, now Endava, is a professional IT services firm that specializes in platform-driven solutions and the use of automation to achieve enterprise business transformation and mission-critical change for some of the largest companies in the world. Using our proprietary solution set, GxFource®, we apply machine learning techniques and predictive analytics tools as part of a broad artificial intelligence strategy that provides effective impact and data-driven business transformation.
Since its founding, GalaxE has been dedicated to advancing the benefits of technology. Recently, we have joined forces with Endava, to offer our employees global exposure and enhanced opportunities. As we continue that legacy and look to the future, a focus on business enablement through agile, cost-efficient, and effective integration of people, process, and technology anchors our success. We revolutionize change in the costs of doing business that transform companies and their ability to leap beyond the competition.
We value people and are committed to diversity and inclusion where our employees are made to feel comfortable and are encouraged to be authentic.
We are always looking for passionate, entrepreneurial-minded innovators and disrupters; game-changers that take ownership of the work they produce and bring it each and every day. Working with like-minded team members you will get a chance to discover, develop, and use cutting-edge technologies to transform the way we deliver creative business solutions.
Sound like you? Join us and find out for yourself what it means for you, and your career, to be part of the GalaxE team. Let’s build something, together.
Equal Opportunity Employer/Veterans/Disabled
** Pay is based on several factors including market location and may vary depending on actual job-related knowledge, skills, and experience.
Physical Requirements:
-
Prolonged periods of remaining stationary at a desk and working on a computer
-
Must be able to lift to 15 lbs., as needed
-
Must be able to work on-site (corporate/client offices), as needed (not applicable for 100% remote roles)
-
Occasionally required to bend, kneel, crouch, and reach overhead.
-
Hand-eye coordination necessary to operate computers and various pieces of office equipment.
-
Specific vision abilities required include close vision, the ability to tolerate fluorescent lighting, and the ability to adjust focus.
Employees must be able to perform the physical requirements of the position satisfactorily and, if requested, reasonable accommodations will be made to enable employees requiring accommodations to perform the essential functions of their jobs, absent undue hardship.
For more information, please visit https://info.endava.com/galaxe-has-joined-endava
