• Develop dashboards for key stakeholders in support of KPIs and key metrics
• Perform analysis for key stakeholders and derive insights between key metrics and drivers. 
• Solidify these ad hoc analyses into dashboards or reports when valuable
• Identify and propose solutions constantly make data accurate.
• Combine data and research into clear and concise conclusions and recommendations.
• Provide data analysis and support to design better workflows, automate processes.
• Support the development of training materials including documenting new processes.
• Be a key driver in Data Governance and Master Data Management initiatives.
• Perform and assist in data audits to support data accuracy and ownership
• Collaborate cross-functionally with all departments and teams to inform decisions through meaningful data deliverables

Skills: Dashboard Development, Data Analysis, Reporting, Data Accuracy, Data Integration, Workflow Optimization, Training Support, Data Governance

• Works on routine problems of moderate scope where analysis of situations or data require a review of a variety of factors. 
• Build productive working relationships internally and externally.
• Work in collaboration with colleagues within the organization to identify best solutions/ approaches
• Assist with technical estimates internally for solutions development and support.
• Responsible for the delivery of customized queries, reports and dashboards
• Coordinate with the developers in order to execute and deliver according to project timelines.
• Perform database administration in terms of modifications to the structure
• Ensuring encryption of sensitive data, manipulating and cleansing data  
• Resolve technical problems pertaining to the use of existing information
• Continuously evaluate and discover new technology solutions

Skills: Problem Solving, Relationship Building, Collaborative Solutions, Technical Estimation, Report Delivery, Project Coordination, Database Administration, Data Encryption.

• Design reporting solutions utilizing team standard development procedures and techniques that support the project requirements 
• Convert existing reports and processes to the standardized set of data sources
• Support the complete software development lifecycle
• Gathering, design, specifications, development, change management, testing and deployment activities
• Work collaboratively with team members and business partners in translating and documenting business requirements
• Participate in the planning and implementation of projects, which includes the design and execution of test plans to ensure a successful implementation
• Develop system documentation for all Business Intelligence solutions, including design and technical specifications
• Perform thorough testing of own and other team members’ developed projects
• Develop standards guidelines, and quality assurance procedures for Business Intelligence processes
• Understand the total team IT computing environment and daily operations and understand the impact of planned changes

Skills: Report Design, Data Standardization, SDLC Support, Requirement Gathering, Collaborative Development, Project Planning, System Documentation, Quality Assurance.

• Design and build metrics, attributes, dashboards and reports using Domo based on the needs of the business and utilizing data from multiple sources
• Produce summary and detailed reporting solutions for key performance indicators utilizing data housed in multiple databases/systems
• Assist in the defining and developing system requirements, designing dashboards, prototyping, testing and supporting the implementation
• Perform detailed data validation to ensure accuracy of all BI reports and data
• Work with vendors and internal business units to facilitate the delivery of BI solutions
• Collaborate with, and understand analytical reporting needs of the business stakeholders
• Troubleshoot and fix production/existing issues and create mockups from business requirements
• Working with large data sets, data modeling, and ETL
• Evaluate and optimize existing dashboards for performance, desktop/mobile usability and standardization
• Provide knowledge and support for how data, reports and dashboards are developed integrated and managed

Skills: Metrics and Dashboard Design, KPI Reporting, System Requirement Development, Data Validation, Vendor Collaboration, Stakeholder Engagement, Data Troubleshooting, Data Modeling and ETL.

• Develop technical documentation to support ongoing maintenance of reporting and data solutions
• Analyze market trends and recommend directional changes to marketing/business development strategies based on tracking analysis and feedback
• Take part in regular status meetings with the IT Manager, BI Managers and development team 
• Track and report development progress and performance on a regular basis
• Support of end-users, including structure, roles and access rights, training and supporting users
• Maintain technical knowledge and proficiency through actively pursuing training and research
• Problem solve with the initiative to think critically to identify improvement opportunities
• Effectively communicate status, changes, and issues to the relevant parties and stakeholders
• Facilitate meetings to work through technical issues as they arise
• Work closely with internal and/or third-party resources to achieve desired development strategies and outcomes

Skills: Technical Documentation, Market Trend Analysis, Progress Reporting, End-User Support, Continuous Learning, Critical Problem Solving, Effective Communication, Technical Issue Facilitation.

