Job ID: JOB_ID_5156
Job Description:
We are looking for a skilled Data Warehouse Modernization Administrator to join our dynamic team and play a key role in modernizing and optimizing our data infrastructure. The ideal candidate will have strong experience in Snowflake, DBT, Fivetran, and related cloud technologies, with a focus on administration and ETL processes. This role requires a hands-on senior resource comfortable with configuration, development, and administrative tasks, while also possessing a holistic view of modernization projects.
Key Responsibilities:
- Design, implement, and maintain Snowflake data warehouse solutions to fulfill business requirements effectively.
- Deploy and optimize DBT models and transformations to streamline data processing and facilitate analytics.
- Manage Fivetran data pipelines to enable seamless data integration and synchronization.
- Utilize AWS Glue for data cataloging, executing ETL jobs, and performing data transformation operations.
- Apply Python and SageMaker for advanced analytics, machine learning initiatives, and data science projects.
- Employ DB2, SQLServer, and Informatica as necessary for data migration, integration, and administration tasks.
- Collaborate with data engineers, analysts, and stakeholders to comprehend data needs and deliver actionable insights.
- Develop and enforce data governance and security protocols to uphold data quality and regulatory compliance.
- Monitor system performance, troubleshoot issues, and implement performance optimization strategies.
- Stay abreast of industry best practices and emerging technologies in data warehousing and cloud computing domains.
- Work onsite 4 days a week.
Qualifications:
- Strong hands-on experience with Snowflake administration and ETL processes.
- Proficiency in Snowflake, DBT, Fivetran, AWS Glue, Python, SageMaker, DB2, SQLServer, and Informatica.
- Experience in data warehouse modernization and optimization.
- Ability to look at modernization projects holistically.
- Experience with data governance and security protocols.
- Excellent troubleshooting and performance tuning skills.
- Familiarity with cloud computing environments.
- Must be comfortable with configuration, development, and admin work.
Location:
- Boston, MA or Woodbridge, NJ
- 4 days/week onsite
- Face-to-face (F2F) is mandatory.
Special Requirements
F2F is mandatory, 4 days/week onsite
Compensation & Location
Salary: $130,000 – $170,000 per year (Estimated)
Location: Boston, MA
Recruiter / Company – Contact Information
Email: vind@golitech.com
Recruiter Notice:
To remove this job posting, please send an email from
vind@golitech.com with the subject:
DELETE_JOB_ID_5156