Job title: Sr ETL Developer – Remote, (Eastern Time)
Company: Arch Capital Group
Job description: With a company culture rooted in collaboration, expertise and innovation, we aim to promote progress and inspire our clients, employees, investors and communities to achieve their greatest potential. Our work is the catalyst that helps others achieve their goals. In short, We Enable Possibility℠.Job Summary
The Senior ETL developer will work with the Corporate IT team to maintain and develop data integration solutions to support our Analytics platform. The solutions must align with data vault, data mart, dimensional modeling, and ETL standards and guidelines. The data modeling and data integration solutions will be based on Matillion with Snowflake data warehouses/databases & Power BI for reporting platform.The ideal candidate will need to understand business and technical requirements and translate this into data integration designs and deliverables by working with the Corporate Data Architect. The position also requires supporting the Agile process in terms of Development, testing, deployment and post-production support.ResponsibilitiesHandle multiple projects in parallel, participate and deliver solution design while working closely with the architectureDesign and Develop/Review ETL programs primarily using modern ETL tools like Matillion, DBT , and PythonCoach and guide the technical team in terms development of ETL jobsProvide performance improvement and tuning of data pipeline.Perform technical reviews, data validation, and end to end testing of ETL objects, source data analysis and data profilingCreate necessary documentation as per the standards and update the project documentationSupport QA on end-to-end testing and provide daily/weekly project status to the project managerWork with deployment team in the code migration across the environmentsTriage the Production issues and work on the code fixesProven experience in database administration with cloud data platforms like SnowflakeFrees up data engineers and analysts from administrative tasksEducation and Experience10+ years of experience in implementation of BI projects in a large-scale enterprise data warehouse environmentHands-on experience in building large cloud data warehouses using Snowflake; including database architecture design, data transformations, stored procedures, account and security principles, performance management, etc.Experience with cloud computing services, particularly deploying and running services in AzureExpert-level understanding of Agile, SDCL, CI/CD, DevOps, GitOps, and ProdOps.A team player with excellent verbal and written communication skillsExperience with other ETL tools like Matillion, ADF, and DBTAdvance SQL knowledge and familiar with relational, Vault, and dimensional modelingknowledge of Power BIFinancial industry data fluency is preferred but not requiredRequired knowledge and skills would typically be a acquired through a bachelor’s degree in information technology or related field#LI-ZP1#LI-REMOTEFor individuals assigned or hired to work in California, Colorado, Hawaii, Jersey City, NJ; New York State; and/or Washington State, the base salary range is listed below. This range is as of the time of posting. Position is incentive eligible.$148,614 – $201,066/yearTotal individual compensation (base salary, short & long-term incentives) offered will take into account a number of factors including but not limited to geographic location, scope & responsibilities of the role, qualifications, talent availability & specialization as well as business needs. The above range may be modified in the futureClick to learn more on available benefitsDo you like solving complex business problems, working with talented colleagues and have an innovative mindset? Arch may be a great fit for you. If this job isn’t the right fit but you’re interested in working for Arch, create a job alert! Simply create an account and opt in to receive emails when we have job openings that meet your criteria. Join our to share your preferences directly with Arch’s Talent Acquisition team.
Expected salary: $148614 – 201066 per year
Location: Jersey City, NJ
Job date: Thu, 11 Jul 2024 05:26:44 GMT
Apply for the job now!
