This site uses cookies. To find out more, see our Cookies Policy

BI and Data Engineer--MS BI Stack--up to 115k in Raleigh, NC at Vaco

Date Posted: 5/31/2018

Job Snapshot

Job Description

Brief Description;
The Data and Business Intelligence (BI) Developer is responsible for designing and developing data, data warehouse, reporting, business intelligence, and analytics solutions, components, databases, and platforms in a primarily SQL Server based environment. Reporting to the Director Data & Analytics Services, the Data & BI Developer will assist in the definition and maintenance of canonical models and data models. In partnership with the PMO, the Data & BI Developer will define and promote good data practices and design early in the software development lifecycle.
The Data & BI Developer is responsible for designing and developing database, reporting, data warehouse, modeling, and ETL solutions. This includes producing efficient and optimized SQL (T-SQL) including DDL, DML, stored procedures, etc.; data warehouse development including ETL, data analysis, data modeling (star schema, Kimball/Inmon), and interface design; performance turning (queries, indexing, partitioning), Microsoft Business Intelligence (MSBI) stack development including SSRS, SSIS, SSAS; and advising the infrastructure team with database best practices including backups, restores, replication, failover, etc. The Data & BI Developer will be involved with supporting the testing, change, release, and production operation of the database code. Responsible for ensuring alignment to the enterprise architecture standards, industry standards, and best practices when designing or changing code or reports.

The Data & BI Developer is an innovative and flexible technologist, participating in the driving of and promoting emerging technologies, Agile and DevOps (CI/CT/CD) methods and patterns, and quality delivery. She or he will be experienced with SQL and NoSQL database design and queries, along with TSQL language and XML and JSON document formats.

  • Senior member of team for the complete software development lifecycle beginning at design, architecture, and development through implementation for data projects
  • Partners with architecture for design and review of projects with respect to adherence to standards, enterprise models, strategies, and best practices
  • Responsible for building, maintaining, and optimizing T-SQL artifacts (DDL, DML, stored procedures, etc.)
  • Responsible for data warehouse, data mart, and BI development including ETL, data analysis, data modeling (star schema, Kimball/Inmon)
  • Responsible for data performance analysis and tuning including query analysis, indexing, and partitioning
  • Responsible for creation and maintenance of reports, reporting dashboards, analytics and evaluation of tools for same
  • Responsible for the analysis of legacy and acquired technologies and the execution plan to transform legacy technology to the strategic technology stack
  • Develop and maintain mock objects, unit tests, and test automation in the data space
  • Ensures creation and maintenance of technical documentation
  • Performs day-to-day development and maintenance activities for data domain
  • Contributes to infrastructure plans, policies, and standards in the data space including backups, restores, replication, failover, data virtualization, etc.
  • Contributes to defining and estimating timelines, costs, and feasibility for development projects
  • Provide proof-of-concept/minimally viable prototypes that set examples regarding new technology or ideas
  • Periodically review database code from staff and vendor contractors and direct enhancements
  • Designs and/or documents data models and data flows/processes
  • Ensure the performance of the developed solution(s) meet expectation and requirement
  • Provides maintenance and support
  • Mentors junior staff
  • 5+ years of experience developing and designing data and analytics/BI solutions
  • Expert with data modeling concepts (star schema, Kimball/Inmon)
  • Demonstrated skill with estimating time, cost, and resource requirements for projects
  • Demonstrated commitment to building and maintaining technical documentation
  • Strong experience and skill with T-SQL, SQL Server (2012/2014 and greater), MS BI Stack (SSRS, SSAS, SSIS), XML, JSON
  • Strong database table and query development experience with a focus on TSQL and SQL Server
  • Demonstrated skill at query analysis and performance tuning
  • Demonstrated skill modeling, building and producing actionable reports
Preferred Qualifications
  • Bachelor's degree in Computer Science, Computer Engineering, Information Systems, or related field, or 10 years equivalent work experience
  • Excellent oral and written communication skills with the ability to communicate technical concepts to a technical and non-technical audience
  • Demonstrated ability to establish relationships and build rapport to influence colleagues at all levels, uncover business issues, and identify needs
  • Experience building PowerShell scripts
  • Experience working in a clustered environment
  • Experience or exposure to DBA-type activities is a plus
  • Experience with Visual Studio and version control (git preferred)
  • Experience with agile project paradigm as well as waterfall
  • Experience with CI/CT/CD processes and tools
  • Experience with NoSQL databases and caches such as MongoDB and Redis
  • Experience in the insurance domain is a plus
  • Experience working in a hybrid on- and off-shore model
  • Experience with JIRA, Bamboo, Bitbucket, Ansible, and similar tools a major plus
  • Excellent knowledge of data integration and integration patterns