drjobs Data Engineer and Reporting Developer

Data Engineer and Reporting Developer

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Boston - USA

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

Required Education:
Bachelors degree in computer science system analysis or a related study or equivalent experience

Required Skills:
Strong understanding of Oracle and Snowflake database concepts including data modeling SQL stored procedures and data types
Hands-on experience with Snowflake including data modeling performance tuning and role-based access control
Proficiency with reporting tools like Power BI Excel integrations or ODBC/JDBC-based access
Strong proficiency in SQL and experience working with large datasets
Experience in migrating reporting workloads from legacy platforms to cloud-based solutions
Solid understanding of BI tools and their integration with Snowflake
Strong problem-solving and documentation skills

Desired Skills:
Familiarity with AWS Redshift Cloud Data Warehouse is a plus.
Knowledge of ETL tools (e.g. Informatica) is a plus
Familiarity with Snowflake Data sharing Snow pipe and Snowpark
Background in financial or government enterprise data environments

Program Data Engineer & Reporting Developer will work with the BEST Senior Data Architect to lead and execute the migration of reporting solutions from legacy platforms (e.g. Oracle SQL Server AWS Redshift etc.) to Snowflake; transform legacy queries and procedures into a modern scalable and maintainable Snowflake-based solution; analyze the data structures in BCV Oracle; and map data elements appropriately in Snowflake doing schema reconciliation and data conversion. This role will also onboard the CTR users in the CTR Snowflake instance for data access create role-based access policies and data masking rules for data security and privacy. The engineer will work on tuning SQL queries on Snowflake for performance efficiency

Job Duties and Responsibilities:
Design and implement strategies for migration of reporting solutions from legacy platforms to Snowflake
Collaborate with subject matter experts (SMEs) to understand report purpose usage frequency and business logic
Analyze data structures and relationships in Oracle understand data quality rules and map data elements to Snowflakes structure
Convert Oracle SQL data types and stored procedures to Snowflake equivalents
Validate data integrity between Oracle and Snowflake identify discrepancies and ensure data accuracy
Implement security measures within Snowflake such as role-based access control data masking and encryption
Create and maintain documentation for data models developed reports and Snowflake configurations.
Optimize Snowflake data warehouse performance storage and query efficiency

Interview Process: Initial contact by phone interview may be conducted in-person or by video conference

Employment Type

Full-time

Company Industry

About Company

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.