Designs and performs data extraction, assessment, translation, transformation, and load (ETL) processes with minimal guidance or from prescribed specifications
In charge of building data equity, it's underlying code, tools, databases, and related infrastructure
Administers and maintains existing data engineering pipelines to their full extent of engineering needs
Analyzes data needs and identifies available internal and external sources.
Utilizes business and analytical data modeling skills to design data integration and structure approaches.
Utilizes programming skills to access and extract data from diverse sources residing on multiple platforms and implement data models by combining, synthesizing and structuring data from databases, files and spreadsheets.
Assures data consistency and reliability. Performs quality checks, contributes to metadata and data dictionaries, documents repeatable extract, transform and load processes.
Bachelor's degree in Computer Science, MIS, or related field
Insights team is cloud based and currently moving from Azure to AWS. We are responsible for providing various data points to the Field, allowing Financial Representatives and their leaders to track product sales, their compensation, CRM (Customer Relationship Management) activities, and planning metrics through our Book of Business application. This is a great opportunity to grow with a valuable team that delivers numerous reports to the field.
A Great Candidate Will Meet The Following Requirements
*1 to 2+ years of experience in BI tools, particularly on Power BI
*Experience working with AWS S3
*2+ years of work experience with ETL, data modeling and business intelligence big data architecture.
*2+ years of experience in analyzing large data sets to build reports and dashboards for decision making.
*1+ years of experience in Spark Development, with knowledge on Databricks platform
*Experience in automated deployment, CICD
*Understand the nature of distributed systems design
*Programming/Scripting/Query language: Java, Python, Apache Spark, SQL.
*Exceptionally self-motivated and directed
*Proven Analytical, evaluative and problem-solving capabilities.
Nice to have:
*Experience with traditional data marts/warehouses
*Experience with Apache Airflow
Financial Services industry background
Cloud experience a strong plus
This job is not covered by the existing Collective Bargaining Agreement.Grow your career with a best-in-class company that puts our client's interests at the center of all we do. Get started now!
We are an equal opportunity/affirmative action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, gender identity or expression, sexual orientation, national origin, disability, age or status as a protected veteran, or any other characteristic protected by law.