Data Engineer

Job#: 2042193

Job Description:

Apex Systems, a World-Class Technology Solutions Provider, is seeking applicants for the below position on behalf of our client.  Please apply if interested and qualified.  Please note that only qualified candidates will be contacted.
 

Position Details: 

Position: Data Engineer

Rate: up to $70.00/ hr

Location: Onsite 3x a week in Orlando/ Lake Mary, FL

Project Description:
PowerBI Development 
o             In addition to just creating reports, there is a big focus on administration, troubleshooting, and support
o             Big plus if folks are comfortable fixing/enhancing reports that may be failing, having performance issues, etc.
o             Will also be doing some light data modelling with star and snowflake schema
o             This role still has some business facing elements so folks that can translate tech into non-tech would be appreciated
o             Experience with additional areas such as descriptive statistics, data transformation, outliers, aggregation, space management in snowflake, and direct querying of snowflake to pull things into Power BI
o             All in all, in addition to new report requests they have a lot of requests to increase performance on existing slower dashboards, and recreate/repurpose older data models/reports
Data Modeling
•              Need to understand how data is being sourced, look at the architecture and find ways to improve and optimize data flow
•              How do we source more data overall, create pipelines, create tables, and do other design work
•              Billions and trillions of data points so latency and performance is a constant issue that needs fixing
•              Constantly looking at data structures and models to make sure we implement the right kind of architecture
Day to Day Responsibilities/typical day look like:  
PowerBI Development 
Candidates with a lot of PowerBI Admin experience, troubleshooting in PowerBI coupled with data modeling. Can be front facing and communicate with the stakeholders.  SQL skills, descriptive statistic experience. Dealing with outliers, space management with Snowflake. Direct querying from Snowflake into PowerBI.  Understand how to repurpose/refactor a report.  STAR Modeling & Snowflake Schema for data modeling. Understanding aggregation and how to deal with issues that arise from slow performing dashboards and being able to recreate or repurpose data models that have already been implemented.  Air Flow, Python, PiSpark, Java.
Data Modeling
Candidates who can understand the current data and how it is being sourced into the application.  Understand the architecture, optimize it, and help source more data.  Create a better data pipeline, create the tables, handle the design.  One of the challenges is performance on the dashboard, bringing in billions/trillions of data and with the large volume- need someone strong who can understand the structures, models, and implement the correct architecture.
Selling Points for Candidates:  
Largest custodial bank in the world;  will be part of highly critical, highly visible projects and growing team. 
Requirements: 
1.   PowerBI
2. Snowflake
3. Python
4. Java
5. Pi Spark
6. OracleDB
Plusses: 
 Background in Financial Services industry 
 
*Please note that as a contract employee of Apex Systems, benefits include the below with employee contribution*   

• Health  
• Dental 
• Vision  
• Life Insurance; Short Term Disability 
• Hospitalization Coverage 
• Direct Deposit 
• Weekly Pay Periods 
• Training and Development Programs 
• 401k 
• Referral Program 

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178.