USZoom LLC
Senior Data Engineer and BI Developer
USZoom LLC, Montebello, New York, United States,
Full Time
Senior Data Engineer and BI Developer
Montebello, New York
iPostal1, the leading provider of Digital Mailbox technology worldwide, is looking for an intelligent and ambitious
Senior Data Engineer and BI Developer to join the newly formed data team. Our website, www.iPostal1.com, lists 3,000 addresses, including retail pack and ship stores, 1,000 Staples stores and coworking spaces. Customers choose a mailing address for business or personal use and view and manage their postal mail and packages anywhere with an app or online.
The incumbent will help us build our enterprise data warehouse on Snowflake from the start! Your role will include ELT design, using low code tools and SQL, visualization tool report and dashboard design, and performing insightful data analysis to meet our corporate growth goals. Our corporate headquarters is in Rockland County, NY, and this person will work in the office 2 - 3 days/ week on a hybrid schedule.
Responsibilities:
Engineer robust ELT solutions:
Design, build, test, and document efficient data pipelines using cutting-edge tools to ensure seamless data integration.Satisfy business requirements:
Leverage your advanced SQL skills to design and implement robust data transformations that directly address business objectives and drive decision-making.Stay ahead of the curve:
Eager to explore and embrace new technologies and algorithms to continuously optimize data solutions.Deliver results with a user-centric approach:
Driven to achieve targets and consistently prioritize user experience in every solution. Meet commitment deadlines.Qualifications:
10+ years of data expertise:
Proven track record in ETL/ELT, data modeling, data warehouse design, development, and population from diverse data sources (databases, unstructured data, APIs).2+ years with Snowflake:
Hands-on experience developing and optimizing within the Snowflake cloud data warehouse environment. Snowpro certification is a plus.SQL mastery:
Advanced-level SQL programming skills with a focus on query and ELT optimization for performance and knowledge of window functions.Analytical problem solver:
Data-driven mindset with sharp analytical skills, comfortable with ambiguity, able to identify and resolve inconsistencies and root causes. Strong business acumen to validate the accuracy of data.Excellent communication skillsUse of ETL/ELT Tools
like Five Tran, Matillon, Kettle, Abinitio, Informatica, SSIS or similar.Use of Visualization tools
such as Tableau, PowerBI, Looker (LookML) or SigmaGood knowledge of RDBMS
like MySQL, Oracle, Postgres, SQL ServerOther Technical know-how:
Proficient in software engineering best practices, adept across Unix/Linux/Windows platforms, and experienced with Agile workflows.Collaboration tools:
Basic familiarity with Git for version control and Jira for project tracking.Education:
Proven track record in a technical field, ideally supported by a BS/MS in Computer Science, Information Systems, or similar experience. Strong technical and business skills are key.Pluses:
Experience with:
Low code data extraction tools like FiveTrans, Matillion or RiverydbtSemantic layer or data virtualization toolsData GovernanceData QualityJob orchestration tools (Airflow or proprietary)AgileScripting languages like Python, Shell or JavaScriptAWS services (S3, RDS, etc) and networking knowledgeGoogle Analytics and Facebook Ads data
iPostal1 is an Equal Opportunity Employer and considers all applicants for employment without regard to race, color, religious creed, ancestry, religion, sex, sexual orientation, gender identity and/or expression, pregnancy, age, national origin, marital status, disability, military status, genetic information, or any other category protected by law.
Apply Now
Senior Data Engineer and BI Developer
Montebello, New York
iPostal1, the leading provider of Digital Mailbox technology worldwide, is looking for an intelligent and ambitious
Senior Data Engineer and BI Developer to join the newly formed data team. Our website, www.iPostal1.com, lists 3,000 addresses, including retail pack and ship stores, 1,000 Staples stores and coworking spaces. Customers choose a mailing address for business or personal use and view and manage their postal mail and packages anywhere with an app or online.
The incumbent will help us build our enterprise data warehouse on Snowflake from the start! Your role will include ELT design, using low code tools and SQL, visualization tool report and dashboard design, and performing insightful data analysis to meet our corporate growth goals. Our corporate headquarters is in Rockland County, NY, and this person will work in the office 2 - 3 days/ week on a hybrid schedule.
Responsibilities:
Engineer robust ELT solutions:
Design, build, test, and document efficient data pipelines using cutting-edge tools to ensure seamless data integration.Satisfy business requirements:
Leverage your advanced SQL skills to design and implement robust data transformations that directly address business objectives and drive decision-making.Stay ahead of the curve:
Eager to explore and embrace new technologies and algorithms to continuously optimize data solutions.Deliver results with a user-centric approach:
Driven to achieve targets and consistently prioritize user experience in every solution. Meet commitment deadlines.Qualifications:
10+ years of data expertise:
Proven track record in ETL/ELT, data modeling, data warehouse design, development, and population from diverse data sources (databases, unstructured data, APIs).2+ years with Snowflake:
Hands-on experience developing and optimizing within the Snowflake cloud data warehouse environment. Snowpro certification is a plus.SQL mastery:
Advanced-level SQL programming skills with a focus on query and ELT optimization for performance and knowledge of window functions.Analytical problem solver:
Data-driven mindset with sharp analytical skills, comfortable with ambiguity, able to identify and resolve inconsistencies and root causes. Strong business acumen to validate the accuracy of data.Excellent communication skillsUse of ETL/ELT Tools
like Five Tran, Matillon, Kettle, Abinitio, Informatica, SSIS or similar.Use of Visualization tools
such as Tableau, PowerBI, Looker (LookML) or SigmaGood knowledge of RDBMS
like MySQL, Oracle, Postgres, SQL ServerOther Technical know-how:
Proficient in software engineering best practices, adept across Unix/Linux/Windows platforms, and experienced with Agile workflows.Collaboration tools:
Basic familiarity with Git for version control and Jira for project tracking.Education:
Proven track record in a technical field, ideally supported by a BS/MS in Computer Science, Information Systems, or similar experience. Strong technical and business skills are key.Pluses:
Experience with:
Low code data extraction tools like FiveTrans, Matillion or RiverydbtSemantic layer or data virtualization toolsData GovernanceData QualityJob orchestration tools (Airflow or proprietary)AgileScripting languages like Python, Shell or JavaScriptAWS services (S3, RDS, etc) and networking knowledgeGoogle Analytics and Facebook Ads data
iPostal1 is an Equal Opportunity Employer and considers all applicants for employment without regard to race, color, religious creed, ancestry, religion, sex, sexual orientation, gender identity and/or expression, pregnancy, age, national origin, marital status, disability, military status, genetic information, or any other category protected by law.
Apply Now