Job details
Job type full-time
Not provided by employer
Full job description
Description:
Position summary:
This position would require a candidate to possess a strong technical background in developing and delivering bi solutions along with a strong understanding of sql server environmentsBusiness intelligence (bi) is a set of technologies and practices for transforming business information into actionable reports and visualizationsThe bi data engineer transforms data into a useful format for analysis and is focused on the design and architecture.
A bi data engineer is the data professional who prepares the data infrastructure to be leveraged by the hbs bi data developersThe bi data engineer will design, build, integrate data from various resources and manage big dataThe bi data engineer ensure the operations of the data pipeline follow a consistent process of ingestion, processing, storage and accessThe work involves tuning databases for fast analysis and creating table schemas.
The bi data engineer is responsible for making data easily accessible, ensure the process works smoothly and is optimizedThe bi data architect is a critical firm member of the data team, the bi data engineer will run extract, transform and load (etl) on top of datasets and create data warehoused that can be used for reporting and analysisThe bi data engineer ensure the operations of the data pipeline follow a consistent process of ingestion, processing, storage and access.
Roles and responsibilities/ essential functions:
Meet with clients to understand their current business processes and needs to provide consulting services and direction on how to build or grow their current data strategy
Work with hbs sales solutions consultants to identify and grow opportunities within hbs client environments
Support and administer the underlining infrastructure and layout of a client data environment
Develop and design the process for the customer data collection process
Develop policies and procedures for the collection and analysis of data
Review customer sources to ensure integrity of the data collection process
Collaborate with the bi data developers to ensure the requirements are being met to build the right solution needed
Estimate development effort required to delivery data customer needs and requests
Use business analysis skillset to identify development needs for the purpose of streamlining and improving the operations of the organization for efficiency and profitability
Ability to work independently or as a team on project-based solutions for clients
Work with team mates to continue to grow and mature data services and delivery options for hbs clients
Based on experience, one may mentor other engineers in developing scalable, secure, high-performance bi and data solutions
Requirements:
Competencies
Accuracy – ability to produce high quality work deliverables leveraging industry best practices
Analytical skills - strong abilities require to effectively interpret customer business needs and translating them into application and operational requirements, resolving complex technical and business problems
Communication – strong written, verbal, and non-verbal communication skills, especially conveying complex information in an understandable manner
Leadership – ability to motivate and guide others to ensure performance is an accordance with clear expectations and goals
Learning – ability to quickly learn new technologies to deliver solutions
Presentation skills – ability to effectively conduct formal and informal presentations in both small and large group settings within all levels of a company
Project management – ability to demonstrate an understanding of process engineering, planning, organizing, staffing, directing, and controlling work tasks
Time management – ability to effectively utilize available time for managing multiple tasks/projects simultaneously
Required experience:
Experience with needs analysis, software evaluation and selection, customization, and implementation
Data warehousing systems and architecture experience in `real world`, practical, successful implementations
Understand multi-dimensional database structures and schemas
Strong knowledge of system design, development, and deployment
Microsoft bi suite experience
Microsoft excel
Microsoft sql server analysis services (ssas)
Microsoft sql server integration services (ssis)
Programming and processing experience
T-sql
Etl
Azure experience
Azure sql database
Azure sql manage instance
Azure architecture
Azure data factory
Strong knowledge of sql utilizing ms sql server
Preferred experience:
Expertise in professional services or similar client facing roles
Experience in multiple industry (education, healthcare, retail, manufacturing) verticals
Powershell knowledge and understanding
Understanding of report writing and visualization
Programming and processing experience
Dax
Power query
M
Microsoft bi suite experience
Microsoft sql server reporting services (ssrs)
Microsoft power bi
Microsoft certified: data analyst associate
Microsoft certified: ai-900 - microsoft azure ai fundamentals
Microsoft certified: dp-200 - implementing an azure data solution
Microsoft certified: dp-201 - designing an azure data solution
Microsoft certified: dp-300 - administering relational databases on microsoft azure
Required skills, education and/ or certifications:
Bachelor’s degree in business or i.tRelated discipline accepted
Equal opportunity employer - disabled/vets
#hbs
Hiring insights
Job activity
Posted 26 days ago