Senior ETL / BI Developer

RIGHTLY ATX102 days ago
Austin, US

About this job

Job type: Full-time
Role: Database Administrator



Technologies

etl, oracle, clojure



Job description

THE COMPANY:  For over 60 years, our client Wilsonart has been a world leading manufacturing and distribution organization driven by a mission to create innovative, high performance surfaces people love, with world-class service their customers can count on, delivered by people who care.
Wilsonart creates Engineered Surfaces like High Pressure Laminate, Quartz, Solid Surface, and other engineered surface options for use in the office, education, healthcare, residential, hospitality and retail markets. If you’ve seen beautiful counter tops in places like Home Depot or Lowe’s that look like real stone but aren’t, you’ve probably already seen a few of Wilsonart’s products firsthand.
Headquartered in ATX, the company has thousands of employees worldwide but their corporate functions here in central Texas remain relatively lean, which makes this a great opportunity for someone who’s looking for that small-team feel but with the ability to grow personally and professionally alongside the resources of a global, multi-billion dollar organization.
THE JOB:  This position sits within the Enterprise Performance Management and Business Intelligence group, which is comprised of flat teams whose work tends to be fast paced and can be both collaborative and individual.
The BI Lead Developer role is a key liaison who is responsible for working directly with business users to translate their needs into useful data that will enable the larger organization to make strategic and informed decisions. The business currently leverages tableau for most of its BI reporting and, while that will be a major focus of this position, this individual will also play an important role in the design, development, and maintenance of other BI related software and systems, including integrations with databases and ERP systems, as well as helping to define the overall data warehouse architecture (e.g., ETL process, ODS, EDW, Data Marts).
Essential duties and responsibilities: Work independently with users to define BI concepts, information needs and defining functional requirements, specifications and recommendations related to a proposed solution Lead and perform complex analysis in an evolving data environment. Extract and analyze data, patterns, and related trends as needed, with the subsequent ability to synthesize the data into information consumable by organization. Ensure high levels of Business Intelligence system availability through support functions and in-depth testing. Responsible for the efficient, compliant, timely, secure acquisition, integration, provision, and exchange of the enterprise data. Work with external vendors and internal business and technology staff to accurately gather and interpret requirements, specifications, and database models to determine appropriate data warehouse development solutions. Monitor and administer automated and manual data integration and ETL jobs to verify execution and measure performance; Build reports to audit, monitor & validate data warehouse job
THE IDEAL CANDIDATE:  This role is an opportunity to be more than a behind-the-scenes developer or simply a reporting partner to business stakeholders. It’s a chance to do both at the same time, in a unique hybrid position that will allow you to leverage your hard technical skills in database management and business intelligence platforms, and combine that with your softer skills in communication and business partnering to make positive impacts across the organization.
The team is looking for someone who brings that fundamental technical background but, perhaps more importantly, has the ability and confidence to build meaningful relationships with cross functional leaders and be an active part of designing solutions. This is the kind of position that takes someone with curiosity and initiative, as it will come with direction but also an expectation that you’re capable of working with autonomy. The manager is looking for someone who wants to lead, and there are growth opportunities for the right individual who shows they are capable of being a leader.
Required Education, skills and experience Bachelor’s degree required Minimum of 3-5+ years’ of demonstrable experience working with business stakeholders Minimum of 5-8+ years’ of related technical experience: 5+ years’ experience with developing programs using SQL 5+ years’ experience with the semantic layer of any one Business Intelligence tools OBIEE, Tableau, Cognos, SAP BW, Business Objects etc. Preferred to have Tableau development skills in addition to Oracle BI suite of products Experience in developing Business Intelligence environment based on OLAP and OTLP frameworks 5+ years’ experience with the ETL development Expertise in any one tool is required. Oracle Data Integrator (ODI), Informatica, Datastage 8+ years’ experience in developing data warehousing systems for enterprises  The ideal candidate will also bring some or all of the below: MBA or advanced degree in a related field Prior experience managing direct reports or other examples of proven leadership capabilities Ability to resolve data related issues including complex data modeling challenges Knowledge of Scrum and Agile methodology, a plus. Any software language like .Net, Java, VB Familiarity/experience with the following products: Hyperion (HFM, Hyperion Close Management, Hyperion Planning, Essbase) FDMEE, BPM Workflow, DRM, SPSS or SAS Exposure to any one ERP (SAP Oracle) data structures and functional knowledge of any given process domain

Location

Austin, US

By clicking apply you will leave devsnap. Please be careful. You should never have to pay to apply.
A new version is available REFRESH