Cinch Home Services, Inc.
Sr Data Warehouse Engineer
Cinch Home Services, Inc., Boca Raton, Florida, us, 33481
Qualifications5-7 years of Data Warehousing and Data Modeling experience.Strong understanding of Normalized/Dimensional model disciplines and similar data warehousing techniques.Strong experience working with ETL/ELT concepts of data integration, consolidation, enrichment, and aggregation in petabyte-scale data sets.Expert in SQL and/or SQL-based languages and performance tuning of SQL queries.Working knowledge of message queuing, stream processing, and highly scalable 'big data' data stores.Collaborate with the BI and Data Analyst teams on normalizing and aggregating data sets based on business needs and requirements.Data auditing skills to verify data integrity, understand discrepancies, and resolve them with the highest sense of urgency.Experience with various data storage technologies - e.g. RDBMS, columnar, tabular, document store, NoSQLExperience using cloud-based data warehouses - e.g. Snowflake, BigQuery, Synapse, RedShift, etcExperience using ETL/ELT tools and technologies - e.g. Talend, Informatica, etc.Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.Demonstrated ability to share findings with non-technical or senior executive individuals.Familiarity with Analytical/Reporting Solutions like MicroStrategy is a plusJob Duties And Responsibilities
Work directly with the developers, system architects, and users to review requirements and deliver best-practice database models.Work with stakeholders including the product, data and architecture teams to assist with data-related technical issues and support their data infrastructure needs.Provide proactive design, operational support, and governance for privacy and security policy for data.Additional Requirements
Bachelor's Degree Library Science, Information Systems, Finance, Information Technology, or equivalent experienceWork in a progressive environment and perform effectively in a sprint based agile development environmentExceptional Communication SkillsAny Public Cloud certification focused on data warehousingAny certification on specific database technologyExperience developing models in modern public data warehousing environments like Snowflake, Synapse, BigQuery, RedshiftExperience developing dimensional models and running quries on edge databases such as Oracle, PostgreSQL, or SQL ServerProficient in Linux environments
Work directly with the developers, system architects, and users to review requirements and deliver best-practice database models.Work with stakeholders including the product, data and architecture teams to assist with data-related technical issues and support their data infrastructure needs.Provide proactive design, operational support, and governance for privacy and security policy for data.Additional Requirements
Bachelor's Degree Library Science, Information Systems, Finance, Information Technology, or equivalent experienceWork in a progressive environment and perform effectively in a sprint based agile development environmentExceptional Communication SkillsAny Public Cloud certification focused on data warehousingAny certification on specific database technologyExperience developing models in modern public data warehousing environments like Snowflake, Synapse, BigQuery, RedshiftExperience developing dimensional models and running quries on edge databases such as Oracle, PostgreSQL, or SQL ServerProficient in Linux environments