Job Description
Reasonable accommodations may be made to enable individuals with disabilities to perform these essential functions.
•Maintains and develops databases in SQL Server, providing integration and replication services as required through other systems to support the Business Intelligence tools
•Manages data security, connections, and documentation of data structures in SQL Server
•Maintains and enhances cubes and underlying relational definition tables once created by updating changes in reporting structure, hierarchies, or adding additional dimensions as requested
•Documents processes, report and query specifications, and other pertinent data to recreate or maintain applications
•Works directly with other dealers and consultants to leverage BI applications and adapt best practices in BI development and use
•Manages joins, relationships, field attributes, aggregations, and underlying report content integrity
•Provides BI development, deployment, maintenance, and support as requested by various stakeholders. BI development includes, but not limited to, ad-hoc queries, cubes, reports, dashboards, metrics, scorecards, report bursting, and event notifications
•Interfaces with other departments to ensure all reporting needs are being met
•Assists with DBA functions to ensure data is being accurately managed for BI Tools, both SQL and admin roles
•Applies knowledge of tables, views, stored procedures, and triggers
•Integrates multiple disparate data sources into a single source for reporting and analysis
•Utilizes ETL tools to schedule and automate data transfer/replication into data marts
•Supports the department in a variety of ways including but not limited to, data mining, developing complex queries, researching/recommending software tools to meet specific needs, and assisting in data cleansing or program conversion efforts
•Effectively discusses, translates, and describes highly technical subjects to a non-technical audience
•Gathers and analyzes business requirements and then executes and delivers a solid end product
•Trains the organization on how to use Business Intelligence products
•Actively contributes to a highly collaborative BI workgroup via peer code review and idea sharing
•Ability to learn new technologies and quickly adapt
•Ability to interpret and write query languages such as SQL and XML
•Applies best practices in BI data presentation and report design
•Supports Installation, configuration, and maintenance of the BI environment
•Other duties as assigned by managerMicrosoft SQL, Microsoft SQL Server, MS SQL Server
•Maintains and develops databases in SQL Server, providing integration and replication services as required through other systems to support the Business Intelligence tools
•Manages data security, connections, and documentation of data structures in SQL Server
•Maintains and enhances cubes and underlying relational definition tables once created by updating changes in reporting structure, hierarchies, or adding additional dimensions as requested
•Documents processes, report and query specifications, and other pertinent data to recreate or maintain applications
•Works directly with other dealers and consultants to leverage BI applications and adapt best practices in BI development and use
•Manages joins, relationships, field attributes, aggregations, and underlying report content integrity
•Provides BI development, deployment, maintenance, and support as requested by various stakeholders. BI development includes, but not limited to, ad-hoc queries, cubes, reports, dashboards, metrics, scorecards, report bursting, and event notifications
•Interfaces with other departments to ensure all reporting needs are being met
•Assists with DBA functions to ensure data is being accurately managed for BI Tools, both SQL and admin roles
•Applies knowledge of tables, views, stored procedures, and triggers
•Integrates multiple disparate data sources into a single source for reporting and analysis
•Utilizes ETL tools to schedule and automate data transfer/replication into data marts
•Supports the department in a variety of ways including but not limited to, data mining, developing complex queries, researching/recommending software tools to meet specific needs, and assisting in data cleansing or program conversion efforts
•Effectively discusses, translates, and describes highly technical subjects to a non-technical audience
•Gathers and analyzes business requirements and then executes and delivers a solid end product
•Trains the organization on how to use Business Intelligence products
•Actively contributes to a highly collaborative BI workgroup via peer code review and idea sharing
•Ability to learn new technologies and quickly adapt
•Ability to interpret and write query languages such as SQL and XML
•Applies best practices in BI data presentation and report design
•Supports Installation, configuration, and maintenance of the BI environment
•Other duties as assigned by managerMicrosoft SQL, Microsoft SQL Server, MS SQL Server