BI Data Engineer

The 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.

What's the Role?

• 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.

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, CI/CD
• 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.
• Bachelor's degree in Computer Science, MIS, or related field

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.

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.