Analytics Engineer II
This position for an experienced data Engineer who will design, build and maintain data systems and pipelines to allow data to be accessed and utilized optimally for analytics or visualization/insight generation purposes. The role requires significant technical expertise in the fields of computer programming, database management and data architecture; and relies on increasing business knowledge. With minimal review by a manager, this individual will take initiative in identifying and executing data engineering approaches to support business priorities.
Principal Duties and Responsibilities
- Employ a variety of languages and tools to develop, construct, test and maintain data pipelines, ensuring they support the requirements of the business.
- Integrate large volume of data from different sources (including DB2, SQL Server, Web API and Teradata).
- Apply validation, aggregation, and reconciliation techniques to create a rich data framework.
- Work closely with the data scientists and business partners to understand the business problem they are trying to solve and the analytics solutions they plan to apply. Use this understanding to create appropriate data structures tailored for the specific problem.
- Create data assets that conform to scalability, extensibility, performance and maintainability requirements for the problem at hand. Promotes development of solutions following appropriate engineering process that is fit to purpose for different use scenarios.
- Understand and contribute to the evolution of the enterprise data architecture including the application of current and emerging data frameworks and tools (eg hosting data in Cloud).
- Efficiently prepares results for interpretation and/or visualization and communicates findings and potential value to influence manager and leadership decision making.
- Support integration of solutions within existing business processes using automation techniques.
- Understand theory and application of current and emerging software engineering practices.
- Provides support, training and/or mentorship to lower level Data Engineer peers.
- Perform other related duties as assigned
Job Specifications
- Bachelor’s degree in quantitative field is required, Master’s is preferred
- 4 years of professional experience or equivalent relevant work experience preferred
- Core Data Engineer Capabilities: Knowledge in all of the following skillsets and deep expertise in at least two: Software Engineering: Expertise in at least one relevant object-oriented programing language (i.e. Java/Scala, Python). Experience in DevOps best practice including CI/CD, process automation and optimization.
- Data Architecture and Infrastructure: Good understanding of data architecture principles and related infrastructure requirements, covering on-prem and Cloud platforms.
- Holistic Data Preparation: The ability to understand and present data in the appropriate context, including a good understanding how the data will build towards a business solution.
- Data Extraction, Transform & Load: Preferred skills include: Expertise in writing complex SQL queries that join multiple tables/databases. Independently explore databases/tables or other legacy data content to identify best data sources to solve business problems. Demonstrates ability to troubleshoot complex SQL queries with little guidance. Demonstrates ability to create logical data models by combining data from multiple sources including internal and external data
- Core business capabilities: Demonstrated communication skills, experience in financial services, leadership experience working with senior management and executive leadership, and attention to detail while effectively and independently prioritizing work and managing multiple projects simultaneously. Demonstrated ability to understand and explain a problem and identify and communicate an appropriate solution.
- Leadership Capabilities: Demonstrated ability to coach or mentor team members, ability to commit quickly and positively to change. Viewed as a promoter of change management and leads proof of concept work and prototyping when necessary
- Preferred characteristics: Entrepreneurial self-starter, a thorough, results-oriented problem-solver, and a lifelong learner with voracious curiosity AND intermediate understanding of their organization
The base salary range for applicants for this position is $73,300.00-$139,200.00
Stay informed about the latest analytics engineering opportunities. Subscribe to our weekly newsletter.