Sr Data Engineer - Finance

Join our dynamic team as we seek a Senior Data Engineer with a focus on finance to bolster our client's Data and Analytics division. This role offers an exhilarating chance to contribute to the evolution and modernization of analytics! We're on the lookout for individuals with exceptional communication skills, adept at engaging with stakeholders at all levels of the organization.

In this role, you'll be tasked with managing concurrent projects that demand innovative problem-solving. Leveraging tools such as SQL, Oracle Business Intelligence, Tableau, Google Cloud Platform, Python, and Informatica ETL, you'll craft data pipelines and models to enrich enterprise reporting and analytics. Furthermore, you'll harness the power of enterprise business intelligence tools like Oracle and Tableau to engineer reports, dashboards, and visualizations.

This is an extraordinary opportunity to make a significant impact and thrive in a collaborative environment dedicated to driving forward-thinking analytics solutions!

Specific 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 the Finance business unit to understand their analytics needs and gather requirements for analytics solutions
• Engineers advanced physical and logical data models for dimensions and facts within the staging, warehouse and semantic layer of our enterprise data warehouse or data lake
• Engineers and performance tunes Python or Informatica ETLs as well as Google BigQuery Dataprocs to move data from a variety of source systems and file types to fit into dimensional data models
• Utilizes advanced SQL within Google BigQuery, 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 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
• Use tools such as SQL, Oracle Business Intelligence, Tableau, Google Cloud Platform, Python and Informatica ETL to engineer data pipelines and data models to enhance enterprise reporting and analytics. 
• Engineer reports, dashboards and visualizations using enterprise business intelligence tools (Oracle and Tableau).?? 

Required Qualifications:

• A bachelor's degree in Computer Science, MIS, or related area and significant experience with business intelligence design and development. 
• 8+ years of experience with reading and writing SQL. 
• 8+ years of experience designing and developing within a business intelligence/reporting tool like Oracle Business Intelligence, Tableau or Google Cloud Platform.
• 5+ years of experience engineering within a data warehouse or related experience with dimensional data modeling.
• 5+ years of experience designing and developing ETLs/pipelines in Python, Google BigQuery Dataprocs and/or Informatica ETL.
• 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 authorization to work in the United States.
• Applicants must not now, or in the future, require sponsorship for an employment visa.

Preferred Qualifications:

• Experience with Finance data analytics
• Experience working within Google Cloud Platform with services like Dataflow, Datafusion, Pub/Sub, Cloud SQL, Cloud Storage
• Experience with Oracle SQL including advanced functions like analytical functions.
• Experience tuning SQL and ETLs.
• Experience 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.)

BENEFITS: 
Our client offers 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 to the corporate headquarters area, paid vacation. 
TRAVEL REQUIREMENTS: Travel may be necessary 10% of the time.
 

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 us. All applicants applying must be legally authorized to work in the country of employment.

PandoLogic. Category:Technology, Keywords:Data Engineer, Location:Austin, MN-55912