Business Intelligence Developer

Vanguard Malvern , PA 19355

Posted 2 weeks ago

To analyze data and informational requirements and provide the best data solutions to internal Vanguard clients.

Duties and Responsibilities
1.Creates sophisticated data solutions to business problems.
2.Translates business specifications into design specifications and code. Responsible for writing complex programs, ad hoc queries, and reports using team procedures and tool selection guidelines. Ensures that all code is developed in a well structured manner - includes sufficient documentation - and is easy to maintain and reuse.
3.Continues to discover and implement new data sources and data integration techniques that are beneficial to clients who self-provision data.
4.Leads all phases of development. Explains technical considerations at related meetings, including those with internal clients and less experienced team members. Tests code thoroughly for accuracy of intended purpose.
5.Understands and enforces team development guidelines. Mentors staff with less experience. Resolves issues elevated from staff with less experience.
6.Partners with internal clients to enhance understanding of business functions and informational needs. Maintains a broad understanding of Vanguard's technologies, tools, and applications, including those that interface with business area and systems.
7.Designs and conducts training sessions on tools and data sources used by the team and self provisioners. Provides supporting documentation to team members and business partners as needed.
8.Understands, complies with and enforces team policies and procedures, especially those for quality and productivity standards that enable the team to meet established milestones. Understands, complies with and enforces all Information Security policies and procedures, and verifies deliverables meet Information Security requirements. Abides by Risk Controls as defined in the team CAF Documentation.
9.Manages and/or participates in special projects and performs other duties as assigned.


  • Undergraduate degree in a related field or the equivalent combination of training and experience.

  • Minimum of five years analyst, developer, or DBA experience.

  • Strong SQL and query performance tuning skills.

  • Knowledge of Vanguard digital properties.

  • Expert-level knowledge of Vanguard UI development tools and processes and of the following technologies Java, JavaScript, JSON, Angular JS, JSF, CSS, HTML and AJAX

  • Extensive experience using one or more of the following data sources: Enterprise, Data Warehouse, VAST, VISTA, Adobe or Tea Leaf

  • Advanced knowledge of one or more of the following: COGNOS Report Studio, Analysis Studio, Framework Manager and Transformer, SAS, FOCUS, SQL, EasyTrieve, Hadoop, Python, UNIX, CIS, IDAA, and Exadata, Java, Tag management Systems, Adobe and Tea Leaf.

  • Strong problem solving, planning, and communication skills.

  • Knowledge of Iport and Institutional data stores preferred.

  • Knowledge of the Retail and Institutional WEB Site preferred.

Vanguard is not offering visa sponsorship for this position.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Analytics Insights And Business Intelligence Specialist

Iz*On Media

Posted 4 weeks ago

