BI Developer – Rockville, MD, US

Job Opportunities

design your future.
engineer your success.


BI Developer – Rockville, MD, US

BI Developer

Department: Engineering
Location: Rockville, MD, US

NIKA is seeking Business Intelligence Developers who will be responsible for designing, developing, implementing, and maintaining various customers’ BI platforms by leveraging your skills with the Tableau and/or Microsoft BI suite. You’ll create reports to communicate business metrics and assist power users with creating their own.

Named a “Top Workplace” by the Washington Post, NIKA is a well-established company that is focused on growth within an entrepreneurial environment. We are revolutionizing how businesses and governments design, build and manage real property by combining architecture and engineering, enterprise technologies, and facilities operations management services all under one roof. When you become part of the NIKA team, you join an organization that encourages collaboration, vision and personal development.


  • Develop standard reports and functional dashboards based on business requirements.
  • Extracting, transforming, analyzing, visualizing, and presenting data from diverse business areas in novel and insightful ways to enable business executives to take informed action.
  • Maintain business intelligence models to design, develop and generate both standard and ad-hoc reports.
  • Generate reports for internal and external customers for business performance monitoring and business decision making.
  • Work with Project Manager in developing and executing project plans within assigned schedule and timeline.
  • Manage new report generation and report enhancement based on the change requests.
  • Perform data warehouse design and modelling according to established standards.
  • Determine business intelligence and data warehousing solutions to meet business needs.
  • Ensure to generate and deliver quality reports to customers in timely and accurate manner.
  • Identify and resolve data reporting issues in a timely fashion.
  • Contribute to data aggregation strategy for reporting, dashboards, and self-service analytics
  • Perform quality assurance checks on new or enhanced reports.
  • Recommend improvements to provide optimum reporting solutions.
  • Supporting business users on answering complex business questions via Tableau and ad-hoc SQL queries.
  • Stay updated with business operations and business intelligence processes.
  • Conduct training programs and knowledge transfer sessions to junior developers when needed.

RDBMS Requirements

  • Expert knowledge of any common structured query language programs is acceptable
  • Expert Knowledge of SQL queries, ability to read and write highly complex SQL statements
  • 5+ years of experience in BI Development
  • Advanced scripting and ETL, data modeling and working with large data sets
  • Background in data warehouse design (e.g. dimensional modeling) and data mining
  • In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
  • Use SQL Server Management Studio to create tables, stored procedures, functions, and other objects using T-SQL.
  • Use SSIS to extract, load, and transform data.
  • Use SSAS to create cubes and adapt existing cubes.

BI Software Requirements

  • Expert knowledge of any common business intelligence application is acceptable (Power BI or Tableau most preferred)
  • Strong understanding of Tableau Architecture required to perform effectively
  • Strong understanding of Tableau Server implementation & administration processes and best practices
  • Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau
  • Knowledge of the best practices for implementation and integration of Tableau.
  • Design and deploy rich Graphic visualizations with Drill Down and Drop-down Menu options, Parameterized and Linked reports, Local and Global filters, context filters using Tableau desktop
  • Generate tableau dashboards with Tree Maps, Geo Maps, Stack Bars, Line Graphs, Histograms, Pie Charts, Donut charts, Heat Maps, Scatter Plots for showing Trends with Dual Axis
  • Develop various reportdashboard using grouping, sorting, filtering, ranking and ordering the data and using Tableau reports for various analysis Top – N Analysis, Comparative Analysis, SystemsSources GAP Analysis, Trend Analysis

General Requirements

  • BSc/BA in Computer Science, Engineering or relevant field
  • Demonstrates knowledge of broader set of business economic, intelligence and analytic techniques
  • Ability to obtain and maintain a DoD secret security clearance
*An Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against on the basis of disability.