Data Engineer II
Backend Developer
Analytics
Big Data
Bigdata
Business Analytics
Business Intelligence
Cloud Operations
Cloudera
Data
Data Analysis
Data Analytics
Data Analytics Tools
Data Engineer
Data Integration
Data Pipeline
Data Platform
Data Processing
Data Visualization
Data Visualization Tools
Data Viz
Data Warehouse
Database
Databases
Dataviz
Digital Marketing
Engineer
ETL
Hadoop
Hive
Informatica
Information Technology (IT)
Programming Languages
Pyspark
Reporting and Analytics
Scala
Software Development
Software Engineering
SQL
Tableau
Visual Design
Job Description
Build and deliver business intelligence capabilities across data engineering, analytics, and data science platforms in a hybrid role in Scottsdale.
Responsibilities
- Partner with business users to define reporting and dashboard requirements and identify gaps in data, logic, and business understanding
- Design and develop backend solutions for new data sources using the Cloudera technology stack
- Create complex, interactive Tableau dashboards, scorecards, and reports for business processes, including trends and projections
- Perform in-depth data analysis, including logical conclusions and cause-and-effect analysis based on available data
- Design data ETL and data manipulations to support production and ad-hoc analysis and reporting
- Research industry best practices and help guide strategic data platform tools and processes
- Recommend standards, policies, and procedures for BI tool form, structure, and attributes
- Support and train business teams as needed
- Write data infrastructure and analytics software tools for Data Science
- Mentor and train interns
- Guide Data Scientists on software engineering best practices
- Collaborate with analytics leadership and engineers across EW to deliver architectural and software enhancements to the Data Science platform
- Collaborate with Data Science leadership to improve ETL and cluster computing
- Support the company commitment to risk management by protecting integrity and confidentiality of systems and data
Requirements
- Bachelor’s degree (education and experience typically obtained through a Bachelor’s degree)
- 2-4 years of demonstrated progressive work experience in PySpark/Python/Spark/Scala for data engineering development in a Linux environment
- Understanding of Tableau Server and Tableau dashboarding
- Demonstrated ability with testing, problem solving, and analysis
- Knowledge of principles, practices, and techniques of dashboard development, reporting, data modeling, ETL, and systems design
- Experience working with SQL and Spark
- Software/data engineering in Python
- Machine learning toolkits in Python/R
- Building reusable frameworks for data ingestion and storage in Hadoop or AWS/S3
- Relational databases with experience optimizing/tuning queries, indexing, and partitioning
- Experience collaborating with internal engineering and technology teams to build data infrastructure in a regulated, enterprise environment
- Strong communication skills
- Background and drug screen
Preferred Qualifications
- Prior demonstrated experience (2-4 years)
- Scala/Java PySpark experience
- Experience with Hive/Impala & Linux
- Fin-tech experience
Technologies
- Cloudera
- Tableau
- Tableau Server
- PySpark
- Python
- Spark
- Scala
- Linux
- SQL
- Hadoop
- AWS
- S3
- Hive
- Impala
- Python/R
Benefits
- Competitive medical (PPO/HDHP), dental, and vision plans, including company contributions to your HSA or pre-tax savings through FSA for commuting, health, and dependent care expenses
- 401(k) Retirement Plan with a 100% Company Safe Harbor Match on the first 6% deferral immediately upon eligibility
- Paid Time Off: Flexible Time Off for Exempt (salaried) employees, generous PTO for Non-Exempt (hourly) employees, plus 11 paid company holidays and a paid volunteer day
- 12 weeks of Paid Parental Leave
- Maven Family Planning support (egg freezing, fertility, adoption, surrogacy, pregnancy, postpartum, early pediatrics, and returning to work)
Physical Requirements
- Primarily sedentary work with extensive computer use and sitting for periods of approximately four hours
- May require occasional standing, walking, kneeling, and reaching
- Must be able to lift 10 pounds occasionally and/or negligible amount of force frequently
- Requires visual acuity and dexterity to view, prepare, and manipulate documents and office equipment including personal computers
- Requires the ability to communicate with internal and/or external customers
- Must be able to perform essential functions with or without reasonable accommodation
Compensation
- Base pay scale (Phoenix, AZ / Chicago, IL): $83,000 - $110,000 per year
- Base pay scale (New York, NY / San Francisco, CA): $99,000 - $132,000 per year
- Discretionary incentive plan and benefits (in addition to base pay)
Job Location & Work Authorization
- Scottsdale, AZ (hybrid)
- Candidates must independently possess eligibility to work in the United States for any employer at the date of hire
- Position is ineligible for employment visa sponsorship