VIEW JOBS 3/22/2019 12:00:00 AM 2019-06-20T00:00 About STRATACACHE, Inc. STRATACACHE solutions deliver engaging experiences by connecting networks of digital signs, kiosks, mobile devices, websites and Internet-connected devices – in both public and private environments. The STRATACACHE family of companies provide the platform to easily create and centrally manage deployment of experiences, while retaining the flexibility to rapidly adapt to local business conditions. Scala is one of the family brands of STRATACACHE. This position will be located at the Scala office headquarters in Malvern, Pa. STRATACACHE and Scala have over 30 years experience entertaining, informing and educating audiences in wide-ranging industries including retail, quick-service restaurants, finance and more, as well as in private areas like corporate environments. At the STRATACACHE the network of partners and developers are located in more than 90 countries drives more than 500,000 screens worldwide. Analytics, Insights and Business Intelligence Specialist Do you enjoy analyzing data, discovering insights, drawing conclusions and telling stories from your results? Do you value working on a pipeline of analytics-driven and data science focused projects? Are you a seasoned professional in the analytics arena with great consulting skills? Are you interested in the future of retail, commerce and customer analytics? Do you want to help your customers solve business problems by identifying and providing actionable insights? If so, this is the role for you. In this role you will have the opportunity to work with customers and clients, understand their business, develop datasets and actionable insights, and turn the insights into valuable business decisions-making deliverables. You will be focused on the future of the retail experience by discovering insights while creating strategic, marketing, retail, customer experience and digital analytics. Your background in data discovery, data science, big data, visualization, business problem analysis and analytics consulting will be very beneficial as you take on this exciting new position in the company. In this role, you will also have the opportunity to continue to build and improve the marketing technology products that are influenced by data and understand human behavior. Through your initiative, you will be able to determine how to influence and impact the retail marketplace with exciting new solutions and insights. You will also work with software engineering, sales and product organizations to develop innovative and impactful applications for data, analytics and insights. Your efforts will enhance overall product quality, utilizing many aspects of data analysis including various types of statistical modeling that drive toward strategic goals. Responsibilities include: * Provide analytical focus to uncover, design and implement useful business insights. * Produce visualizations and stories that connect data analysis, data science and analytics to useful business insights. * Create impactful client presentations and reports to educate internal and external customers on solutions, insights and opportunities. * Present yourself in a professional way to clients, prospects and customers. * Conduct data discovery and analysis to identify insights and opportunities. * Collect and define data and analytical requirements and reporting strategies for customers. * Develop and prototype dashboards and visualizations to support client and customer needs. * Analyze performance metrics, business functions and operations to determine insights and recommendations to customers. * Collect and define metric-based requirements for customer pilot programs. * Design and build database-driven analytical solutions and dashboards. * Manage data and analytic solution deliverables for quality assurance and successful completion. * Provide direction to product managers and engineers using advanced data modeling and analysis techniques to discover insights that will guide strategic decisions and uncover new product and customer opportunities. * Research and identify data trends and key business drivers. * Offer new ideas for types of analyses and data visualizations to drive product innovation. * Provide expertise handling sensitive, privacy-protected data, including sources, structures, organization and optimization. * Ensure accuracy of data and deliverables of reporting employees with comprehensive policies and processes. * Communicate ideas, processes and results to all levels of internal and external clients and teams * Collaborate and partner with team members on projects and solutions. * Keep up-to-date with emerging data science and statistical technologies, methods and practices. * Engage with third-party vendors and other groups as required. Qualifications: * Bachelor's degree required (Information Systems, Business and/or Computer Science preferred) * Minimum 5 years of related experience working with data, analytics and insights. * Minimum 5 years designing and delivering analytic solutions, dashboards, visualizations and actionable insights. * Minimum 5 years creating and delivering client presentations and stories that connect data analysis, data science and analytics to useful business insights. * Ability to articulate and correlate data to business strategy. * Hands-on experience with Tableau Desktop. * Experience working with Postgres, Timescale DB and/or other related database technologies. * Experience working with SQL and complex SQL. * Experience with dimensional data modeling techniques. * Dynamic personality and passion for data, analytics, visualizations and storytelling is very important for this role. * Keen sense of user interface design, style, aesthetics and effective visual presentation. * Experience with client consultation to internal or external customers is required. * Experience with Microsoft Excel and PowerPoint. * Experience with retail, QSR, CPG, digital advertising and mobile industries is beneficial. * Experience with data in sensors, wifi, digital signage is beneficial. * Experience in the retail industry from a data perspective is beneficial. * Hands-on experiences with other BI/visualization technologies including open source or proprietary. * Understanding and experience with database technologies is beneficial including Oracle, SQLServer, etc.. * Understanding and experience with BI platform technologies is beneficial: Tableau, Microstrategy, Microsoft, OBI, etc.. * A solid understanding of methodology, data and systems from a broad range of research and analytics providers, including emerging tools and methods. * Experience and understanding of the following areas: strategic analytics, marketing analytics, digital analytics, data analytics, statistics, data science, big data, normalization, modeling, quant research, analytics consulting. * Ability to distill complex statistical concepts and methodology, and articulate insights to cross-functional teams and clients with varying levels of knowledge in this space. * Experience and understanding of various statistical modeling tools and platforms -- including R, SAS and SPSS -- is beneficial. * Experience in ecommerce, wifi, app messaging, social and other datasets is beneficial. * Experience in machine learning and artificial intelligence methods and practice is beneficial. * Ability to work effectively in fast-paced, results-oriented work environment. * Experience with agile development methodologies. * Ability to handle and adjust to change in requirements and direction. * Positive attitude, attention to detail and great problem solving skills are important. * Self-motivated, self-starter with a team-centric focus while working in a fluid environment. * Exceptional communication skills: verbal, written and presentation STRATACACHE and its family of companies provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, creed, sex, sexual orientation, gender identity, national origin, age, disability, genetic information, pregnancy, childbirth or related medical condition, veteran, marital, parental, citizenship, or domestic partner status, or any other status protected by applicable national, federal, state or local law. While we are excited and appreciate you interest in our opportunities, please keep in mind that we are not able to contact all applicants that have applied. No vendor/agency solicitation please. Iz*On Media Malvern PA

Business Intelligence Developer