Middle Bi Engineer
TEAM International, Colombia
Job Description
The Mid BI Engineer is expected to support software developer’s database architects, data analysts and data scientists on BI initiatives and to ensure that optimal data delivery architecture is consistent throughout ongoing projects. They must be self-directed and comfortable supporting the data needs of multiple teams, systems and products
Requirements
3-year degree or studies in progress in Software Engineering, Computer Science or similar from an accredited college or University or relevant experience in the field.
3+ years of experience in Data Engineering, at least 2+ years in middle roles. Prior experience of owning some significant aspect of the data design and implementation. Has an in-depth understanding of the product /application domain. Proven experience of driving tech solutions for commercial projects, working from idea to production support, has experience in several tech stacks and business domain
· 2+ years of practical experience in development of data and/or BI and/or MDM solutions (at least 3 years on Microsoft technology stack).
· 1+ years of Cloud Development Experience (at least 1 year with Microsoft Azure)
· Prior professional experience in a management consulting environment or client facing role strongly preferred
· Demonstrated ability in engaging and communicating with stakeholders, across both business and technology functions
· Strong understanding of application architecture concepts: REST API services, DevOps and CI/CD (Continuous Integration/Continuous Delivery), Source Control and Versioning, Software Development Life Cycle
· Expertise in data solution architectures and the tools and techniques used for data management
· Experience in master data management systems
· Experience in creating and managing data warehouse solutions using best practices
· Experience in establishing methods and procedures for tracking data sources, data lineage, data quality, completeness, redundancy vs. replication, data dictionary, data models, metadata and master data catalogs.
· Experience developing Extract, Transform, and Load (ETL) specifications and mappings to support data conversion and integration
· Experience creating integration/synchronization solutions between multiple systems
· Ability to identify and adopt enterprise data architecture patterns, concepts, approaches, and solutions in support of business needs.
· Advanced knowledge of multiple database platforms and design and support tools, including in-depth hands-on experience with at least either SQL Server or Azure SQL
· Experience in database design, deployment options and performance tuning
· Experience developing logical and physical data models for complex projects using both relational and other modeling techniques and approaches
· Solid understanding of governance frameworks developed to resolve data ownership, sharing, and access rights within a federated environment
· Has solid understanding of programming language concepts, algorithms and data structures. Has experience working with multiple languages, frameworks and design concepts.
· Has solid understanding and usage of the base paradigm concepts and how paradigm concepts can be applied to business requirements. Works with the team on correct application of the base paradigms.
· Works with business on choosing the base concepts that best would fit the needs of the product.
· Knows how to use libraries and frameworks on the project.
· Knows other libraries and frameworks apart from the ones used on the project. Able to conduct researches. Able to evaluate existing frameworks and suggest new approaches.
· Able to select appropriate 3rd party libraries/frameworks basing on high level customer's requirements and technical infrastructure restrictions. Able to justify solution's value in cost/benefit terms and present research results to the business.
· Able to set up code refactoring process.
· Able to define the review procedure.
· Able to set up and/or adjust code review processes, tools, techniques and then to communicate them to other team members.
· Audits code review quality and ensuring that other team members follow the review process.
· Develops branching strategies, monitors team usage of the branching strategies.
· Able to define and set up CI process from scratch and works with the team on improvement.
· Proactive technical risks identification, assessment, escalation, proposing risk response strategies, estimating the strategies, escalating them throughout whole project life, explaining the risks to the business.
· Able to document new solution, create project documentation from scratch.
· Collaborates with other team members regarding requirements specifications interpretation.
· Creates and reads any diagram of any complexity.
<