Must Have
- 4+ years of Snowflake
- Advanced SQL
- API
- Build and enhance ETL pipelines both on-prem on cloud
- Business Intelligence - Data Engineering
- cloud data build tools (DBT, Azure)
- Good written and oral communication
- Python
- Quality and Testing embedded in ETL
Nice To Have
- Building data repositories in Snowflake for PowerBI
- Microsoft Power Apps
PowerBI
JOB DESCRIPTION
May consider remote for right candidate (would need to have majority of both required and nice to have skills).
Onsite requirement: 4 days a week.
Must have the ability to clearly communicate.
History of being proactive, challenging the status quo, being vocal to ensure the right solution is in place
This role is to focus on data movement and transformation needs specific to an Enterprise Risk and Governance technology team. Combination of individual and collaborative work.
Part of that role is to build out data products from sources systems to Snowflake for others to consume, enhancing existing ETL pipelines, adding quality and testing capabilities.
Current team size is ten with two other data engineers.
Job Summary:
Handle the design and construction of scalable management systems, ensure that all data systems meet company requirements, and also research new uses for data acquisition. Required to know and understand the ins and outs of the industry such as data mining practices, algorithms, and how data can be used.
Primary Responsibilities:
- Design, construct, install, test and maintain data management systems.
- Build high-performance algorithms, predictive models, and prototypes.
- Ensure that all systems meet the business/company requirements as well as industry practices.
- Integrate up-and-coming data management and software engineering technologies into existing data structures.
- Develop set processes for data mining, data modeling, and data production.
- Create custom software components and analytics applications.
- Research new uses for existing data.
- Employ an array of technological languages and tools to connect systems together.
- Collaborate with members of your team (eg, data architects, the IT team, data scientists) on the project’s goals.
- Install/update disaster recovery procedures.
- Recommend different ways to constantly improve data reliability and quality.
Qualifications:
- Technical Degree or related work experience
- Experience with non-relational & relational databases (SQL, MySQL, NoSQL, Hadoop, MongoDB, etc.)
- Experience programming and/or architecting a back-end language (Java, J2EE, etc)