Business Intelligence Developer

Key Skills

.NET, Analytical and Problem solving, Big Data Technology, Business Intelligence, C Programming, C# Programming, C++, Data science techniques, Design, Effective communication skills, ETL frameworks, Java Programming, NoSQL, PowerBI, Project management, Python Programming, SQL, SQL Server, Tableau

Job Description

Applies advanced subject matter knowledge to solve complex business issues and is regarded as a subject matter expert. Frequently contributes to the development of new ideas and methods. Works on complex problems where analysis of situations or data requires an in-depth evaluation of multiple factors. Leads and/or provides expertise to functional project teams and may participate in cross-functional initiatives. Acts as an expert providing direction and guidance to process improvements and establishing policies. Frequently represents the organization to external customers/clients. Exercises significant independent judgment within broadly defined policies and practices to determine best method for accomplishing work and achieving objectives. May provide mentoring and guidance to lower level employees.

Responsibilities

• Communicates tactical process decisions and plans, project status, and issues and workarounds, in order to achieve alignment with relevant areas of the business, function, or region.
• Leads internal projects with medium to high complexity and risk, provides feedback on projects, and conducts post- project evaluations.
• Represents the needs of the business, function, or region on an ongoing basis to drive process improvements.
• Collaborates with operational teams and business stakeholders to gather business requirements, supporting the design of new or improved processes of medium to high complexity, and understand business/customer impact.
• Utilizes and assists others in utilizing standard project management and quality
• improvement methodologies in process improvement approaches.
• Establishes processes which are consistent with overall organization objectives and maintains process documentation.
• Constantly improves communication skills that will enable her/him to successfully explain technical information to non-technical business people.
•  Will cover and do other additional activities assigned by the acting manager or her/his back-up, as needed.
• Identifies development, optimization and implementation requirements for the solutions.
• Works on designing the architecture for database applications within the organization.
• Installs, configures and maintains the server and client components of the Database management system.
• Makes assessments on data volumes, storage space and most used data processing patterns.
• May design the logical and physical structure of the database/data warehouse.
• Creates and configures the database, including maintenance plans and database adjacent services.
• Provides a coherent action plan for database failovers.
• Defines, configures and implements all required instruments for the back-up of the data.
• Rebuild and restores the database after any failovers.
• Proactively identifies, manages and tweaks all parameters that impact the overall performance of the database system to ensure optimal responses.
• Recurrently monitors the overall performance of the database and its components.
• Designs, implements and adjusts the security layers of the server and database, in accordance with the company’s and team’s policies.
• Manages the user access, privileges and security models and designs are compliant with company and cyber security policies, ensuring data and systemic integrity at all times.
• Works on integration with other systems and moves data from one layer (database) to another, as needed.
• Takes a wholistic approach in managing client’s requests: data recovery, acquisition, processing and delivery.
• As needed, will perform changes on structure of the databases, indexes and any other components.
• Designs and delivers trainings to team members or clients and is in charge of communication tasks related to the assets in her/his ownership.

• Knowledge & Skills
• Extensive experience with data engineering tools, languages, frameworks to mine, cleanse and explore data.
• Excellent analytical and problem-solving skills.
• Fluent in NoSQL & relational based systems.
• Strong experience in overall architecture of big data systems, cloud services/systems.
• Designing data systems/solutions to manage complex data in complex, distributed and massively parallel systems.
• Evaluating forms and processes for database architecture testing and methodology, including writing and execution of test plans, debugging, and testing scripts and tools.
• Excellent written and verbal communication skills; mastery in English and local language.
• Ability to effectively communicate product architectures, design proposals and negotiate options at senior management levels.
• Scope & Impact
• Collaborates with peers, junior engineers, data scientists and project team.
• Typically interacts with high- level Individual Contributors, Managers, Directors and Program Core Teams.
• Leads multiple projects requiring data engineering solutions development.
• Drives design innovation.
• Education & Experience
• Typically, 6-10 years of related experience in IT/business operations.
• Typically, 5-8 years of project management experience.

  Quality improvement training required and certification a plus.

• Knowledge in software development with one or more of the following programming languages, Java, Python, JavaScript, C/C++, C#, .NET. 
• Background working with REST API's
• Proven experience as a BI Developer or Data Scientist

  Industry experience is preferred.

• Background in data warehouse design (e.g. dimensional modeling) and data mining.
• In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework.
• Familiarity with BI technologies (e.g. ThoughtSpot, Microsoft Power BI, Tableau). ThoughtSpot is a plus.
• Knowledge of Snowflake or SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).
• Proven abilities to take initiative and be innovative
• Analytical mind with a problem-solving aptitude.
• BSc/BA in Computer Science, Engineering, or relevant field.