• Translate business needs into technical specifications
• Design, build, and deploy BI solutions
• Write code in a variety of development environments 
• Design, build, test, and maintain ETL processes, data marts and data warehouses
• Create analytic environments from defined architectures
• Provide requirement analysis & effort estimates.
• Integrate logic and understanding of business operations 
• Apply that understanding to develop reporting and analytical solutions
• Perform coding/programming tasks to specification and in accordance with development standards
• Develop test plans and participate in code testing to ensure workability, completeness and quality

Skills: Technical Specifications Translation, BI Solution Development, Coding Proficiency, ETL Process Design, Data Warehouse Management, Requirement Analysis, Business Logic Integration, and Code Testing.

• Framing business problems, maintaining data needed for analysis
• Database design, writing design specs for ETLs and coding 
• Extracting and maintaining 3rd party market data using API calls.
• Support the best decision making within the organization.
• Performing hypothesis testing and causal analyses 
• Statistically assess relative impact and extract trends.
• Creating analysis frameworks to effectively answer strategic questions
• Interacting with customer success, support, product, engineering, sales, and marketing functions.
• Synthesizing results and making recommendations to the executive team and other leaders in various departments.
• Developing models around predictive recommendations, marketing attribution, financial forecasts, etc 

Skills: Business Problem Framing, Database Design, API Data Extraction, Decision Support, Hypothesis Testing, Trend Analysis, Strategic Framework Development, Predictive Modeling.

• Work with the rest of data and development teams
• Support internal data warehouse and data management products 
• Creating vital data and insight reports on key metrics within the business.
• Offer an expert view of data across the businesses
• Improve the visibility that have over the various datasets 
• Ensure the quality of the outputs produced.
• Perform code promotion activities to ensure the synchronization of all environments
• Participate in and contribute to peer code reviews and design sessions
• Provide on-going implementation/production support
• Create and maintain functional requirements and technical specification documentation

Skills: Team Collaboration, Data Warehouse Support, Insight Report Creation, Data Expertise, Data Visibility Enhancement, Output Quality Assurance, Code Promotion, Documentation Maintenance.

• Design, build, test and maintain SSIS ETL packages 
• Prepare and structure incoming data and the underlying tables. 
• Connect to and explore data APIs to determine what data we should collect to meet business needs
• Strategically develop and maintain database warehouse tables and underlying schemas
• Know the importance of data quality, privacy, and security
• Design, build, test, and maintain SSAS tabular models
• Create SQL queries to create/update tables as well as create views and stored procedures to maintain reproducible code
• Work with the business to design and deliver dashboards and KPIs
• Design/make data available in a consumable format for analytics tools
• Work with business partners to prioritize and drive value from our BI capabilities

Skills: SSIS ETL Development, Data Preparation, API Data Exploration, Data Warehouse Management, Data Quality and Security, SSAS Tabular Model Design, SQL Query Writing, Dashboard and KPI Development.

• Build and maintain reports, dashboards and other data visualization components in the area of energy trading
• Collaborate closely with business stakeholders to understand business needs and propose new ways to leverage data for insights
• Consult business specialists about their reports, data models and ETL processes
• Design and develop a data architecture and reports
• Optimize and maintain reports including data models and ETL processes
• Coordinate troubleshooting across involved layers (report, source, infrastructure...)
• Support leadership and executive analytics requirements
• Help drive the adoption of self-service BI capabilities into business units
• Provide third level support for all self-service BI capabilities across business units
• Provide oversight and guidance to projects and the usage of/ impact on BI and/or expected BI deliverables within a project

Skills: Report Development, Stakeholder Collaboration, Data Consultation, Architecture Design, Report Optimization, Troubleshooting, Executive Support, Self-Service BI.

• Participates in analyzing business requirements associated with the design and implementation of highly efficient, highly scalable data processes. 
• Designs and develops robust and efficient processes for extracting, transforming, and loading (ETL) data to meet the needs of large-scale projects.
• Reviews and analyzes data objects and models to improve data management and data access.
• Performs data profiling, source-target mappings, codes data transformation development, optimization, testing and implementation. 
• Identifies required tasks and accurately determines needed resources and timeframes to ensure delivery of business needs.
• Identifies and solves a range of problems in straightforward situations
• Analyzes possible solutions and assesses each using established procedures. 
• Coordination with others outside own organization, to identify innovative solutions.
• Responds to non-standard requests from internal customers
• Interacts primarily with department peers, supervisor, and internal customers.

Skills: Business Requirement Analysis, ETL Process Design, Data Management, Data Profiling, Resource Planning, Problem Solving, Solution Assessment, Cross-Department Coordination.

