Redshift, Proven ability to translate business problems effectively into analytical specifications and requirements, Demonstrated thought-leadership with a passion for translating data into action and business insights, Demonstrated ability to earn trust of senior leadership and business stakeholders through collaboration and attention to detail, Demonstrated ability and willingness to operate autonomously, roll up sleeves and execute to get the job done, Translate business requirements into data models that drive data warehouse or data mart design and configuration, Work with cross-functional teams to gather, document, and approve business requirements for data analysis and reporting projects, Use BI and database tools to develop reporting solutions to meet business needs, Design, develop and implement the reporting and analysis environment, including canned and parameterized reports, Design, develop and implement data integration processes to transform unstructured and disparate source data into the target data warehouse or data marts, Oversee implementation and maintenance of BI systems that support feature development and testing, Provide 24x7 support to ensure availability of BI environments for internal and external users, Minimum 4 years overall work experience as a technical contributor in an IT setting, Minimum 2 years’ experience implementing enterprise-scale reporting systems using business intelligence tools such as Cognos, Business Objects, Microstrategy, etc, Minimum 2 years use of SQL and RDBMS systems (Oracle, SQL Server, etc. Amazon Business Intelligence Engineer - Blind. OBIEE), Strong ability to multi-task and prioritize, Excellent interpersonal skills, with the ability to communicate complex data issues correctly and clearly to both internal and external customers, Design, build, enhance and maintain enterprise business intelligence platform to support business intelligence and advanced analytics for DATG, Create and improve upon timely, relevant, and actionable insights, intelligence and recommendations for business stakeholders, Full life cycle development of BI reports, dashboards and other analytics products, Data cleanup, requirement gathering, data modeling & transformation, reports/dashboard creation, data mining and analytics on complex datasets, Strong Business Intelligence skills, including: Reporting, Data cleanup, ETL and handling scalability issues for enterprise BI, Experience in handling visualization for very large datasets, BS or MS in Computer Science or related field or equivalent work experience, Experience with data mining and advance analytics, 3 years utilizing SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS), 3 years working on Data Warehouse BI projects supporting a Data Warehouse client experience, 3 years developing complex SQL queries, including the use of joins and sub-queries, stored procedures, and performance tuning, 3 years creating complex reports, including drill down reports, using cursors and multi-dimensional objects, 2 years implementing enterprise-scale reporting systems using business intelligence tools, including Cognos, Business Objects, and Microstrategy, 2 years use of SQL and RDBMS systems, including Oracle and SQL Server, 2 years applying logical and physical data modeling concepts and utilizing dimensional data modeling designs and techniques, 2 years developing and optimizing DAX code, Conduct deep dive investigations into business problems and identify potential opportunities, Design, implement and support a scalable and reliable infrastructure for Data Warehousing, BI and Analysis to drive key business decisions, Develop reports and dashboards using various technologies (i.e. Provide business intelligence reports and data warehouse operational support. ), Knowledge of R and/or Python based data programming skills is a definite plus, Focus on the development of solution approaches and designs for individual projects based on functional requirements and project objectives, Oversee the design, development, customization and integration efforts to deploy these solutions, Responsible for leading multiple junior engineers and deliver the ESBI solutions to our customers, Acts as a liaison between site business teams, lottery business teams and various technology teams in addressing their BI needs, The Engineer would act as a solution architect on case by case and is also responsible for supporting the junior development team during the implementation phase, Responsible for evaluating and incorporating emerging standards, best practices, and new technologies, Participating in the definition of the BI roadmap for the lottery customers, Manage technical assessment and design activities for medium to large Business Objects business intelligence solutions, Develop and Deliver solution approach (STR’s) and design artifacts to all project stakeholders, Ensure the alignment of technical solutions with established IT standards and business objectives, Provide project leadership; oversee and own design activities during the project, Address and resolve routine design issues using standard issue resolution methodologies, Deliver effective verbal and written communications to technical and business stakeholders regarding the BI solution design, Discuss technical concepts, issues and ideas with technology and business stakeholders by initiating collaborative discussions, public speaking forums, and presentations, 7+ years of hands on experience with the Business Objects suite of applications, in particular XI release 3.0 and 4.x, 5+ years of hands on experience with IBM Information Server / Data Stage ETL, Experience with Business Objects in a Data Mart or Data Warehouse environment, Experience with dimensional, logical and physical data modeling for data warehouse/data marts (DB2 based), Experience and knowledge of Business Objects SDK, including actual customization work with the SDK, Strong Analytical, problem solving and quantitative skills, Ability to check ones work for errors and be able to problem solve, Ability to work cooperatively and effectively as part of a team, Ability to work closely with business leaders and project teams to understand business requirements, develop solutions, and deliver projects on time, Counsel, consult, mentor and transfer knowledge of key functionalities across Business Intelligence team, Participate in periodic management review of projects to communicate project status, present business process improvements, demonstrate application functionality, and ensure needs are being met, Ability to perform in a team environment as a leader and member of the team, Able to work on multiple projects or multiple complex tasks with competing priorities, 10 + years relevant experience with in the industry.
business intelligence engineer amazon quora .
The MS BI expert should have a good understanding of the SSAS architecture and be able to provide insight into best practices and advanced techniques, Work with business teams to gain a good understanding of their business, analytical, and reporting needs, including the identification of critical metrics and KPIs, Partner closely with cross-function peers and leaders to deliver reporting projects that solve business requirements, Build and prototype dashboards to provide insights into the operations of a business function, Develop rich interactive visualizations integrating various reporting components from multiple data sources, Leverage strong analytical and problem solving skills to identify and deliver actionable insights to relevant decision makers, Design and develop Business Intelligence solutions using multidimensional cubes MOLAP and Tabular Models, Provide training and expertise to business users and other stakeholders on Self-service BI, Proficient building more complex calculations and presentations, Work closely with the Data Architecture team and provide technical design recommendations on the data mart structures which support analytical applications, Provide and own the technical details for implementation and maturing of BI solutions, Design functional specs for BI front end applications including dash boards and reporting, considering appropriate data flow and capture, Must be able to routinely work with little or no supervision, Perform ad-hoc analysis that helps in understanding business and performance trends. Master’s degree a plus, 8+ years Business Intelligence / Data Warehouse development experience, 5+ years working with Service / Field Service / Sales functional areas, preferably in the Medical Device industry, 3+ years of experience in ETL development tools, preferably with knowledge of Microsoft Integration Services 2005 or greater (SSIS), Experience in Microsoft BI development in Integration Services (SSIS), Analysis Services (SSAS) or Reporting Services (SSRS), Experience in database development (T-SQL, PLSQL, and/or SQL scripts), Demonstrated experience in utilizing R, Python, SPSS or comparable to develop analyses, Experience visualizing data in business intelligence tools such as Tableau, Business Objects or Hana Analytics, Experience creating test plans, testing and resolving data discrepancies, Must be a self-motivated, energetic, detail oriented team player passionate about producing high quality BI & Analytics deliverables, Knowledge of SAP CRM ecosystem or similar ecosystems is preferred, Strong sense of customer service for internal customers, Medical robotics has unique characteristics that will require immersion in clinical and technical training and he or she must come up to speed quickly– an interest and desire to learn are critical, Drive the development and implementation of advanced data visualization and dashboards to support various L&TD programs, Identify opportunities and implement use of automation and metrics to drive process improvements, Develop and maintain network-level standards for analyzing and reporting L&TD metrics and data, Provide KPI’s to support program and leadership level decision-making, 5+ years of relevant professional experience in business intelligence, business analytics, data science, or equivalent, Strong record for identifying opportunities to improve performance and efficiencies of processes, while partnering successfully with stakeholders and teammates to implement solutions, Advanced SQL skills, with experience querying large datasets from multiple sources, Experience with data visualization tools, such as Power BI, AWS Quick Sight, or Tableau, Expert skill level in Excel, e.g. Or relevant combination of education and experience, Add new data sources to our cloud-based data warehouse using ETL tools and custom connectors as needed, Design and develop SQL-based views on our data warehouse to enable multi-source data analysis, Build solutions using BusinessObjects and SAS Visual Analytics, or any open source tool for interfacing between source application and the enterprise data warehouse, Perform unit tests and validate expected results; iterate on them until test conditions have passed, Manage problem assessment, resolution, and documentation, Modify existing universes to provide defect fixes, Troubleshoot defects to determine the root cause, 2+ years of demonstrated ETL development experience, Understanding of the processes of data quality, data cleansing, and data transformation, Extensive knowledge of data warehousing tools, patterns, and processes, Ability to interpret written requirements and technical specification documents, Good coding skills according to published standards and design guidelines, MSc in an analytical area such as Statistics, Computer Science, Physics, Mathematics, Engineering or similar, 5+ years of relevant employment experience, Strong track record of building ML models that use huge amounts of training data and which demonstrated a clear impact to the business, Expert level data analysis and statistical skills including knowledge of statistical packages in R and Python, Strong proven analytical/problem solving skills and attention to detail, including the ability to recognize non-obvious patterns/predictors, with the ability to propose insightful hypotheses, Excellent verbal/written communication skills, including an ability to effectively collaborate with business, research and technical teams, and earn the trust and influence senior stakeholders, Interest in mentoring and guiding junior team members, Interest in using voice to search, interact with technology, and shop, Experience in defining a vision and getting buy-in from senior leaders across the company, Operate within a diverse team to design and build improvements to a highly-available, enterprise-scale platform providing secure access to large financial datasets, Interface with cross-functional teams to deliver complete business intelligence solutions, Model data and metadata to support performance management reporting, Proliferate best practices in reporting and analysis, including data integrity, test design, analysis, validation, and documentation, Provide risk assessment for new functionality and enhancements, and identify process improvement opportunities to drive innovation, Facilitate and improve recurring processes for project intake, prioritization, and ongoing management reporting, Bachelor's Degree (BS/BA) in Information Systems, Computer Science, Finance, Statistics or a related discipline, 5+ years of developing end-to-end performance management and business intelligence solutions with complex datasets, including planning automation, data modeling, ETL, and reporting, Direct experience using Business Intelligence (BI) reporting tools, preferably Cognos v10x (Report Studio, Analysis Studio, Workspace, Framework Manager), or similar technology (OBIEE, Business Objects, Tableau, MicroStrategy, SAP, etc), Direct experience using OLAP performance management (CPM) tools, preferably Cognos TM1 v10x (Perspectives/Architect), or similar technology (Hyperion/Essbase, etc), Excellent communication (verbal and written) and interpersonal skills, and an ability to effectively communicate with both business and technical teams, Quick learner with a positive attitude and professional demeanor, and strong analytical and troubleshooting skills, A person with a work ethic based on a strong desire to exceed expectations, and who thrives in a hyper-growth environment where priorities shift rapidly, Master’s degree in Computer Science, Engineering, Math, Finance, Statistics, or a related discipline, Advanced knowledge and expertise with SQL, Oracle, OLAP, and data warehousing concepts, Familiarity with AWS solutions such as EC2, DynamoDB, S3, Redshift, and Aurora, Familiarity and development experience with web services technologies is a strong plus (e.g.