• • Open only for W2 • • • • Local Candidates Only • • Position Description The Senior Data Engineer is a senior technical role in supporting the information management architecture of the Enterprise Data Warehouse solution. The role will be actively responsible for designing the data acquisition, data staging, loading, and transformation into the Enterprise Data Warehouse. This role will be a technical expert and resource collaborating with the Data Architect, Software Engineers, Product Owners, and Project Team to develop and deliver data storage and movement solutions and to organize and oversee the loading of data into the related systems. Additionally, the Senior Data Engineer will bridge gaps related to Business Intelligence functions, supporting the analytics produced by the organization, and providing expertise tying data movement together with data consumption. Position Accountabilities: · Design and develop complex ETL solutions using data warehouse design best practices · Analyze data requirements, data models, and determine the best methods in extracting, transforming and loading the data into the data staging, warehouse and other system integration projects · Create complex business intelligence reports and data visualizations using tools like Python, Tableau, and Power BI · Analyze business requirements and outline solutions · Validate code against business and architectural requirements · Create and test prototypes · Troubleshoot applications and resolve defects · Work within an agile framework · Plan, Prioritize and Deliver Resilient, Scalable technical solutions · Communicate ideas in both technical and user-friendly language · Update and maintain product documentation · Escalate issues and impediments in a timely manner · Work within established framework and processes (Agile) · Collaboratively work with Agile teams, as well as independently · Perform and coordinate unit and system integration testing when required · Participate in peer programming, mobbing, hackathons, and code reviews as required · Support and occasionally lead business intelligence efforts, data analytics efforts, and data governance/quality efforts Position Qualifications Education & Experience • A bachelor’s degree or a combination of equivalent work experience • 7+ years of previous experience in information technology, preferably within the financial services or other highly regulated industry • 5+ years ETL development experience • 3+ years of Business Intelligence, Data Analytics, or Data Science experience • 3+ years of experience in an Agile environment • Knowledge of ETL and data warehouse design • Experience using Python for data movement/manipulation • Extensive experience with data dictionaries, data analysis and relational databases • Experience with a business intelligence toolset Preferred Qualifications • A master’s degree in a technology area of study; preferably in Computer Science, MIS or Analytics. Knowledge & Skills · · Creative problem solver with excellent communication, leadership and collaboration skills. · Advanced decision making and problem-solving skills · Business acumen, knowledge and professionalism · Proactive leadership style and a self-starter and strong attention to detail · A clear and familiar understanding of the concepts and best practices of data warehouse ETL design · Demonstrable expertise with RDBMS or Big Data technology · Foundational Database administration skills; Broad DW skills including Semantic Layer, Basic BI Development and basic data modeling & data analysis · Methodical and structured approach to design and development. · Delivery focused with the ability to prioritize activities. · Flexible team player within a small, multi-disciplinary team.