• Analyzes and reports on customer needs. 
• Serves as a liaison for data users or customers. 
• Education, negotiation, and problem-solving tasks to deliver desirable outcome.
• Implementation, maintenance, testing and/or functional design.
• Attend and lead meetings provide project status reporting
• Management assist with testing scenarios and validate results. 
• Perform technical analysis to determine gaps and create future state solution requirements. 
• Work with data management and visualization tools like Snowflake, SQL, Tableau, Alteryx, etc.
• Maintains optimal operation of departmental reports in partnership with information technology or external software vendor
• Drive the implementation and operations of Analytics Solutions that connect data systems and Business Intelligence (BI) systems. 

Skills: Customer Analysis, Data Liaison, Negotiation, Functional Design, Status Reporting, Gap Analysis, Data Tools, Analytics Implementation.

• End-to-end business intelligence development. 
• Clarifying requirements, provision data, creating ETL processes
• Model and publish data, design and build of visualisations.
• Dialogue with end users to acquire understanding and support use of products.
• Completion of relevant documentation and capturing evidence of development tests.
• Support requests, access management, audit and monitoring server performance.
• Ensure that work being performed aligns with business needs and priorities.
• Work with internal customers to understand the requirements, map to BI requirements and implement 
• Build, track and analyze key business metrics.
• Collaborate with engineering teams to understand the data sources to build indicators that are intuitive and actionable.

Skills: BI Development, Requirement Clarification, ETL Process Creation, Data Modeling, User Dialogue, Documentation, Support and Monitoring, Business Alignment, Metrics Analysis, Engineering Collaboration.

• Supports the company’s reporting systems and performs complex assignments 
• Working with key users to improve business processes. 
• Assists with the establishment, deployment, and governance of Self-Service Analytics.
• Provides support for the Business Intelligence/Data Warehousing (BI/BW) module and portal including configuration and enhancement requests. 
• Designs and develops reports to meet business requirements, across BW, Business Objects, and PowerBI.
• Designs and performs quality assurance testing, performs unit and integration testing
• Understands and works within corporate IT governance practices
• Collaborates with BI team members, IT partners, and business super users 
• Establish, design, deploy, and govern self-service analytics in a way that is consistent with HFC’s size and cost structure.
• Provides support for various functions as it relates to data transformation, cleansing and integration in to reporting platforms. 

Skills: Reporting System Support, Business Process Improvement, Self-Service Analytics Deployment, BI/BW Module Support, Report Design, Quality Assurance Testing, IT Governance, Data Transformation.

• Perform code development by following deployment life cycle in agile fashion delivering iteratively.
• Perform ETL development with MySQL, SSMS and SSIS to maintain and expand data marts and perform integrations.
• Performs data analysis and report development activities, such as writing/troubleshooting complex SQL queries/stored procedures for bug fixes and extract data for reports.
• Analyzes source system data to understand the data structure, definitions, and anomalies.
• Documents report designs and processes in a clear and concise manner.
• Assists in the training, support, maintenance, best practices, code reviews and ongoing administration of reporting system
• Reporting/analytics enhancement requests from the user community.
• Participates in IT projects that are implementing new business analytics and reports
• Interfacing with multiple data sources tied to strategic business applications
• Partners with the BI team members on data modeling, licensing, and other technical aspects of the reporting and dashboarding lifecycle

Skills: Agile Code Development, ETL Development, Data Analysis, Source Data Analysis, Documentation, Training and Support, Reporting Enhancement, BI Team Collaboration.

• A strong analytical foundation
• Problem-solving, inquisitive and questioning mind
• Enthusiasm, drive for excellence and self-development, flexibility, team player
• Expertise in MS Power BI (incl. Power Query)
• Expertise in design of reporting solutions that effectively present business information
• Proven ability to work with complex multi-system data sourcing
• Working experience in relational databases (DQL, DDL, DML)
• Working experience in ETL Tools such as Alteryx, Knime, Azure Data Factory
• Fluency in English (verbal and written)
• Organizational, communication and writing skills

Qualifications: BS in Computer Science with 3 years of Experience 

• Have plenty of experience with SQL for data manipulation and analysis.
• Have experience with the Linux command line and Bash scripting.
• Have overall experience with different types of reporting
• Have a technical and analytical mindset. 
• Good communication skills with various stakeholders are gold
• Experience with Tableau, Redash or a similar BI tool is absolutely helpful in this position. 
• Experience with Docker and Docker Compose 
• Experience with AWS infrastructure and tools  
• Data understanding and the ability to analyze whether data is as expected for use in the process
• Demonstrable capabilities in ensuring stability and operation in ETL processes on Microsoft Integration Services and in Agent jobs on Microsoft SQL Server

