.the data warehouse developer will work under the guidance and supervision of the data warehouse tech manager to build confie's next generation enterprise data warehouse.the data warehouse developer will help develop data-centric solutions to meet the company's business needs - specifically, integrating existing silo data and providing data solutions that reflect the integrated landscape.
*summary of duties*:the data warehouse developer core responsibilities will include, but are not limited to:- gather business requirements and functional specifications.- perform data analysis and data modeling as required to design tables and processes to fulfill thebusiness requirements- transform complex customer business requirements into effective, efficient, and maintainable enterprise-level solutions- research, analyze, support, and implement database solutions and changes on ms sql server/snowflake cloud data warehouse platform- write and code logical and physical database descriptions and specify identifiers of database creating a data dictionary.- design, develop and maintain scalable data pipelines- develop data ingestion and integrations (rest, soap, sftp, etc.)
processes- ability to work with multiple data sources and types (structured/semi-structured/unstructured)- modify existing data warehouse processes and objects as necessary to include best practice standards- query optimization and performance tuning of complex sql stored procedures and queries.- mitigate existing disparate data sources into the enterprise data warehouse- maintain data dictionary documentation- implements processes and systems to monitor data quality, ensuring production data is always accurate and available for key stakeholders and business processes that depend on it- monitor database jobs for timely and accurate completion- on call support.
*requirements*:- bachelor's degree (ba or bs) and or equivalent work experience- snowflake certification is a plus- additional certifications related to data processing are a plus.- 5 years professional experience as a data warehouse developer, sql developer or data engineer with knowledge of relational databases using microsoft sql server, mysql, or other rdbms- 4 years' experience with programming in c# and asp net technologies.- sql developer experience is a must; able to write complex store procedures, user-defined functions, common table expressions, and correlated sub-queries; able to optimize indexes; understanding of atomicity and transaction isolation levels- 4 years of experience in data warehouse processes (etl, oltp, olap, etc