Job Details
The Data Warehouse Developer is responsible for developing Data Engineering solutions that conform to group standards, budgets and agreed estimated timelines. This role wrangles data in support of Data Science projects and constructs, tests, and maintains scalable data solutions for structured and unstructured data to support reporting, analytics, ML and AI.
The Data Warehouse Developer assists with optimization the performance of big data eco-systems while assisting with research and building of proof of concepts to test out theories recommended by Senior and Lead Data Engineers. This is a fully remote position.
**Responsibilities:**
* Gains a thorough understanding of the requirements and ensure that work product aligns with customer requirements
* Works within the established development guidelines, standards, methodologies, and naming conventions
* Works with Business users and domain SMEs to understand requirements.
* Building and maintaining dimensional data structures and other entity relational models.
* Assist in building ETL processes to load and reconcile data in the data warehouse.
* Develop, maintain, and support SSIS packages
* Assists in data mapping activities by specifying logic and business rules for transforming and preparing data.
* Assists with Data Quality (DQ) and Master Data Management (MDM) initiatives.
* Assists in developing governance processes around data management and data warehouse development.
* Builds processes to ingest, process and store massive amount of data
* Assists with optimization the performance of bigdata ecosystems
* Wrangles data in support of data science projects
* Assists with research and building of proof of concepts to test out theories recommended by Senior and Lead Data Engineers
* Collaborates and contributes to identifying project risks, design mitigation plans, develops estimates
* Contributes to the design, development of data-pipelines, and feature engineering of data solutions
* Established processes or methods are still relied on however Data Engineer will be required to come up with creative solutions to problems. Senior teammates are still needed to provide oversight on solutions to complex problems
**Basic Qualifications:**
* Bachelor of Science in a related field required
* 5 years of design and development experience in a Data Warehouse Environment
* 5 years ETL (SSIS) experience
* 5 years of requirements gathering and data analysis using MS SQL Server
**Preferred Experience:**
* Proficiency in ETL development, maintenance, and support of SSIS packages
* Experience in writing and understanding SQL code and Stored Procedures.
* Experience with Visual Studio and TFS.
* Familiarity with Master Data Management, data quality tools, and data integration tools is a plus
* Advanced knowledge of Business Intelligence, Data Warehousing
Knowledge in fundamentals of Machine Learning and Artificial Intelligence using Microsoft technologies
* Performance tuning and code optimization in SQL
* Data profiling and dimension modeling techniques and creation of logical and physical data models
* Experience with Azure, and/or Azure Cloud development with an emphasis on data
* Experience working with job scheduling tools
* Experience with SQL
**Join our talent community**
Get discovered. Introduce yourself, and we'll get in touch if there's a role that seems like a good match.