Qualifications: BS in Information Technology with 3 years of Experience 

• Capable of determining data lineage and an understanding of the data from source to presentation.
• Experienced in using a variety of reporting tools to provide queries and reports while improving the efficiency of analysis cycles.
• Champion for modern BI and analytics in the business with an understanding of governance, and appropriate use of technology to ensure data quality and reliability.
• Exhibits a solid understanding of methodologies, best practice and tailoring to suit the project goals and structure (i.e. roles and tasks required to deliver BI solutions).
• Demonstrates ability to organize tasks and time to complete deliverables and achieve agreed milestones.
• Shows ability to motivate team members and assist in meeting goals and commitments.
• Demonstrated ability to work effectively in teams and as an individual contributor
• Strong organization skills to manage multiple timelines and projects
• Hands-on experience in participating in all phases of a BI implementation
• Working experience in schema design, developing data models 

Qualifications: BS in Data Science with 5 years of Experience 

• Enjoy understanding cause and effect in various business situations. 
• Enjoy finding creative technical solutions to hard problems and are structured in thinking. 
• Have solid teamwork and partnership skills.
• Be a proactive analytical problem solver with excellent troubleshooting skills.
• Have exceptional communications skills and organizational.
• Willing to maintain logical consistency across metrics and indicators.
• Ability to create dashboards with Power BI and Manage multiple stakeholders.
• Ability to leverage the Microsoft stack to further advance analytical systems
• Ability to develop predictive analytical models based upon data mining and machine learning techniques
• Experience using SSMS or Azure PAAS required incoming for ETL pipelines using the Microsoft toolset available.

Qualifications: BA in Business Administration with 5 years of Experience 

• Advanced SQL experience
• Client service mentality, adaptability and willingness to collaborate openly with other functions
• Ability to explain complicated or technical information to non-technical audiences
• Knowledge of PowerBI and DAX
• Knowledge of Salesforce data structure and Snowflake  
• Knowledge of ETL and data warehouse concepts and processes 
• Product Owner skills and experience with process evaluation and design 
• Practical or academic background in math, statistics, or computer science 
• Able to build stored procedures and coherent processes in SQL
• Able to implement dimensional models for BI reporting

Qualifications: BS in Finance with 4 years of Experience 

• Knowledge of Microsoft SQL Server 2008 to present version
• Knowledge of Microsoft SQL Server Reporting Services (MSSQLRS)
• Knowledge of Tableau, Qlik and ability to adaptable
• Competent in architecting client-side apps and web applications
• Experience with Salesforce and strong Time-Management
• Strong Customer Service and interpersonal skills
• Call Center & CSO operational experience
• Knowledge of SQL Administration and Team Foundation Server
• Knowledge of Azure DevOps and Bilingual in French and English
• A practical understanding of the pharmaceutical and healthcare industries. 

Qualifications: BS in Statistics with 2 years of Experience 

• Strong communication, negotiation and influencing skills to drive dialogue to understand business needs and requirements and convert into solution designs
• Strong business acumen and proven stakeholder consultative approach
• Ability to work with and understand large volumes of numerical based data sets
• A strong awareness of industry best practices related to Business Intelligence and data management
• Demonstrated experience with SQL Server Databases and SQL Server Reporting Services 
• Ability to function as a team player and lead team members in projects
• Experience with other Microsoft languages and technologies, including SharePoint, Visual Studio Team System (VSTS) and Team Foundation Server 
• Demonstrated experience with adhering to usability, design, and development standards
• Understanding of the development lifecycle and software development methodologies
• Ability to work in a collaborative, dynamic team environment and interact at all levels to ensure reliability, availability, scalability, and performance of Business Intelligence solutions

Qualifications: BSc in Mathematics with 5 years of Experience 

• Ability to meet deadlines in a fast-paced environment
• Strong analytical and problem resolution skills
• Strong verbal and written communication skills
• Highly self-motivated and able to work independently
• Experience with Operations processes
• Exposure to WFM software applications and principles
• Exposure to financial and performance benchmarking
• Able to write analytical queries from scratch
• Able to build data structures for ETL processes
• Excellent organizational, time management, and project planning/strategizing skills

Qualifications: BA in Economics with 3 years of Experience 

