Find Jobs
Senior Data Engineer
Austin, Minnesota
Direct Hire Position
It appears that you have already applied to this job.
Applied on April 16, 2021
Job Id #46370 Posted March 29, 2021

SUMMARY: 
As a Senior Data Engineer, you will work within our Data Engineering team, part of a broader IT Analytics team, to gather requirements, engineer, and scale our custom Oracle Enterprise Data Warehouse using Informatica ETL, data modeling and SQL.  Additionally, you will engineer reports, dashboards and visualizations within our enterprise business intelligence platform (OBIEE – Oracle Business Intelligence Enterprise Edition).  

Competencies include:
Data Structures and Models

Designs, develops and scales the overall database/data warehouse structure based on functional and technical requirements.  Designs, develops and scales data collection frameworks for structured and unstructured data.

Data Pipelines and ELT
Designs, applies and scales data extraction, loading and transformation techniques in order to connect large data sets from a variety of sources.

Data Performance
In complete autonomy, troubleshoots and fixes for data performance issues that come with querying and combining large volumes of data.  Accounts for scaled performance in initial design.

Visualizations and Dashboards
Gathers requirements, designs and develops reports, dashboards and visualizations with multiple sources that meet business needs.  Understands data and ideates ways for business to leverage data in innovative ways.

RESPONSIBILITIES
•    Works directly with business units to understand their analytics use cases and gather requirements for an analytics solution
•    Engineers data models for dimensions and facts within the staging and warehouse layer of our enterprise data warehouse
•    Engineers and performance tunes Informatica ETLs to move data from a variety of source systems and file types to fit into dimensional data models
•    Utilizes advanced SQL within Informatica ETLs or Oracle SQL Views when necessary to achieve proper metric calculations or derive dimension attributes
•    Engineers schedule and orchestration for batch and near-real time data loads into the enterprise data warehouse
•    Provide issue resolution and maintenance for a large variety of business unit solutions already existing in the enterprise data warehouse
•    Engineers within a core metadata model (RPD) including the physical, logical and presentation layers for the enterprise business intelligence platform (OBIEE – Oracle Business Intelligence Enterprise Edition)
•    Engineers dashboards within the enterprise business intelligence platform containing reports and visualization that have intelligent user interface design and flow for the business including adequate performance

QUALIFICATIONS:
Required:

•     A bachelor's degree in Computer Science, MIS, or related area and significant experience with business intelligence design and development.  
•    7+ years of experience with reading and writing SQL. 
•    7+ years of experience designing and developing within a business intelligence/reporting tool like OBIEE (Oracle Business Intelligence Enterprise Edition) or OTBI (Oracle Transactional Business Intelligence). 
•    5+ years of experience engineering within a data warehouse or related experience with dimensional data modeling.
•    5+ years of experience designing and developing ETLs with tools like Informatica, Microsoft SSIS (SQL Server Integration Services), Oracle Data Integrator (ODI), Python.
•     Excellent written and verbal communication skills.
•    Proven ability to gather detailed technical requirements to design and develop business intelligence report solutions from beginning to end.
•     Excellent organizational and time management skills.
•     Tested problem-solving and decision-making skills.
•     A strong pattern of initiative.
•    Highly developed interpersonal and leadership skills.
•     Must be a Citizen or National of the United States, a lawful, permanent resident or have the authorization to work in the United States.
•    Applicants must not now, or any time in the future, require sponsorship for an employment visa

Preferred:
•     Experience with Oracle SQL including advanced functions like analytical functions.
•     Experience with business processes or core database tables within Oracle Cloud Supply Chain and Finance modules. 
•    Experience working with Informatica ETL tools
•    Experience tuning SQL and ETLs.
•    Experience working with Oracle Analytics Cloud, Oracle Data Visualization or Oracle Autonomous Data Warehouse

BENEFITS: 
We offer an excellent benefits package. Competitive base salary plus bonus, annual merit increase performance reviews, medical, dental, vision, non-contributory pension, profit sharing, 401(k), stock purchase plan, relocation assistance, paid vacation.

Horizontal is proud to be an Equal Opportunity and Affirmative Action Employer. We seek to provide employment opportunities to talented, qualified candidates regardless of race, color, sex/gender including gender identity and/or expression, national origin, religion, sexual orientation, disability, marital status, citizen status, veteran status, or any other protected classification under federal, state or local law.

In addition, Horizontal will provide reasonable accommodations for qualified individuals with disabilities. If you need to request a reasonable accommodation in order to complete the application or interview process, please contact hr@horizontal.com.

All applicants applying must be legally authorized to work in the country of employment.

Upload Your Resume

We accept .DOC, .DOCX, .PDF up to 10 MB.

We do not accept scanned documents, images, or resumes containing images and/or icons.

Password must contain:
  • minimum 10 characters

  • 1 uppercase letter

  • 1 lowercase letter

  • 1 numeric character

  • 1 special character (such as !, %, @, #)

  • Passwords match

EQUAL OPPORTUNITY EMPLOYMENT SURVEY

What is your gender?

What is your ethnicity? Select all that apply

What is your Veteran / U.S. Military Status?

Do you have a disability?

You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such am impairment or medical condition.

Horizontal is proud to be an Equal Employment Opportunity/Affirmative Action Employer providing a drug-free workplace.

Success!

You have saved your first job! To see all your Saved Jobs, click here. Or continue scrolling through jobs and bookmark openings that catch your eye and apply for those jobs later.

Return to Job Search
Close

We’re sorry!

There are currently no open positions in your location or accepting applications from out of the country

Return to Home
Close
X
Cookies help us improve your website experience.
By using our website, you agree to our use of cookies.
Confirm