Data Warehouse Developer

• Integrity- We maintain the highest standard of ethical behavior, and do the right thing for the customers and employees.

• Commitment- We strive to provide value to our customers, our employees and our company.
• Accountability- We hold ourselves to the highest standards of accountability in all our actions.
• Respect- We are always mindful to respect our customers, ourselves and each other.
• Excellence- We focus on going the extra mile to exceed expectations.

Because we CARE, Confie conducts phone and video interviews to practice social distancing to accommodate the state, local or national guidelines. If you are selected to formally video interview, please consider the following recommendations:

Interviews can be conducted using a laptop or desktop computer with a webcam, tablet, or smartphone.

• Find a quiet, private, well-lit space that is free from possible interruptions
• Position yourself so that you have a neutral background that’s free from distractions
• Test your internet connection to be sure you have a good connection
• Remember it’s an interview, so dress appropriately
• Place your phone on do not disturb

• Gather business requirements and functional specifications
• Perform data analysis and data modeling as required to design tables and processes to fulfill the business 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

Experience:

• 3 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
• 2 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
• 2 years of experience in Data Warehouse processes (e.g., 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

Skills:

• A Love for All Things Data! The backbone of a good data engineer is to understand the life cycle of data movements from source to final interpretations on a report
• A Passion to Learn! Strong desire and ability to learn new tools, skills, and acquire knowledge
• Confidence communicating & translating data driven insights and technical concepts into simple terminology for business clients of various levels
• The following skills are important to the success of a skilled Confie technical professional:
  • Listening skills - the ability to understand what people say
  • Analytical skills- the ability to critically evaluate the information from multiple sources and breakdown high-level information into details
  • Critical thinking and problem solving skills
  • Observation skills - the ability to validate data obtained via other techniques and expose new areas for elicitation
  • Organizational skills - the ability to work with the vast array of information gathered during analysis and to cope with rapidly changing information
  • Interpersonal skills - the ability to help set priorities
  • Oral and written skills – excellent written and verbal communication with little or no supervision
  • Self-motivated
• Ability to work and communicate effectively with any levels of the user community
• Must be willing and able to work off hours or remote support as needed

• 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