• Experience in data engineering or analytics
• Have a engineering, data science, statistics, economics or quantitative background
• Either have a strong technology or strong stats/ML background.
• Experience in database design, 3NF, denormalization, star schemas
• Experience with Big Data
• Familiarity with ETL flows/tools (Stitch, HEVO, etc)
• Knowledge of reporting Tools Tableau or similar
• Experience working with statistical packages (e.g. R, Python, Stata, MATLAB, etc.).
• Experience Model Diagnostics and understanding ROC curves, calibration, PDP
• Experience with advanced analytics/models/basic machine learning: Regression Models, Logit, Elastic Net

Qualifications: BS in Management Information Systems with 4 years of Experience 

• Expert level experience with PowerBI, DAX and Excel.
• Proven ability to work with AWS cloud services such as RDS, Glue, Lambda etc.
• Strong knowledge of SQL and T-SQL
• Previous experience with PostgreSQL 
• Ability to Requirements gathering from researchers or other data intense business roles.
• Understand concepts of relational database theory.
• Understand concepts of Data Warehousing.
• Proven experience creating high quality and error free documentation.
• Experience working in a data business where data is the product.
• Experience developing reports, data marts and other extracts.

Qualifications: BS in Computer Science with 4 years of Experience 

• Experience in BI development (Power BI, Qlik, Tableau)
• Good data processing skills in SQL or other programming language
• Knowledge of UI/UX will be considered an advantage
• Enjoy solving complex problems and getting any job well done
• Passioned about technology and data and analytics challenges
• A great team player and collaborate flawlessly
• Have sustained attention to detail 
• Have ability to describe complex technical issues in a clear non-technical way
• Fluent in spoken and written English
• Experience in development in Power BI (including DAX and Power Query M) will be considered an advantage

Qualifications: BS in Information Technology with 3 years of Experience 

• Business Intelligence development experience
• Development experience in SQL including SQL queries and reporting
• Experience managing and administering Domo or similar software
• Prior experience working in the franchise industry
• Experience working with MindBody Data Mart and/or Snowflake
• Working knowledge of ITIL processes and concepts
• Demonstrate a positive approach towards problem solving under pressure
• A self-motivated, emotionally intelligent and pro-active person
• Demonstrates good communication skills, critical thinking
• Problem solving skills and eagerness to learn and grow.

Qualifications: BS in Data Science with 4 years of Experience 

• Software development experience in a large-scale organization.
• Proven track record of successful Business Intelligence project deliveries in an agile environment, working on multiple high-profile deliveries to a wide range of stakeholders at any one time
• Strong analytical, problem-solving and synthesizing skills
• Experience in development of BI solutions in numerous applications (Microstrategy and PowerBI would be an asset)
• Experience in Complete ownership of driving end to end BI development projects  
• Experience with data modelling, designing a semantic layer and strong SQL skills
• Experience working in a Data warehousing environment
• Familiar with ETL concepts, prior exposure to Cloud/Big Data would be an advantage
• Experience in OLAP tools like Essbase, Kyligence, Kyvos 
• Strong communicator with excellent written and verbal skills in English

Qualifications: BA in Business Administration with 8 years of Experience 

• Work experience in the field of Business Intelligence and Data warehousing
• Knowledge and experience with building dashboards, reports and user experience
• Experience with BI-tools, preferable with Qlik Sense/View
• Experience with SQL and relational databases
• Strong communication skills in English (verbally and written)
• Knowledge and experience with Business Intelligence concepts, data modelling and Extract-Transform-Load (ETL)
• Understanding of current industry climates including sales, potential opportunities, managed care environments and competition
• Ability to display complex quantitative data in a simple, intuitive format and to present findings in a clear and concise manner
• Individual contributor with a strong technology background that is able to deliver own complex portfolio of work while collaborating with the team
• Well acquainted with latest developments in the BI, BIG DATA world

Qualifications: BS in Finance with 3 years of Experience 

• Demonstrated experience designing, implementing
• Experience in supporting business intelligence platforms and solutions
• Must have knowledge and experience with one or more of the following BI technologies in BI
• Experience in ETL Tools: ODI , Informatica, AbInitio, Talend, IBM – Infosphere Information Server etc.
• Experience in analytics tool : OBIEE, Tableau, Mcirostrategy, Qlickview etc .
• Must have strong grasp of Oracle Database 11G/12C, PL/SQL, Oracle Architecture, OLAP features 
• Must have strong development methodologies including hands on experience on PL/SQL (created stored procedures, functions, triggers, packages, cursors etc.)
• Knowledge and working experience in the Hadoop ecosystem, Spark, Python, Kafka 
• Knowledge with domains: Software-as-a-Service (SaaS), financials, order management
• Knowledge of customer relationship management 

Qualifications: BS in Statistics with 6 years of Experience