This role will partner with Product Management, Analysts, Management, and users throughout the business to deliver world-
class business intelligence to drive our key goals. The engineer will design and build reporting and analytics infrastructure from the project start to finish including table design, ETL, reporting structures, metadata, and performance tuning.
The ideal candidate must be eager to learn and motivated to support the business in helping them create the metrics to drive key business decisions.
About the Job
Analyze data schemas and data. Work with the data analysts and data modelers to define and refine the analytics / reporting consumption layer.
Design star schema model for complex business process.
Transform requirements into consumable data and / or new report designs in our reporting tools. We currently use Oracle Business Intelligence Enterprise Edition.
Build efficient, maintainable, and consistent ETL processes.
Create test cases, support user testing, ensure data integrity.
Maintaining requirements, project and application documentation as well as providing solution proposals
Proposing efficient solutions for the business requirements by analyzing, evaluating and prioritizing various solution options
Reviewing and quality assuring outputs, improving or amending design standards and policies as required.
Are you passionate about data? Are you the kind of engineer who loves to produce results quickly to help drive key company initiatives and business decisions?
Do you have a passion for the outdoor retail customer and desire to make a direct impact in customer experience through data and analytics?
Do you enjoy working on a team that collaborates to challenge each other and improve the work they produce every day?
Bachelor's degree (or higher) in Computer Science or Information Systems
At least 2 years of technical experience with 1+ years in BI technologies
Experience collaborating with business analysts and end users
Experience with SQL and SQL scripting for relational databases such as Oracle and PostgreSQL.
Experience in designing / developing the analysis / reporting Consumption layer
Experience in the BI / Data warehousing domain
Experience with the design of ETL solutions integrating multiple source systems
Experience in translating requirements into Dimensional data model design and development
Excellent problem solving and quality testing skills
Ability to carry out data discrepancy investigation, program debugging, trouble shooting, data investigation
Ability to understand business processes and to connect business processes to data. Should be capable of telling 'stories' behind data by analyzing an entity relationship diagrams.
Experience in data analysis and problem solving with large amounts of data
Experience using source control systems
Experience in continuous integration and deployment
English skills at an advanced level (both written and spoken)
The following will be viewed favorably :
Hands-on Experience with Oracle Database and / or Oracle BI Enterprise Edition (OBIEE)
Experience with Talend Data Integration
Experience of working in Agile methodology
Experience working with one of the following programming languages : Java, Python, Scala
Experience with Big Data technologies : Hadoop, Apache Spark, Impala, Hive
Experience with different databases and environments - MongoDB, PostgreSQL, AWS, NoSQL, Redshift etc.
Backcountry is a portfolio of premium specialty retail brands. We create remarkable customer experiences through the best selection of premium outdoor product, a flawless shopping experience, the expertise of our gearheads, the lightning speed of our fulfillment, and the shared knowledge of our Community.
We operate six specialty stores Backcountry, Competitive Cyclist, MotoSport, Bergfreunde and SteepandCheap.