Database Administrator - Business Intelligence Analyst Consona
Department: Administration - G&A
Salary: Salary + Bonus
Apply To This Job
Return To List
Our Business Systems team is seeking a Business Intelligence Analyst that will serve as the subject matter expert in data modeling, reporting infrastructure, design and development, and report creation and maintenance through the use of enterprise reporting tools. This position will work closely with other departments to gather reporting and data requirements and work closely with peers to ensure understanding of the various data models and solutions that may need to be developed to complete the projects.
This position will primarily be engaged with all aspects of the core business systems in use at Aptean. You will be expected to be a main resource for the ongoing development, foresight and maintenance of the Business Intelligence processes that will be the key to driving increased revenue. This position will report directly to the Director, Front Office Applications and will not have any direct reports.
Manage the communication with other departments related to Business Intelligence (BI) system and Data Warehouse (i.e. SQL Database) & and provide decision making on implementations.
Decides on best business design to meet reporting needs for the organization. Work with peers to ensure correct understanding and implementation of these business needs.
Implements new enhancements to BI, supporting additional insight into existing products and services. Ensures correct implementation from beginning to end.
Educate & train user community on the potential uses of the business intelligence system.
Provide customized ad-hoc reports as requested by management by extracting data from internal databases using SQL or using Business Intelligence tools. Summarize data in business and financial terms for management, executives, and other stakeholders.
Perform and adopt best practices in testing and reporting: usability, data integrity, test design, analysis, validation, and documentation.
Research and document potential data integrity issues through the use of SQL querying or Business Intelligence tools.
Document rules and processes for business intelligence of reports, dashboards, change requests, projects, or other outputs.
Maintain library of model documents, templates, or other reusable knowledge.
Willing to perform other job duties/responsibilities as may be assigned for the successful operation of the business.
Two or more years of combined work experience in business intelligence report or dashboard creation in conjunction with data systems integration and data modeling experience
Strong ETL and data modeling experience especially with Star and Snowflake schema.
Demonstrated experience with data modeling tools and methodologies, specifically:
SQL Server Integration Services
SQL Server Analysis Services
SQL Server Reporting Services
Ability to manage multiple concurrent processes while understanding and successfully solving business problems
Exposure to SQL Server Data Tools, and incorporating built in visualization algorithms (Na-ve Bayes, Decision Trees) or an understanding of alternative methods (gradient tree boosting)
Proficiency in MDX Query and SQL query writing including the ability to write advanced analytical queries and functions.
Understanding of algorithm efficiency classes, and asymptotic analysis/measurement
Exposure to one or more types of optimization algorithms is a plus (Simulated Annealing, Genetic Algorithms)
R programming experience strongly preferred
Exposure to D3 Visualizations or other visualization software (Tableau, SAS, PowerView)
Understanding of Data Warehousing concepts, schemas, slowly changing dimensions, facts and dimensions and implementation of the same
Experience with data sourcing, data transformation, data load, data integration and conversion processes, business intelligence tools and ETL tools
Experience with executive-level report development business intelligence reports, BI analytics
Ability to translate fluid business requirements into flexible data models.
Excellent understanding of entire development process, including specification, documentation, quality assurance, debugging practices and source control systems
Ability to understand business issues as they impact the software development project.
Strong communications and interpersonal skills.
Hands on expertise and experience in one or more of the following areas:
- Applied mathematics
- modeling of complex systems
- pattern formation in nonlinear systems
- numerical analysis
- data mining
- anomaly detection
||Atlanta, GA |