BI Engineer Job Description
BI engineer
provides advanced technical support and work with customers to solve complex issues with the AppDynamics’ product in their environment, focusing on the java agent, java application, and java technologies.
BI Engineer Duties & Responsibilities
To write an effective BI engineer job description, begin by listing detailed duties, responsibilities and expectations. We have included BI engineer job description templates that you can modify and use.
Sample responsibilities for this position include:
Provide advanced technical support to resolve issues related to SQL Server issues related to SQL Server connectivity, linked servers, data movement, and SQL BI related to SQL Server Integration Services (SSIS), BDD (SSIS Balanced Data Distributor Transform), and Hadoop Connector for SQL Server issues for SQL On-Premise and in Windows Azure Virtual Machine environments (IaaS)
Develop solutions for SQL Server issues related to Installation, Administration of Reporting Services (SSRS) including Report Builder, Report Viewer, Powerview, Power BI, and the .NET chart controls for SQL On-Premise and in Windows Azure Virtual Machine environments (IaaS)
Design and build analytical data stores on Microsoft SQL Server using your extensive background with data analysis and dimensional modeling, Transact-SQL expertise, and strong understanding of how to deliver the right model to nimbly solve business problems
Design and create semantic models (e.g., Multidimensional, Tabular) using SQL Server Analysis Services (SSAS), and develop reports and analytics/visualization using your experience with tools like Power BI, SQL Server Reporting Services (SSRS), MDX and DAX, and understanding of how to effectively present data
Communicate with business clients via telephone and written correspondence regarding technical questions and issues related to SQL Server technologies
Interact with customers and provide the highest level of support for SQL BI issues related to Microsoft OLAP, Analysis Services, and certain Power Pivot cases for business clients
Design and develop robust ETL processes using tools like SQL Server Integration Services (SSIS) or IBM’s DataStage, sourcing data from many disparate systems and applying your strong experience with best integration patterns and standards
Develop and drive the adoption of self-service BI tools and solutions
Manage multiple complex projects and recognize relationships/synergies between them
Focus on day to day BI application availability and performance
BI Engineer Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for BI Engineer
List any licenses or certifications required by the position: OSHA, AWS, BI, DHS, DAWIA, MCSE, ITIL, CDMP, SW, SAP
Education for BI Engineer
Typically a job would require a certain level of education.
Employers hiring for the BI engineer job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Computer Science, Engineering, Technical, Statistics, Mathematics, Information Systems, Business, Education, Information Technology, Math
Skills for BI Engineer
Desired skills for BI engineer include:
SQL
KAFKA
Building API
Python
Similar coding languages
Java
Python/Java
Cassandra and Hbase along with Java
Amazon Web Services and Redshift in an enterprise environment
Analyze and evaluate the effectiveness of operating programs
Desired experience for BI engineer includes:
5+ years with SAP BI (BW, DSO, InfoCubes, etc) components
Experience with BI reporting tools (Tableau, Microstrategy, SSRS)
Experience with distributed data architectures and their eco-systems (Hadoop/EMR, Hive, Pig, Spark)
Experience developing reports, charts, dashboards in a major BI reporting technology (Tableau, Microstrategy, SSRS)
Strong experience developing reports, charts, dashboards in a major BI reporting technology (Tableau, Microstrategy, SSRS)
Experience with distributed data architectures and their eco-systems (Hadoop, Hive, Pig, Spark, EMR)
BI Engineer Examples
1
BI Engineer Job Description
Job Description Example
Our growing company is searching for experienced candidates for the position of BI engineer. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for BI engineer
- Develop ETL packages to be run to move data from one system to another
- Schedule packages to be run from JAMS in such a way that conflicts are avoided
- Manage ELT packages in a TFS repository
- Write packages that will operate in multiple scopes using the same package
- Create packages that are easily maintained by junior staff
- Work in a self-organizing team environment where you determine your tasks in coordination with your team
- Collaborate with development and business experts to gain an understanding of complex business logic
- Gather and analyze business requirements to build new data jobs and tables, implement automated processes/workflows to support data initiatives both internally and with external marketing partners
- 25%-Partner with leaders to identify needs and gather requirements
- Understanding the Data Warehouse and leveraging BI tools to create standard reports, dashboards and other components
Qualifications for BI engineer
- 8+ years of experience in architecting, designing and implementing Business Intelligence & Visualization solutions using Tableau and/or Microstrategy
- Tableau Certification and/or Microstrategy Developer/Architect certified
- Excellent data modeling skills with experience in working with very large scale databases including star schemas and snowflake schemas
- Strong understanding of different subject areas of eCommerce business including but not limited to Site Metrics, Internet Marketing, Experimentation, Financial reporting
- Deep knowledge of SQL coding, stored procedures, UDFs, and query optimization
- Influences organization, customers, suppliers and peers within industry on the contribution of own specialism
2
BI Engineer Job Description
Job Description Example
Our company is hiring for a BI engineer. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for BI engineer
- Two years of experience preferred with SQL Server Analysis Services and MDX query language
- Two years of experience preferred SQL Server database administration
- Two years of experience with SQL Server Integration Services or similar ETL tool
- Operating, maintaining and running the Data Warehouse and BI solutions
- Performing additional job duties and responsibilities as being part of the development team such as collaborating with the BI Architect to develop a robust solution
- Working closely with stakeholders, subject matter experts
- Should have minimum 5 years of relevant experience in SAP Business Objects XIR3/4.x
- Strong experience in Web Intelligence reports development using BI Launchpad (Infoview) / Webi Rich Client
- Knowledge of building Universes using IDT/Universe Designer
- Experience in Crystal Reports development
Qualifications for BI engineer
- Good understanding of underlying data technologies such as Redshift, SQL Server
- Understanding on Business Intelligence Dimensional Modelling, Star Schemas, Slowly Changing Dimensions
- Understanding of ETL process and development
- Lead delivery of new BI and Analytics Platforms
- Influences organization, customers, suppliers and peers within industry
- Advises on the available standards, methods, tools and applications relevant to Business Intelligence, Data Analytics and Data Science and can make correct choices from alternatives
3
BI Engineer Job Description
Job Description Example
Our company is hiring for a BI engineer. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for BI engineer
- Work with internal customers and other IT disciplines to understand requirements – the data and insight needed to power operational performance, customer experience and competitive advantage, in order to iteratively deliver effective BI solutions across the enterprise
- Work with the BI Team to drive data quality and security standards and practices, using your data lifecycle and classification experience to deliver safe and credible information
- Stay current with leading-edge “big data”/NoSQL/virtualization technologies and patterns, and influence and actively participate in the use of newer platforms, tools and methods for efficient and rapid delivery of high-value BI solutions
- Partner with the Engineering Manager, Engineers, and BI Analysts to build complete BI solutions
- Model data and metadata for pre-built reporting
- Design and implement ELT and ETL data processing solutions from both on-premise (Teradata, Wherescape) and AWS (S3, Redshift)
- Continual performance and query tuning
- Contribute new and innovative ideas to the Enterprise Reporting and BI platform roadmap
- Provide occasional on-call production support after hours
- Design and implement disaster recovery and business continuity plan for data and services
Qualifications for BI engineer
- Expert/Advanced SQL programming skills required
- At least 5 years’ experience administering and supporting a SAP Business Objects server platform
- At least 2 years’ experience with Windows Server and/or Linux server administration
- 4 years’ experience as Business Intelligence platform owner or lead tech engineer
- 1 year experience with big data technologies Hadoop, Mongo, and Cassandra
- SAP Business Intelligence Platform certification
4
BI Engineer Job Description
Job Description Example
Our innovative and growing company is hiring for a BI engineer. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for BI engineer
- Troubleshoot and resolve issues occurred in daily operations
- Build monitoring reports for various systems, databases and services
- Migrate database, tools, services and applications to AWS cloud
- Maintain and continuous improve the process, tools and configurations for automatic data integration and delivery
- Support diagnosing and fixing problems during release process
- Tracks and reports on the test execution in a timely manner with attention given to
- Achieving a high level of quality
- Work as part of a team to test DWH/BI ODS AND/OR Reports
- Create test plan and align it with overall scope
- Design and create test cases based on business requirements
Qualifications for BI engineer
- Bachelors degree required, ideally with a technical focus
- Minimum 2 years of experience in developing reporting, dashboards, and business analysis with a focus on marketing technologies and solutions
- Highly flexible with an ability to execute well in a fast-paced environment
- Experience with Vertica, MySQL or other database systems
- A strong analytical nature with a focus on performance optimization
- Experience with Hadoop infrastructure
5
BI Engineer Job Description
Job Description Example
Our growing company is looking to fill the role of BI engineer. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for BI engineer
- Raise Defects on time and should bring them to closure when it meets business requirements
- Ability and desire to take charge of projects and help drive to completion
- Demonstrated ability to work independently with a team
- Passion for analytics, technology and troubleshooting
- Great personality with strong ambitions to succeed and seek out new challenges and growth opportunities
- Understand OLAP architecture and how the cube interacts with data warehouse model
- Quickly iterate and prototype on key business metrics to arrive at a finished product that aligns with end user expectations
- Understand the fundamentals of a dimensional data warehouse model and how to optimize the way data is organized for consumption in BI tool
- Define and implement relational structures, dimensional data marts/models and cubes for the needs of analytics
- Designs, builds, tests, deploys and maintains cubes and reports
Qualifications for BI engineer
- Experience in working with a range of data tools for example, Ab Initio, Informatica, DataFlux, Datanomic, Trillium, Teradata, IBM InfoSphere DataStage SQL, Access/Excel, Tableau, MicroStrategy
- Ability to write Bash, Perl, Python scripts for monitoring, regular maintenance, and automation of tasks
- 5+ years of experience in executing BI / data warehouse projects
- Minimum Bachelor’s degree in Business, IT or similar field such as Technology
- Learning new things – technology is always changing
- Detailed oriented – will need to juggle multiple deals at once keep track of time