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.) is required
- good experience with etl tools like ssis; or experience with wherescape, talend, informatica and other etl tools is acceptable; experience with maintaining and enhancing load jobs
- some experience with reporting tools is desirable, like tableau, ssrs, powerbi and others
- knowledge of best practices and principles for data warehousing, particularly the kimball method
- experience or knowledge in cloud platforms like snowflake, azure or aws is a plus
- additional programming/scripting language knowledge is a plus: windows powershell, python, r, javascript, linux shells (ksh, bash)
- key experience in the following is highly desirable or a strong willingness to learn in lieu of:
- snowflake cloud warehouse
- data vault 2.0 methodology
- wherescape red and/or 3d
- tableau
tipo de puesto: tiempo completo, por tiempo indeterminado
salario: $30,000.00 al mes
beneficios:
- seguro de gastos médicos
horario:
- diurno
educación:
- licenciatura terminada (deseable)
experiência:
- .net: 1 año (deseable)
- javascript: 1 año (deseable)
- desarrolladores ios: 1 año (deseable)
- desarrolladores android: 1 año (deseable)
idioma:
- inglés (deseable)