Sr. Data Engineer

M & R Consultants Corporation
M & R Consultants Corporation

Job Overview

Local candidates only. No sponsorship is provided for this role. SSIS is important for this role. or – will not sponsor Flexibility on remote work. will be remote until Labor Day, then would like a combo of remote and onsite so has to local. .Must Have skills -Strong communication skills ndash be able to speak with business users as well as technical folks -SQLSSIS must be very strong, as well as ETL experience -Would prefer Azure, AWS Cloud could work as well. Going to be working on bringing Data platform to Azure Nice to haves -Power BI (currently using) however Tableau would work as well. -SQL Runing -Troubleshooting The Senior Data Engineer will join the enterprise Data Management team as a technical leader and designer and builder of the bankrsquos evolving Enterprise Data Platform (EDP). In this role, the incumbent will work in conjunction with the business to design and implement logical and physical data warehouse structures, extract transform and load (ETL) processes that support current reporting needs and business initiatives. As a data-innovator, the incumbent will help to guide the bankrsquos transition towards migration to the Azure cloud. Major Responsibilities include bull Work closely with constituents at all levels throughout the organization to identify and define innovative solutions to extend the bankrsquos Enterprise Data Platform. bull Design, develop, and maintain optimal data pipeline architecture and ETLELT load processes, consistent with client architecture standards, providing optimized and secure access to these data sources. bull Participate in design and build of scalable data processing and analytics solutions to expand our evolving data platform. bull Work with business lines and technology architects to continually evolve and expand the corporate data store to provide increasing value to the enterprise. bull Design and develop optimized data structures in support of BI, analytics and reporting. Recommend strategies to improve performance and capacity of BI tools. bull Suggest and build platform operations to increase efficiency and resiliency in overall operations. Develop and manage the necessary governance for providing end-user and end-system access to warehouse resources. bull Participate in proof of concept exploration to guide future direction for enterprise data platform. bull Develop, manage and publish the necessary enterprise architecture artifacts, including the evolving data warehouse data dictionary. bull Define both administrative and development standards for the platform and oversee compliance with those standards bull Maintain operational control over the reliable operation and acceptable performance of clientrsquos internal data platform technologies. bull Assume responsibility for and resolve all operational and performance issues as they arise. Participate in on-call rotation for production support and off-hours technical support for the data platform. bull Chart and execute a physical data plan roadmap the continually evolve the bankrsquos data availability and utility using emerging techniques and technologies for both operational and analytics applications. JOB REQUIREMENTS Education and Experience bull Bachelorrsquos degree or equivalent experience bull 10 years of experience with deep understanding of both traditional and modern data architecture and processing concepts, including relational databases bull 5 years of experience with Data Warehouse analysis, design and development. Development of new and maintenance of existing SSIS packages and processes bull Significant experience with BI tools (e.g., PowerBI), reporting (SSRS) and analytics (SSAS), data visualization concepts bull Experience with creation of enterprise data lake using Azure bull Demonstrable experience in designing objects for MPP database platform bull Experience with cloud-based infrastructure and development in Azure preferred bull Significant proven experience with ETL design and implementation (SSIS Talend) for large datasets bull Mastery of structured query language (SQL) (T-SQL, PLSQL, Postgres, etc.) bull Demonstrated experience in design, coding, testing, and maintenance of technical solutions using SQL, T-SQL, views, stored procedures, indexes bull Demonstrated experience with build of Azure SQL DBDW and Azure Data Factory pipelines bull Extremely strong analytical ability, proactive problem-solving skills, performance tuning, and debugging skills bull Experience in software development lifecycle including Agile methodology required bull A good communicator who can express their ideas, consider othersrsquo and make informed decisions bull Self-directed and motivated with the drive to work independently on multiple concurrent projects while making effective progress bull Experience with Azure Synapse Analytics SQL Data Warehouse a plus bull Experience with CICD, automated deployments a plusSr. Data Engineer 1

View More
Job Detail
Shortlist Never pay anyone for job application test or interview.